Northstar Design Collaborative · Sales & Proposal Development Training Guide · 2026 Edition
N
Calculation Tools
Five precision calculators: team structure reference, six-phase labor allocation, fee chart with population-driven method, specialty service line sizing, and bar seat-count budget calculator.
Northstar Design Collaborative USA · 2026 Edition · Internal Use Only
Section N · Calculation Tools · N.0
N.0 · Orientation
How to Use This Section
Every calculator in this module replicates the exact logic of the master Northstar Design Collaborative spreadsheets. Enter values in the blue input fields. All other fields calculate automatically. No formula knowledge required.
Blue field: Input (you type here)
Dark field: Calculated result
Grey field: Auto-calculated sub-value
⊷ Recommended Order
Start with N.4 Team Structure to enter your personnel roster. Then complete N.3 Labor Calculator with each person's rate and phase commitments. Use those figures to inform N.1 Fee Chart and N.5 Bar Seat Calculator. The laundry calculator (N.2) is independent and can be run at any time.
❝ Expert Perspective
"The fee is not a guess. It is a calculation. When you can show a client exactly how you arrived at a number from their square footage, the conversation shifts from negotiation to confirmation."
· Northstar Design Collaborative OS · The Proposal Standard
Section N · Calculation Tools · N.4
N.4 · Team Structure Reference
Team Structure
Add your team organized by function. Use for SF 330 personnel sections, proposal team pages, and internal resource planning. Enter names, credentials, office locations, job titles, and billable rates. Add rows as needed in each section.
✎ How to Fill In This Section
Section titles are editable: click and type your own (e.g. Leadership, Project Team 1).
Each row: enter name and credentials, office location, select a job title from the dropdown (choose Custom to enter your own), and enter the billable rate.
Add Row button at the bottom of each section adds a blank row. Fill in and repeat.
Each row: enter name and credentials, office location, select a job title from the dropdown (choose Custom to enter your own), and enter the billable rate.
Add Row button at the bottom of each section adds a blank row. Fill in and repeat.
ⓘ Team Note
Always verify current credentials and titles with the audit manager before submission. Billable rates apply to all client-chargeable time; internal administration is not billed.
Section N · Calculation Tools · N.3
N.3 · 6-Phase Labor Calculator
6-Phase Labor Calculator
Phase-by-phase labor allocation across all six project phases. Enter the fee for each phase and each person's commitment percentage. Hours and costs calculate automatically. The Percent Check column validates that commitment percentages sum to 1.000 per phase.
✎ How to Use This Calculator
Personnel Rates: Enter each team member's name and hourly rate. Pull these from N.4 Team Structure.
Phase Fee: Enter the dollar fee allocated to each phase (from your fee proposal).
Commitment %: For each person in each phase, enter the decimal percentage of that phase they will work (e.g., 0.10 = 10%). Percentages across all people for each phase must sum to 1.000.
Hours formula: Hours = (Phase Fee × Commitment%) ÷ Rate
Phase Fee: Enter the dollar fee allocated to each phase (from your fee proposal).
Commitment %: For each person in each phase, enter the decimal percentage of that phase they will work (e.g., 0.10 = 10%). Percentages across all people for each phase must sum to 1.000.
Hours formula: Hours = (Phase Fee × Commitment%) ÷ Rate
- Enter each person's name and hourly rate in the Personnel Rates section
- Enter Phase Fee for each of the six phases (Prog, SD, DD, CD, BN, CA)
- Enter commitment % for each person per phase (must sum to 1.000 per phase)
- Review the Phase Summary table for total hours and cost by phase
- Percent Check column shows 1.000 = valid; any other value = re-check percentages
Project Name / Reference
| Phase | Code | Phase Fee Input | Calc'd Hours | Calc'd Cost | Pct Check |
|---|---|---|---|---|---|
| Program / Concept | Prog | 0.00 | $0 | 0.000 | |
| Conceptual Design | SD | 0.00 | $0 | 0.000 | |
| Design Development | DD | 0.00 | $0 | 0.000 | |
| Project Documents | CD | 0.00 | $0 | 0.000 | |
| Bidding / Negotiations | BN | 0.00 | $0 | 0.000 | |
| Implementation Administration | CA | 0.00 | $0 | 0.000 | |
| Total Professional Fee | $0 | 0.00 | $0 | 6.000 | |
| Person / Role | Rate ($/hr) |
|---|---|
⊷ Percent Check Rule
The Percent Check column in each phase must equal exactly 1.000. A value below 1.000 means you have unallocated fee. A value above 1.000 means the commitments exceed the budget. Adjust individual percentages until each phase checks to 1.000 before using hours figures in a proposal or internal resource plan.
Section N · Calculation Tools · N.1
N.1 · Fee Chart Calculator
Fee Chart Calculator
Population-driven fee model: enter population, participation, sector rates, and the areas being designed. The calculator derives the equipment budget and proposed fee using the same formula chain as the master Fee Chart spreadsheet.
✎ How to Use This Calculator
Method A (Population-Driven): Enter population and participation rate; the calculator derives seats, square footage, and equipment budget. Adjust the $ per SF and fee percentage to match the project sector.
Manual area entry (right column): Type specific square footages and $/SF for each discrete area (kitchen, bar, market, etc.). Use + Add Area to include additional spaces. The equipment total and fee calculate from those figures.
Manual area entry (right column): Type specific square footages and $/SF for each discrete area (kitchen, bar, market, etc.). Use + Add Area to include additional spaces. The equipment total and fee calculate from those figures.
- Enter project name and population in Project Inputs
- Adjust participation rate (default 35%) and SF/seat (default 18)
- Set $/SF and fee % to match sector rates from the Fee Chart 2026
- Enter individual area square footages and $/SF in the Area Breakdown; use + Add Area for more spaces
- The Proposed Fee panel shows the rounded fee to use in proposals
Project Name
Population Total people served by this facility
Participation Rate Typically 35% for corporate/education
Derived Demand
Auto-calculated
Average Daily Participation
700
Peak Half-Hour Factor 50% of daily participation
350
Lunch Customers (Peak)
350
Seating Inefficiency Factor 85% occupancy standard
0.85
Number of Seats
298
SF Per Seat
Total SF Kitchen & Servery
5,364
$ Per SF See Fee Chart 2026 by sector
Kitchen & Servery Equipment Budget
$1,206,900
Fee % 5 to 7% typical; see sector rates
Calculated Fee (Population Method)
$72,414
Area Description
Approx. SF
$ / SF
Total $
$559,325
$47,250
$18,200
$0
$0
Equipment Total (Area Method)
$624,775
Fee Percentage (Area Method)
5.0%
Calculated Fee (Area Method)
$31,239
Phase Split
%
Fee Allocation
Program / Concept
7.0%
$2,187
Conceptual Design (SD)
18.0%
$5,623
Design Development (DD)
35.0%
$10,934
Project Documents (CD)
22.0%
$6,873
Bidding / Negotiations (BN)
3.0%
$937
Implementation Administration (CA)
15.0%
$4,686
Number of Site Visits (CA)
▶ Fee to Use in Proposal (Area Method): Round to nearest $250
$31,250
✓ Best Practice
Always present the rounded Area Method fee in the proposal, not the Population Method fee. The population method is a sanity check. The area-by-area breakdown is the defensible number because it ties to specific designed spaces. Round up to the nearest $250 for clean proposal presentation.
Section N · Calculation Tools · N.2
N.2 · Laundry Sizing Calculator
Laundry Sizing Calculator
Two-scenario comparison using the 15-lb standard. Enter room keys and the calculator derives daily specialty service line volume, hourly capacity, and the number of washers and dryers required. Adjust machine capacity and cycle time to match specified equipment.
✎ How to Use This Calculator
Standard mode: Enter lbs per person (default 15) and room keys. The calculator multiplies to get total lbs, divides by working hours for hourly demand, then rounds up to get equipment counts.
Override mode: If you already know total daily pounds (from a client-provided survey or existing specialty service line records), enter it in the Direct Total Lbs Override field. When populated, it replaces the keys calculation.
Additional Equipment: Use the section below to add any supplemental equipment items with quantity and unit cost.
Override mode: If you already know total daily pounds (from a client-provided survey or existing specialty service line records), enter it in the Direct Total Lbs Override field. When populated, it replaces the keys calculation.
Additional Equipment: Use the section below to add any supplemental equipment items with quantity and unit cost.
- Enter lbs/person (15 = standard hotel; 20 = luxury; 3 = correctional)
- Enter room keys for Scenario 1 and optionally Scenario 2
- Leave Direct Override blank (use keys calculation) or enter a known daily lbs figure
- Adjust washer/dryer capacity and cycle time to match actual specified equipment
- Add any additional equipment items in the Additional Equipment section below
Scenario 1
Scenario 2
Lbs of Laundry Per Person / Key 15 = standard; 20 = luxury; 3 = correctional
Room Keys
Direct Total Lbs Override Leave blank to use keys calculation
Daily Volume
Total Lbs / Day
2,880
2,250
Working Hours Per Day
Lbs Per Working Hour
411.4
321.4
Rounded Up (Ceiling)
412
322
Equipment Sizing: Washers
Washer Capacity (lbs)
Washer Cycle Time (min)
Washer Lbs Per Hour
266.7
266.7
Wash Loads Per Day
15
12
Washing Machines Needed
2
2
Equipment Sizing: Dryers
Dryer Capacity (lbs)
Dryer Cycle Time (min)
Dryer Lbs Per Hour
200.0
200.0
Dry Loads Per Day
15
12
Dryers Needed
3
2
Equipment Name
Qty
Cost Each
Total
Additional Equipment Total
$0
ⓘ Formula Reference
Total Lbs = Keys × Lbs/Person (or override value)
Lbs/Hr = Total Lbs ÷ Working Hours
Machine Lbs/Hr = Capacity × (60 ÷ Cycle Minutes)
Machines Needed = Ceiling(Lbs/Hr ÷ Machine Lbs/Hr)
Loads/Day = Total Lbs ÷ Machine Capacity
Lbs/Hr = Total Lbs ÷ Working Hours
Machine Lbs/Hr = Capacity × (60 ÷ Cycle Minutes)
Machines Needed = Ceiling(Lbs/Hr ÷ Machine Lbs/Hr)
Loads/Day = Total Lbs ÷ Machine Capacity
Section N · Calculation Tools · N.5
N.5 · Bar Seat Calculator
Bar Seat Calculator
Classify your bar by seat count and calculate the seat-based equipment budget in addition to the square footage method used in N.1. Enter your firm's standard rate per seat for each bar size category. The calculator detects the category automatically and applies the correct rate.
✎ How to Use This Calculator
Step 1: Enter the total number of bar seats. The calculator classifies the bar as Small, Medium, or Large automatically.
Step 2: Enter your firm's standard rate per seat for each size category. Only the applicable category rate is used in the calculation.
Step 3: The seat total (seats × rate) is shown separately from the square footage total. The combined bar budget adds both methods together. Cross-reference the bar row in N.1 for the SF figure.
Step 2: Enter your firm's standard rate per seat for each size category. Only the applicable category rate is used in the calculation.
Step 3: The seat total (seats × rate) is shown separately from the square footage total. The combined bar budget adds both methods together. Cross-reference the bar row in N.1 for the SF figure.
- Enter total bar seat count
- Enter your standard $/seat rate for Small (12 or under), Medium (13 to 17), and Large (18 or above)
- Bar is auto-classified and the applicable rate is displayed
- Read the seat total and combined bar budget below
Number of Bar Seats
Bar Classification
Auto-detected
Size Category Small = 12 or under | Medium = 13 to 17 | Large = 18 or above
Category
Seat Range
Your $/Seat Rate
Small Bar
12 seats or under
Medium Bar
13 to 17 seats
Large Bar
18 seats or above
Applicable Rate (based on seat count)
--
Calculation Number of seats × applicable rate
0 seats × $0 = $0
Seat-Based Total
$0
Cross-Reference: N.1 Bar Area SF Budget
Bar SF Budget (from N.1 Area Breakdown: Bar row)
$0
Combined Bar Budget (SF method + Seat method)
$0
ⓘ How to Use This Figure in Proposals
The seat-based calculation provides an additional data point for bar design fees separate from the square footage method. Compare both totals and present the higher figure, or average them, depending on client type and project complexity. Store your firm's standard rates per category so every bar project produces a consistent, defensible estimate.
⊷ Bar Size Classifications
Small Bar (12 seats or under): Intimate bar program, limited back-of-bar equipment, typically one bartender station.
Medium Bar (13 to 17 seats): Moderate bar program, dual bartender capability, expanded back-bar.
Large Bar (18 seats or above): Full-service bar program, multiple stations, full draft and spirits systems.
Medium Bar (13 to 17 seats): Moderate bar program, dual bartender capability, expanded back-bar.
Large Bar (18 seats or above): Full-service bar program, multiple stations, full draft and spirits systems.