Capstone · Week 6
Pricing & Forecast
Explore price and volume with a 2‑variable data table. Build a CVP chart that updates when assumptions change.
Quality is judged by the capstone Rubrics.
What to include
Connect model to visuals
- Assumptions table that feeds the data table.
- 2‑variable data table exploring price and volume.
- CVP chart tied to the same cells.
- Short note: your best current price and why.
Excel Requirements
Data tables and chart linkage
- Set up a base case: price, volume, variable cost, fixed cost.
- Create a 2‑variable data table (price as rows, volume as columns) returning profit.
- Build a CVP chart (lines for revenue, total cost, and profit break‑even).
- Ensure both the data table and chart update when base inputs change.
Quality Checks
Readable, defensible pricing work
- Axis labels and units are clear; chart is not cluttered.
- Profit direction makes sense (higher volume improves profit when margin is positive).
- Any “best price” claim is tied to the data table results.
Submission
What to turn in
- Excel file with assumptions, 2‑variable table, and CVP chart.
- Short paragraph (4–6 sentences) on your pricing decision and tradeoffs.