# CFO Training Guide: Unified Forecaster System
**Updated December 2025 | M1 ERP System**

## Executive Summary

The **Forecaster** is your unified strategic planning system combining equipment capacity planning with product-level financial projections. It provides capacity-constrained forecasts that answer critical CFO questions:

- 📊 **When will we hit capacity limits?**
- 💰 **What CapEx investments do we need?**
- 🎯 **What's our true profitability by business line?**
- 📈 **How do different scenarios impact cash flow?**

---

## What's New (December 2025 Updates)

### 1. **Unified Command Center**
- **Single dashboard** with tabs for Equipment Line and Product Line overviews
- Real-time KPIs: 30-day revenue, margins, break-even status, cash runway
- Critical alerts automatically displayed
- Quick access to all forecasting tools

### 2. **Unified Generate Projections**
- **One page** with tabs for both Equipment Line and Product Line generation
- No more switching between pages
- Default opens to Equipment Line (strategic view first)

### 3. **Clean, Consistent UI**
- Dark theme support throughout
- Consistent card styling with corner decorations
- Improved table headers (white on dark)
- Better spacing and readability

### 4. **Updated Menu Structure**
Organized into logical groups:
- **Quick Start** (Getting Started, Command Center)
- **Daily Operations** (Daily Update, Assumption Sets, Variance)
- **Equipment Line Forecasting** (Business Lines, Capacity, Cost Allocation)
- **Product Line Forecasting** (Product Configs)
- **Reports & Analysis** (Pro Forma, Sensitivity, Compare)
- **Advanced Tools** (Scenario Modeler, Profit Optimizer)

---

## System Architecture: How It All Fits Together

```
┌─────────────────────────────────────────────────────────┐
│                   COMMAND CENTER                         │
│          (Your Daily Starting Point)                     │
│   • Equipment Line Overview Tab                          │
│   • Product Line Overview Tab                            │
│   • Real-time alerts & KPIs                             │
└─────────────────────────────────────────────────────────┘
                            ↓
        ┌───────────────────┴───────────────────┐
        ↓                                       ↓
┌──────────────────┐                  ┌──────────────────┐
│ DAILY OPERATIONS │                  │  STRATEGIC       │
│                  │                  │  PLANNING        │
│ • Daily Update   │                  │                  │
│ • Variance Track │                  │ • Generate       │
│ • Assumption Sets│                  │   Projections    │
└──────────────────┘                  │ • Capacity       │
        ↓                              │   Analysis       │
        └──────────────┬───────────────┤ • Business Line  │
                       ↓               │   Rollup         │
               ┌───────────────┐       └──────────────────┘
               │  DATA LAYER   │                ↓
               │               │       ┌──────────────────┐
               │ • Products    │       │  REPORTS &       │
               │ • Equipment   │       │  ANALYSIS        │
               │ • Locations   │       │                  │
               │ • Assumptions │       │ • Pro Forma      │
               └───────────────┘       │ • Sensitivity    │
                                      │ • Compare        │
                                      └──────────────────┘
```

---

## Your First Week: Getting Started

### Day 1: Orientation (30 minutes)

**Morning: Tour the Command Center**

1. Navigate to **Forecaster → Command Center**
2. Review the two tabs:
   - **Equipment Line Overview**: Capacity stats, equipment by business line
   - **Product Line Overview**: Revenue KPIs, margins, cash runway, alerts

**What to Look For:**
- Total equipment lines and configuration status
- 30-day revenue projections
- Gross margin % (compare to target)
- Break-even status (safe/warning)
- Cash runway in months
- Critical alerts (low cash, capacity issues, etc.)

**Action:** Take a screenshot for your reference

### Day 2: Setup Equipment Lines (45 minutes)

**Configure Your Equipment**

