Unit Economics & Batch Sensitivity Modeling
Build a dynamic 3-way financial sensitivity model to calculate machine amortized rate, raw material variance, and setup break-even.
Action Steps Progress: 40% Completed
Work through each action item at your own pace. All progress is automatically saved to your profile.
Step 1: Open the Unit Economics Master Model in Google Drive
STEP 1Click the button below to generate a fresh, pre-formulated copy into your personal Google Drive account.
Step 2: Populate Machine Hourly Rate & Overhead Allocations
STEP 2In Tab 1 ("Machine Cost Center"), input your monthly lease/depreciation and power consumption figures.
Step 3: Compute Batch Sensitivity Thresholds
STEP 3In Tab 2 ("Batch Sensitivity"), test run sizes of 50, 200, and 1,000 units to observe setup time amortization.
Step 4: Self-Verify Against the Faculty Benchmark Output
STEP 4Toggle the benchmark drawer below to cross-check your contribution margin formulas and sensitivity charts against our reference solution.
Step 5: Store Your Working Sheet Link for Your Capstone Evaluation
STEP 5Paste your personal Google Sheet link into your repository below. This persists your work for the Day 10 certification.
Save Your Working Google Sheet Link
Paste your working Google Sheet URL here so you can access it easily anytime from any device during your 10-day training.