Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Authentication
digital resources
158x Filetype XLSX File size 0.06 MB Source: www.gaildoby.com
Sheet 1: Client Budget Calculator (1)
| START HERE | GENERAL INFORMATION | |||||||
| STEP 1: Fill in these values to compute fee and furnishings budget | Your total net dollars available for purchasing FF & E at your cost is calculated based on your desired percentage for fees of the overall Budget - See D32, E32, F32, I32, J32, K32 | |||||||
| (A) Enter House Value if not stated by client, look up on http://www.Zillow.com: | $2,000,000 | |||||||
| (B) Enter the percentage of Furnishings Needed (if using some existing furnishings) | 25.0% | Your client's cost per square foot of furnishings is shown on Line 33. | ||||||
| (C) Enter the project's square footage: | 6000 | ADDITIONAL NOTES | ||||||
| (D) Enter percentage of project budget for renovations if it will be deducted from overall budget | 0.0% | NOTE 1: Overall Budget for Project - includes furnishings, fees, and possible minor remodel. | ||||||
| (E) Enter your mark-up percentage. We automatically calculate your net margin in cell B30: | 30.0% | NOTE 2: Home Trust is the source of the budget recommendations - https://thehometrust.com/luxury-home/interiors-index/ | ||||||
| (F) Enter any applicable percentage for Project Installation Fees (if applicable): | 0.0% | |||||||
| (G) Enter your sales tax percentage: | 6.6% | Note 3: If you are working with extremely high-end or custom furnishings, you may want to increase the budget. | ||||||
| (H) Enter an estimate for freight, delivery and crating: | 5.0% | |||||||
| STEP 2: create an itemized list of furnishings per room on Tab 2. | ||||||||
| STEP 3: create a budget for hours so you can track whether you are over or under budget. | ||||||||
| Low | Budget | High Budget | ||||||
| EASY CLIENT BUDGET CALCULATOR | Total $ Budget Based on 35% | 20% Design Fees of Total Budget | 25% Design Fees of Total Budget | 33% Design Fees of Total Budget | Total $ Budget Based on 40% | 20% Design Fees of Total Budget | 25% Design Fees of Total Budget | 33% Design Fees of Total Budget |
| (A) House Value | $2,000,000 | $2,000,000 | ||||||
| (B) Total Design & Construction Budget [Fees + Furnishings + Renovation] Based on 35% of Total House Value | $700,000 | $800,000 | ||||||
| (C) Adjusted Design Fee Budget Based on Actual Furnishings Needed For Project | $175,000 | $200,000 | ||||||
| (D) Overall Budget for Renovation (if Applicable) Deduction From Overall Budget | $- | $- | ||||||
| Total Budget Available for Fees & Furnishings | $175,000 | $200,000 | ||||||
| Total Design Fees Based on % of Total Budget Available | $35,000 | $43,750 | $57,750 | $40,000 | $50,000 | $66,000 | ||
| Design Fee Per Square Foot | $5.83 | $7.29 | $9.63 | $6.67 | $8.33 | $11.00 | ||
| Product Budget Before Additional Deductions Below | $140,000 | $131,250 | $117,250 | $160,000 | $150,000 | $134,000 | ||
| (E) Your Mark-up % | 30% | 30% | ||||||
| Additional Deductions From Gross Product Budget To Determine Net Purchasing $ | ||||||||
| Budget Available For Furnishings After Installation Deduction | $140,000 | $131,250 | $117,250 | $160,000 | $150,000 | $134,000 | ||
| (F) Project Installation Fees (if applicable) | 0.0% | 0.0% | ||||||
| (G) Your Sales Tax % | 6.6% | 6.6% | ||||||
| (H) Freight, Delivery, Crating % | 5.0% | 5.0% | ||||||
| Total Deductions | 11.6% | 11.6% | ||||||
| Your Gross Margin [Automatically Calculated] | 23.1% | 23.1% | ||||||
| Net Purchasing Dollars Available | $91,452 | $85,737 | #NAME? | $104,517 | #NAME? | #NAME? | ||
| Furnishings Budget/SF [Based on Gross Product Cost to Client] | $15.24 | $14.29 | $12.77 | $17.42 | $16.33 | $14.59 | ||
| Total Budget Per Square Foot for Design Fees + Furnishings | $21.08 | $21.58 | $22.39 | $24.09 | $24.66 | $25.59 | ||
| to lock/unlock: gdcc | ||||||||
| Total Net $ Budget (From Tab 1) | 91,452.31 | STEP 1: Decide which net budget on Tab 1 will be used for the project & select that value in B1 See C32, D32, E32, G32, H32, I32 | |||||||||||
| Variance from Tab 1 | 91,452.31 | STEP 2: Allocate a percentage of the total net budget on Tab 1 to each room - insert your value in Column B - Dark yellow cells | |||||||||||
| STEP 3: Insert a percentage of the total net budget (B1) to each room. The total should add up to 100%. | |||||||||||||
| Total Project Budget | $- | ||||||||||||
| Total Budget Allocated | 0.00% | ||||||||||||
| Room 1: | Net Cost | Room 2: | Net Cost | Room 3: | Net Cost | Room 4: | Net Cost | Room 5: | Net Cost | ||||
| Desired Percentage Allocated to Room | 10% | Desired Percentage Allocated to Room | 10% | Desired Percentage Allocated to Room | 10% | Desired Percentage Allocated to Room | 10% | Desired Percentage Allocated to Room | 10% | ||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Room 1 total | $- | Room 2 total | $- | Room 3 total | $- | Room 4 total | $- | Room 5 total | $- | ||||
| Room 1 Actual Percentage Allocation | 0.00% | Room 2 Actual Percentage Allocation | 0.00% | Room 3 Actual Percentage Allocation | 0.00% | Room 4 Actual Percentage Allocation | 0.00% | Room 5 Actual Percentage Allocation | 0.00% | ||||
| Room 6: | Net Cost | Room 7: | Net Cost | Room 8: | Net Cost | Room 9: | Net Cost | Room 10: | Net Cost | ||||
| Desired Percentage Allocated to Room | 10% | Desired Percentage Allocated to Room | 10% | Desired Percentage Allocated to Room | 10% | Desired Percentage Allocated to Room | 10% | Desired Percentage Allocated to Room | 10% | ||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Item Description | Item Description | Item Description | Item Description | Item Description | |||||||||
| Room 6 total | $- | Room 7 total | $- | Room 8 total | $- | Room 9 total | $- | Room 10 total | $- | ||||
| Room 6 Actual Percentage Allocation | 0.00% | Room 7 Actual Percentage Allocation | 0.00% | Room 8 Actual Percentage Allocation | 0.00% | Room 9 Actual Percentage Allocation | 0.00% | Room 10 Actual Percentage Allocation | 0.00% | ||||
| PROJECT NAME: | ||||||||||||||||||||
| Employee Position | Predesign Hours Budget | Predesign Actual Hours | Design Development Hours Budget | Design Development Actual Hours | FF & E Hours Budget | FF & E Actual Hours | Construction Documentation Hours Budget | Construction Documentation Actual Hours | Construction Administration Hours Budget | Construction Administration Actual Hours | Expediting Hours Budget | Expediting Actual Hours | Close-out & Punchlist Hours Budget | Close-out & Punchlist Hours Actual Hours | Total Hours Budgeted | Hourly Billable Rate | Total Billable Time Budget | Total Hours Actually Billed | Total Actual $ | Variance Over (+) Under (-) Budget |
| Principal Designer | 0 | $225.00 | $- | 0 | $- | $- | ||||||||||||||
| Project Manager | 0 | $175.00 | $- | 0 | $- | $- | ||||||||||||||
| Senior Designer | 0 | $150.00 | $- | 0 | $- | $- | ||||||||||||||
| Junior Designer | 0 | $125.00 | $- | 0 | $- | $- | ||||||||||||||
| Design Assistant | 0 | $100.00 | $- | 0 | $- | $- | ||||||||||||||
| Purchasing Manager | 0 | $100.00 | $- | 0 | $- | $- | ||||||||||||||
| CAD Drafting | 0 | $- | 0 | $- | $- | |||||||||||||||
| 0 | $- | 0 | $- | $- | ||||||||||||||||
| 0 | $- | 0 | $- | $- | ||||||||||||||||
| 0 | $- | 0 | $- | $- | ||||||||||||||||
| 0 | $- | 0 | $- | $- | ||||||||||||||||
| 0 | $- | 0 | $- | $- | ||||||||||||||||
| 0 | $- | 0 | $- | $- | ||||||||||||||||
| 0 | $- | 0 | $- | $- | ||||||||||||||||
| 0 | $- | 0 | $- | $- | ||||||||||||||||
| 0 | $- | 0 | $- | $- | ||||||||||||||||
| 0 | $- | 0 | $- | $- | ||||||||||||||||
| 0 | $- | 0 | $- | $- | ||||||||||||||||
| 0 | $- | 0 | $- | $- | ||||||||||||||||
| Total Hours Includes Meetings | 0 | $- | 0 | $- | $- | |||||||||||||||
| Fill in yellow values to compute time budget for project | Low Fee Budget (tab 1) | $249,900.00 | ||||||||||||||||||
| Actual Variance From Budget | $249,900.00 | |||||||||||||||||||
no reviews yet
Please Login to review.