1. Navigate to **Forecaster → Equipment Line Forecasting** (menu section header)
2. You'll see your equipment already listed (pulled from Equipment master data)
3. For each critical equipment line:
   - Click **Configure**
   - Fill in:
     - **Max capacity** (units/year)
     - **Cycle time** (hours per unit)
     - **Labor cost** per unit
     - **Power cost** per unit
     - **Monthly lease cost**
   - Save

**Start Simple:** Just configure your top 3 bottleneck lines. You can add more later.

**Tip:** Click "Auto-Configure All" if you want the system to populate reasonable defaults based on historical data.

### Day 3: Setup Product Configurations (30 minutes)

**Link Products to Equipment**

1. Navigate to **Forecaster → Product Configs**
2. Select your assumption set (or create "Baseline" if first time)
3. For each key product:
   - Set **growth rate** (annual %)
   - Set **lifecycle stage** (Introduction, Growth, Maturity, Decline)
   - Link to **equipment line** (which line produces it)
   - Set **production time** per unit
   - Add **seasonality factors** if applicable

**Quick Path:** Click "Auto-Configure All" to populate defaults, then refine the top 10 revenue products.

### Day 4: Generate Your First Projections (20 minutes)

**Run Both Equipment and Product Forecasts**

1. Navigate to **Forecaster → Generate Projections**
2. **Equipment Line Tab** (default):
   - Set forecast horizon: **5 years**
   - Select allocation method: **Hybrid** (recommended)
   - Choose scenario name: "Base Case Q4 2025"
   - Click **Generate Equipment Projections**
3. **Product Line Tab**:
   - Select assumption set: "Baseline"
   - Set start date: Today
   - Set end date: +12 months
   - Period type: **Monthly**
   - Click **Generate Product Projections**

**Result:** System redirects to Command Center showing your new projections

### Day 5: Review & Understand (45 minutes)

**Explore the Results**

1. **Command Center** - See high-level summary
2. **Business Line Rollup** - P&L by business unit
   - Revenue breakdown by line
   - Utilization % for each line
   - Operating margins
3. **Capacity Analysis** - Bottleneck identification
   - Lines over 85% utilization (red alerts)
   - CapEx recommendations
   - Timeline of when you'll hit capacity
4. **Pro Forma Statements** - Full financial projections
   - Income Statement (monthly/quarterly)
   - Break-even analysis
   - Product performance breakdown

---

## Your Daily/Weekly/Monthly Routine

### Daily (5 minutes)

**Every Morning: Update Assumptions**

1. Navigate to **Forecaster → Daily Update**
2. Quick-edit any changes:
   - Product prices
   - Expected volumes
   - Cost changes
   - Market conditions
3. System auto-saves and tracks changes

**Why Daily?** Keeps forecasts current with real-time market conditions.

### Weekly (15 minutes)

**Every Friday: Variance Review**

1. Navigate to **Forecaster → Variance Tracking**
2. Compare actual sales vs. projected sales
3. Review variance by product:
   - Green: Within 5% of forecast ✅
   - Yellow: 5-15% variance ⚠️
   - Red: >15% variance ❌
4. Adjust assumptions for consistently over/under-performing products

**Why Weekly?** Improves forecast accuracy over time by learning from variances.

### Monthly (30 minutes)

**First Friday of Month: Strategic Review**

1. **Regenerate Projections** (5 min)
   - Go to Generate Projections
   - Run both Equipment and Product tabs
   - Uses all your updated daily assumptions

2. **Review Command Center** (10 min)
   - Check 30-day revenue trend
   - Monitor margin changes
   - Review cash runway
   - Address any new alerts

3. **Check Capacity Analysis** (10 min)
   - Monitor utilization trends
   - Note any lines approaching 85%+
   - Plan CapEx if needed (6-12 months ahead)

4. **Export for Board** (5 min)
   - Screenshot Command Center KPIs
   - Export Pro Forma to Excel
   - Save Capacity Analysis charts

**Why Monthly?** Keeps strategic view current and identifies capacity needs early.

