Video · 1:19
Project Quote Calculator walkthrough
Chapters
- 0:00Price against walk-away price
- 0:06Start Here and the color key
- 0:19Setup: your business name
- 0:25Dashboard: delivery cost and markup
- 0:29Team Rates: cost per delivery hour
- 0:37Scope Lines: type one line
- 0:46Dashboard: fee, rounding and walk-away price
- 0:56Checks
- 1:01The Quote sheet you send
- 1:05Clear the sample data
- 1:10Help and support
Transcript
The video has no sound. This is what it shows, in order: each caption, then what is on screen.
- Price a project so it still pays. Fictional quote: 25,500.00; walk-away 19,436.68. On screen: the Dashboard's price build-up for a fictional quote. Price excl. tax, 25,500.00, and Walk-away price, 19,436.68, are outlined.
- Yellow cells: you type. Leave every other cell to the workbook. On screen: Start Here, row 3. The key sentence and the yellow swatch, "Yellow: you type here", are outlined. The About this file block below shows the version and the release date.
- White cells calculate. Grey cells hold lists and reference values. On screen: Start Here, row 3. The white swatch reads "White: calculated, don't type here" and the grey swatch reads "Grey: lists and reference values"; both are outlined.
- Start Here has nothing to type. Do this next says what to do. On screen: Start Here, row 5. Do this next is outlined. It reads "Open Setup: type your business name; it prints at the top of every quote."
- On Setup, type your business name. Setup complete then reads Yes. On screen: Setup, the Business name cell, empty, with the active-cell outline. Example Studio is typed. The view then moves down to Setup complete, which reads Yes and is outlined.
- Delivery cost: 13,919.00. Contribution: 11,581.00, an 83.2% markup. On screen: the Dashboard key figures for quote EX-Q0142, Harbor Retail, Website rebuild. Delivery cost, 13,919.00, and Contribution before overhead, 11,581.00, are outlined. Quote price excl. tax, 25,500.00, quoted margin, 45.4%, and markup on delivery cost, 83.2%, are shown beside them.
- On Team Rates, type each role's pay, on-costs, leave and delivery share. On screen: Team Rates, five fictional roles. The Strategist row is outlined: annual pay 76,000.00, employer on-costs 7.65%, other annual on-costs 8,426.00, paid hours 2,080.0, leave hours 200.0 and delivery share 60.0%.
- The Strategist's cost: 80.00 USD per delivery hour. On screen: the view moves to the calculated columns for the same roles. The Strategist's annual cost is 90,240.00, delivery hours per year 1,128.0 and cost per paid hour 48.00. The role and the loaded cost rate, 80.00, are outlined.
- On Scope Lines, add one row per deliverable, typing left to right. On screen: Scope Lines, with EX-1 to EX-6 shown and the empty row 11 outlined. Row 11 is typed one cell at a time: EX-4, Project management, Weekly check-ins and launch coordination, Strategist, then 14.0 hours. The cursor moves one cell right after each entry.
- The line costs 1,120.00 USD: 14.0 hours at the Strategist's 80.00. On screen: the view moves to row 11's calculated columns. Cost rate 1 is 80.00, line hours 14.0 and labor cost 1,120.00, which are outlined.
- Fee at the 45.0% target: 25,307.27. Rounded up to the next 500: 25,500.00. On screen: the price build-up. Delivery cost 13,919.00, target margin applied 45.0%, equivalent markup 81.8%, fee at target margin before rounding 25,307.27 (outlined), fee as quoted 25,500.00 and rounding added 192.73.
- The walk-away price is 19,436.68; this quote clears it by 6,063.32. On screen: further down the Dashboard, overhead share for these hours, 5,517.68, and walk-away price, 19,436.68, are outlined; then headroom over walk-away price, 6,063.32, is outlined.
- Ten checks: nine read OK. Sample data is flagged until you clear it. On screen: the Dashboard checks. Checks 1 to 9 read OK. Check 10, Sample data, has a count of 12 and reads SAMPLE, and Checks failing reads 1.
- The Quote sheet is the page you send. Costs and margins never print. On screen: the Quote sheet as it prints: a SAMPLE banner, Harbor Retail as the client, the six deliverables EX-1 to EX-6 with their descriptions, and Fee for the scope above, 25,500.00, and Total, 25,500.00, outlined. No cost or margin appears on the sheet.
- Clear the sample with these steps, and the status then reads OK. On screen: Start Here, the steps to clear the sample data, with steps 1 and 2 outlined. Choose MV_Clear_ScopeLines in the Name Box and press Delete, then repeat for MV_Clear_QuoteDetails and MV_Clear_TeamRates. Then the status in Start Here row 3 reads OK; Setup, with the typed business name, is kept.
- The Guide explains every input and check. Support replies within 1 business day. On screen: the Guide sheet, with the five setup steps and the time each takes; then Start Here, the Support rows only: the Email row is outlined: [email protected], and "You get a reply within 1 business day (Monday to Friday, Australian Eastern time)."
- See every sheet and what is tested at metricvalley.com. On screen: the end card. Project Quote Calculator, v1.1.0, Excel 365, Google Sheets edition when it ships, metricvalley.com, above the Dashboard key figures for EX-Q0142: 25,500.00, 13,919.00, 11,581.00, 45.4%, 83.2% and 6,063.32. Every sheet shown is the v1.1.0 worked-example file in Excel 365, with fictional data. One scope line was cleared before this video, then typed back in. The business name was typed on Setup for the recording.