I am unsure how to fill out the charts please help. The first 6 charts. Wherever there are green boxes is where numbers are inserted. The reat of the charts are there to help.

Please let me know if you need more information.

Racalculate Research & Development DRAFT SAVED AT Jul 20, 2020 05:47PM EDT Perceptual map (at end of this year) Decisions Name New Pfmn New Size MTBF Revision Date Age at Revision 18 R&D Cost ($000) $0 $0 16 14 Attic Axe Art Ant NA NA NA NA 13.3 10.6 6.0 8.0 0.0 Attic 6.7 9.4 12.1 14.2 0.0 0.0 0.0 0.0 20000 22000 24000 26000 0 12 $0 $0 $0 Axe 10 0.0 0 $0 Ant 0.0 0 $0 0.0 0 $0 Art Total $0 Performance 18 19 20 0 2 4 6 8 10 12 13 14 15 16 Material Cost I Old New Age Profiles 10.0 SO $5 $10 $15 $20 9.0 Attic 8.0 Attic Axe Art Ant #NA NA +NA NA Axe- 7.0- Art 6.0- Perceived Age in Years 5.0 Ant 4.01 NAH 3.0 NA- 2.0 NA- 1.0 NA- 0.0 Recalculate Marketing DRAFT SAVED AT Jul 20, 2020 07:12PM EDT Marketing Decisions Name Price Promo Budget Sales Budget Benchmark Prediction Your Sales Forecast Variable Costs Contrib Margin Forecast Less Promo & Sales 26.00 $ 32.00 $ 40.00 $ 42.00 $ 0 0 0 0 Attic Axe Art Ant NA NA NA NA Total $ $ $ $ $0.0 $0.0 $0.0 $0.0 1200 1200 $ 1200 $ 1200 $ $ 0 $ 0 $ 0 $ 0 $ 4,800 2000 1000 1000 1000 $ 0 $ 0 $ 0 $ 0 $ 5,000 769 1,958 2,045 1,486 0 0 0 0 6,258 Gross Revenue Forecast Costs $ 19,988 $ 62,658 $ 81,808 $ 62,416 $ 0 $ 0 $ 0 $ 0 $ 226,870 $ 10,977 $ 37,966 $ 52,748 $ 38,112 $ 0 $ 0 $ 0 $0 $ 139,803 $ 9,011 $ 24,692 $ 29,060 $ 24,304 $ 0 $ 0 $ 0 $ 0 $ 87,067 $ 5,811 $ 22,492 $ 26,860 $ 22,104 $ 0 $ 0 $ 0 $0 $ 77,267 0 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 useless for forecasting. A/R Lag (days) A/P Lag (days) 30 30 Revenue Forecast $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 SO Unit Sales Forecast 2,200 2,000 1,800 1,600 1,400 1,200 1,000 800 600 400 200 0 Attic Axe Attic Axe Art Ant NA NA NA NA Art Ant NA NA NA NA Variable Costs Marketing Margin After Marketing Elite Nano Core Thrift Recalculate Production DRAFT SAVED AT Jul 20, 2020 07:12PM EDT NA NA NA NA Attic 769 758 2150 2,129 Axe 1,958 47 1800 1,782 Art 2,045 264 950 941 Ant 1,486 216 750 743 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 ($000) WORKFORCE Complement 90.3% $8.28 $6.00 $14.28 45.1% 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% 0.0% $0.00 $0.00 $0.00 0.0% 0.0% $0.00 $0.00 $0.00 0.0% 0.0% $0.00 $0.00 $0.00 0.0% 0.0% $0.00 $0.00 $0.00 0.0% Total 3,772 0 1,130 0 6.0 6.0 $ 0 Last Year 804 1,200 0 5.0 5.0 $ 0 Needed 804 728 0 4.0 4.0 $ 0 This Year % 100% 714 0 4.0 4.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 Both Shifts Production Vs. Capacity 2,500 Base Capacity Production Material Labor Margin Price Vs. Unit Cost $50 $40 2,000 $30 1,500 $20 1,000 $10 500 $0 Attic Axe Art Ant NA NA NA NA 0 Attic Axe Art Ant NA NA NA NA Recalculate Human Resources DRAFT SAVED AT Jul 20, 2020 07:12PM EDT Staffing Labor Negotiations Current Contract Hourly Wage $ 25.53 Benefits $ 2,500 Profit Sharing % 2.0% Annual Raise 5.0% Labor Demands $ 28.08 $ 2,750 2.2% 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 100.0% 100.0% $80 $0 $0 $80 0 Recalculate Finance DRAFT SAVED AT Jul 20, 2020 07:13PM EDT Liabilities & Owner's Equity Common Stock $0 $0 Retained Earnings Long Term Debt 2,051 $ 95.61 $ 12.32 $ 39,219 0 $ 9,805 0 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 ($000) 'Issue Stock ($000) Max Stock Retire ($000) Retire Stock ($000) Dividend Per Share CURRENT DEBT Interest Rate Due This Year Borrow ($000) CASH POSITIONS December 31, 2019 December 31, 2020 $ $ $ 0.00 Long Term Debt Retire Long Term Debt ($000) Issue Long Term Debt ($000) Long Term Interest Rate Maximum Issue This Year 10.0% $ 15,717 0 0 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.5S2021 $ 11,300 11.252026 $ 8,837 11.952027 $ 7,072 Current Yield 13.0% 11.3% 11.6% 2019 Close $ 103.58 $ 99.07 $ 102.54 Recalculate TQM Initiative DRAFT SAVED AT Jul 20, 2020 07:13PM EDT Process Management Initiatives Projected Impact Total Current Expenditures ($000): $ 0 CPI Systems "Vendor/JIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs Budget ($000) $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 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 0 0 $ $ $ $ 0 Reduction in Cost of Goodsterial For the Year Just Ended Admin Cost Reductions For the Year Just Ended R&D Cycle Time Reductions For the Year Just Ended Demand Increase For the Year Just Ended 1.0% 0% 209 0% 10 0% 594 Andrews Andrews Andrews Baldwin Baldwin Baldwin 0.5% Chester Chester Chester Digby Digby Digby 0.0% Andrews Baldwin Chester Digby Proforma Balance Sheet DRAFT SAVED AT Jul 20, 2020 07:14PM EDT $ 41,547 $ 13,725 $ 31,387 Assets CURRENT ASSETS Cash Accts Receivable Inventories Total Current Assets FIXED ASSETS Plant & Equipment Accum. Deprec. Total Fixed Assets TOTAL ASSETS 31.3% 10.3% 23.7% 65.3% Liabilities & Owner's Equity LIABILITIES Accts Payable Current Borrowing Emergency Loan Maturing L.T. Debt Long Term Debt Total Liabilities OWNER'S EQUITY Common Stock Retained Earn. Total Equity TOTAL LIAB. & O.E. $ 8,899 $ 0 $ 0 $ 0 $ 27,209 6.7% 0.0% 0.0% 0.0% 20.5% 27.2% $ 86,659 $ 36,108 $ 96,824 ($ 50,865) 73.0% (38.4%) 34.7% 100.0% $ 45,959 $ 132,619 $ 12,081 $ 84,431 9.1% 63.7% 72.8% 100.0% $ 96,512 $ 132,619 Assets Liabilities & Owner's Equity Inventories Common Stock Fixed Accounts Receiv Retained Earnings Long Term Debt Current Debt Accounts Payable Cash Accounts Receivable O Long Term Debt Cash 0 Inventories Accounts Payable Common Stock Current Debt Retained Earnings O Fixed Proforma Income Statement DRAFT SAVED AT Jul 20, 2020 07:14PM EDT Attic NA NA NA NA Axe $ 58,540 $ 19,988 Art $ 48,190 Ant $ 40,266 $0 $ 0 0.0% 100.0% $0 $ 0 TOTAL $ 166,984 Income Statement REVENUE Sales VARIABLE COSTS Direct Labor Direct Material Inventory Carry Total Variable Costs Contribution margin PERIOD COSTS Depreciation SG&A: R&D Promotion Sales Admin Total Period Costs Net Margin $ 6,604 $ 4,787 $ 3,766 $ 15,157 $ 4,831 $ 17,211 $ 18,333 $ 0 $ 35,544 $ 22,997 $ 12,654 $ 18,417 $ 0 $ 31,071 $ 17,119 $ 0 $ 0 $0 $0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $0 $0 $0 $0 $0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 45,777 $ 56,924 $ 3,766 $ 106,467 $ 60,517 27.4% 34.1% 2.3% 63.8% 36.2% $ 2,260 $ 0 $ 1,200 $ 2,000 $ 150 $ 5,610 ($ 779) $ 2,080 $ 0 $ 1,200 $ 1,000 $ 438 $ 4,718 $ 18,279 $ 1,068 $0 $ 1,200 $ 1,000 $361 $ 3,628 $ 13,491 $ 9,308 $ 15,388 $ 0 $ 24,696 $ 15,571 $ 1,047 $ 0 $ 1,200 $ 1,000 $ 301 $ 3,548 $ 12,022 $0 $ 0 $0 $0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $0 $ 0 $ 0 $ 0 $0 $ 0 $ 0 $0 $ 0 OTHER (FEES, WRITE OFFS, TQM) EBIT Interest Taxes Profit Sharing Net Profit $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 6,455 $0 $ 4,800 $ 5,000 $ 1,249 $ 17,504 $ 43,013 $ 0 $ 43,013 $ 3,357 $ 13,880 $ 516 $ 25,261 3.9% 0.0% 2.9% 3.0% 0.7% 10.5% 25.8% 0.0% 25.8% 2.0% 8.3% 0.3% 15.1% $60,000 $55,000 $50,000 $45,000 $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 SO $5,000 Labor Material Inventory Carrying Costs Depreciation Research & Development Marketing Administrative / Other Net Margin Attic Axe Art Ant NA NA NA NA Proforma Cash Flow DRAFT SAVED AT Jul 20, 2020 07:14PM EDT $40,000 Cash Flow from Operations $30,000 $ 25,261 $ 6,455 ($ 617) ($ 5,562) ($ 286) $20,000 Net Income (Loss) Depreciation O Accounts Payable O Inventories Accounts Receivable ONet Cash Flow $10,000 $ 25,250 SO $ 0 -$10,000 Cash Flows from Operations Net income(loss) Depreciation & Writeoffs Change in accounts payable Change in inventory Change in accounts receivable Net cash from operations Cash Flows from Investing Cash Flow From Financing Cash Flow From Financing Dividends paid Sales of common stock Purchase of common stock Increase long term debt Retire Long Term Debt Change current debt (net) Net cash from financial actions Net change in cash position Starting cash position Closing cash position Cash Flow from Investing $0 $ 0 $ 0 $ 0 $ 0 ($ 15,717) Plant Improvements Net Cash Flow SO ($ 15,717) $ 9,533 $ 32,014 $ 41,547 Cash Flow from Finance -$2,000 -$4,000 $25,000 Cash Flow Summary $20,000 $15,000 $10,000 Cash Flow from Operations $5,000 Cash Flow from Investing Cash Flow from Financial Actions Net Change in Cash Position$5,000 -$10,000 -$15,000 Dividends Sales of Stock Purchase of Stock New Long Term Debt Retire Long Term Debt Change Current Debt Net Cash Flow -$6,000 -$8,000 -$10,000 -$12,000 -$14,000 Proforma Financial Ratios DRAFT SAVED AT Jul 20, 2020 07:14PM EDT Ratios Return On Sales (ROS) or "Profitability" = Profit/Sales Asset Turnover or "Turnover" = Sales/Assets Return On Assets (ROA) = Profitability * Turnover Leverage = Assets/Equity Return on Equity (ROE) = Profit/Equity Free Cash Flow = Cash Flow From Ops - Capital Expenditures Working Capital = Current Assets - Current Liabilities Days of Working Capital = Working Capital Projected Stock Price Market Capitialization ($M) = Stock Price * Shares Outstanding Book Value Per Share = Equity/Shares Outstanding Price Earnings Ratio (P/E) = Stock Price /EPS Market/Book Ratio = Stock Price/ EPS Dividend Yield = Dividend Per Share / Stock Price Dividend Payout Ratio = Dividend Per Share / EPS 15.1% 1.3 19.0% 1.4 26.2% $ 25,250 $ 77,761 170 $110.16 $ 226 $ 47.06 8.9 2.3 0.0% 0.0% ROS Asset Turnover Leverage ROE 16% 2.0 14% 12% 1.5 10% 8% 1.4 1.3 1.2 1.1 1.0 0.9 0.8 0.7 0.6 0.5 0.4 0.3 0.2 0.1 0.0 1.0 28% 26% 24% 22% 20% 18% 16% 14% 12% 10% 8% 6% 4% 2% 0% 6% 4% 0.5 2% 0% 0.0 COMP-XM Financial Summary INQUIRER Round: 0 December 31, 2019 Andrews Baldwin Chester Digby $20,172 $10,723 $7,540 $10,177 Cash Flow Statement Survey Cash flows from operating activities Net Income (Loss) Adjustment for non-cash items: Depreciation Extraordinary gains/losses/writeoffs Changes in current assets and liabilities: Accounts payable Inventory Accounts receivable Net cash from operations $6,455 $0 $5,625 $0 $9,527 $0 $8,293 $0 $735 ($11,210) $15 $16,168 $1,216 ($2,062) ($1,778) $13,725 $1.457 ($2,615) ($1,043) $14,864 $608 $1,388 ($946) $19,521 ($3,520) ($6,500) ($15,800) ($26,642) Cash flows from investing activities Plant improvements (net) Cash flows from financing activities Dividends paid Sales of common stock Purchase of common stock Cash from long term debt issued Early retirement of long term debt Retirement of current debt Cash from current debt borrowing Cash from emergency loan ($13,332) $0 ($1,935) $0 $0 ($5,725) $8.184 $0 ($4,479) $0 ($1,833) $5,671 $0 ($10,493) $12, 110 $0 ($12,733) $0 $0 $9,473 $0 ($22,180) $21,713 $0 ($6,270) $0 SO $15,601 $0 ($15,869) $19,612 $0 Net cash from financing activities ($12,808) $977 ($3,727) $13,073 Net change in cash position Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets ($160) Andrews $32,014 $13,439 $25,825 $71,278 $8,201 Baldwin $17,334 $9,833 $17,117 $44,284 ($4,662) Chester $32,316 $10,828 $10,293 $53,437 $5,952 Digby $32,550 $9,760 $6,407 $48,717 Plant and equipment Accumulated Depreciation Total Fixed Assets $96,824 ($44,409) $52,415 $84,380 ($35,023) $49,357 $142,900 ($51,265) $91,635 $124,400 ($47.289) $77,111 Total Assets $123,693 $93,641 $145,072 $125,828 Accounts Payable Current Debt Total Current Liabilities $9,516 $15,717 $25,233 $6,601 $18,436 $25,037 $7,283 $29,246 $36,529 $5,796 $25,494 $31,290 Long Term Debt Total Liabilities $27,209 $52,443 $19,477 $44,514 $53,832 $90.362 $41,366 $72,657 $12,081 Common Stock Retained Earnings Total Equity $59,170 $9,100 $40,027 $49,127 $24,679 $30,031 $54,710 $145,072 $14,385 $38.786 $53,171 $71,250 Total Liabilities & Owners' Equity $123,693 $93,641 $125,828 Income Statement Survey Sales Variable Costs (Labor, Material, Carry) Contribution Margin Depreciation SGA (R&D, Promo, Sales, Admin) Other (Fees, Writeoffs, TQM, Bonuses) EBIT Interest (Short term, Long term) Taxes Profit Sharing Net Profit COMP-XM INQUIRER Andrews $ 163,508 $107,672 $55,836 $6,455 $12,835 $29 $36,518 $4,850 $11,084 $412 $20,172 Baldwin $119,634 $80,302 $39,332 $5,625 $12,317 $311 $21,079 $4,246 $5,892 $219 $10,723 Chester $131,743 $87,231 $44,512 $9,527 $12,712 $474 $21,799 $9,963 $4,143 $154 $7,540 Digby $118,744 $72,680 $46,064 $8,293 $13,265 $780 $23,726 $7,749 $5,592 $208 $10,177 Page 3 Top COMP.XM Production Analysis Round: 0 December 31, 2019 Production vs Capacity Andrews Baldwin Chester Digby 0 500 1,000 1,500 2.000 2,500 3,000 3,500 4,000 4,500 5,000 5,500 Capacity O Production Production Information Unit Primary Units Inven Age Pfmn Size Name Segment Sold tory Revision Date Dec.31 MTBF Coord Coord 2nd Auto Shift & mation Capacity Material Labor Contr. Over Next Next Plant Price Cost Cost Marg time Round Round Utiliz. 1,371 1,830 33% 35% Attic Art Ant Thrift Core Nano Elite 758 47 264 216 922 4/13/2017 12/10/2018 11/9/2019 11/14/2019 5.1 20000 2.2 22000 1.1 24000 1.1 26000 6.7 9.4 12.1 14.2 13.3 $26.00 $8.13 $7.90 10.6 $32.00 $11.60 $8.96 6.0 $40.00 $16.13 $10.29 8.0 $42.00 $16.81 $9.80 33% 90% 50% 42% 22% 6.0 5.0 4.0 4.0 1,130 188% 1,200 149% 728 141% 714 121% 772 36% Best Bam Bell Bit Nano Elite Nano Elite 1,128 436 960 865 86 145 262 240 11/12/2019 12/13/2019 12/22/2019 12/5/2019 2.2 23000 1.9 25000 1.0 23000 1.0 25000 10.4 13.6 12.0 14.0 7.8 $30.00 $13.98 $9.50 8.6 $38.00 $15.87 $7.73 6.0 $37.00 $15.79 $8.65 8.0 $39.00 $16.39 $8.14 25% 41% 33% 36% 93% 0% 33% 13% 5.0 5.0 5.0 5.0 570 191% 700 64% 850 132% 950 111% 236 Creak Cat Cent City Thrift Thrift Core Core 1,340 1,674 1,290 1,417 284 148 83 12/11/2019 12/19/2019 12/3/2019 11/19/2019 2.8 17000 2.6 17000 1.2 18000 1.2 20000 7.8 8.0 10.4 11.1 12.2 $19.00 $8.40 $4.03 12.0 $19.00 $8.61 $4.22 9.2 $27.00 $11.68 $7.38 9.7 $28.00 $12.39 $7.38 41% 37% 30% 30% 33% 57% 93% 93% 8.0 8.0 6.0 6.0 1,050 132% 1,250 155% 900 191% 950 191% Drum Daft Deal Dino Thrift Core Nano Elite 1,726 1,881 699 604 22 14 162 134 6/27/2020 11/30/2019 12/22/2019 11/5/2019 3.5 14000 1.2 16000 1.1 18000 1.1 20000 7.0 9.6 11.5 13.5 13.0 $20.00 $6.65 $2.82 10.4 $22.00 $10.01 $5.64 6.7 $31.00 $13.64 $6.24 8.5 $35.00 $14.36 $7.09 51% 100% 31% 100% 36% 25% 38% 8% 9.0 7.0 6.0 5.0 1,000 198% 1,150 198% 750 124% 800 107% COMP-XM INQUIRER Page 4 Top Thrift Market Segment Analysis COMP-XM INQUIRER Round: 0 December 31, 2019 Accessibility Thrift Andrews Thrift Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 5,104 5,104 27.0% Baldwin Next Year's Segment Growth Rate 11.0% Chester Digby Thrift Customer Buying Criteria Expectations Importance 1. Price $14.00 - 20.00 55% 2. Reliability MTBF 14000-20000 20% 3. Ideal Position Pfmn 7.5 Size 12.5 15% Ideal Age = 3.0 10% Perceptual Map for Thrift Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% 4. Age Actual vs Potential Market Share 2019 Thrift 50% 40% Drum Crear 30% LI Daft 20% Cerity 10% 0% Andrews Baldwin Chester Digby O Actual Potential Performande 16 18 20 Top Products in Thrift Segment Stock Out Units Market Sold to Name Share Seg Cat 28% 1,404 Creak 23% 1,186 Drum 20% 1,038 Attic 16% 841 10% 515 Cent 1% 72 City 1% 48 COMP-XM INQUIRER Revision Date 12/19/2019 12/11/2019 6/27/2020 4/13/2017 11/30/2019 12/3/2019 11/19/2019 Pfmn Size Coord Coord 8.0 12.0 7.8 12.2 7.0 13.0 6.7 13.3 9.6 10.4 10.4 9.2 11.1 9.7 List Age Price MTBF Dec.31 $19.00 17000 2.56 $19.00 17000 2.76 $20.00 14000 3.46 $26.00 20000 5.11 $22.00 16000 1.17 $27.00 1.21 $28.00 20000 1.25 Promo Budget $1,050 $1,050 $950 $1,200 $950 $1,050 $1,050 Cust. Aware- ness 63% 63% 52% 79% 52% 62% 63% Cust. Sales Access- Budget ibility $800 62% $1,000 62% $1,000 63% $2,000 74% $1,000 63% $600 62% $600 62% Dec. Cust. Survey 30 31 18 13 Daft 18000 0 0 Page 5 Top Core Market Segment Analysis COMP. XM INQUIRER Round: 0 December 31, 2019 Accessibility Core Andrews Core Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 6,681 6,681 35.3% Baldwin Next Year's Segment Growth Rate 10.0% Chester Digby Core Customer Buying Criteria Expectations Importance 1. Price $20.00 - 32.00 46% 2. Age Ideal Age = 2.0 20% 3. Reliability MTBF 16000-22000 18% 4. Ideal Position Pfmn 9.6 Size 10.4 16% Perceptual Map for Core Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% Actual vs Potential Market Share 2019 Core 35% 30% 25% Freak 20% LII 15% 19 bait Cit! Ger Dino 10% 5% Best Deal 0% Andrews Baldwin Chester Digby Potential 0 Units Market Sold to Name Share Seg Daft 20% 1,366 Axe 18% 1,228 City 15% 988 Cent 15% 980 Drum 10% 688 Attic 8% 530 Best 6% 414 Cat 4% 270 Creak 2% 154 Deal 1% 54 Dino 0% 8 COMP-XM INQUIRER Actual Performand 10 11 12 13 14 15 16 17 18 19 20 Top Products in Core Segment Cust. Revision Stock Pfmn Size List Age Promo Aware- Date Out Coord Coord Price MTBF Dec.31 Budget ness 11/30/2019 9.6 10.4 $22.00 16000 1.17 $950 52% 12/10/2018 9.4 10.6 $32.00 22000 2.24 $1,200 80% 11/19/2019 11.1 9.7 $28.00 20000 1.25 $1,050 63% 12/3/2019 10.4 9.2 $27.00 18000 1.21 $1,050 62% 6/27/2020 7.0 13.0 $20.00 14000 3.46 $950 52% 4/13/2017 6.7 13.3 $26.00 20000 5.11 $1,200 79% 11/12/2019 10.4 7.8 $30.00 23000 2.19 $1,100 71% 12/19/2019 8.0 12.0 $19.00 17000 2.56 $1,050 63% 12/11/2019 7.8 12.2 $19.00 17000 2.76 $1,050 63% 12/22/2019 11.5 6.7 $31.00 18000 1.08 $950 53% 11/5/2019 13.5 8.5 $35.00 20000 1.12 $950 52% Cust. Sales Access- Budget ibility $1,000 62% $1,000 85% $600 58% $600 58% $1,000 62% $2,000 85% 22% $800 58% $1,000 58% $600 62% $1,300 62% Dec. Cust. Survey 33 27 18 18 9 5 7 27 26 0 0 Page 6 $400 Top Nano Market Segment Analysis COMP. XM INQUIRER Round: 0 December 31, 2019 Accessibility Nano Andrews Nano Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 3,651 3,651 19.3% Baldwin Next Year's Segment Growth Rate 14.0% Chester Digby 1. Nano Customer Buying Criteria Expectations Importance Ideal Position Pfmn 11.5 Size 6.5 35% 2. Price $28.00 - 40.00 27% 3. Age Ideal Age = 1.0 20% 4. Reliability MTBF 18000-24000 18% Perceptual Map for Nano Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% Actual vs Potential Market Share 2019 Nano 40% 35% 30% 25% 20% 1 15% Gent 10% Best Deal 5% 0% Andrews Digby Potential 0 Market Name Share Bell 18% Art 17% Deal 13% Best 12% Axe 8% Bit 7% City 7% Dino 6% Cent 5% Ant 4% Bam 2% 82% O Actual Performande 8 9 10 11 12 13 14 15 16 17 18 19 20 Top Products in Nano Segment Cust. Revision Stock Pfmn Size List Age Promo Aware- Date Out Coord Coord Price MTBF Dec.31 Budget ness 12/22/2019 12.0 6.0 $37.00 23000 1.04 $1,100 70% 11/9/2019 12.1 6.0 $40.00 24000 1.12 $1,200 78% 12/22/2019 11.5 6.7 $31.00 18000 1.08 $950 53% 11/12/2019 10.4 7.8 $30.00 23000 2.19 $1,100 71% 12/10/2018 9.4 10.6 $32.00 22000 2.24 $1,200 80% 12/5/2019 14.0 8.0 $39.00 25000 1.05 $1,100 69% 11/19/2019 11.1 9.7 $28.00 20000 1.25 $1,050 63% 11/5/2019 13.5 8.5 $35.00 20000 1.12 $950 52% 12/3/2019 10.4 9.2 $27.00 18000 1.21 $1,050 62% 11/14/2019 14.2 8.0 $42.00 26000 1.09 $1,200 77% 12/13/2019 13.6 8.6 $38.00 25000 1.91 $1,100 72% Units Sold to Seg 660 631 464 431 296 260 240 236 183 161 90 Cust. Sales Access- Budget ibility $1,200 81% $1,000 $600 66% $400 81% 82% $1,200 81% $600 28% $1,300 66% $600 $1,000 82% $400 81% Dec. Cust. Survey 44 42 37 43 10 10 20 12 15 4 13 $1,000 28% COMP-XM INQUIRER Page 7 102 Elite Market Segment Analysis INQUIRER Round: 0 December 31, 2019 Accessibility Elite Andrews Elite Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 3,479 3,479 18.4% Baldwin Next Year's Segment Growth Rate 16.0% Chester Digby Elite Customer Buying Criteria Expectations Importance 1. Age Ideal Age = 0.0 34% 2. Price $30.00 - 42.00 24% 3. Ideal Position Pfmn 13.5 Size 8.5 22% 4. Reliability MTBF 20000-26000 20% Perceptual Map for Elite Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% Actual vs Potential Market Share 2019 Elite 18 40% 35% 30% 25% 20% 15% 10% 5% 0% il. City Dea - Andrews Baldwin Chester Digby Potential Units Market Sold to Name Share Seg Ant 18% 612 Bit 17% 605 Dino 10% 361 Bam 10% 346 Axe 9% 306 Bell 9% 300 Art 8% 291 Best 8% 282 Deal 5% 182 City 4% 141 Cent 2% 54 COMP-XM INQUIRER O Actual Performand 10 11 12 13 14 15 16 17 18 19 20 Top Products in Elite Segment Cust. Revision Stock Pfmn Size List Age Promo Aware- Date Out Coord Coord Price MTBF Dec. 31 Budget ness 11/14/2019 14.2 8.0 $42.00 26000 1.09 $1,200 77% 12/5/2019 14.0 8.0 $39.00 25000 1.05 $1,100 69% 11/5/2019 13.5 8.5 $35.00 20000 1.12 $950 52% 12/13/2019 13.6 8.6 $38.00 25000 1.91 $1,100 72% 12/10/2018 9.4 10.6 $32.00 22000 2.24 $1,200 80% 12/22/2019 12.0 6.0 $37.00 23000 1.04 $1,100 70% 11/9/2019 12.1 6.0 $40.00 24000 1.12 $1,200 78% 11/12/2019 10.4 7.8 $30.00 23000 2.19 $1,100 71% 12/22/2019 11.5 6.7 $31.00 18000 1.08 $950 53% 11/19/2019 11.1 9.7 $28.00 20000 1.25 $1,050 63% 12/3/2019 10.4 9.2 $27.00 18000 1.21 $1,050 62% Cust. Sales Access- Budget ibility $1,000 87% $1,200 81% $1,300 55% $400 81% $1,000 87% $1,200 81% $1,000 87% $400 81% $600 55% $600 19% $600 19% Dec Cust. Survey 39 40 25 32 8 11 11 22 11 11 5 Page 8 Top Market Share Report INQUIRER Round: 0 December 31, 2019 Units Sold vs Demand Chart Market Share 50% 6,000 40% 5,000 30% 4,000 3,000 20% 10% 2.000 0% 1,000 0 Andrews Baldwin Chester Digby Thrift Core Nano Elite Industry Unit Sales 0 Total Unit Demand Thrift 0 Core O Nano O Elite Total Actual Market Share in Units Thrift Core Nano Elite Industry Unit 5,104 6,681 3,651 3,479 Sales % of Market 27.0% 35.3% 19.3% 18.4% 18,914 100.0% Attic Axe Art Ant 16.5% 7.9% 18.4% 8.1% 8.8% 17.3% 8.4% 4.4% 17.6% 16.5% 26.3% 29.8% 34.8% 7.1% 9.5% 4.9% 4.1% 25.6% Total 25.9% Best Bam Bell Bit Total 6.2% 11.8% 8.1% 2.5% 9.9% 18.1% 8.6% 7.1% 17.4% 6.2% 39.5% 44.1% Potential Market Share in Units Total Thrift Core Nano Elite 18,914 Units 5,104 Demanded 6,681 3,651 3,479 100.0% % of Market 27.0% 35.3% 19.3% 18.4% 7.3% 9.7% Attic 16.3% 7.8% 4.9% Axe 17.9% 8.1% 8.8% 4.1% Art 17.3% 8.4% Ant 4.4% 17.6% Total 16.3% 25.7% 29.8% 34.8% 6.0% 2.3% Best 6.1% 11.8% 8.1% 5.1% Bam 2.5% 9.9% 4.6% Bell 18.1% 8.6% 17.9% Bit 7.1% 17.4% Total 6.0% 39.5% 44.1% 7.1% 8.8% Creak 23.0% 2.3% 6.8% Cat 27.2% 4.0% 7.5% Cent 1.4% 14.3% 5.0% 1.6% 30.2% City 0.9% 14.4% 4.0% Total 52.4% 35.0% 11.6% 5.6% 9.1% 9.9% Drum 20.3% 10.2% 3.7% Daft 11.0% 22.2% 3.2% Deal 0.8% 12.7% 5.2% Dino 0.1% 6.5% 10.4% Total 31.3% 33.2% 19.2% 5.9% 2.3% 5.1% 4.6% 17.9% Creak Cat Cent City Total 23.2% 2.3% 27.5% 4.0% 1.4% 14.7% 5.0% 0.9% 14.8% 6.6% 53.1% 35.8% 11.6% 1.6% 4.0% 5.6% 7.0% 8.7% 6.7% 7.4% 29.8% 6.6% Drum Daft peal bino Total 20.3% 10.3% 10.1% 20.4% 0.8% 12.7% 5.2% 0.1% 6.5% 10.4% 30.4% 31.7% 19.2% 15.6% 26.0% 9.1% 10.8% 3.7% 3.2% 26.8% Page 9 15.6% COMP-XM INQUIRER Top COMP. XM INQUIRER Perceptual Map Round: December 31, 2019 Perceptual Map for All Segments Perceptual map (at end of this year) Size 201 19 18 17 16 15 14 13 Drum Freak 12 1 10 Dafy City Cent 9 Dino EAD 8 Best Deat 6 5 4 3 2 Performance 10 11 12 13 14 15 16 17 18 19 20 0 2 3 4 5 6 8 9 Name Attic Axe Art Ant Revised Name 4/13/2017 Best 12/10/2018 Bam 11/9/2019 Bell 11/14/2019 Bit Baldwin Pfmn Size 10.4 7.8 13.6 8.6 12.0 6.0 14.0 8.0 Revised Name 11/12/2019 Creak 12/13/2019 Cat 12/22/2019 Cent 12/5/2019 City Chester Pfmn Size 7.8 12.2 8.0 12.0 10.4 9.2 11.1 9.7 Revised 12/11/2019 12/19/2019 12/3/2019 11/19/2019 Andrews Pfmn Size 6.7 13.3 9.4 10.6 12.1 6.0 14.2 8.0 Digby Size 7.0 13.0 9.6 10.4 11.5 6.7 13.5 8.5 Pfmn Name Drum Daft Deal Dino Revised 6/27/2020 11/30/2019 12/22/2019 11/5/2019 COMP-XM INQUIRER Page 10 Proforma Balanced Scorecard DRAFT SAVED AT Jul 20, 2020 07:14PM EDT Days Round 1 Projected Results CRITERIA Score / Points No Credit Partial Credit Full Credit Financial Stock Price 7.0 / 7.0 = $80.00 Profits 7.0 / 7.0 = $14,000,000 Leverage 0.9 / 6.0 = 4.0 1.3 ... 4.0 1.8 ... 2.8 Sub Total Financial 14.9 / 20.0 Internal Business Process Contribution Margin 2.8 / 4.0 = 40.0% Plant Utilization 4.0 / 4.0 = 200.0% 90.0% ... 200.0% 100.0% ... 180.0% of Working Capital 0.0 / 4.0 = 105 15 ... 105 30 ... 90 Stock-out Costs 0.0 / 4.0 >= 5.0% 5.0% ... 0.0% = 5.5% 5.5% ... 2.5% = 47.0 Customer Awareness 3.0 / 4.0 = 90.0% Customer Accessibility 2.0 / 4.0 = 90.0% Product Count 2.3 / 4.0 = 8.0 3.2 / 4.0 = 25.0% 5.0% ... 25.0% 7.0% ... 20.0% Sub Total Customer 12.1 / 20.0 Learning and Growth Employee Turnover Rate 0.0 / 6.0 >= 10.0% 10.0% ... 8.0% = 103.0% TOM Material Reduction 0.0 / 2.0 = 3.1% TOM R&D Reduction 0.0 / 2.0 = 26.7% TOM Admin Cost Reduction 0.0 / 2.0 = 38.0% TOM Demand Increase 0.0/2.0 = 4.3% Sub Total Learning and Growth 0.0 / 20.0 Score for Round 1 37.8 / 80.0 Recapitulation Interim Results Recap criteria evaluate your company's overall performance and are finalized when your simulation is completed. Interim results chart your progress towards those ending goals. Your score only includes the Recap for the last completed round. SG&A Expense 15.0 / 15.0 9.7 / 15.0 15.0 / 15.0 39.7 / 45.0 = 2.0% 1.0% ... 35.0% $97,000,000 ... $205,000,000 2.0% ... 0.0% >= 35.0% >= $205,000,000 = $88,000,000 Financial Market Cap (End) Sales (Ave) Emergency Loan (Ave) Sub Total Financial Internal Business Process Operating Profit (Cum) Sub Total Internal Business Process Customer Wtg Avg Cust Survey Score (Ave) Market Share (Ave) Sub Total Customer Learning and Growth Sales/Employee (Ave) Assets/Employee (Ave) Profits/Employee (Cum) Sub Total Learning and Growth Recap Score 5.5 / 15.0 6.5 / 30.0 12.0 / 45.0 = 44.0 >= 31.0% 8.8 / 15.0 4.8 / 15.0 4.1 / 15.0 17.7 / 45.0 82.4 / 180.0 = $290,000 >= $278,000 >= $115,000 Racalculate Research & Development DRAFT SAVED AT Jul 20, 2020 05:47PM EDT Perceptual map (at end of this year) Decisions Name New Pfmn New Size MTBF Revision Date Age at Revision 18 R&D Cost ($000) $0 $0 16 14 Attic Axe Art Ant NA NA NA NA 13.3 10.6 6.0 8.0 0.0 Attic 6.7 9.4 12.1 14.2 0.0 0.0 0.0 0.0 20000 22000 24000 26000 0 12 $0 $0 $0 Axe 10 0.0 0 $0 Ant 0.0 0 $0 0.0 0 $0 Art Total $0 Performance 18 19 20 0 2 4 6 8 10 12 13 14 15 16 Material Cost I Old New Age Profiles 10.0 SO $5 $10 $15 $20 9.0 Attic 8.0 Attic Axe Art Ant #NA NA +NA NA Axe- 7.0- Art 6.0- Perceived Age in Years 5.0 Ant 4.01 NAH 3.0 NA- 2.0 NA- 1.0 NA- 0.0 Recalculate Marketing DRAFT SAVED AT Jul 20, 2020 07:12PM EDT Marketing Decisions Name Price Promo Budget Sales Budget Benchmark Prediction Your Sales Forecast Variable Costs Contrib Margin Forecast Less Promo & Sales 26.00 $ 32.00 $ 40.00 $ 42.00 $ 0 0 0 0 Attic Axe Art Ant NA NA NA NA Total $ $ $ $ $0.0 $0.0 $0.0 $0.0 1200 1200 $ 1200 $ 1200 $ $ 0 $ 0 $ 0 $ 0 $ 4,800 2000 1000 1000 1000 $ 0 $ 0 $ 0 $ 0 $ 5,000 769 1,958 2,045 1,486 0 0 0 0 6,258 Gross Revenue Forecast Costs $ 19,988 $ 62,658 $ 81,808 $ 62,416 $ 0 $ 0 $ 0 $ 0 $ 226,870 $ 10,977 $ 37,966 $ 52,748 $ 38,112 $ 0 $ 0 $ 0 $0 $ 139,803 $ 9,011 $ 24,692 $ 29,060 $ 24,304 $ 0 $ 0 $ 0 $ 0 $ 87,067 $ 5,811 $ 22,492 $ 26,860 $ 22,104 $ 0 $ 0 $ 0 $0 $ 77,267 0 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 useless for forecasting. A/R Lag (days) A/P Lag (days) 30 30 Revenue Forecast $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 SO Unit Sales Forecast 2,200 2,000 1,800 1,600 1,400 1,200 1,000 800 600 400 200 0 Attic Axe Attic Axe Art Ant NA NA NA NA Art Ant NA NA NA NA Variable Costs Marketing Margin After Marketing Elite Nano Core Thrift Recalculate Production DRAFT SAVED AT Jul 20, 2020 07:12PM EDT NA NA NA NA Attic 769 758 2150 2,129 Axe 1,958 47 1800 1,782 Art 2,045 264 950 941 Ant 1,486 216 750 743 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 ($000) WORKFORCE Complement 90.3% $8.28 $6.00 $14.28 45.1% 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% 0.0% $0.00 $0.00 $0.00 0.0% 0.0% $0.00 $0.00 $0.00 0.0% 0.0% $0.00 $0.00 $0.00 0.0% 0.0% $0.00 $0.00 $0.00 0.0% Total 3,772 0 1,130 0 6.0 6.0 $ 0 Last Year 804 1,200 0 5.0 5.0 $ 0 Needed 804 728 0 4.0 4.0 $ 0 This Year % 100% 714 0 4.0 4.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 Both Shifts Production Vs. Capacity 2,500 Base Capacity Production Material Labor Margin Price Vs. Unit Cost $50 $40 2,000 $30 1,500 $20 1,000 $10 500 $0 Attic Axe Art Ant NA NA NA NA 0 Attic Axe Art Ant NA NA NA NA Recalculate Human Resources DRAFT SAVED AT Jul 20, 2020 07:12PM EDT Staffing Labor Negotiations Current Contract Hourly Wage $ 25.53 Benefits $ 2,500 Profit Sharing % 2.0% Annual Raise 5.0% Labor Demands $ 28.08 $ 2,750 2.2% 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 100.0% 100.0% $80 $0 $0 $80 0 Recalculate Finance DRAFT SAVED AT Jul 20, 2020 07:13PM EDT Liabilities & Owner's Equity Common Stock $0 $0 Retained Earnings Long Term Debt 2,051 $ 95.61 $ 12.32 $ 39,219 0 $ 9,805 0 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 ($000) 'Issue Stock ($000) Max Stock Retire ($000) Retire Stock ($000) Dividend Per Share CURRENT DEBT Interest Rate Due This Year Borrow ($000) CASH POSITIONS December 31, 2019 December 31, 2020 $ $ $ 0.00 Long Term Debt Retire Long Term Debt ($000) Issue Long Term Debt ($000) Long Term Interest Rate Maximum Issue This Year 10.0% $ 15,717 0 0 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.5S2021 $ 11,300 11.252026 $ 8,837 11.952027 $ 7,072 Current Yield 13.0% 11.3% 11.6% 2019 Close $ 103.58 $ 99.07 $ 102.54 Recalculate TQM Initiative DRAFT SAVED AT Jul 20, 2020 07:13PM EDT Process Management Initiatives Projected Impact Total Current Expenditures ($000): $ 0 CPI Systems "Vendor/JIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs Budget ($000) $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 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 0 0 $ $ $ $ 0 Reduction in Cost of Goodsterial For the Year Just Ended Admin Cost Reductions For the Year Just Ended R&D Cycle Time Reductions For the Year Just Ended Demand Increase For the Year Just Ended 1.0% 0% 209 0% 10 0% 594 Andrews Andrews Andrews Baldwin Baldwin Baldwin 0.5% Chester Chester Chester Digby Digby Digby 0.0% Andrews Baldwin Chester Digby Proforma Balance Sheet DRAFT SAVED AT Jul 20, 2020 07:14PM EDT $ 41,547 $ 13,725 $ 31,387 Assets CURRENT ASSETS Cash Accts Receivable Inventories Total Current Assets FIXED ASSETS Plant & Equipment Accum. Deprec. Total Fixed Assets TOTAL ASSETS 31.3% 10.3% 23.7% 65.3% Liabilities & Owner's Equity LIABILITIES Accts Payable Current Borrowing Emergency Loan Maturing L.T. Debt Long Term Debt Total Liabilities OWNER'S EQUITY Common Stock Retained Earn. Total Equity TOTAL LIAB. & O.E. $ 8,899 $ 0 $ 0 $ 0 $ 27,209 6.7% 0.0% 0.0% 0.0% 20.5% 27.2% $ 86,659 $ 36,108 $ 96,824 ($ 50,865) 73.0% (38.4%) 34.7% 100.0% $ 45,959 $ 132,619 $ 12,081 $ 84,431 9.1% 63.7% 72.8% 100.0% $ 96,512 $ 132,619 Assets Liabilities & Owner's Equity Inventories Common Stock Fixed Accounts Receiv Retained Earnings Long Term Debt Current Debt Accounts Payable Cash Accounts Receivable O Long Term Debt Cash 0 Inventories Accounts Payable Common Stock Current Debt Retained Earnings O Fixed Proforma Income Statement DRAFT SAVED AT Jul 20, 2020 07:14PM EDT Attic NA NA NA NA Axe $ 58,540 $ 19,988 Art $ 48,190 Ant $ 40,266 $0 $ 0 0.0% 100.0% $0 $ 0 TOTAL $ 166,984 Income Statement REVENUE Sales VARIABLE COSTS Direct Labor Direct Material Inventory Carry Total Variable Costs Contribution margin PERIOD COSTS Depreciation SG&A: R&D Promotion Sales Admin Total Period Costs Net Margin $ 6,604 $ 4,787 $ 3,766 $ 15,157 $ 4,831 $ 17,211 $ 18,333 $ 0 $ 35,544 $ 22,997 $ 12,654 $ 18,417 $ 0 $ 31,071 $ 17,119 $ 0 $ 0 $0 $0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $0 $0 $0 $0 $0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 45,777 $ 56,924 $ 3,766 $ 106,467 $ 60,517 27.4% 34.1% 2.3% 63.8% 36.2% $ 2,260 $ 0 $ 1,200 $ 2,000 $ 150 $ 5,610 ($ 779) $ 2,080 $ 0 $ 1,200 $ 1,000 $ 438 $ 4,718 $ 18,279 $ 1,068 $0 $ 1,200 $ 1,000 $361 $ 3,628 $ 13,491 $ 9,308 $ 15,388 $ 0 $ 24,696 $ 15,571 $ 1,047 $ 0 $ 1,200 $ 1,000 $ 301 $ 3,548 $ 12,022 $0 $ 0 $0 $0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $0 $ 0 $ 0 $ 0 $0 $ 0 $ 0 $0 $ 0 OTHER (FEES, WRITE OFFS, TQM) EBIT Interest Taxes Profit Sharing Net Profit $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 6,455 $0 $ 4,800 $ 5,000 $ 1,249 $ 17,504 $ 43,013 $ 0 $ 43,013 $ 3,357 $ 13,880 $ 516 $ 25,261 3.9% 0.0% 2.9% 3.0% 0.7% 10.5% 25.8% 0.0% 25.8% 2.0% 8.3% 0.3% 15.1% $60,000 $55,000 $50,000 $45,000 $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 SO $5,000 Labor Material Inventory Carrying Costs Depreciation Research & Development Marketing Administrative / Other Net Margin Attic Axe Art Ant NA NA NA NA Proforma Cash Flow DRAFT SAVED AT Jul 20, 2020 07:14PM EDT $40,000 Cash Flow from Operations $30,000 $ 25,261 $ 6,455 ($ 617) ($ 5,562) ($ 286) $20,000 Net Income (Loss) Depreciation O Accounts Payable O Inventories Accounts Receivable ONet Cash Flow $10,000 $ 25,250 SO $ 0 -$10,000 Cash Flows from Operations Net income(loss) Depreciation & Writeoffs Change in accounts payable Change in inventory Change in accounts receivable Net cash from operations Cash Flows from Investing Cash Flow From Financing Cash Flow From Financing Dividends paid Sales of common stock Purchase of common stock Increase long term debt Retire Long Term Debt Change current debt (net) Net cash from financial actions Net change in cash position Starting cash position Closing cash position Cash Flow from Investing $0 $ 0 $ 0 $ 0 $ 0 ($ 15,717) Plant Improvements Net Cash Flow SO ($ 15,717) $ 9,533 $ 32,014 $ 41,547 Cash Flow from Finance -$2,000 -$4,000 $25,000 Cash Flow Summary $20,000 $15,000 $10,000 Cash Flow from Operations $5,000 Cash Flow from Investing Cash Flow from Financial Actions Net Change in Cash Position$5,000 -$10,000 -$15,000 Dividends Sales of Stock Purchase of Stock New Long Term Debt Retire Long Term Debt Change Current Debt Net Cash Flow -$6,000 -$8,000 -$10,000 -$12,000 -$14,000 Proforma Financial Ratios DRAFT SAVED AT Jul 20, 2020 07:14PM EDT Ratios Return On Sales (ROS) or "Profitability" = Profit/Sales Asset Turnover or "Turnover" = Sales/Assets Return On Assets (ROA) = Profitability * Turnover Leverage = Assets/Equity Return on Equity (ROE) = Profit/Equity Free Cash Flow = Cash Flow From Ops - Capital Expenditures Working Capital = Current Assets - Current Liabilities Days of Working Capital = Working Capital Projected Stock Price Market Capitialization ($M) = Stock Price * Shares Outstanding Book Value Per Share = Equity/Shares Outstanding Price Earnings Ratio (P/E) = Stock Price /EPS Market/Book Ratio = Stock Price/ EPS Dividend Yield = Dividend Per Share / Stock Price Dividend Payout Ratio = Dividend Per Share / EPS 15.1% 1.3 19.0% 1.4 26.2% $ 25,250 $ 77,761 170 $110.16 $ 226 $ 47.06 8.9 2.3 0.0% 0.0% ROS Asset Turnover Leverage ROE 16% 2.0 14% 12% 1.5 10% 8% 1.4 1.3 1.2 1.1 1.0 0.9 0.8 0.7 0.6 0.5 0.4 0.3 0.2 0.1 0.0 1.0 28% 26% 24% 22% 20% 18% 16% 14% 12% 10% 8% 6% 4% 2% 0% 6% 4% 0.5 2% 0% 0.0 COMP-XM Financial Summary INQUIRER Round: 0 December 31, 2019 Andrews Baldwin Chester Digby $20,172 $10,723 $7,540 $10,177 Cash Flow Statement Survey Cash flows from operating activities Net Income (Loss) Adjustment for non-cash items: Depreciation Extraordinary gains/losses/writeoffs Changes in current assets and liabilities: Accounts payable Inventory Accounts receivable Net cash from operations $6,455 $0 $5,625 $0 $9,527 $0 $8,293 $0 $735 ($11,210) $15 $16,168 $1,216 ($2,062) ($1,778) $13,725 $1.457 ($2,615) ($1,043) $14,864 $608 $1,388 ($946) $19,521 ($3,520) ($6,500) ($15,800) ($26,642) Cash flows from investing activities Plant improvements (net) Cash flows from financing activities Dividends paid Sales of common stock Purchase of common stock Cash from long term debt issued Early retirement of long term debt Retirement of current debt Cash from current debt borrowing Cash from emergency loan ($13,332) $0 ($1,935) $0 $0 ($5,725) $8.184 $0 ($4,479) $0 ($1,833) $5,671 $0 ($10,493) $12, 110 $0 ($12,733) $0 $0 $9,473 $0 ($22,180) $21,713 $0 ($6,270) $0 SO $15,601 $0 ($15,869) $19,612 $0 Net cash from financing activities ($12,808) $977 ($3,727) $13,073 Net change in cash position Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets ($160) Andrews $32,014 $13,439 $25,825 $71,278 $8,201 Baldwin $17,334 $9,833 $17,117 $44,284 ($4,662) Chester $32,316 $10,828 $10,293 $53,437 $5,952 Digby $32,550 $9,760 $6,407 $48,717 Plant and equipment Accumulated Depreciation Total Fixed Assets $96,824 ($44,409) $52,415 $84,380 ($35,023) $49,357 $142,900 ($51,265) $91,635 $124,400 ($47.289) $77,111 Total Assets $123,693 $93,641 $145,072 $125,828 Accounts Payable Current Debt Total Current Liabilities $9,516 $15,717 $25,233 $6,601 $18,436 $25,037 $7,283 $29,246 $36,529 $5,796 $25,494 $31,290 Long Term Debt Total Liabilities $27,209 $52,443 $19,477 $44,514 $53,832 $90.362 $41,366 $72,657 $12,081 Common Stock Retained Earnings Total Equity $59,170 $9,100 $40,027 $49,127 $24,679 $30,031 $54,710 $145,072 $14,385 $38.786 $53,171 $71,250 Total Liabilities & Owners' Equity $123,693 $93,641 $125,828 Income Statement Survey Sales Variable Costs (Labor, Material, Carry) Contribution Margin Depreciation SGA (R&D, Promo, Sales, Admin) Other (Fees, Writeoffs, TQM, Bonuses) EBIT Interest (Short term, Long term) Taxes Profit Sharing Net Profit COMP-XM INQUIRER Andrews $ 163,508 $107,672 $55,836 $6,455 $12,835 $29 $36,518 $4,850 $11,084 $412 $20,172 Baldwin $119,634 $80,302 $39,332 $5,625 $12,317 $311 $21,079 $4,246 $5,892 $219 $10,723 Chester $131,743 $87,231 $44,512 $9,527 $12,712 $474 $21,799 $9,963 $4,143 $154 $7,540 Digby $118,744 $72,680 $46,064 $8,293 $13,265 $780 $23,726 $7,749 $5,592 $208 $10,177 Page 3 Top COMP.XM Production Analysis Round: 0 December 31, 2019 Production vs Capacity Andrews Baldwin Chester Digby 0 500 1,000 1,500 2.000 2,500 3,000 3,500 4,000 4,500 5,000 5,500 Capacity O Production Production Information Unit Primary Units Inven Age Pfmn Size Name Segment Sold tory Revision Date Dec.31 MTBF Coord Coord 2nd Auto Shift & mation Capacity Material Labor Contr. Over Next Next Plant Price Cost Cost Marg time Round Round Utiliz. 1,371 1,830 33% 35% Attic Art Ant Thrift Core Nano Elite 758 47 264 216 922 4/13/2017 12/10/2018 11/9/2019 11/14/2019 5.1 20000 2.2 22000 1.1 24000 1.1 26000 6.7 9.4 12.1 14.2 13.3 $26.00 $8.13 $7.90 10.6 $32.00 $11.60 $8.96 6.0 $40.00 $16.13 $10.29 8.0 $42.00 $16.81 $9.80 33% 90% 50% 42% 22% 6.0 5.0 4.0 4.0 1,130 188% 1,200 149% 728 141% 714 121% 772 36% Best Bam Bell Bit Nano Elite Nano Elite 1,128 436 960 865 86 145 262 240 11/12/2019 12/13/2019 12/22/2019 12/5/2019 2.2 23000 1.9 25000 1.0 23000 1.0 25000 10.4 13.6 12.0 14.0 7.8 $30.00 $13.98 $9.50 8.6 $38.00 $15.87 $7.73 6.0 $37.00 $15.79 $8.65 8.0 $39.00 $16.39 $8.14 25% 41% 33% 36% 93% 0% 33% 13% 5.0 5.0 5.0 5.0 570 191% 700 64% 850 132% 950 111% 236 Creak Cat Cent City Thrift Thrift Core Core 1,340 1,674 1,290 1,417 284 148 83 12/11/2019 12/19/2019 12/3/2019 11/19/2019 2.8 17000 2.6 17000 1.2 18000 1.2 20000 7.8 8.0 10.4 11.1 12.2 $19.00 $8.40 $4.03 12.0 $19.00 $8.61 $4.22 9.2 $27.00 $11.68 $7.38 9.7 $28.00 $12.39 $7.38 41% 37% 30% 30% 33% 57% 93% 93% 8.0 8.0 6.0 6.0 1,050 132% 1,250 155% 900 191% 950 191% Drum Daft Deal Dino Thrift Core Nano Elite 1,726 1,881 699 604 22 14 162 134 6/27/2020 11/30/2019 12/22/2019 11/5/2019 3.5 14000 1.2 16000 1.1 18000 1.1 20000 7.0 9.6 11.5 13.5 13.0 $20.00 $6.65 $2.82 10.4 $22.00 $10.01 $5.64 6.7 $31.00 $13.64 $6.24 8.5 $35.00 $14.36 $7.09 51% 100% 31% 100% 36% 25% 38% 8% 9.0 7.0 6.0 5.0 1,000 198% 1,150 198% 750 124% 800 107% COMP-XM INQUIRER Page 4 Top Thrift Market Segment Analysis COMP-XM INQUIRER Round: 0 December 31, 2019 Accessibility Thrift Andrews Thrift Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 5,104 5,104 27.0% Baldwin Next Year's Segment Growth Rate 11.0% Chester Digby Thrift Customer Buying Criteria Expectations Importance 1. Price $14.00 - 20.00 55% 2. Reliability MTBF 14000-20000 20% 3. Ideal Position Pfmn 7.5 Size 12.5 15% Ideal Age = 3.0 10% Perceptual Map for Thrift Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% 4. Age Actual vs Potential Market Share 2019 Thrift 50% 40% Drum Crear 30% LI Daft 20% Cerity 10% 0% Andrews Baldwin Chester Digby O Actual Potential Performande 16 18 20 Top Products in Thrift Segment Stock Out Units Market Sold to Name Share Seg Cat 28% 1,404 Creak 23% 1,186 Drum 20% 1,038 Attic 16% 841 10% 515 Cent 1% 72 City 1% 48 COMP-XM INQUIRER Revision Date 12/19/2019 12/11/2019 6/27/2020 4/13/2017 11/30/2019 12/3/2019 11/19/2019 Pfmn Size Coord Coord 8.0 12.0 7.8 12.2 7.0 13.0 6.7 13.3 9.6 10.4 10.4 9.2 11.1 9.7 List Age Price MTBF Dec.31 $19.00 17000 2.56 $19.00 17000 2.76 $20.00 14000 3.46 $26.00 20000 5.11 $22.00 16000 1.17 $27.00 1.21 $28.00 20000 1.25 Promo Budget $1,050 $1,050 $950 $1,200 $950 $1,050 $1,050 Cust. Aware- ness 63% 63% 52% 79% 52% 62% 63% Cust. Sales Access- Budget ibility $800 62% $1,000 62% $1,000 63% $2,000 74% $1,000 63% $600 62% $600 62% Dec. Cust. Survey 30 31 18 13 Daft 18000 0 0 Page 5 Top Core Market Segment Analysis COMP. XM INQUIRER Round: 0 December 31, 2019 Accessibility Core Andrews Core Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 6,681 6,681 35.3% Baldwin Next Year's Segment Growth Rate 10.0% Chester Digby Core Customer Buying Criteria Expectations Importance 1. Price $20.00 - 32.00 46% 2. Age Ideal Age = 2.0 20% 3. Reliability MTBF 16000-22000 18% 4. Ideal Position Pfmn 9.6 Size 10.4 16% Perceptual Map for Core Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% Actual vs Potential Market Share 2019 Core 35% 30% 25% Freak 20% LII 15% 19 bait Cit! Ger Dino 10% 5% Best Deal 0% Andrews Baldwin Chester Digby Potential 0 Units Market Sold to Name Share Seg Daft 20% 1,366 Axe 18% 1,228 City 15% 988 Cent 15% 980 Drum 10% 688 Attic 8% 530 Best 6% 414 Cat 4% 270 Creak 2% 154 Deal 1% 54 Dino 0% 8 COMP-XM INQUIRER Actual Performand 10 11 12 13 14 15 16 17 18 19 20 Top Products in Core Segment Cust. Revision Stock Pfmn Size List Age Promo Aware- Date Out Coord Coord Price MTBF Dec.31 Budget ness 11/30/2019 9.6 10.4 $22.00 16000 1.17 $950 52% 12/10/2018 9.4 10.6 $32.00 22000 2.24 $1,200 80% 11/19/2019 11.1 9.7 $28.00 20000 1.25 $1,050 63% 12/3/2019 10.4 9.2 $27.00 18000 1.21 $1,050 62% 6/27/2020 7.0 13.0 $20.00 14000 3.46 $950 52% 4/13/2017 6.7 13.3 $26.00 20000 5.11 $1,200 79% 11/12/2019 10.4 7.8 $30.00 23000 2.19 $1,100 71% 12/19/2019 8.0 12.0 $19.00 17000 2.56 $1,050 63% 12/11/2019 7.8 12.2 $19.00 17000 2.76 $1,050 63% 12/22/2019 11.5 6.7 $31.00 18000 1.08 $950 53% 11/5/2019 13.5 8.5 $35.00 20000 1.12 $950 52% Cust. Sales Access- Budget ibility $1,000 62% $1,000 85% $600 58% $600 58% $1,000 62% $2,000 85% 22% $800 58% $1,000 58% $600 62% $1,300 62% Dec. Cust. Survey 33 27 18 18 9 5 7 27 26 0 0 Page 6 $400 Top Nano Market Segment Analysis COMP. XM INQUIRER Round: 0 December 31, 2019 Accessibility Nano Andrews Nano Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 3,651 3,651 19.3% Baldwin Next Year's Segment Growth Rate 14.0% Chester Digby 1. Nano Customer Buying Criteria Expectations Importance Ideal Position Pfmn 11.5 Size 6.5 35% 2. Price $28.00 - 40.00 27% 3. Age Ideal Age = 1.0 20% 4. Reliability MTBF 18000-24000 18% Perceptual Map for Nano Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% Actual vs Potential Market Share 2019 Nano 40% 35% 30% 25% 20% 1 15% Gent 10% Best Deal 5% 0% Andrews Digby Potential 0 Market Name Share Bell 18% Art 17% Deal 13% Best 12% Axe 8% Bit 7% City 7% Dino 6% Cent 5% Ant 4% Bam 2% 82% O Actual Performande 8 9 10 11 12 13 14 15 16 17 18 19 20 Top Products in Nano Segment Cust. Revision Stock Pfmn Size List Age Promo Aware- Date Out Coord Coord Price MTBF Dec.31 Budget ness 12/22/2019 12.0 6.0 $37.00 23000 1.04 $1,100 70% 11/9/2019 12.1 6.0 $40.00 24000 1.12 $1,200 78% 12/22/2019 11.5 6.7 $31.00 18000 1.08 $950 53% 11/12/2019 10.4 7.8 $30.00 23000 2.19 $1,100 71% 12/10/2018 9.4 10.6 $32.00 22000 2.24 $1,200 80% 12/5/2019 14.0 8.0 $39.00 25000 1.05 $1,100 69% 11/19/2019 11.1 9.7 $28.00 20000 1.25 $1,050 63% 11/5/2019 13.5 8.5 $35.00 20000 1.12 $950 52% 12/3/2019 10.4 9.2 $27.00 18000 1.21 $1,050 62% 11/14/2019 14.2 8.0 $42.00 26000 1.09 $1,200 77% 12/13/2019 13.6 8.6 $38.00 25000 1.91 $1,100 72% Units Sold to Seg 660 631 464 431 296 260 240 236 183 161 90 Cust. Sales Access- Budget ibility $1,200 81% $1,000 $600 66% $400 81% 82% $1,200 81% $600 28% $1,300 66% $600 $1,000 82% $400 81% Dec. Cust. Survey 44 42 37 43 10 10 20 12 15 4 13 $1,000 28% COMP-XM INQUIRER Page 7 102 Elite Market Segment Analysis INQUIRER Round: 0 December 31, 2019 Accessibility Elite Andrews Elite Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 3,479 3,479 18.4% Baldwin Next Year's Segment Growth Rate 16.0% Chester Digby Elite Customer Buying Criteria Expectations Importance 1. Age Ideal Age = 0.0 34% 2. Price $30.00 - 42.00 24% 3. Ideal Position Pfmn 13.5 Size 8.5 22% 4. Reliability MTBF 20000-26000 20% Perceptual Map for Elite Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% Actual vs Potential Market Share 2019 Elite 18 40% 35% 30% 25% 20% 15% 10% 5% 0% il. City Dea - Andrews Baldwin Chester Digby Potential Units Market Sold to Name Share Seg Ant 18% 612 Bit 17% 605 Dino 10% 361 Bam 10% 346 Axe 9% 306 Bell 9% 300 Art 8% 291 Best 8% 282 Deal 5% 182 City 4% 141 Cent 2% 54 COMP-XM INQUIRER O Actual Performand 10 11 12 13 14 15 16 17 18 19 20 Top Products in Elite Segment Cust. Revision Stock Pfmn Size List Age Promo Aware- Date Out Coord Coord Price MTBF Dec. 31 Budget ness 11/14/2019 14.2 8.0 $42.00 26000 1.09 $1,200 77% 12/5/2019 14.0 8.0 $39.00 25000 1.05 $1,100 69% 11/5/2019 13.5 8.5 $35.00 20000 1.12 $950 52% 12/13/2019 13.6 8.6 $38.00 25000 1.91 $1,100 72% 12/10/2018 9.4 10.6 $32.00 22000 2.24 $1,200 80% 12/22/2019 12.0 6.0 $37.00 23000 1.04 $1,100 70% 11/9/2019 12.1 6.0 $40.00 24000 1.12 $1,200 78% 11/12/2019 10.4 7.8 $30.00 23000 2.19 $1,100 71% 12/22/2019 11.5 6.7 $31.00 18000 1.08 $950 53% 11/19/2019 11.1 9.7 $28.00 20000 1.25 $1,050 63% 12/3/2019 10.4 9.2 $27.00 18000 1.21 $1,050 62% Cust. Sales Access- Budget ibility $1,000 87% $1,200 81% $1,300 55% $400 81% $1,000 87% $1,200 81% $1,000 87% $400 81% $600 55% $600 19% $600 19% Dec Cust. Survey 39 40 25 32 8 11 11 22 11 11 5 Page 8 Top Market Share Report INQUIRER Round: 0 December 31, 2019 Units Sold vs Demand Chart Market Share 50% 6,000 40% 5,000 30% 4,000 3,000 20% 10% 2.000 0% 1,000 0 Andrews Baldwin Chester Digby Thrift Core Nano Elite Industry Unit Sales 0 Total Unit Demand Thrift 0 Core O Nano O Elite Total Actual Market Share in Units Thrift Core Nano Elite Industry Unit 5,104 6,681 3,651 3,479 Sales % of Market 27.0% 35.3% 19.3% 18.4% 18,914 100.0% Attic Axe Art Ant 16.5% 7.9% 18.4% 8.1% 8.8% 17.3% 8.4% 4.4% 17.6% 16.5% 26.3% 29.8% 34.8% 7.1% 9.5% 4.9% 4.1% 25.6% Total 25.9% Best Bam Bell Bit Total 6.2% 11.8% 8.1% 2.5% 9.9% 18.1% 8.6% 7.1% 17.4% 6.2% 39.5% 44.1% Potential Market Share in Units Total Thrift Core Nano Elite 18,914 Units 5,104 Demanded 6,681 3,651 3,479 100.0% % of Market 27.0% 35.3% 19.3% 18.4% 7.3% 9.7% Attic 16.3% 7.8% 4.9% Axe 17.9% 8.1% 8.8% 4.1% Art 17.3% 8.4% Ant 4.4% 17.6% Total 16.3% 25.7% 29.8% 34.8% 6.0% 2.3% Best 6.1% 11.8% 8.1% 5.1% Bam 2.5% 9.9% 4.6% Bell 18.1% 8.6% 17.9% Bit 7.1% 17.4% Total 6.0% 39.5% 44.1% 7.1% 8.8% Creak 23.0% 2.3% 6.8% Cat 27.2% 4.0% 7.5% Cent 1.4% 14.3% 5.0% 1.6% 30.2% City 0.9% 14.4% 4.0% Total 52.4% 35.0% 11.6% 5.6% 9.1% 9.9% Drum 20.3% 10.2% 3.7% Daft 11.0% 22.2% 3.2% Deal 0.8% 12.7% 5.2% Dino 0.1% 6.5% 10.4% Total 31.3% 33.2% 19.2% 5.9% 2.3% 5.1% 4.6% 17.9% Creak Cat Cent City Total 23.2% 2.3% 27.5% 4.0% 1.4% 14.7% 5.0% 0.9% 14.8% 6.6% 53.1% 35.8% 11.6% 1.6% 4.0% 5.6% 7.0% 8.7% 6.7% 7.4% 29.8% 6.6% Drum Daft peal bino Total 20.3% 10.3% 10.1% 20.4% 0.8% 12.7% 5.2% 0.1% 6.5% 10.4% 30.4% 31.7% 19.2% 15.6% 26.0% 9.1% 10.8% 3.7% 3.2% 26.8% Page 9 15.6% COMP-XM INQUIRER Top COMP. XM INQUIRER Perceptual Map Round: December 31, 2019 Perceptual Map for All Segments Perceptual map (at end of this year) Size 201 19 18 17 16 15 14 13 Drum Freak 12 1 10 Dafy City Cent 9 Dino EAD 8 Best Deat 6 5 4 3 2 Performance 10 11 12 13 14 15 16 17 18 19 20 0 2 3 4 5 6 8 9 Name Attic Axe Art Ant Revised Name 4/13/2017 Best 12/10/2018 Bam 11/9/2019 Bell 11/14/2019 Bit Baldwin Pfmn Size 10.4 7.8 13.6 8.6 12.0 6.0 14.0 8.0 Revised Name 11/12/2019 Creak 12/13/2019 Cat 12/22/2019 Cent 12/5/2019 City Chester Pfmn Size 7.8 12.2 8.0 12.0 10.4 9.2 11.1 9.7 Revised 12/11/2019 12/19/2019 12/3/2019 11/19/2019 Andrews Pfmn Size 6.7 13.3 9.4 10.6 12.1 6.0 14.2 8.0 Digby Size 7.0 13.0 9.6 10.4 11.5 6.7 13.5 8.5 Pfmn Name Drum Daft Deal Dino Revised 6/27/2020 11/30/2019 12/22/2019 11/5/2019 COMP-XM INQUIRER Page 10 Proforma Balanced Scorecard DRAFT SAVED AT Jul 20, 2020 07:14PM EDT Days Round 1 Projected Results CRITERIA Score / Points No Credit Partial Credit Full Credit Financial Stock Price 7.0 / 7.0 = $80.00 Profits 7.0 / 7.0 = $14,000,000 Leverage 0.9 / 6.0 = 4.0 1.3 ... 4.0 1.8 ... 2.8 Sub Total Financial 14.9 / 20.0 Internal Business Process Contribution Margin 2.8 / 4.0 = 40.0% Plant Utilization 4.0 / 4.0 = 200.0% 90.0% ... 200.0% 100.0% ... 180.0% of Working Capital 0.0 / 4.0 = 105 15 ... 105 30 ... 90 Stock-out Costs 0.0 / 4.0 >= 5.0% 5.0% ... 0.0% = 5.5% 5.5% ... 2.5% = 47.0 Customer Awareness 3.0 / 4.0 = 90.0% Customer Accessibility 2.0 / 4.0 = 90.0% Product Count 2.3 / 4.0 = 8.0 3.2 / 4.0 = 25.0% 5.0% ... 25.0% 7.0% ... 20.0% Sub Total Customer 12.1 / 20.0 Learning and Growth Employee Turnover Rate 0.0 / 6.0 >= 10.0% 10.0% ... 8.0% = 103.0% TOM Material Reduction 0.0 / 2.0 = 3.1% TOM R&D Reduction 0.0 / 2.0 = 26.7% TOM Admin Cost Reduction 0.0 / 2.0 = 38.0% TOM Demand Increase 0.0/2.0 = 4.3% Sub Total Learning and Growth 0.0 / 20.0 Score for Round 1 37.8 / 80.0 Recapitulation Interim Results Recap criteria evaluate your company's overall performance and are finalized when your simulation is completed. Interim results chart your progress towards those ending goals. Your score only includes the Recap for the last completed round. SG&A Expense 15.0 / 15.0 9.7 / 15.0 15.0 / 15.0 39.7 / 45.0 = 2.0% 1.0% ... 35.0% $97,000,000 ... $205,000,000 2.0% ... 0.0% >= 35.0% >= $205,000,000 = $88,000,000 Financial Market Cap (End) Sales (Ave) Emergency Loan (Ave) Sub Total Financial Internal Business Process Operating Profit (Cum) Sub Total Internal Business Process Customer Wtg Avg Cust Survey Score (Ave) Market Share (Ave) Sub Total Customer Learning and Growth Sales/Employee (Ave) Assets/Employee (Ave) Profits/Employee (Cum) Sub Total Learning and Growth Recap Score 5.5 / 15.0 6.5 / 30.0 12.0 / 45.0 = 44.0 >= 31.0% 8.8 / 15.0 4.8 / 15.0 4.1 / 15.0 17.7 / 45.0 82.4 / 180.0 = $290,000 >= $278,000 >= $115,000