---

## Understanding the Key Pages

### 1. Command Center (Your Dashboard)

**Purpose:** Daily health check of the business

**Equipment Line Overview Tab:**
- Total equipment lines and configuration status
- Equipment grouped by business line
- Utilization rates
- Quick actions (generate projections, capacity analysis, etc.)

**Product Line Overview Tab:**
- 30-day revenue projection
- Gross margin % vs. target
- Break-even status
- Cash runway (months)
- Critical alerts
- Top 10 products by revenue
- Revenue trend chart (90 days)

**When to Use:** Every morning as your starting point

### 2. Generate Projections (Unified)

**Purpose:** Create new forecasts

**Equipment Line Tab:**
- Strategic, long-term view (1-5 years)
- Capacity-constrained projections
- Business line rollup
- CapEx planning

**Product Line Tab:**
- Tactical, detailed view (3-12 months)
- Product-by-product projections
- Working capital impact
- Cash flow timing

**When to Use:**
- Monthly after updating assumptions
- Before board meetings
- When creating new scenarios

### 3. Business Line Rollup

**Purpose:** P&L by business unit

**Shows:**
- Revenue by business line
- Full cost allocation (direct + overhead)
- EBITDA by line
- Utilization rates
- Capacity constraints impact

**When to Use:**
- Monthly strategic review
- Board presentations
- Evaluating business unit performance

### 4. Capacity Analysis

**Purpose:** Identify bottlenecks and CapEx needs

**Shows:**
- Utilization % by equipment line
- Red flags (>85% utilization)
- Timeline of capacity constraints
- CapEx recommendations with ROI
- Lost revenue from capacity limits

**When to Use:**
- Monthly capacity review
- Annual CapEx budgeting
- When considering growth initiatives

### 5. Pro Forma Statements

**Purpose:** Complete financial projections

**Shows:**
- Income Statement (Revenue → Net Income)
- Monthly/Quarterly/Annual views
- Break-even analysis
- Product breakdown
- Export to Excel (4-tab workbook)

**When to Use:**
- Board meetings
- Investor presentations
- Banking relationships
- Strategic planning sessions

### 6. Sensitivity Analysis

**Purpose:** "What-if" scenario testing

**Shows:**
- Interactive sliders for key assumptions
- Real-time impact on revenue/margins
- Best/Base/Worst case scenarios
- Tornado charts showing sensitivity

**When to Use:**
- Risk analysis
- Board "what-if" questions
- Stress testing assumptions

### 7. Compare Scenarios

**Purpose:** Side-by-side comparison

**Shows:**
- Multiple assumption sets compared
- Revenue/margin/cash flow differences
- Identify optimal scenario
- Export comparison report

**When to Use:**
- Deciding between strategies
- Board decision support
- Annual planning

---

## Common Scenarios & How to Use the System

### Scenario 1: Board Asks "When Will We Need More Capacity?"

**Your Answer in 10 Minutes:**

1. Go to **Capacity Analysis**
2. Look at utilization trend chart
3. Identify lines crossing 85% threshold
4. Note the **month/quarter** when it happens
5. Review CapEx recommendations
6. Screenshot and present

**Example Answer:**
> "Our Prismatic Assembly line will hit 85% capacity in Q2 2026. We need to invest $2M in a second line by Q4 2025 to avoid losing $5M in revenue."

### Scenario 2: CEO Asks "What If We Grow 20% Instead of 10%?"

**Your Answer in 5 Minutes:**

1. Go to **Daily Update**
2. Clone current assumption set → "Aggressive Growth"
3. Change product growth rates from 10% to 20%
4. Go to **Generate Projections** → Run both tabs
5. Go to **Compare Scenarios**
6. Select "Baseline" vs "Aggressive Growth"
7. Export comparison report

