Research & Development DRAFT SAVED ATAU 40 W COT Perceptual map ( end of this Decisions Name New Pfmn New Size MTBF Revision Date Age at Revision RAD Cost (9000) $0 Art Ate Attic Axe 7.9 10.6 12.7 5.2 0.0 0.0 0.0 0.0 Na 12.2 7.6 9.6 14.9 0.0 0.0 0.0 0.0 22000 24000 26000 20000 0 0 Na Na Na 0 0 Total $0 4 1012 Die 18 18 20 14 Old New Material Cost 30 Age Profiles 100 55 $10 $15 $20 9.0 Art Ale A AME BO Ale Attic Porceived ones Axe Ne NA Marketing DRAFT SAVED AT A 04, 2000 01:30PM COT Marketing Decisions Name Price Promo Budget Sales Budget Benchmark Prediction "Your Sales Forecast "Variable Costs "Less Promo & Sales 32.00 $ 40.00 $ 42.00 $ 26.00 $ o o o o Art Ate Attic Axe NA NA NA NA Total $ $ $ $ $0.0 $0.0 $0.0 $0.0 1200 $ 1200$ 1200 S 1200 $ $0 $0 $0 $0 $ 4,800 1000 1000 1000 2000 $0 $0 $0 $o $ 5,000 1,958 2,045 1,486 769 0 0 0 0 6,258 Gross Revenue Forecast Costs $ 62,658 $ 81,808 $ 62,416 $ 19,988 $0 $0 $0 $ 0 $ 226,870 $ 37,966 $ 52,748 $ 38,112 $ 10,977 $0 $0 $0 $0 $ 139,803 Contrib Margin Forecast $ 24,692 $ 29,060 $ 24,304 $ 9,011 $0 $0 $0 $0 $ 87,067 $ 22,492 $ 26,860 $ 22,104 $ 5,811 $0 $0 $0 $0 $ 77,267 0 30 2.200 Note: The Benchmark Prediction estimates unit sales assuming your product competes with a standardized, mediocre playing field. It does not use your actual competitors products. It is useful for experimenting with price, promo and sales budgets. It is AVR Lag (days) ucelace for forecasting A/P Lag (days) Revenue Forecast Unit Sales Forecast $80,000 2.000 $70,000 1,800 550.000 1 600 $50,000 1,400 $40.000 1,200 1.000 $30.000 300 520,000 600 450 $10.000 200 90 0 Art Ale Alle Axe NA NA NA NA Art Ale Alto Axe Variable costs Marketing Margin At Marketing Ee Nano NA NA NA NA Core That Roca Production DRAFT SAVED AT Aug 04, 2120 01:34PM COT NA NA NA NA Art 1,958 47 1800 1,782 Ate 2,045 264 950 941 Attic 1,486 216 750 743 Axe 769 758 2150 2,129 Total 6,258 1,285 5,650 5,595 - - SCHEDULE Unit Sales Forecast Inventory On Hand Production Schedule Production After Adj. MARGINS 2nd Shift Production% Labor Cost/Unit Material Cost/Unit Total Unit Cost Contribution Margin PHYSICAL PLANT 1st Shift Capacity Buy/Sell Capacity Automation Rating New Autom. Rating Investment (5000) WORKFORCE Complement 50.0% $9.39 $10.00 $19.39 39.4% 30.5% $10.50 $15.29 $25.79 35.5% 5.1% $9.67 $15.98 $25.65 38.9% 90.3% $8.28 $6.00 $14.28 45.1% 0.0% $0.00 $0.00 $0.00 0.0% 0.0% $0.00 $0.00 $0.00 0.0% 0.09 $0.00 $0.00 $0.00 0.0% 0.0% $0.00 $0.00 $0.00 0.0% Total 3,772 0 1,200 0 5.0 5.0 $0 Last Year 804 728 0 4.0 4.0 $0 Needed 804 714 0 4.0 4.0 $0 This Year % 100% 1,130 0 6.0 6.0 $0 This Year 804 $0 1st Shift 552 $0 2nd Shift 252 $0 $0 Overtime Max Invest 0.0% AP Lag $ 0 $ 59,668 30 Production Vs. Capacity 2,500 Both Shis Base Capacity Production Price Vs. Unit Cost 550 Water Man 2,000 540 1,500 530 1.000 $10 500 10 Art Abe NA NA NA Art Ate NA NA NA NA Rece Human Resources DRAFT SAVED ATAU 4.2020 PM COT Staffing Labor Negotiations Current Labor Contract Demands Hourly Wage $25.53 $28.08 Benefits $ 2,500 $ 2,750 Profit Sharing % 2.0% 2.2% Annual Raise 5.0% 5.5% Negotiation Postion Starting Ceiling $25.53 $28.08 $2,500 $2,750 2.0% 2.2% 5.0% 5.5% Contract Expiration: 1-Oct-2024 Needed Complement Complement % Complement 1st Shift Complement 2nd Shift Complement Overtime% Turnover Rate New Employees Separated Employees Recruiting Spend Training Hours Productivity Index Recruiting Cost Separation Cost Training Cost Total HR Admin Costs Last Year This Year 804 804 100% 100% 804 804 525 552 279 252 0.0% 0.0% 10.0% 10.0% 140 80 0 0 $0 $ 0 0 0 100.0% 100.0% $80 $0 $0 $80 Finance DRAFT SAVED AT Aug 04,2020 01:30PM COT Liabilities & Owner's Equity Common Stock $0 $0 Retained Emning Long Term Debit Current Debt Accounts Payable Finances PLANT IMPROVEMENTS Total Investments ($000) Sales Of Plant & Equipment COMMON STOCK Shares Outstanding (000) Price Per Share Earnings Per Share Max Stock Issue (5000) Issue Stock ($000) Max Stock Retire (5000) Retire Stock ($000) Dividend Per Share CURRENT DEBT Interest Rate Due This Year Borrow ($000) CASH POSITIONS December 31, 2019 December 31, 2020 2,051 $95.61 $ 12.32 $ 39,219 0 $ 9,805 0 0.00 $ $ $ $ 0 Long Term Debt Retire Long Term Debt (5000) Issue Long Term Debt (5000) Long Term Interest Rate Maximum Issue This Year $ 10.0% $ 15,717 0 11.4% $ 14,722 30 30 A/R Lag (days) A/P Lag (days) $ $ 32,014 $ 41,547 Outstanding Bonds Series Number Face Amount $0 13.552021 $ 11,300 11.25 2026 $ 8,837 11.952027 $7,072 Current Yield 13.0% 11.39 11.6% 2019 Cose $ 103.58 $ 99.07 $102.54 DRAFT SAVED AT A04,200 TPM COT TQM Initiative Process Management Initiatives Projected Impact Budget (5000) Total Current Expenditures ($000): $0 CPI Systems Vendor/JIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs $ $ $ $ $ OOOOOO PROJECTED CUMULATIVE IMPACTS Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction in Admin Costs Demand increase Worst Case Best Case 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% TQM INITIATIVES Benchmarking Quality Function Deployment Effort CCE/6 Sigma Training GEMI TQEM Sustainability Initiatives $ $ $ S OOOO Reduction in Cost of God For the Year Just Ended Admin Cost Reductions For the Year Just Ended 0% RAD Cycle Time Reductions For the Year Just Ended 04 Demand Increase For the Year Just Ended 09 200 10% TON 50 Andrews Andrews Andrews Batwin Baldwin Baldwin Chester Chester Chester Dihy Digby Digby 0.99 Andrews Baldwin Chester Day Research & Development DRAFT SAVED ATAU 40 W COT Perceptual map ( end of this Decisions Name New Pfmn New Size MTBF Revision Date Age at Revision RAD Cost (9000) $0 Art Ate Attic Axe 7.9 10.6 12.7 5.2 0.0 0.0 0.0 0.0 Na 12.2 7.6 9.6 14.9 0.0 0.0 0.0 0.0 22000 24000 26000 20000 0 0 Na Na Na 0 0 Total $0 4 1012 Die 18 18 20 14 Old New Material Cost 30 Age Profiles 100 55 $10 $15 $20 9.0 Art Ale A AME BO Ale Attic Porceived ones Axe Ne NA Marketing DRAFT SAVED AT A 04, 2000 01:30PM COT Marketing Decisions Name Price Promo Budget Sales Budget Benchmark Prediction "Your Sales Forecast "Variable Costs "Less Promo & Sales 32.00 $ 40.00 $ 42.00 $ 26.00 $ o o o o Art Ate Attic Axe NA NA NA NA Total $ $ $ $ $0.0 $0.0 $0.0 $0.0 1200 $ 1200$ 1200 S 1200 $ $0 $0 $0 $0 $ 4,800 1000 1000 1000 2000 $0 $0 $0 $o $ 5,000 1,958 2,045 1,486 769 0 0 0 0 6,258 Gross Revenue Forecast Costs $ 62,658 $ 81,808 $ 62,416 $ 19,988 $0 $0 $0 $ 0 $ 226,870 $ 37,966 $ 52,748 $ 38,112 $ 10,977 $0 $0 $0 $0 $ 139,803 Contrib Margin Forecast $ 24,692 $ 29,060 $ 24,304 $ 9,011 $0 $0 $0 $0 $ 87,067 $ 22,492 $ 26,860 $ 22,104 $ 5,811 $0 $0 $0 $0 $ 77,267 0 30 2.200 Note: The Benchmark Prediction estimates unit sales assuming your product competes with a standardized, mediocre playing field. It does not use your actual competitors products. It is useful for experimenting with price, promo and sales budgets. It is AVR Lag (days) ucelace for forecasting A/P Lag (days) Revenue Forecast Unit Sales Forecast $80,000 2.000 $70,000 1,800 550.000 1 600 $50,000 1,400 $40.000 1,200 1.000 $30.000 300 520,000 600 450 $10.000 200 90 0 Art Ale Alle Axe NA NA NA NA Art Ale Alto Axe Variable costs Marketing Margin At Marketing Ee Nano NA NA NA NA Core That Roca Production DRAFT SAVED AT Aug 04, 2120 01:34PM COT NA NA NA NA Art 1,958 47 1800 1,782 Ate 2,045 264 950 941 Attic 1,486 216 750 743 Axe 769 758 2150 2,129 Total 6,258 1,285 5,650 5,595 - - SCHEDULE Unit Sales Forecast Inventory On Hand Production Schedule Production After Adj. MARGINS 2nd Shift Production% Labor Cost/Unit Material Cost/Unit Total Unit Cost Contribution Margin PHYSICAL PLANT 1st Shift Capacity Buy/Sell Capacity Automation Rating New Autom. Rating Investment (5000) WORKFORCE Complement 50.0% $9.39 $10.00 $19.39 39.4% 30.5% $10.50 $15.29 $25.79 35.5% 5.1% $9.67 $15.98 $25.65 38.9% 90.3% $8.28 $6.00 $14.28 45.1% 0.0% $0.00 $0.00 $0.00 0.0% 0.0% $0.00 $0.00 $0.00 0.0% 0.09 $0.00 $0.00 $0.00 0.0% 0.0% $0.00 $0.00 $0.00 0.0% Total 3,772 0 1,200 0 5.0 5.0 $0 Last Year 804 728 0 4.0 4.0 $0 Needed 804 714 0 4.0 4.0 $0 This Year % 100% 1,130 0 6.0 6.0 $0 This Year 804 $0 1st Shift 552 $0 2nd Shift 252 $0 $0 Overtime Max Invest 0.0% AP Lag $ 0 $ 59,668 30 Production Vs. Capacity 2,500 Both Shis Base Capacity Production Price Vs. Unit Cost 550 Water Man 2,000 540 1,500 530 1.000 $10 500 10 Art Abe NA NA NA Art Ate NA NA NA NA Rece Human Resources DRAFT SAVED ATAU 4.2020 PM COT Staffing Labor Negotiations Current Labor Contract Demands Hourly Wage $25.53 $28.08 Benefits $ 2,500 $ 2,750 Profit Sharing % 2.0% 2.2% Annual Raise 5.0% 5.5% Negotiation Postion Starting Ceiling $25.53 $28.08 $2,500 $2,750 2.0% 2.2% 5.0% 5.5% Contract Expiration: 1-Oct-2024 Needed Complement Complement % Complement 1st Shift Complement 2nd Shift Complement Overtime% Turnover Rate New Employees Separated Employees Recruiting Spend Training Hours Productivity Index Recruiting Cost Separation Cost Training Cost Total HR Admin Costs Last Year This Year 804 804 100% 100% 804 804 525 552 279 252 0.0% 0.0% 10.0% 10.0% 140 80 0 0 $0 $ 0 0 0 100.0% 100.0% $80 $0 $0 $80 Finance DRAFT SAVED AT Aug 04,2020 01:30PM COT Liabilities & Owner's Equity Common Stock $0 $0 Retained Emning Long Term Debit Current Debt Accounts Payable Finances PLANT IMPROVEMENTS Total Investments ($000) Sales Of Plant & Equipment COMMON STOCK Shares Outstanding (000) Price Per Share Earnings Per Share Max Stock Issue (5000) Issue Stock ($000) Max Stock Retire (5000) Retire Stock ($000) Dividend Per Share CURRENT DEBT Interest Rate Due This Year Borrow ($000) CASH POSITIONS December 31, 2019 December 31, 2020 2,051 $95.61 $ 12.32 $ 39,219 0 $ 9,805 0 0.00 $ $ $ $ 0 Long Term Debt Retire Long Term Debt (5000) Issue Long Term Debt (5000) Long Term Interest Rate Maximum Issue This Year $ 10.0% $ 15,717 0 11.4% $ 14,722 30 30 A/R Lag (days) A/P Lag (days) $ $ 32,014 $ 41,547 Outstanding Bonds Series Number Face Amount $0 13.552021 $ 11,300 11.25 2026 $ 8,837 11.952027 $7,072 Current Yield 13.0% 11.39 11.6% 2019 Cose $ 103.58 $ 99.07 $102.54 DRAFT SAVED AT A04,200 TPM COT TQM Initiative Process Management Initiatives Projected Impact Budget (5000) Total Current Expenditures ($000): $0 CPI Systems Vendor/JIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs $ $ $ $ $ OOOOOO PROJECTED CUMULATIVE IMPACTS Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction in Admin Costs Demand increase Worst Case Best Case 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% TQM INITIATIVES Benchmarking Quality Function Deployment Effort CCE/6 Sigma Training GEMI TQEM Sustainability Initiatives $ $ $ S OOOO Reduction in Cost of God For the Year Just Ended Admin Cost Reductions For the Year Just Ended 0% RAD Cycle Time Reductions For the Year Just Ended 04 Demand Increase For the Year Just Ended 09 200 10% TON 50 Andrews Andrews Andrews Batwin Baldwin Baldwin Chester Chester Chester Dihy Digby Digby 0.99 Andrews Baldwin Chester Day