Reopen your group workbook from Lesson 08 and understand Milestone 2 goals.
Complete Your Workbook and Rehearse the Recommendation
In Lesson 08, your team opened your assigned workbook, classified costs, and completed the first analysis sheets. Today you will finish the remaining sheets, test your recommendation under different conditions, write a clear claim-evidence-risk statement, and rehearse with peer feedback. This is your dress rehearsal before the final presentation in Lesson 10.
Do not start a new file today. Reopen the exact workbook your team saved in Lesson 08. Your workbook already contains the seven-sheet structure from the rehearsal lesson. Your job today is to fill in the remaining sheets, test your recommendation, and practice explaining it.
Missing your file? Re-download your assigned starter workbook below and rebuild quickly from yesterday's notes. Use the same file naming convention: Period-TeamName-Unit06-Project.xlsx
Group 1: Neighborhood Shine
Mobile Car Detailing
- Capacity: 45 units/month
- Target Profit: $400/month
Group 2: Northside Print Lab
Custom Hoodie Print Shop
- Capacity: 220 units/month
- Target Profit: $500/month
Group 3: Fresh Fork Weekly
Meal Prep Delivery
- Capacity: 420 units/month
- Target Profit: $900/month
Group 4: CitySpark Studio
Social Media Content Studio
- Capacity: 30 units/month
- Target Profit: $800/month
- Turn your early analysis into one clear pricing recommendation
- Test whether your recommendation still works under different price and volume conditions
- Identify one risk or downside case and explain why your recommendation still makes sense
- Prepare to explain your trade-offs to classmates acting as stakeholders
- Complete TargetProfit — solve for price or units to hit your target
- Complete PriceSensitivity — test profit as price changes
- Complete ProfitMatrix — build the full price-by-volume grid
- Complete Dashboard — state recommendation, risk, and explanation
Your workbook has seven sheets. You completed the first three in Lesson 08. Today you will finish sheets 4-7 and polish the Dashboard for presentation.
- Minutes 0-5: Reopen your team workbook and review what you completed in Lesson 08
- Minutes 5-15: Complete the TargetProfit sheet — solve for your target
- Minutes 15-25: Complete PriceSensitivity and ProfitMatrix sheets
- Minutes 25-35: Complete the Dashboard sheet with your recommendation
- Minutes 35-40: Write your claim-evidence-risk statement and rehearse with your team
- Minutes 40-45: Exchange with another team for peer critique, then revise
Your Dashboard and presentation notes should follow this structure. Every group must include all four parts:
1. Claim
Name the pricing option your team recommends. Be specific — include the exact price.
Example: "We recommend pricing at $45 per unit."
2. Evidence
Cite at least three numbers from your workbook: projected profit, break-even units, and capacity fit.
Example: "At $45, we project $1,200 monthly profit, break even at 80 units, and stay within our 220-unit capacity."
3. Risk
Explain one weakness or downside case from your sensitivity work.
Example: "If volume drops below 60 units, we lose money. This could happen if a competitor undercuts us."
4. Close
Explain why this option is still the best business choice despite the risk.
Example: "Even with this risk, $45 gives us the best balance of profit and capacity fit compared to lower prices."
Your team must meet all six criteria before the end of class:
- All seven workbook tabs are complete and readable
- TargetProfit sheet shows the price or units needed to hit your target profit
- PriceSensitivity and ProfitMatrix sheets show tested scenarios with clear results
- The Dashboard names one final recommendation with at least three cited workbook numbers
- Your team has written a claim-evidence-risk statement following the structure above
- A peer critique has happened and feedback is recorded with at least one revision made
Exchange workbooks with another team. Review their Dashboard and recommendation statement. Use the form below to give feedback focused on model accuracy, evidence clarity, and presentation readiness. After receiving feedback, make at least one revision before Lesson 10.
PriceLab Workbook Review
Project by Classmate
- Technical Accuracy — 50%: Correct modeling, formulas, validations, and sensitivity analysis
- Strategic Rationale — 20%: Recommendation aligns to business goals and addresses trade-offs
- Communication & Clarity — 15%: Concise story, clear visuals, appropriate for stakeholder audience
- Time Management — 10%: Pacing during presentation, clean transitions between sections
- Q&A Readiness — 5%: Confident, concise responses to stakeholder questions
- Team workbook saved with clear file name following the naming convention
- All seven workbook tabs complete: CostSetup, PriceOptions, Feasibility, TargetProfit, PriceSensitivity, ProfitMatrix, Dashboard
- Dashboard includes recommendation, three cited numbers, and one risk statement
- Claim-evidence-risk statement written and rehearsed
- Peer critique completed with at least one revision made