**Shows:**
- Revenue impact: +$X million
- Capacity impact: Need equipment by [date]
- Margin impact: +/- X%
- Cash flow impact: Working capital needs

### Scenario 3: Investor Asks "What's Your Break-Even?"

**Your Answer in 2 Minutes:**

1. Go to **Command Center → Product Line Overview**
2. Look at **Break-Even Status** KPI card
3. Shows: X% above/below break-even
4. Go to **Pro Forma Statements**
5. Scroll to **Break-Even Analysis** card
6. Shows:
   - Break-even revenue: $X
   - Actual revenue: $Y
   - Revenue gap: $Z
   - Status: Profitable / Below Break-Even

**Done.** Screenshot and send.

### Scenario 4: Month-End Close Shows Variance

**Your Response (Weekly Process):**

1. Go to **Variance Tracking**
2. Filter to products with >15% variance (red)
3. For each:
   - Review actual vs. projected
   - Identify reason (seasonality, market, one-time event)
   - Adjust forecast assumptions if persistent
4. Go to **Daily Update**
5. Update affected product growth rates
6. Regenerate projections next month

**Why This Matters:** Improves forecast accuracy over time. After 3-6 months, your forecasts should be within 5-10% consistently.

---

## Advanced Features (When You're Ready)

### Product Distribution (Equipment Lines)

**Purpose:** Allocate products across multiple equipment lines

**Use Case:** A product can be made on Line A or Line B. System optimizes allocation based on:
- Available capacity
- Cost per unit
- Cycle time

**When to Use:** Complex manufacturing with flexible routing

### Cost Allocation Methods

**Purpose:** Choose how overhead is allocated to products

**5 Methods Available:**
1. **Hybrid** (Recommended) - Blended approach
2. **Revenue-Based** - Based on revenue contribution
3. **Unit-Based** - Based on unit volume
4. **Space-Based** - Based on floor space used
5. **Fixed Percentage** - Equal allocation

**When to Use:** Analyzing true product profitability, transfer pricing, make-vs-buy decisions

### Scenario Modeler (Advanced Tools)

**Purpose:** Complex financing scenarios with debt/equity instruments

**Features:**
- Multiple financing sources
- Debt schedules with amortization
- Equity rounds with dilution
- Covenant tracking
- Cash flow waterfall

**When to Use:**
- Raising capital
- Complex financing structures
- Board-level strategic decisions

---

## Best Practices

### 1. Start Simple, Build Complexity

**Week 1:** Just get data in
- Auto-configure everything
- Generate first projections
- Review results

**Month 1:** Refine top items
- Focus on top 10 products
- Configure top 3 equipment lines
- Monthly regeneration routine

**Quarter 1:** Add sophistication
- Multiple scenarios
- Sensitivity analysis
- Variance tracking

### 2. Make It a Habit

**Daily:** 5-minute assumption update
**Weekly:** 15-minute variance review
**Monthly:** 30-minute strategic review
**Quarterly:** 2-hour board prep

### 3. Trust the Data, But Verify

- **Sanity check** first projections against historical
- **Adjust assumptions** if results seem off
- **Iterate** - It gets better with use

### 4. Use Scenarios for Decisions

Don't just forecast one future. Create:
- **Base Case** (most likely)
- **Optimistic** (if things go well)
- **Pessimistic** (if market softens)

Then make decisions that work in **all three** scenarios.

### 5. Communicate Capacity Constraints Early

The #1 benefit of this system: **Early warning of capacity issues**

When you see a line approaching 85% utilization:
- Alert COO immediately
- Start CapEx process (6-12 months lead time)
- Update board on timeline and investment needed

---

## Quick Reference Card

### Most Common Tasks

| Task | Navigation | Time |
|------|-----------|------|
| Daily health check | Command Center | 2 min |
| Update assumptions | Daily Update | 5 min |
| Generate new forecast | Generate Projections | 5 min |
| Check capacity | Capacity Analysis | 3 min |
| Board prep | Pro Forma → Export Excel | 10 min |
| What-if analysis | Sensitivity Analysis | 5 min |
| Compare scenarios | Compare Scenarios | 5 min |
| Variance review | Variance Tracking | 10 min |

