| Quarterly Decisions |
| Plan | Q4'20A | Q1'21 | Q2'21 | Q3'21 | Q4'21 |
| Sales |
| Total Market Demand [Units] | 2,485 | 3,047 | 3,891 | 5,044 | 6,637 |
| Lost Sales [Units] | 0 | 0 | 0 | 0 | 0 |
| Units Sold [Units] | 829 | 1,005 | 1,322 | 1,665 | 2,190 |
| Price [$] | $550.00 | $550.00 | $575.00 | $575.00 | $580.00 |
| Terms [Days] | 60 | 45 | 40 | 40 | 30 |
| Average Collection Period [Days] | 64.4 | 47.0 | 44.0 | 44.0 | 34.0 |
| Production |
| Raw Material On Order [Units] | 1,000 | 900 | 1,825 | 3,550 | 3,000 |
| Units Produced [Units] | 1,166 | 600 | 1,400 | 1,900 | 3,400 |
| Labor Force Hires [People] | 5 | 0 | 10 | 0 | 17 |
| Labor Force Layoffs [People] | 0 | 0 | 0 | 0 | 0 |
| Lines On Order [Units] | 0 | 3 | 3 | 3 | 0 |
| Planned Time | 1.28 | 1.2 | 1.1 | 1 | 0.9 |
| Effectiveness | 85.40% | 96.80% | 72.70% | 90.00% | 92.00% |
| Discretionary Costs |
| Quality Engineering Expense | $42,000.00 | $40,000.00 | $45,000.00 | $90,000.00 | $80,000.00 |
| Research Funding Expense | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Project 01 Funding | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Project 02 Funding | $45,000.00 | $35,000.00 | $0.00 | $0.00 | $0.00 |
| Project 03 Funding | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Inventory Rework Cost | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Marketing Expense | $41,000.00 | $46,000.00 | $72,000.00 | $135,000.00 | $142,000.00 |
| Advertising Expense | $31,000.00 | $28,000.00 | $30,000.00 | $40,000.00 | $25,000.00 |
| Lean Six Sigma Expense | $25,000.00 | $25,000.00 | $32,000.00 | $38,000.00 | $25,000.00 |
| Building Lease and Utilities | $79,953.00 | $70,951.00 | $75,015.00 | $84,293.00 | $87,350.00 |
| Reports |
| Marketing Report |
| Business Intelligence Dashboard |
| Quarterly Decisions |
| Expected OM Levers for Q1'21 * |
| * All Ceteris Paribus |
| * Variable/Base Cost Improvements Imply Cost Reduction |
| ** % Volume Increase Required To Maintain CM $ Facing a 1% Price Reduction |
| *** % Improvement (Decrease) Required To Maintain CM $ Facing a 1% Price Reduction |
kingstonman41
QuarterlyDecisions.xlsx
