BATCH-2026-NOV14
DAY 03 WORKBENCHZero-Grading Self-Guided Action Plan

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.

Select Practice Day
2/5

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 1

Click the button below to generate a fresh, pre-formulated copy into your personal Google Drive account.

Do not modify column headers in yellow; these link to the automated summary dashboard.

Step 2: Populate Machine Hourly Rate & Overhead Allocations

STEP 2

In Tab 1 ("Machine Cost Center"), input your monthly lease/depreciation and power consumption figures.

Use standard 208 working hours/month per machine shift.

Step 3: Compute Batch Sensitivity Thresholds

STEP 3

In Tab 2 ("Batch Sensitivity"), test run sizes of 50, 200, and 1,000 units to observe setup time amortization.

Notice the steep margin drop on batches under 75 units.

Step 4: Self-Verify Against the Faculty Benchmark Output

STEP 4

Toggle 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 5

Paste 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.