### Key KPIs to Monitor

**Daily:**
- Command Center alerts (red flags)

**Weekly:**
- Variance % (target: <10%)
- Top product performance

**Monthly:**
- 30-day revenue trend
- Gross margin %
- Equipment utilization %
- Cash runway (months)

**Quarterly:**
- Break-even status
- Capacity timeline (when do we hit limits?)
- CapEx needs (6-12 months out)

---

## Getting Help

### In-System Help

1. **Getting Started Page** - Overview of system
2. **Help Cards** - On each major page (right sidebar)
3. **Tooltips** - Hover over (?) icons

### Training Resources

1. This guide (print or bookmark)
2. Equipment Line Forecasting Guide (detailed technical doc)
3. Implementation team (for setup questions)

### Common Questions

**Q: How often should I regenerate projections?**
A: Monthly, after updating assumptions. More frequently if major changes occur.

**Q: How far out should I forecast?**
A: Equipment Lines: 3-5 years (strategic). Product Lines: 3-12 months (tactical).

**Q: What if my variances are consistently high (>15%)?**
A: Normal in first 3 months. Review assumptions, adjust growth rates, consider seasonality factors.

**Q: How do I present this to the board?**
A: Export Pro Forma to Excel. Include Capacity Analysis chart. Highlight key alerts from Command Center.

**Q: What's the difference between Equipment and Product forecasting?**
A: Equipment = Strategic, capacity-focused, 3-5 years. Product = Tactical, detailed, 3-12 months. Both feed into Pro Forma.

**Q: Can I delete old projections?**
A: System replaces old projections when you generate new ones. Keep different scenarios in separate assumption sets.

---

## Success Metrics (Your First 90 Days)

### Month 1: Learning
- ✅ Command Center is your daily starting page
- ✅ You've generated projections at least twice
- ✅ You understand the Business Line Rollup
- ✅ You've identified your top capacity bottleneck

### Month 2: Refining
- ✅ Variance tracking is part of your weekly routine
- ✅ You've adjusted assumptions based on actuals
- ✅ You're comfortable with Generate Projections page
- ✅ You've presented one forecast to leadership

### Month 3: Mastery
- ✅ You have 2-3 scenarios running (Base, Optimistic, Pessimistic)
- ✅ Your variance is consistently <15%
- ✅ You've used Sensitivity Analysis to answer a "what-if"
- ✅ Board presentations include Capacity Analysis
- ✅ You've identified CapEx needs 6+ months in advance

**When you hit these milestones, you're no longer learning the system—you're using it to make better decisions.**

---

## Conclusion

The Forecaster is not just a forecasting tool. It's a **strategic decision-support system** that:

1. ✅ Tells you when you'll hit capacity limits (before it's too late)
2. ✅ Quantifies CapEx needs with data-backed justification
3. ✅ Shows true profitability by business line
4. ✅ Provides board-ready financial projections
5. ✅ Enables scenario-based decision making

**Your Action Items:**
1. [ ] Bookmark Command Center as your daily starting page
2. [ ] Schedule 5 minutes every morning for Daily Update
3. [ ] Set calendar reminder for monthly projection regeneration
4. [ ] Create your first 3 scenarios (Base, Optimistic, Pessimistic)
5. [ ] Print this guide and keep it handy for first month

**Remember:** The system gets better with use. The more you update assumptions based on actuals, the more accurate your forecasts become. Within 90 days, you'll wonder how you made strategic decisions without it.

---

**Questions or Issues?**
Contact your implementation team or refer to the detailed technical documentation in the system docs folder.

**Document Version:** 2.0 (December 2025)
**Last Updated:** December 23, 2025