Recalculate in Research & Development Teamname: Andrews SimID: C121835_071 Round: 2 Year: 2022 Draft saved at Sep 21, 2020 04:17PM PDT Perceptual Map (at end of this year) Name Pfmn Size MTBF Revision Date 10-May-22 Age at Revision R&D Cost 20 Able 5.7 14.3 14000 1.4 $363 18 Ader2 Alt Acre 4.0 15.0 10000 3.7 $1875 16 Aft Able Adam 3.0 17.0 10-Nov-23 03-Apr-25 17-Feb-25 12000 14 2.4 $3258 12 TAgape Adam Agape Aft 4.1 16.3 13000 2.6 $3136 10 4.3 13.0 17000 1.9 $258 8 Agape Agape2 03-Apr-22 07-Jan-23 3.0 17.0 12000 0.0 $1020 6 4 NA 0.0 0.0 0 $0 2 NA 0.0 0.0 0 $0 0 Total $9910 0 2 4 6 8 10 12 14 16 18 20 Performance Material Cost o Age Profile 7.5 Able 19.28 10.53 Acre 5.6 6.6 5.93 6.91 Adam 14.89 4.1 5 Aft 14.82 5.37 Perceived Age in Years 3.9 3.6 37 12.26 10.36 2.7 2.6 2.4 2.8 2.5 1.9 Agape Agape20 $0 5.62 114 1.6 $2.5 $5 $12.5 $15 $17.5 $7.5 $10 Material Cost in dollars 0 0 0 O New Material Cost Old Material Cost Able Acre + Adam - Aft + Agape + Agape2 Recalculate Production Teamname: Andrews SimID: C121835_071 | Round: 2 Year: 2022 Draft saved at Sep 21, 2020 04:19PM PDT Able Acre Adam Aft Agape Agape2 NA NA Total 1,695 2,700 775 740 630 0 0 0 6,540 Production Schedule Unit Sales Forecast Inventory On Hand Production Schedule Production After Adj. 0 328 35 63 170 0 0 0 596 1212 c 2194 462 426 372 0 4,666 .. 1,200 2,173 458 422 368 0 0 0 4,621 0 15.4% 37.1% 0.0% 0.0% 0.0% 0.0% 0 0 $8.13 $5.31 $9.41 $9.41 $7.05 $0.00 0 0 Margins 2nd Shift Production% Labor Cost/Unit Material Cost/Unit Total Unit Cost Contribution Margin $9.73 $6.91 $14.89 $14.82 $5.62 0 0 $17.85 $12.21 $24.30 $24.23 $10.85 $17.91 16.7% $5.62 0 0 6.0% 21.2% 10.0% 16.5% 0.0% 0 0 Total 1,050 1,600 480 600 0 0 0 4,905 1,175 100 100 100 100 100 100 600 4.5 7.0 3.0 3.0 5.0 0.0 0.0 0.0 Physical Plant 1st Shift Capacity 0 Buy/Sell Capacity Automation Rating New Autom. Rating Investment ($000) Workforce Complement 5.0 3.0 3.0 4.0 $ 4,300 Last Year $ 15,400 Needed $ 1,800 This Year % 100 % $ 1,800 This Year o 3.0 $ 11,200 1st Shift 3.0 $ 1,800 2nd Shift $ 0 Overtime $ 0 Max Invest A/P Lag $ 36,300 $ 36,611 30 829 640 640 556 84 0.0% Production vs Capacity 4k Price vs Unit Cost $40 3k $30 2k $20 ik $10 Ok $0 Able Acre Adam Aft Agape Agape2 Able Acre Adam Aft Agape Agape2 Both Shifts Base Capacity Production Material Labor Margin Recalculate M Marketing Name Price Promo Budget $ 1100 Sales Budget Benchmark Prediction 2,391 Your Forecast 1695 $ 19.00 800 $ 15.50 1000 $ 700 2700 $ $ 3,279 617 $ 27.00 600 $ 700 775 $ Teamname: Andrews SimID: C121835_071 Round: 2 Year: 2022 Draft saved at Sep 21, 2020 04:18PM PDT Gross Variable Contrib Less Revenue 0 Costs Margin Promo/Sales $ 32,205 $ 30,264 $ 1,941 $ 41 $ 41,850 $ 32,980 $ 8,870 $ 7,170 $ 20,925 $ 18,833 $ 2,092 $ 792 $ 21,460 $ 17,928 $ 3,532 $ 1,832 $ 13,545 $ 11,281 $ 2,264 $ 564 $ 0 $ 0 $ 0 $ 0 $ 0 $0 $ 0 $0 $ 0 $0 $ 0 $ 0 $ 129,985 $ 111,286 $ 18,699 $ 10,399 29.00 $ 700 $ 1000 Able Acre Adam Aft Agape Agape2 NA NA 466 740 630 $ 21.50 $ 1000 $0.0 700 $0 $ 0 $ 0 1,655 0 0 $0.0 $ 0 $0.0 $ 0 0 $ 0 $ 4,200 Total $ 4,100 8,408 6,540 A/R Lag (days) 0:30 A/P Lag (days) : 30 Revenue Forecast Unit Sales Forecast 60 2,700 $41,850 40 $32,205 1,695 Revenue forecast (in DOO's) Unit Sales forecast (in 000's) $20,925 $21,460 20 776 $13,545 740 630 0 0 $0 Agape2 Able Acre Adam Aft Agape Able Acre Adam Aft Agape Agape2 Variable Cost Marketing Margin After Marketing Trad Low High Pfmn Size Recalculate Staffing Last Year This Year 829 100% Human Resources Teamname: Andrews | SimID: C121835_071 Round: 2 Year: 2022 Draft saved at Sep 21, 2020 04:20PM PDT Labor Negotiations Current Negotiation Labor Negotiation Position Contract Position 640 Demands Starting Ceiling 100% Hourly $22.05 $24.26 $ 22.05 $ 24.26 640 Wage Benefits $ 2,500 $ 2.750 $ 2,500 $ 2,750 556 Profit 2.0% 2.2% 2.0% 2.2% 84 Sharing % 0.0% Annual 5.0% 5.5% 5.0% 5.5% Raise 829 638 191 0.0% 10.0% 8.1% 212 52 Contract Expiration: 1-Oct-2029 Needed Complement Complement % 0 Complement 1st Shift Complement 2nd Shift Complement Overtime% Turnover Rate O New Employees Separated Employees Recruiting Spend Training Hours Productivity Index 0 Recruiting Cost Separation Cost Training Cost Total HR Admin Costs 0 189 $0 2700 0 50 100.0% 100.4% $192 $945 $640 $1777 Recalculate Finance Teamname: Andrews SimID: C121835_071 | Round: 2 Year: 2022 Draft saved at Sep 21, 2020 04:21PM PDT Liabilities & Owner's Equity Finances Retained Earnings: 11.7% $36,300 $ 0 Accounts Payable : 4.6 % Current Debt: 5.296 Common Stock: 24.5 % - Plant Improvements Total Investments ($000) Sales of Plant & Equipment Common Stock Shares Outstanding (000) Price Per Share o Earnings Per Share Max Stock Issue ($000) O Issue Stock ($000) Max Stock Retire ($000) Retire Stock ($000) Dividend Per Share 2,426 $ 34.73 ($ 6.43) $ 16,531 1600 Long Term Debt: 54% $ $ 4,133 0 $ $ 0.00 Current Debt Interest Rate 11.2% $ 20,000 Long Term Debt Retire Long Term Debt ($000) O 0 Issue Long Term Debt ($000) O 20000 Long Term Interest Rate 12.6% Maximum Issue This Year $ 20,080 A/R Lag (days) 30 A/P Lag (days) 30 Outstanding Bonds Series Number Face Amount Current Yield o 2021 Close 11.0S2022 $ 6,950 11.2% $ 98.58 12.5S2024 $ 13,900 12.5% $ 99.76 14.0S2026 $ 20,850 13.3% $ 104.97 11.352031 $ 18,000 12.2% $ 92.83 $ Due This Year Borrow ($000) Cash Positions December 31, 2021 December 31, 2022 0 $ 37,220 $ 9,956 Selected Financial Statistics Digby Andrews - 15.0% 0.74 - 11.196 2.7 Baldwin 5.3% 1.03 5.5% 2.0 Chester 6.7% 1.20 8.196 1.9 7.2% 1.17 8.496 1.9 Ferris 7.596 1.33 10.09 1.9 ROS Asset Turnover ROA Leverage (Assets/Equity) ROE Emergency Loan Sales EBIT Profits Cumulative Profit SG&A / Sales Contrib. Margin % -30.596 SO $100,201,259 ($13.098.467) ($15.006,788) ($9,076,864) 15.49% 14.396 11.196 SO $116.880.954 $15.980.922 $6,180.088 $17.935.733 14.79 35.09 15.69 so $145.901.196 $21.792.128 $9.818,484 $17,440,514 11.296 31.496 16.39% SO $ 153,203,554 $24,157,838 $11.020.518 $20.902.493 12.5% 33.396 Erie 5.496 0.90 4.896 2.0 9.896 SO $106,384,603 $15,794,202 $5.748.184 $14,320,616 11.496 33.896 19.49 SO $138,557 285 $21,624 214 $10,399,271 $20,561,468 13 296 32.696 Percent of Sales C121835_071 $ Market Share C121835_071 O Profit 0 Other O SGA O Depr O Var Costs 100% 90% 80% 70% 60% 50% 40% 30% 20 20% 10% 0% -10% Andrews 13.17 % Baldwin 15.35% Chester 19.17 % Digby 20.13 % Erie 13.98 % Andrews Chester Digby Erie Ferris O Ferris 18.2 % CAPSTONE COURIER Page 1 Top CAPSTONE Round: 2 Stocks & Bonds COURIER C121835_071 December 31, 2022 Company Close Shares EPS Dividend Yield PIE Andrews Baldwin Chester Digby Erie Ferris $3.22 $46.62 $48.27 $54.21 $ $41.57 $52.87 Change (531.51) $1.44 $11.13 $12.67 $2.56 $11.62 2,425,595 2,048,274 2,069,366 2,070,649 2,128.085 2.000.000 MarketCap Book Value ($M) Per Share $8 $20.32 $95 $27.14 $100 $30.33 $112 $32.59 S88 $27.68 $106 $26.80 (56.10) $3.02 $4.74 $5.32 $2.70 $5.20 $0.00 $3.78 $0.39 $0.00 $1.67 $1.51 0.096 8.196 0.89 0.096 4.096 2.8% -0.5 15.4 10.2 10.2 15.4 10.2 Closing Stock Price C121835_071 $70 S60 $50 $40 * Andrews Baldwin Chester Digby Erie Ferris $30 S20 $10 SO 2020 2021 2022 2023 2024 2025 2026 2027 2028 Bond Market Summary Company Series# Face Yield Close $ S&P Andrews 12.5S2024 14.0S2026 11.38 2031 12.6S2032 $13.900.000 $20.850.000 $18,000.000 $20.000.000 12.79 13.8% 12.7% 13.2% 98.34 101.47 88.92 95.21 0000 5 Baldwin 12.5S2024 14.0S2026 $11.201,656 $20.850.000 12.5% 13.496 100.17 104.82 B B Chester 12.55 2024 14.0S2026 $13.900.000 $20.850.000 12.49 13.296 100.67 105.78 B B Digby 12.5S2024 14.09 2020 11.782032 $13.828,904 $20,850,000 $2.918.008 12.4% 13.2% 12.09 100.67 105.76 97.75 B B Erie 12.5S2024 14.0S2026 11.752032 $13.900.000 $20.850.000 $1.998,506 12.596 13.39 12.196 100.34 105.13 96.65 B B B Ferris 12.55 2024 14.0S2026 $4.683.196 $20.850.000 12.496 13.296 100.87 105.76 B B Next Year's Prime Rate 8.00% CAPSTONE COURIER Page 2 Top Financial Summary CAPSTONE COURIER C121835_071 Round: 2 December 31, 2022 Andrews Baldwin Chester Digby Erie Ferris ($15,007) $8.180 $9.818 $11.021 $5.748 $10.399 Cash Flow Statement Survey Cash flows from operating activities Net Income (Loss) Adjustment for non-cash items: Depreciation Extraordinary gains/losses/writeoffs $10.939 SO $7.587 S63 $7.707 $10 $7.473 $7 $8,255 $ (5539) $5.927 (5807) CAPSTONE Financial Summary COURIER C121835_071 Round: 2 December 31, 2022 Andrews Baldwin Chester Digby Erie Ferris ($15.007) $8.180 $9,818 $11,021 $5,748 $10.399 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 $10.939 SO $7,587 $63 $7.707 $10 $7.473 $7 $8,255 (5539) $5,927 (3807) ($1.574) $10.987 $2.402 $7.748 (5611) $689 $502 $14,409 $886 $5.267 ($2.406) $21,283 $1,805 $3.680 $ ($3.079) $20,706 ($1,331) $9,575 $224 $21,931 $1.060 $3.6921 ($2,170) $18.101 (836,300) ($3.230) ($5,840) ($19.920) ($7.792) ($6.910) 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 SO $1.600 SO $20,000 SO ($20,000) SO SO ($7.731) SO SO SO ($3,745) (S11,359) $19.214 SO (5813) SO SO SO (5419) ($11,350) $15,192 SO SO $2.300 SO $2.918 SO ($11.350) $18.138 SO ($3,562 SO SO $1.999 SO ($11.350) $14.443 SO ($3,011) SO SO SO ($1,240) ($11.350 $17.422 SC Net cash from financing activities $1,600 (53,620) $2.601 $11.997 $1,521 $1,812 ($26.952) $7.559 $18.244 $12.783 $15.660 $13.003 Net change in cash position Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets Andrews $10.268 58.236 Baldwin $28.985 $9.605 $8.725 $45.295 Chester $33.729 $11.992 $5.333 $51,054 Digby $30.061 $12.592 $7.009 $49.663 Erie $32.560 $8.744 $719 $42.022 Ferris $29.222 $11,388 $7.162 $47.773 $228 $18.732 Plant and equipment Accumulated Depreciation Total Fixed Assets $165,890 ($49,492 $116,398 S113.800 ($46,187) $67,613 $115,600 ($44.853) $70,747 $127.100 ($45,527) $81.573 $123.818 (346.928) $76.890 $88.900 ($32,807 $56.093 Total Assets S135.130 $112.908 $121,800 $131,236 $118.912 S103,866 Accounts Payable Current Debt Total Current Liabilities $8.153 $6.950 $13.103 $8.099 $19.214 $25,313 $7.736 $16.558 $24.294 $8.022 $18.138 $28.160 $5.012 $18.253 $23,265 $7,307 $17.422 $24.729 Long Term Debt Total Liabilities $72.750 $85.853 $32.052 $57.365 $34.750 $50,043 $37.597 $63.757 $36.749 $60.013 $25,533 $50.262 Common Stock Retained Earnings Total Equity $32.960 $16.317 $49.276 $19.045 $35,598 $55,543 $20.736 $42.021 $62.757 $21.183 $48.296 $67.470 $22.747 $38,152 $58,899 $18.360 $35.244 $53,604 Total Liabilities & Owners' Equity $135.130 $112.908 $121,800 $131,236 $118.912 S103.866 Digby 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 CAPSTONE COURIER Andrews $100 201 $85.881 $14,320 $10.930 $15.399 $1,080 ($13.098) $9.989 ($8,081) SO ($15,007) Baldwin $116.881 $75,946 $40.015 $7,587 $17.228 $120 $15.981 $6,270 $3.396 $126 $8.180 Chester $145,901 $100,026 $45,875 $7,707 $16.360 $17 $21.792 $8.378 $5.395 $200 $9,818 $153,204 S102.127 $51,077 $7.473 $19.178 $268 $24,158 $8,857 $8.055 $225 $11.021 Erie S106,385 $70,637 $35.748 $8,255 $12.138 ($439) $15.794 $8.770 $3.158 $117 $5.748 Ferris $138,557 $93,453 $45,104 $5.927 $18.341 ($788 $21,824 $5.299 $5,714 $212 $10.399 Page 3 Top CAPSTONE Production Analysis COURIER C121835_071 Round: 2 December 31, 2022 Production vs Capacity C121835_071 Andrews Baldwin Chester Digby Erie Ferris 0 500 1,000 1,500 2.000 2,500 3,000 3,500 4,000 4,500 5,000 Capacity Production Production Information Unit Primary Units Inven Age Pfmn Size Segment Sold tory Revision Date Dec.31 MTBF Coord Coord Price 2nd Auto Shift & mation Capacity Material Labor Contr. Over Next Next Plant Cost Cost Marg. time Round Round Utiliz. Name 0 0 Able Acre Adam Aft Agape Agape2 Trad Low Trad Pfmn Trad 1.200 2,500 492 476 538 0 5/11/2022 11/12/2023 4/4/2025 2/18/2025 4/3/2022 1/8/2023 2.0 14000 6.6 14000 2.6 23000 3.1 25000 2.7 17000 0.0 0 5.7 3.0 8.9 10.0 4.3 0.0 14.3 $10.00 $8.95 $8.13 17.0 $15.50 $6.38 $5.31 12.0 $27.00 $14.27 $9.41 15.5 $29.00 $14.24 $9.41 13.0 $21.50 $9.97 $7.05 0.0 $0.00 $0.00 $0.00 798 20% 11% 1796 1196 096 1596 37% 096 096 096 096 4.0 5.0 3.0 3.0 3.0 3.0 1.150 114% 1.700 136% 580 9596 700 7096 1.275 31% 100 096 9 0 Baker Bead Bid Trad Low High High Size 946 1.799 813 317 270 83 0 131 69 102 12/5/2022 5/24/2018 12/18/2022 7/27/2022 9/18/2022 1.8 17000 6.6 14000 1.2 23500 1.7 22000 1.6 16000 6.5 3.0 10.4 8.8 6.2 13.5 $29.00 $10.60 $7.05 17.0 $21.00 $6.38 $6.37 9.6 $39.00 $16.26 $11.50 13.5 $34.00 $13.29 $9.40 11.4 $34.00 $11.26 $9.40 40% 38% 3096 3096 3496 096 2196 8996 098 096 5.0 7.0 3.0 3.0 3.0 1.300 69% 1.400 120% 550 1879 600 5896 650 5096 Bold Buddy Trad Low Cake Cedar Cid Coat Cure High Pfmn Size 1,271 1.885 710 710 793 0 0 106 29 82 8/26/2022 1/29/2021 11/15/2022 11/3/2022 9/10/2022 1.9 14000 6.6 12000 1.3 23000 1.5 27000 1.6 17000 6.4 3.0 10.2 11.8 5.4 13.6 $26.50 $9.81 $7.49 17.0 $19.50 $5.78 $5.79 9.8 $37.50 $15.92 $10.04 13.9 $32.50 $16.38 $10.04 8.6 $32.50 $12.94 $10.51 35% 3896 3196 2196 2796 1596 2596 17% 1796 3396 5.5 7.5 3.0 4.0 4.0 1.000 1149 1.400 1249 600 11696 600 11696 600 132% 6 Trad Low High Daze Dell Dixie Dot Dune Doom 1.385 1.814 712 715 773 0 8/22/2022 5/24/2018 12/3/2022 11/13/2022 11/13/2022 8/9/2023 141 45 86 0 1.8 18100 6.6 14000 1.2 24000 1.5 27000 1.5 19000 0.0 0 6.8 3.0 10.2 11.8 5.8 0.0 13.3 $20.00 $11.17 $7.18 17.0 $21.50 $6.38 $6.06 9.8 $39.00 $16.22 $10.88 13.9 $34.00 $16.38 $10.04 8.6 $34.00 $13.65 $10.51 0.0 $0.00 $0.00 $0.00 3796 4096 3196 2496 3096 096 496 796 50% 1796 3396 096 5.0 7.0 3.0 3.0 3.0 6.0 1,200 10396 1.400 100% 800 1499% 600 116% 850 13296 500 096 Pfmn Size Eat Ebb Echo Edge Egg Trad Low Trad Pfmn Size 1.407 1.778 1,059 66 84 0 0 0 0 33 4/8/2022 1/15/2022 7/20/2022 6/30/2018 12/24/2022 2.1 15500 6.6 12000 1.4 16000 4.5 25000 2.3 19000 5.5 3.0 6.4 9.4 6.9 14.5 $27.00 $9.21 $7.05 17.0 $19.50 $5.78 $6.30 13.6 $27.00 $10.21 $8.43 15.5 $34.00 $13.87 $11.63 13.4 $34.00 $11.44 $9.40 3896 3696 2696 2896 33% 096 1896 696 9996 096 7.0 6.0 5.0 3.0 3.0 1,400 9296 1,400 11796 900 105% 1 198% 800 896 Fast Feat Fist Foam Fume Fox Trad Low High Pfmn Size 1,085 1.310 712 689 798 0 69 0 112 38 91 0 4/22/2022 7/27/2025 12/22/2022 11/11/2022 11/9/2022 12/12/2022 2.1 14000 6.6 13000 1.2 25000 1.5 27000 1.5 19000 0.0 25000 5.5 3.0 10.2 11.8 5.4 11.0 14.5 $29.00 $8.78 59.15 36% 17,0 $22.00 $6.08 $8.36 3396 9.8 $39.00 $16.52 $10.67 3296 14.2 $34.00 $16.30 $16.30 $8.78 2896 8.4 $34.00 $13.67 $9.20 33% 9.0 $39.00 $0.00 $0.00 096 3196 6496 4096 17% 3396 096 4.0 6.0 3.0 4.0 4.0 5.5 800 130% 700 163% 550 139% 600 11696 800 13296 500 096 CAPSTONE COURIER Page 4 Accessibility C121835_071 Traditional Andrews Traditional Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 8.800 8.800 30.49 Baldwin Chester Next Year's Segment Growth Rate 9.2% Digby Erie Ferris Traditional Customer Buying Criteria Expectations Importance 1. Age Ideal Age = 2.0 4796 2. Price $19.00 - 20.00 239 3. Ideal Position Pfmn 6.4 Size 13.6 21% Reliability MTBF 14000-19000 996 Perceptual Map for Traditional Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% Actual vs Potential Market Share 2022 C121835_071 Traditional TH 30% 25% Sabte 1 ape 20% . 15% 10% 5% 0% Actual Potential Performance 16 17 18 19 20 0 56 10 12 14 Top Products in Traditional Segment Units Market Sold to Revision Stock Name Share Seg Date Out Eat 1596 1.362 4/8/2022 YES Daze 1596 1,348 8/22/2022 Cake 1496 1.255 8/26/2022 YES Fast 12% 1.084 4/22/2022 Able 1296 1.032 5/11/2022 YES Echo 1296 1,021 7/20/2022 YES Baker 1196 945 12/5/2022 Agape 5% 467 4/3/2022 YES Adam 3% 288 4/4/2025 YES Bead 096 1 5/24/2016 YES Dell 0% 1 1 5/24/2018 YES CAPSTONE COURIER Pfmn Size Coord Coord 5.5 14.5 6.8 13.3 6.4 13.6 5.5 14.5 5.7 14.3 6.4 13.8 6.5 13.5 4.3 13.0 8.9 12.0 3.0 17.0 3.0 17.0 Cust. List Age Promo Aware- Price MTBF Dec.31 Budget ness $27.00 15500 2.09 $1.050 63% $29.00 18100 1.84 $1,100 68% $26.50 14000 1.87 $1.100 68% $29.00 14000 2.08 $900 59% $19.00 14000 2.04 $1,100 64% $27.00 16000 1.40 $1.050 57% $29.00 17000 1.76 $1.300 78% $21.50 17000 2.67 $700 44% $27.00 23000 2.62 $600 41% $21.00 14000 6.60 $1,300 74% $21.50 14000 6.60 $1,100 64% Cust Sales Access Budget ibility $1.085 5496 $1,440 5396 $1.270 4796 $1.235 4896 $800 51% $775 5496 $1,418 5396 $1.000 5196 $700 5196 $1.418 5396 $1,512 5396 Dec Cust. Survey 31 36 35 24 45 29 37 24 12 0 0 Page 5 8.48 Top CAPSTONE Low End Market Segment Analysis COURIER C121835_071 Round: 2 December 31, 2022 Accessibility C121835_071 Low End Andrews Low End Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 11.180 11.123 38.6% Baldwin Chester Next Year's Segment Growth Rate 11.796 Digby Erie Low End Customer Buying Criteria Expectations 1. Price $14.00 - 24.00 Ideal Age = 7.0 3. Ideal Position Pfmn 2.7 Size 17.3 4. Reliability MTBF 12000-17000 Ferris 2 Age Importance 5396 24% 1696 796 0% 20% 40% 60% 80% 100% Perceptual Map for Low End Segment Perceptual map (at end of this year) Actual vs Potential Market Share 2022 C121835_071 Low End 18 30% % 25% Agape 20% 15% 10 10% 8 5% 0% Ene Actual Potential Performance 8 9 10 11 12 13 14 15 16 16 17 18 19 20 0 2 4 8 Top Products in Low End Segment Units Market Sold to Name Share Seg Acre 2296 2.490 Cedar 1796 1,884 Bead 1696 1.798 Ebb 1896 1.777 Dell 1596 1.813 Feat 12% 1.309 Able 296 168 Eat 096 45 Cake 096 15 Agape 0 15 CAPSTONE COURIER Revision Stock Date Out 11/12/2023 YES 1/20/2021 YES 5/24/2016 YES 1/15/2022 YES 5/24/2016 YES 7/27/2025 YES 5/11/2022 YES 4/8/2022 YES 8/26/2022 YES 4/3/2022 YES Pfmn Size Coord Coord 3.0 17.0 3.0 17.0 3.0 17.0 3.0 17.0 3.0 17.0 3.0 17.0 5.7 14.3 5.5 14.5 6.4 13.8 4.3 13.0 Cust List Age Promo Aware- Price MTBF Dec. 31 Budget ness $15.50 14000 6.80 $1.000 74% $19.50 12000 6.60 $1.100 64% $21.00 14000 6.60 $1,300 74% $19.50 12000 6.60 $1.050 62% $21.50 14000 6.60 $1,100 6496 $22.00 13000 6.60 $1,100 64% $19.00 14000 2.04 $1.100 64% $27.00 15500 2.09 $1.050 63% $26.50 14000 1.87 $1.100 68% $21.50 17000 2.67 $700 $ 4496 Cust. Sales Access- Budget ibility $700 4096 $1.333 4096 $1,418 4096 $1.085 $ 3696 $1,512 4296 $1.235 $ 3696 $800 4096 $1,085 3696 $1.270 4096 $1.000 4096 Dec Cust. Survey 45 25 23 23 20 17 5 1 0 2 2 Page 6 096 Accessibility C121835_071 High End High End Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 3.448 3.448 11.996 Andrews Baldwin Chester Next Year's Segment Growth Rate 16.2% Digby Erie Ferris 2 Age High End Customer Buying Criteria Expectations Importance 1. Ideal Position Pfmn 10.7 Size 9.3 4396 Ideal Age = 0.0 299% 3. Reliability MTBF 20000-25000 19% 4. Price $29.00 - 39.00 996 Perceptual Map for High End Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% JULI Actual vs Potential Market Share 2022 C121835_071 High End 30% 25% Ephe Bold 20% - Adam Budd 15% Desde 10% 5% 0% O Actual Potential 0 2 8 8 10 Performande 14 15 16 17 18 19 20 12 Top Products in High End Segment Units Market Sold to Name Share Seg Bid 24% 813 Fist 2196 712 Dixie 2196 712 Cid 2196 710 Bold 696 206 Adam 896 198 Daze 196 31 Echo 196 20 Buddy 196 19 Dot 096 11 Coat 096 11 Foam 096 3 CAPSTONE COURIER Revision Stock Date Out 12/18/2022 12/22/2022 12/3/2022 11/15/2022 7/27/2022 4/4/2025 YES 8/22/2022 7/20/2022 YES 9/18/2022 11/13/2022 11/3/2022 11/11/2022 Pfmn Size Coord Coord 10.4 9.6 10.2 9.8 10.2 9.8 10.2 9.8 8.8 13.5 8.9 12.0 6.8 13.3 6.4 13.6 6.2 11.4 11.8 13.9 11.8 13.9 11.8 14.2 List Age Promo Price MTBF Dec. 31 Budget $39.00 23500 1.10 $1.250 $39.00 25000 1.18 $1.100 $39.00 24000 1.23 $1,100 $37.50 23000 1.25 $1,000 $3400 22000 1.67 $1,300 $27.00 23000 2.62 $600 $29.00 18100 1.84 $1,100 $27.00 16000 1.40 $1,050 $ $34.00 16000 1.64 $1.300 $34.00 27000 1.47 $1,100 $32.50 27000 1.48 $1.000 $34.00 27000 1.47 $1,100 Cust. Aware- ness 71% 61% 63% 5896 72% 41% 68% 5796 7296 62% 56% 59% % Cust. Sales Access- Budget ibility $1.418 53% $1.235 4496 $1,512 $ 5196 $1,333 4496 $681 5396 $700 29% $1,440 5196 $775 20% $737 5396 $1,368 5196 $1.206 4496 $1.235 4496 Dec Cust. Survey 38 36 36 30 5 4 1 0 1 0 0 0 Page 7 Top CAPSTONE Performance Market Segment Analysis COURIER C121835_071 Round: 2 December 31, 2022 Accessibility C121835_071 Performance Performance Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry Andrews 2.749 2.749 9.5% Baldwin Chester Next Year's Segment Growth Rate 19.896 Digby Erie Ferris Performance Customer Buying Criteria Expectations Importance 1. Reliability MTBF 22000-27000 4396 2 Ideal Position Pimn 11.4 Size 14.6 2996 3. Price $24.00 - 34.00 1996 4. Age Ideal Age = 1.0 996 Perceptual Map for Performance Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% Actual vs Potential Market Share 2022 C121835_071 Performance 25% Edge Fast 20% 15% ..ILI 10% 5% 0% Baldwin Chester O Actual Potential Performand 16 17 18 19 20 8 10 12 14 Top Products in Performance Segment Units Market Sold to Name Share Seg Dot 26% 704 Coat 25% 890 Foam 25% 686 JAft 1796 476 Bold 49 111 Edge 2% 68 Adam 096 6 Daze 09 1 CAPSTONE COURIER Revision Stock Date Out 11/13/2022 11/3/2022 11/11/2022 2/18/2025 7/27/2022 8/30/2018 YES 4/4/2025 YES 8/22/2022 Pfmn Size Coord Coord 11.8 13.9 11.8 13.9 11.8 14.2 10.0 15.5 8.8 13.5 9.4 15.5 8.9 12.0 6.8 13.3 List Age Price MTBF Dec.31 $34.00 27000 1.47 $32.50 27000 1.48 $34.00 27000 1.47 $29.00 25000 3.10 $34.00 22000 1.67 $34.00 25000 4.50 $27.00 23000 2.62 $29.00 18100 1.84 Promo Budget $1,100 $1.000 $1.100 $700 $1.300 $300 $ $800 $1.100 Cust. Aware- ness 62% 58% 59% 44% 72% 25% 4196 68% Cust. Sales Access- Budget ibility $1,368 3896 $1,206 3396 $1.235 3596 $1.000 2896 $681 2396 $155 1796 $700 2896 $1.440 3896 Dec Cust. Survey 35 34 35 16 3 7 1 0 Page & Accessibility C121835_071 Size Andrews Size Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 2,778 2.776 9.696 Baldwin Next Year's Segment Growth Rate 18.39 Chester Digby Erie Ferris 1. Ideal Position 2. Age 3. Reliability 4 Price Size Customer Buying Criteria Expectations Pfmn 5.4 Size 8.6 Ideal Age = 1.5 MTBF 18000-21000 $24.00 - 34.00 Importance 43% 29% 19% 996 0% 20% 40% 60% 80% 100% Perceptual Map for Size Segment Perceptual map (at end of this year) Actual vs Potential Market Share 2022 C121835_071 Size 16 25% Agape 20% % 15% 10 10% Don 5% 0% O Actual Potential Performande 18 19 20 0 2 4 6 8 Top Products in Size Segment Units Market Sold to Name Share Seg Fume 29% 796 Cure 29% 793 Dune 2896 773 Buddy 9% 251 Egg 396 83 Agape 29 57 Echo 196 18 Daze 096 4 Cake 096 1 CAPSTONE COURIER Revision Stock Date Out 11/9/2022 9/10/2022 11/13/2022 9/18/2022 12/24/2022 4/3/2022 YES 7/20/2022 YES 8/22/2022 8/26/2022 YES Pfmn Size Coord Coord 5.4 8.4 5.4 8.6 5.8 8.6 6.2 11.4 6.9 13.4 4.3 13.0 6.4 13.6 6.8 13.3 6.4 13.6 List Age Price MTBF Dec.31 $34.00 19000 1.48 $32.50 17000 1.58 $34.00 19000 1.50 $34.00 16000 1.64 $34.00 19000 2.30 $21.50 17000 2.67 $27.00 16000 1.40 $29.00 18100 1.84 $26.50 14000 1.87 Promo Budget $1,100 $1.000 $1.100 $1,300 $1.050 $700 $1.050 $1,100 $1,100 Cust. Aware- ness 59% 56% 62% 72% 58% 44% 57% 6896 68% Cust Sales Access Budgetibility $1,235 39% $1,206 3796 $1,368 $ 4296 $737 28% $775 29% $1.000 27% $775 2996 $1,440 4296 $1.270 3796 Dec Cust. Survey 39 33 39 7 0 2 0 0 0 Page 9 Top CAPSTONE COURIER Market Share Report C121835_071 Round: 2 December 31, 2022 Units Sold vs Demand Chart C121835_071 Market Share C121835_071 30% 10,000 25% 20% 8,000 15% 6,000 10% 4,000 5% 0% 2,000 0 Trad Low High Pfmn Size Industry Unit Sales Total Unit Demand Trad I Low High OPfmn Size Potential Market Share in Units Trad Low High Pfmn 8,800 11,180 3,448 2,749 Size Total 2,776 28.961 30.496 38.6% 11.9% 9.5% 9.6% 100.0% 19.1% 2.4% 29.1% 3.2% 6.0% 0.2% 16.6% 6.8% 11.2% 1.7% 1.6% 3.3% 24.6% 9.4% 31.796 0.3% 31.9% 6.0% 3.2% 3.2% 16.8% 9.2% 14.3% 23.5% 6.0% 0.8% 30.0% 2.8% 5.5% 2.8% 1.1% 0.9% 13.1% 3.8% 9.2% 8.9% 8.9% 14.3% 3.9% 0.196 12.196 0.1% 0.1% 15.7% Actual Market Share in Units Trad Low High Pfmn Size Total Industry Unit 8,809 11,123 3,448 2,749 2,778 28,905 Units Sales pemanded of Market 30.5% 38.5% 11.9% 9.5% 9.6% 100.0% % of Market Able 11.7% 1.5% 4.2% Acre 0.0% 22.5% 8.7% Able Adam 3.3% 5.7% 0.2% 1.7% Acre Aft 17.3% 1.696 Adam Agape 5.39 0.196 2.0% 1.9% Aft Total 20.3% 24.1% 5.7% 17.596 2.0% 18.0% Agape Total Baker 10.7% 0.0% 3.3% Bead 0.0% 16.2% 6.2% Baker Bid 23.6% 2.8% Bead Bold 6.0% 4.0% 1.1% Bid Buddy 0.8% 9.0% 0.9% Bold Total 10.7% 16.2% 30.1% 4.0% 9.1% 14.3% Buddy Total Cake 14.2% 0.1% 4.4% Cedar 0.0% 16.996 6.5% Cake Cid 20.6% 2.5% Cedar Coat 0.3% 25.4% 2.5% Cid Cure 28.6% 2.7% Coat 14.396 17.1% 20.9% 25.4% 28.6% 18.8% Cure Total paze 15.3% 0.99% 0.1% 0.196 4.8% bell 0.0% 14.596 5.6% Daze pixie 20.6% 2.5% bell Pot 0.3% 25.6% 2.5% pacie pune 27.8% 2.7% pot Total 15.396 14.5% 21.9% 25.6% 28.0% 18.0% pune Total Eat 15.5% 0.4% 4.9% Ebb 0.0% 16.0% 8.2% Eat Echo 11.6% 0.6% 0.6% 3.7% Ebb Edge 2.4% 0.2% Echo F99 0.0% 3.0% 0.3% Edge Total 27.1% 16.4% 0.6% 2.4% 3.696 15.2% Egg Total Fast 12.3% 3.8% Feat 0.0% 11.8% 4.5% Fast Fist 20.7% 2.5% Feat Foam 0.1% 25.0% 2.4% Fist Fume 28.7% 2.8% Foam Total 12.3% 11.8% 20.8% 25.0% 28.7% 15.9% Eume Total CAPSTONE COURIER 20.5% 0.3% 3.7% 6.1% 2.4% 2.3% 2.7% 17.3% 24.1% Total 12.2% 15.8% 20.8% 24.1% 28.2% 28.2% 0.1% 12.9% 0.9% 12.6% 20.6% 0.3% 4.0% 4.9% 2.5% 2.3% 2.6% 16.3% 24.396 27.5% 27.7% 12.9% 12.6% 21.8% 24.3% 13.0% 0.3% 14.7% 10.6% 0.6% 0.6% 4.1% 5.7% 3.496 0.796 0.3% 14.1% 7.3% 23.7% 3.0% 3.6% 15.096 0.6% 7.3% 10.4% 10.4% 20.6% 0.1% 23.7% 3.2% 4.0% 2.5% 2.3% 2.7% 14.6% Page 10 10.4% 10.4% 20.7% 23.6% 28.4% 28.4% Perceptual Map for All Segments Perceptual map (at end of this year) Size 201 19 18 17 Elan 16 12 Edge 14 Els Bold 13 Agape Adam 12 1 BV 101 9 Drene 8 7 6 4 3 2 1 0 Performance 10 11 12 13 14 15 16 17 18 19 20 1 2 4 5 6 7 8 9 Name Able Acre Adam Aft Agape Andrews Pfmn Size 5.7 14.3 3.0 17.0 8.9 12.0 10.0 15.5 4.3 13.0 Revised Name 5/11/2022 Baker 11/12/2023 | Bead 4/4/2025 Bid 2/18/2025 | Bold 4/3/2022 Buddy Baldwin Pfmn Size 6.5 13.5 3.0 17.0 10.4 9.6 8.8 13.5 6.2 11.4 Revised Name 12/5/2022 Cake 5/24/2016 Cedar 12/18/2022 Cid 7/27/2022 | Coat 9/18/2022 Cure Chester Pfmn Size 13.6 3.0 17.0 10.2 9.8 11.8 13.9 5.4 8.6 Revised 8/20/2022 1/29/2021 11/15/2022 11/3/2022 9/10/2022 Name Daze Dell Dixie Dot Dune Pfmn 5.5 3.0 Digby Size 13.3 17.0 9.8 13.9 8.6 Pfmn 6.8 3.0 10.2 11.8 5.8 Revised Name 8/22/2022 | Eat 5/24/2016 Ebb 12/3/2022 Echo 11/13/2022 Edge 11/13/2022 Egg Erie Size 14.5 17.0 13.6 15.5 13.4 Revised Name 4/8/2022 Fast 1/15/2022 Feat 7/20/2022 Fist 6/30/2018 Foam 12/24/2022 Fume Fox Pfmn 5.5 3.0 10.2 11.8 5.4 11.0 Ferris Size 14.5 17.0 9.8 14.2 8.4 9.0 Revised 4/22/2022 7/27/2025 12/22/2022 11/11/2022 11/9/2022 12/12/2022 9.4 6.9 CAPSTONE COURIER Page 11 Top CAPSTONE HR/TOM Report C121835_071 Round: 2 December 31, 2022 HUMAN RESOURCES SUMMARY Needed Complement Complement 1st Shift Complement 2nd Shift Complement Andrews 640 840 556 84 Baldwin 632 832 517 115 Chester 788 788 850 138 Digby 805 805 878 127 Erie 562 562 523 39 Ferris 740 740 541 199 Overtime %6 Turnover Rate New Employees Separated Employees Recruiting Spend Training Hours Productivity Index 0.096 8.196 52 189 $2.700 50 100.49 0.096 8.9% 56 105 $2.000 30 100.0% 0.0% 9.196 99 0 $2.000 25 100.0% 0.0% 8.996 181 0 $2,200 30 0.0% 9.1% 51 145 $2.000 25 100.096 0.096 8.99 129 0 $2.500 30 100.0% 100.0% Recruiting Cost Separation Cost Training Cost Total HR Admin Cost $192 $945 $640 $1.777 $168 $520 $379 $1.074 $297 SO $394 $691 $580 SO $483 $1,063 $153 $723 $281 $1.157 $451 SO $444 $895 Labor Contract Next Year Wages Benefits Profit Sharing Annual Raise $23.15 2.500 2.09 5.09 $23.15 2.500 2.09 5.09 $23.15 2.500 2.096 5.0% $23.15 2.500 2.096 5.0% $23.15 2.500 2.0% 5.0% $23.15 2.500 2.0% 5.0% Starting Negotiation Position Wages Benefits Profit Sharing Annual Raise Ceiling Negotiation Position Wages Benefits Profit Sharing Annual Raise Adjusted Labor Demands Wages Benefits Profit Sharing Annual Raise Strike Days TQM SUMMARY Baldwin Andrews Chester Digby Erie Ferrie Process Mgt Budgets Last Year CPI Systems sc sc so SO $0 SO SO SO $0 SO SO SO SO SO SO SO SO SO SO SO $0 SO SO SO SO SO SO SO SO SO SO SO SO Vendor/JIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs TQM Budgets Last Year Benchmarking Quality Function Deployment Effort CCE/6 Sigma Training GEMI TQEM Sustainability Initiatives Total Expenditures SO SO SO SO $0 SO SO SO SO SO SO SO SO SO SO SO SO SO SO SO sc SC sc sc sc SO SO Cumulative Impacts Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction Admin Costs Demand Increase CAPSTONFA GOURIFR 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.0096 0.0096 0.00% 0.0096 0.0096 0.00% 0.0096 0.00% 0.0096 0.00% 0.0096 0.00% 0.00% 0.0096 0.00% 0.00% 0.00% 0.0096 0.00% 0.0095 0.009 0.0098 0.00 0.009 Pane 17 Recalculate in Research & Development Teamname: Andrews SimID: C121835_071 Round: 2 Year: 2022 Draft saved at Sep 21, 2020 04:17PM PDT Perceptual Map (at end of this year) Name Pfmn Size MTBF Revision Date 10-May-22 Age at Revision R&D Cost 20 Able 5.7 14.3 14000 1.4 $363 18 Ader2 Alt Acre 4.0 15.0 10000 3.7 $1875 16 Aft Able Adam 3.0 17.0 10-Nov-23 03-Apr-25 17-Feb-25 12000 14 2.4 $3258 12 TAgape Adam Agape Aft 4.1 16.3 13000 2.6 $3136 10 4.3 13.0 17000 1.9 $258 8 Agape Agape2 03-Apr-22 07-Jan-23 3.0 17.0 12000 0.0 $1020 6 4 NA 0.0 0.0 0 $0 2 NA 0.0 0.0 0 $0 0 Total $9910 0 2 4 6 8 10 12 14 16 18 20 Performance Material Cost o Age Profile 7.5 Able 19.28 10.53 Acre 5.6 6.6 5.93 6.91 Adam 14.89 4.1 5 Aft 14.82 5.37 Perceived Age in Years 3.9 3.6 37 12.26 10.36 2.7 2.6 2.4 2.8 2.5 1.9 Agape Agape20 $0 5.62 114 1.6 $2.5 $5 $12.5 $15 $17.5 $7.5 $10 Material Cost in dollars 0 0 0 O New Material Cost Old Material Cost Able Acre + Adam - Aft + Agape + Agape2 Recalculate Production Teamname: Andrews SimID: C121835_071 | Round: 2 Year: 2022 Draft saved at Sep 21, 2020 04:19PM PDT Able Acre Adam Aft Agape Agape2 NA NA Total 1,695 2,700 775 740 630 0 0 0 6,540 Production Schedule Unit Sales Forecast Inventory On Hand Production Schedule Production After Adj. 0 328 35 63 170 0 0 0 596 1212 c 2194 462 426 372 0 4,666 .. 1,200 2,173 458 422 368 0 0 0 4,621 0 15.4% 37.1% 0.0% 0.0% 0.0% 0.0% 0 0 $8.13 $5.31 $9.41 $9.41 $7.05 $0.00 0 0 Margins 2nd Shift Production% Labor Cost/Unit Material Cost/Unit Total Unit Cost Contribution Margin $9.73 $6.91 $14.89 $14.82 $5.62 0 0 $17.85 $12.21 $24.30 $24.23 $10.85 $17.91 16.7% $5.62 0 0 6.0% 21.2% 10.0% 16.5% 0.0% 0 0 Total 1,050 1,600 480 600 0 0 0 4,905 1,175 100 100 100 100 100 100 600 4.5 7.0 3.0 3.0 5.0 0.0 0.0 0.0 Physical Plant 1st Shift Capacity 0 Buy/Sell Capacity Automation Rating New Autom. Rating Investment ($000) Workforce Complement 5.0 3.0 3.0 4.0 $ 4,300 Last Year $ 15,400 Needed $ 1,800 This Year % 100 % $ 1,800 This Year o 3.0 $ 11,200 1st Shift 3.0 $ 1,800 2nd Shift $ 0 Overtime $ 0 Max Invest A/P Lag $ 36,300 $ 36,611 30 829 640 640 556 84 0.0% Production vs Capacity 4k Price vs Unit Cost $40 3k $30 2k $20 ik $10 Ok $0 Able Acre Adam Aft Agape Agape2 Able Acre Adam Aft Agape Agape2 Both Shifts Base Capacity Production Material Labor Margin Recalculate M Marketing Name Price Promo Budget $ 1100 Sales Budget Benchmark Prediction 2,391 Your Forecast 1695 $ 19.00 800 $ 15.50 1000 $ 700 2700 $ $ 3,279 617 $ 27.00 600 $ 700 775 $ Teamname: Andrews SimID: C121835_071 Round: 2 Year: 2022 Draft saved at Sep 21, 2020 04:18PM PDT Gross Variable Contrib Less Revenue 0 Costs Margin Promo/Sales $ 32,205 $ 30,264 $ 1,941 $ 41 $ 41,850 $ 32,980 $ 8,870 $ 7,170 $ 20,925 $ 18,833 $ 2,092 $ 792 $ 21,460 $ 17,928 $ 3,532 $ 1,832 $ 13,545 $ 11,281 $ 2,264 $ 564 $ 0 $ 0 $ 0 $ 0 $ 0 $0 $ 0 $0 $ 0 $0 $ 0 $ 0 $ 129,985 $ 111,286 $ 18,699 $ 10,399 29.00 $ 700 $ 1000 Able Acre Adam Aft Agape Agape2 NA NA 466 740 630 $ 21.50 $ 1000 $0.0 700 $0 $ 0 $ 0 1,655 0 0 $0.0 $ 0 $0.0 $ 0 0 $ 0 $ 4,200 Total $ 4,100 8,408 6,540 A/R Lag (days) 0:30 A/P Lag (days) : 30 Revenue Forecast Unit Sales Forecast 60 2,700 $41,850 40 $32,205 1,695 Revenue forecast (in DOO's) Unit Sales forecast (in 000's) $20,925 $21,460 20 776 $13,545 740 630 0 0 $0 Agape2 Able Acre Adam Aft Agape Able Acre Adam Aft Agape Agape2 Variable Cost Marketing Margin After Marketing Trad Low High Pfmn Size Recalculate Staffing Last Year This Year 829 100% Human Resources Teamname: Andrews | SimID: C121835_071 Round: 2 Year: 2022 Draft saved at Sep 21, 2020 04:20PM PDT Labor Negotiations Current Negotiation Labor Negotiation Position Contract Position 640 Demands Starting Ceiling 100% Hourly $22.05 $24.26 $ 22.05 $ 24.26 640 Wage Benefits $ 2,500 $ 2.750 $ 2,500 $ 2,750 556 Profit 2.0% 2.2% 2.0% 2.2% 84 Sharing % 0.0% Annual 5.0% 5.5% 5.0% 5.5% Raise 829 638 191 0.0% 10.0% 8.1% 212 52 Contract Expiration: 1-Oct-2029 Needed Complement Complement % 0 Complement 1st Shift Complement 2nd Shift Complement Overtime% Turnover Rate O New Employees Separated Employees Recruiting Spend Training Hours Productivity Index 0 Recruiting Cost Separation Cost Training Cost Total HR Admin Costs 0 189 $0 2700 0 50 100.0% 100.4% $192 $945 $640 $1777 Recalculate Finance Teamname: Andrews SimID: C121835_071 | Round: 2 Year: 2022 Draft saved at Sep 21, 2020 04:21PM PDT Liabilities & Owner's Equity Finances Retained Earnings: 11.7% $36,300 $ 0 Accounts Payable : 4.6 % Current Debt: 5.296 Common Stock: 24.5 % - Plant Improvements Total Investments ($000) Sales of Plant & Equipment Common Stock Shares Outstanding (000) Price Per Share o Earnings Per Share Max Stock Issue ($000) O Issue Stock ($000) Max Stock Retire ($000) Retire Stock ($000) Dividend Per Share 2,426 $ 34.73 ($ 6.43) $ 16,531 1600 Long Term Debt: 54% $ $ 4,133 0 $ $ 0.00 Current Debt Interest Rate 11.2% $ 20,000 Long Term Debt Retire Long Term Debt ($000) O 0 Issue Long Term Debt ($000) O 20000 Long Term Interest Rate 12.6% Maximum Issue This Year $ 20,080 A/R Lag (days) 30 A/P Lag (days) 30 Outstanding Bonds Series Number Face Amount Current Yield o 2021 Close 11.0S2022 $ 6,950 11.2% $ 98.58 12.5S2024 $ 13,900 12.5% $ 99.76 14.0S2026 $ 20,850 13.3% $ 104.97 11.352031 $ 18,000 12.2% $ 92.83 $ Due This Year Borrow ($000) Cash Positions December 31, 2021 December 31, 2022 0 $ 37,220 $ 9,956 Selected Financial Statistics Digby Andrews - 15.0% 0.74 - 11.196 2.7 Baldwin 5.3% 1.03 5.5% 2.0 Chester 6.7% 1.20 8.196 1.9 7.2% 1.17 8.496 1.9 Ferris 7.596 1.33 10.09 1.9 ROS Asset Turnover ROA Leverage (Assets/Equity) ROE Emergency Loan Sales EBIT Profits Cumulative Profit SG&A / Sales Contrib. Margin % -30.596 SO $100,201,259 ($13.098.467) ($15.006,788) ($9,076,864) 15.49% 14.396 11.196 SO $116.880.954 $15.980.922 $6,180.088 $17.935.733 14.79 35.09 15.69 so $145.901.196 $21.792.128 $9.818,484 $17,440,514 11.296 31.496 16.39% SO $ 153,203,554 $24,157,838 $11.020.518 $20.902.493 12.5% 33.396 Erie 5.496 0.90 4.896 2.0 9.896 SO $106,384,603 $15,794,202 $5.748.184 $14,320,616 11.496 33.896 19.49 SO $138,557 285 $21,624 214 $10,399,271 $20,561,468 13 296 32.696 Percent of Sales C121835_071 $ Market Share C121835_071 O Profit 0 Other O SGA O Depr O Var Costs 100% 90% 80% 70% 60% 50% 40% 30% 20 20% 10% 0% -10% Andrews 13.17 % Baldwin 15.35% Chester 19.17 % Digby 20.13 % Erie 13.98 % Andrews Chester Digby Erie Ferris O Ferris 18.2 % CAPSTONE COURIER Page 1 Top CAPSTONE Round: 2 Stocks & Bonds COURIER C121835_071 December 31, 2022 Company Close Shares EPS Dividend Yield PIE Andrews Baldwin Chester Digby Erie Ferris $3.22 $46.62 $48.27 $54.21 $ $41.57 $52.87 Change (531.51) $1.44 $11.13 $12.67 $2.56 $11.62 2,425,595 2,048,274 2,069,366 2,070,649 2,128.085 2.000.000 MarketCap Book Value ($M) Per Share $8 $20.32 $95 $27.14 $100 $30.33 $112 $32.59 S88 $27.68 $106 $26.80 (56.10) $3.02 $4.74 $5.32 $2.70 $5.20 $0.00 $3.78 $0.39 $0.00 $1.67 $1.51 0.096 8.196 0.89 0.096 4.096 2.8% -0.5 15.4 10.2 10.2 15.4 10.2 Closing Stock Price C121835_071 $70 S60 $50 $40 * Andrews Baldwin Chester Digby Erie Ferris $30 S20 $10 SO 2020 2021 2022 2023 2024 2025 2026 2027 2028 Bond Market Summary Company Series# Face Yield Close $ S&P Andrews 12.5S2024 14.0S2026 11.38 2031 12.6S2032 $13.900.000 $20.850.000 $18,000.000 $20.000.000 12.79 13.8% 12.7% 13.2% 98.34 101.47 88.92 95.21 0000 5 Baldwin 12.5S2024 14.0S2026 $11.201,656 $20.850.000 12.5% 13.496 100.17 104.82 B B Chester 12.55 2024 14.0S2026 $13.900.000 $20.850.000 12.49 13.296 100.67 105.78 B B Digby 12.5S2024 14.09 2020 11.782032 $13.828,904 $20,850,000 $2.918.008 12.4% 13.2% 12.09 100.67 105.76 97.75 B B Erie 12.5S2024 14.0S2026 11.752032 $13.900.000 $20.850.000 $1.998,506 12.596 13.39 12.196 100.34 105.13 96.65 B B B Ferris 12.55 2024 14.0S2026 $4.683.196 $20.850.000 12.496 13.296 100.87 105.76 B B Next Year's Prime Rate 8.00% CAPSTONE COURIER Page 2 Top Financial Summary CAPSTONE COURIER C121835_071 Round: 2 December 31, 2022 Andrews Baldwin Chester Digby Erie Ferris ($15,007) $8.180 $9.818 $11.021 $5.748 $10.399 Cash Flow Statement Survey Cash flows from operating activities Net Income (Loss) Adjustment for non-cash items: Depreciation Extraordinary gains/losses/writeoffs $10.939 SO $7.587 S63 $7.707 $10 $7.473 $7 $8,255 $ (5539) $5.927 (5807) CAPSTONE Financial Summary COURIER C121835_071 Round: 2 December 31, 2022 Andrews Baldwin Chester Digby Erie Ferris ($15.007) $8.180 $9,818 $11,021 $5,748 $10.399 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 $10.939 SO $7,587 $63 $7.707 $10 $7.473 $7 $8,255 (5539) $5,927 (3807) ($1.574) $10.987 $2.402 $7.748 (5611) $689 $502 $14,409 $886 $5.267 ($2.406) $21,283 $1,805 $3.680 $ ($3.079) $20,706 ($1,331) $9,575 $224 $21,931 $1.060 $3.6921 ($2,170) $18.101 (836,300) ($3.230) ($5,840) ($19.920) ($7.792) ($6.910) 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 SO $1.600 SO $20,000 SO ($20,000) SO SO ($7.731) SO SO SO ($3,745) (S11,359) $19.214 SO (5813) SO SO SO (5419) ($11,350) $15,192 SO SO $2.300 SO $2.918 SO ($11.350) $18.138 SO ($3,562 SO SO $1.999 SO ($11.350) $14.443 SO ($3,011) SO SO SO ($1,240) ($11.350 $17.422 SC Net cash from financing activities $1,600 (53,620) $2.601 $11.997 $1,521 $1,812 ($26.952) $7.559 $18.244 $12.783 $15.660 $13.003 Net change in cash position Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets Andrews $10.268 58.236 Baldwin $28.985 $9.605 $8.725 $45.295 Chester $33.729 $11.992 $5.333 $51,054 Digby $30.061 $12.592 $7.009 $49.663 Erie $32.560 $8.744 $719 $42.022 Ferris $29.222 $11,388 $7.162 $47.773 $228 $18.732 Plant and equipment Accumulated Depreciation Total Fixed Assets $165,890 ($49,492 $116,398 S113.800 ($46,187) $67,613 $115,600 ($44.853) $70,747 $127.100 ($45,527) $81.573 $123.818 (346.928) $76.890 $88.900 ($32,807 $56.093 Total Assets S135.130 $112.908 $121,800 $131,236 $118.912 S103,866 Accounts Payable Current Debt Total Current Liabilities $8.153 $6.950 $13.103 $8.099 $19.214 $25,313 $7.736 $16.558 $24.294 $8.022 $18.138 $28.160 $5.012 $18.253 $23,265 $7,307 $17.422 $24.729 Long Term Debt Total Liabilities $72.750 $85.853 $32.052 $57.365 $34.750 $50,043 $37.597 $63.757 $36.749 $60.013 $25,533 $50.262 Common Stock Retained Earnings Total Equity $32.960 $16.317 $49.276 $19.045 $35,598 $55,543 $20.736 $42.021 $62.757 $21.183 $48.296 $67.470 $22.747 $38,152 $58,899 $18.360 $35.244 $53,604 Total Liabilities & Owners' Equity $135.130 $112.908 $121,800 $131,236 $118.912 S103.866 Digby 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 CAPSTONE COURIER Andrews $100 201 $85.881 $14,320 $10.930 $15.399 $1,080 ($13.098) $9.989 ($8,081) SO ($15,007) Baldwin $116.881 $75,946 $40.015 $7,587 $17.228 $120 $15.981 $6,270 $3.396 $126 $8.180 Chester $145,901 $100,026 $45,875 $7,707 $16.360 $17 $21.792 $8.378 $5.395 $200 $9,818 $153,204 S102.127 $51,077 $7.473 $19.178 $268 $24,158 $8,857 $8.055 $225 $11.021 Erie S106,385 $70,637 $35.748 $8,255 $12.138 ($439) $15.794 $8.770 $3.158 $117 $5.748 Ferris $138,557 $93,453 $45,104 $5.927 $18.341 ($788 $21,824 $5.299 $5,714 $212 $10.399 Page 3 Top CAPSTONE Production Analysis COURIER C121835_071 Round: 2 December 31, 2022 Production vs Capacity C121835_071 Andrews Baldwin Chester Digby Erie Ferris 0 500 1,000 1,500 2.000 2,500 3,000 3,500 4,000 4,500 5,000 Capacity Production Production Information Unit Primary Units Inven Age Pfmn Size Segment Sold tory Revision Date Dec.31 MTBF Coord Coord Price 2nd Auto Shift & mation Capacity Material Labor Contr. Over Next Next Plant Cost Cost Marg. time Round Round Utiliz. Name 0 0 Able Acre Adam Aft Agape Agape2 Trad Low Trad Pfmn Trad 1.200 2,500 492 476 538 0 5/11/2022 11/12/2023 4/4/2025 2/18/2025 4/3/2022 1/8/2023 2.0 14000 6.6 14000 2.6 23000 3.1 25000 2.7 17000 0.0 0 5.7 3.0 8.9 10.0 4.3 0.0 14.3 $10.00 $8.95 $8.13 17.0 $15.50 $6.38 $5.31 12.0 $27.00 $14.27 $9.41 15.5 $29.00 $14.24 $9.41 13.0 $21.50 $9.97 $7.05 0.0 $0.00 $0.00 $0.00 798 20% 11% 1796 1196 096 1596 37% 096 096 096 096 4.0 5.0 3.0 3.0 3.0 3.0 1.150 114% 1.700 136% 580 9596 700 7096 1.275 31% 100 096 9 0 Baker Bead Bid Trad Low High High Size 946 1.799 813 317 270 83 0 131 69 102 12/5/2022 5/24/2018 12/18/2022 7/27/2022 9/18/2022 1.8 17000 6.6 14000 1.2 23500 1.7 22000 1.6 16000 6.5 3.0 10.4 8.8 6.2 13.5 $29.00 $10.60 $7.05 17.0 $21.00 $6.38 $6.37 9.6 $39.00 $16.26 $11.50 13.5 $34.00 $13.29 $9.40 11.4 $34.00 $11.26 $9.40 40% 38% 3096 3096 3496 096 2196 8996 098 096 5.0 7.0 3.0 3.0 3.0 1.300 69% 1.400 120% 550 1879 600 5896 650 5096 Bold Buddy Trad Low Cake Cedar Cid Coat Cure High Pfmn Size 1,271 1.885 710 710 793 0 0 106 29 82 8/26/2022 1/29/2021 11/15/2022 11/3/2022 9/10/2022 1.9 14000 6.6 12000 1.3 23000 1.5 27000 1.6 17000 6.4 3.0 10.2 11.8 5.4 13.6 $26.50 $9.81 $7.49 17.0 $19.50 $5.78 $5.79 9.8 $37.50 $15.92 $10.04 13.9 $32.50 $16.38 $10.04 8.6 $32.50 $12.94 $10.51 35% 3896 3196 2196 2796 1596 2596 17% 1796 3396 5.5 7.5 3.0 4.0 4.0 1.000 1149 1.400 1249 600 11696 600 11696 600 132% 6 Trad Low High Daze Dell Dixie Dot Dune Doom 1.385 1.814 712 715 773 0 8/22/2022 5/24/2018 12/3/2022 11/13/2022 11/13/2022 8/9/2023 141 45 86 0 1.8 18100 6.6 14000 1.2 24000 1.5 27000 1.5 19000 0.0 0 6.8 3.0 10.2 11.8 5.8 0.0 13.3 $20.00 $11.17 $7.18 17.0 $21.50 $6.38 $6.06 9.8 $39.00 $16.22 $10.88 13.9 $34.00 $16.38 $10.04 8.6 $34.00 $13.65 $10.51 0.0 $0.00 $0.00 $0.00 3796 4096 3196 2496 3096 096 496 796 50% 1796 3396 096 5.0 7.0 3.0 3.0 3.0 6.0 1,200 10396 1.400 100% 800 1499% 600 116% 850 13296 500 096 Pfmn Size Eat Ebb Echo Edge Egg Trad Low Trad Pfmn Size 1.407 1.778 1,059 66 84 0 0 0 0 33 4/8/2022 1/15/2022 7/20/2022 6/30/2018 12/24/2022 2.1 15500 6.6 12000 1.4 16000 4.5 25000 2.3 19000 5.5 3.0 6.4 9.4 6.9 14.5 $27.00 $9.21 $7.05 17.0 $19.50 $5.78 $6.30 13.6 $27.00 $10.21 $8.43 15.5 $34.00 $13.87 $11.63 13.4 $34.00 $11.44 $9.40 3896 3696 2696 2896 33% 096 1896 696 9996 096 7.0 6.0 5.0 3.0 3.0 1,400 9296 1,400 11796 900 105% 1 198% 800 896 Fast Feat Fist Foam Fume Fox Trad Low High Pfmn Size 1,085 1.310 712 689 798 0 69 0 112 38 91 0 4/22/2022 7/27/2025 12/22/2022 11/11/2022 11/9/2022 12/12/2022 2.1 14000 6.6 13000 1.2 25000 1.5 27000 1.5 19000 0.0 25000 5.5 3.0 10.2 11.8 5.4 11.0 14.5 $29.00 $8.78 59.15 36% 17,0 $22.00 $6.08 $8.36 3396 9.8 $39.00 $16.52 $10.67 3296 14.2 $34.00 $16.30 $16.30 $8.78 2896 8.4 $34.00 $13.67 $9.20 33% 9.0 $39.00 $0.00 $0.00 096 3196 6496 4096 17% 3396 096 4.0 6.0 3.0 4.0 4.0 5.5 800 130% 700 163% 550 139% 600 11696 800 13296 500 096 CAPSTONE COURIER Page 4 Accessibility C121835_071 Traditional Andrews Traditional Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 8.800 8.800 30.49 Baldwin Chester Next Year's Segment Growth Rate 9.2% Digby Erie Ferris Traditional Customer Buying Criteria Expectations Importance 1. Age Ideal Age = 2.0 4796 2. Price $19.00 - 20.00 239 3. Ideal Position Pfmn 6.4 Size 13.6 21% Reliability MTBF 14000-19000 996 Perceptual Map for Traditional Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% Actual vs Potential Market Share 2022 C121835_071 Traditional TH 30% 25% Sabte 1 ape 20% . 15% 10% 5% 0% Actual Potential Performance 16 17 18 19 20 0 56 10 12 14 Top Products in Traditional Segment Units Market Sold to Revision Stock Name Share Seg Date Out Eat 1596 1.362 4/8/2022 YES Daze 1596 1,348 8/22/2022 Cake 1496 1.255 8/26/2022 YES Fast 12% 1.084 4/22/2022 Able 1296 1.032 5/11/2022 YES Echo 1296 1,021 7/20/2022 YES Baker 1196 945 12/5/2022 Agape 5% 467 4/3/2022 YES Adam 3% 288 4/4/2025 YES Bead 096 1 5/24/2016 YES Dell 0% 1 1 5/24/2018 YES CAPSTONE COURIER Pfmn Size Coord Coord 5.5 14.5 6.8 13.3 6.4 13.6 5.5 14.5 5.7 14.3 6.4 13.8 6.5 13.5 4.3 13.0 8.9 12.0 3.0 17.0 3.0 17.0 Cust. List Age Promo Aware- Price MTBF Dec.31 Budget ness $27.00 15500 2.09 $1.050 63% $29.00 18100 1.84 $1,100 68% $26.50 14000 1.87 $1.100 68% $29.00 14000 2.08 $900 59% $19.00 14000 2.04 $1,100 64% $27.00 16000 1.40 $1.050 57% $29.00 17000 1.76 $1.300 78% $21.50 17000 2.67 $700 44% $27.00 23000 2.62 $600 41% $21.00 14000 6.60 $1,300 74% $21.50 14000 6.60 $1,100 64% Cust Sales Access Budget ibility $1.085 5496 $1,440 5396 $1.270 4796 $1.235 4896 $800 51% $775 5496 $1,418 5396 $1.000 5196 $700 5196 $1.418 5396 $1,512 5396 Dec Cust. Survey 31 36 35 24 45 29 37 24 12 0 0 Page 5 8.48 Top CAPSTONE Low End Market Segment Analysis COURIER C121835_071 Round: 2 December 31, 2022 Accessibility C121835_071 Low End Andrews Low End Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 11.180 11.123 38.6% Baldwin Chester Next Year's Segment Growth Rate 11.796 Digby Erie Low End Customer Buying Criteria Expectations 1. Price $14.00 - 24.00 Ideal Age = 7.0 3. Ideal Position Pfmn 2.7 Size 17.3 4. Reliability MTBF 12000-17000 Ferris 2 Age Importance 5396 24% 1696 796 0% 20% 40% 60% 80% 100% Perceptual Map for Low End Segment Perceptual map (at end of this year) Actual vs Potential Market Share 2022 C121835_071 Low End 18 30% % 25% Agape 20% 15% 10 10% 8 5% 0% Ene Actual Potential Performance 8 9 10 11 12 13 14 15 16 16 17 18 19 20 0 2 4 8 Top Products in Low End Segment Units Market Sold to Name Share Seg Acre 2296 2.490 Cedar 1796 1,884 Bead 1696 1.798 Ebb 1896 1.777 Dell 1596 1.813 Feat 12% 1.309 Able 296 168 Eat 096 45 Cake 096 15 Agape 0 15 CAPSTONE COURIER Revision Stock Date Out 11/12/2023 YES 1/20/2021 YES 5/24/2016 YES 1/15/2022 YES 5/24/2016 YES 7/27/2025 YES 5/11/2022 YES 4/8/2022 YES 8/26/2022 YES 4/3/2022 YES Pfmn Size Coord Coord 3.0 17.0 3.0 17.0 3.0 17.0 3.0 17.0 3.0 17.0 3.0 17.0 5.7 14.3 5.5 14.5 6.4 13.8 4.3 13.0 Cust List Age Promo Aware- Price MTBF Dec. 31 Budget ness $15.50 14000 6.80 $1.000 74% $19.50 12000 6.60 $1.100 64% $21.00 14000 6.60 $1,300 74% $19.50 12000 6.60 $1.050 62% $21.50 14000 6.60 $1,100 6496 $22.00 13000 6.60 $1,100 64% $19.00 14000 2.04 $1.100 64% $27.00 15500 2.09 $1.050 63% $26.50 14000 1.87 $1.100 68% $21.50 17000 2.67 $700 $ 4496 Cust. Sales Access- Budget ibility $700 4096 $1.333 4096 $1,418 4096 $1.085 $ 3696 $1,512 4296 $1.235 $ 3696 $800 4096 $1,085 3696 $1.270 4096 $1.000 4096 Dec Cust. Survey 45 25 23 23 20 17 5 1 0 2 2 Page 6 096 Accessibility C121835_071 High End High End Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 3.448 3.448 11.996 Andrews Baldwin Chester Next Year's Segment Growth Rate 16.2% Digby Erie Ferris 2 Age High End Customer Buying Criteria Expectations Importance 1. Ideal Position Pfmn 10.7 Size 9.3 4396 Ideal Age = 0.0 299% 3. Reliability MTBF 20000-25000 19% 4. Price $29.00 - 39.00 996 Perceptual Map for High End Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% JULI Actual vs Potential Market Share 2022 C121835_071 High End 30% 25% Ephe Bold 20% - Adam Budd 15% Desde 10% 5% 0% O Actual Potential 0 2 8 8 10 Performande 14 15 16 17 18 19 20 12 Top Products in High End Segment Units Market Sold to Name Share Seg Bid 24% 813 Fist 2196 712 Dixie 2196 712 Cid 2196 710 Bold 696 206 Adam 896 198 Daze 196 31 Echo 196 20 Buddy 196 19 Dot 096 11 Coat 096 11 Foam 096 3 CAPSTONE COURIER Revision Stock Date Out 12/18/2022 12/22/2022 12/3/2022 11/15/2022 7/27/2022 4/4/2025 YES 8/22/2022 7/20/2022 YES 9/18/2022 11/13/2022 11/3/2022 11/11/2022 Pfmn Size Coord Coord 10.4 9.6 10.2 9.8 10.2 9.8 10.2 9.8 8.8 13.5 8.9 12.0 6.8 13.3 6.4 13.6 6.2 11.4 11.8 13.9 11.8 13.9 11.8 14.2 List Age Promo Price MTBF Dec. 31 Budget $39.00 23500 1.10 $1.250 $39.00 25000 1.18 $1.100 $39.00 24000 1.23 $1,100 $37.50 23000 1.25 $1,000 $3400 22000 1.67 $1,300 $27.00 23000 2.62 $600 $29.00 18100 1.84 $1,100 $27.00 16000 1.40 $1,050 $ $34.00 16000 1.64 $1.300 $34.00 27000 1.47 $1,100 $32.50 27000 1.48 $1.000 $34.00 27000 1.47 $1,100 Cust. Aware- ness 71% 61% 63% 5896 72% 41% 68% 5796 7296 62% 56% 59% % Cust. Sales Access- Budget ibility $1.418 53% $1.235 4496 $1,512 $ 5196 $1,333 4496 $681 5396 $700 29% $1,440 5196 $775 20% $737 5396 $1,368 5196 $1.206 4496 $1.235 4496 Dec Cust. Survey 38 36 36 30 5 4 1 0 1 0 0 0 Page 7 Top CAPSTONE Performance Market Segment Analysis COURIER C121835_071 Round: 2 December 31, 2022 Accessibility C121835_071 Performance Performance Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry Andrews 2.749 2.749 9.5% Baldwin Chester Next Year's Segment Growth Rate 19.896 Digby Erie Ferris Performance Customer Buying Criteria Expectations Importance 1. Reliability MTBF 22000-27000 4396 2 Ideal Position Pimn 11.4 Size 14.6 2996 3. Price $24.00 - 34.00 1996 4. Age Ideal Age = 1.0 996 Perceptual Map for Performance Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% Actual vs Potential Market Share 2022 C121835_071 Performance 25% Edge Fast 20% 15% ..ILI 10% 5% 0% Baldwin Chester O Actual Potential Performand 16 17 18 19 20 8 10 12 14 Top Products in Performance Segment Units Market Sold to Name Share Seg Dot 26% 704 Coat 25% 890 Foam 25% 686 JAft 1796 476 Bold 49 111 Edge 2% 68 Adam 096 6 Daze 09 1 CAPSTONE COURIER Revision Stock Date Out 11/13/2022 11/3/2022 11/11/2022 2/18/2025 7/27/2022 8/30/2018 YES 4/4/2025 YES 8/22/2022 Pfmn Size Coord Coord 11.8 13.9 11.8 13.9 11.8 14.2 10.0 15.5 8.8 13.5 9.4 15.5 8.9 12.0 6.8 13.3 List Age Price MTBF Dec.31 $34.00 27000 1.47 $32.50 27000 1.48 $34.00 27000 1.47 $29.00 25000 3.10 $34.00 22000 1.67 $34.00 25000 4.50 $27.00 23000 2.62 $29.00 18100 1.84 Promo Budget $1,100 $1.000 $1.100 $700 $1.300 $300 $ $800 $1.100 Cust. Aware- ness 62% 58% 59% 44% 72% 25% 4196 68% Cust. Sales Access- Budget ibility $1,368 3896 $1,206 3396 $1.235 3596 $1.000 2896 $681 2396 $155 1796 $700 2896 $1.440 3896 Dec Cust. Survey 35 34 35 16 3 7 1 0 Page & Accessibility C121835_071 Size Andrews Size Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 2,778 2.776 9.696 Baldwin Next Year's Segment Growth Rate 18.39 Chester Digby Erie Ferris 1. Ideal Position 2. Age 3. Reliability 4 Price Size Customer Buying Criteria Expectations Pfmn 5.4 Size 8.6 Ideal Age = 1.5 MTBF 18000-21000 $24.00 - 34.00 Importance 43% 29% 19% 996 0% 20% 40% 60% 80% 100% Perceptual Map for Size Segment Perceptual map (at end of this year) Actual vs Potential Market Share 2022 C121835_071 Size 16 25% Agape 20% % 15% 10 10% Don 5% 0% O Actual Potential Performande 18 19 20 0 2 4 6 8 Top Products in Size Segment Units Market Sold to Name Share Seg Fume 29% 796 Cure 29% 793 Dune 2896 773 Buddy 9% 251 Egg 396 83 Agape 29 57 Echo 196 18 Daze 096 4 Cake 096 1 CAPSTONE COURIER Revision Stock Date Out 11/9/2022 9/10/2022 11/13/2022 9/18/2022 12/24/2022 4/3/2022 YES 7/20/2022 YES 8/22/2022 8/26/2022 YES Pfmn Size Coord Coord 5.4 8.4 5.4 8.6 5.8 8.6 6.2 11.4 6.9 13.4 4.3 13.0 6.4 13.6 6.8 13.3 6.4 13.6 List Age Price MTBF Dec.31 $34.00 19000 1.48 $32.50 17000 1.58 $34.00 19000 1.50 $34.00 16000 1.64 $34.00 19000 2.30 $21.50 17000 2.67 $27.00 16000 1.40 $29.00 18100 1.84 $26.50 14000 1.87 Promo Budget $1,100 $1.000 $1.100 $1,300 $1.050 $700 $1.050 $1,100 $1,100 Cust. Aware- ness 59% 56% 62% 72% 58% 44% 57% 6896 68% Cust Sales Access Budgetibility $1,235 39% $1,206 3796 $1,368 $ 4296 $737 28% $775 29% $1.000 27% $775 2996 $1,440 4296 $1.270 3796 Dec Cust. Survey 39 33 39 7 0 2 0 0 0 Page 9 Top CAPSTONE COURIER Market Share Report C121835_071 Round: 2 December 31, 2022 Units Sold vs Demand Chart C121835_071 Market Share C121835_071 30% 10,000 25% 20% 8,000 15% 6,000 10% 4,000 5% 0% 2,000 0 Trad Low High Pfmn Size Industry Unit Sales Total Unit Demand Trad I Low High OPfmn Size Potential Market Share in Units Trad Low High Pfmn 8,800 11,180 3,448 2,749 Size Total 2,776 28.961 30.496 38.6% 11.9% 9.5% 9.6% 100.0% 19.1% 2.4% 29.1% 3.2% 6.0% 0.2% 16.6% 6.8% 11.2% 1.7% 1.6% 3.3% 24.6% 9.4% 31.796 0.3% 31.9% 6.0% 3.2% 3.2% 16.8% 9.2% 14.3% 23.5% 6.0% 0.8% 30.0% 2.8% 5.5% 2.8% 1.1% 0.9% 13.1% 3.8% 9.2% 8.9% 8.9% 14.3% 3.9% 0.196 12.196 0.1% 0.1% 15.7% Actual Market Share in Units Trad Low High Pfmn Size Total Industry Unit 8,809 11,123 3,448 2,749 2,778 28,905 Units Sales pemanded of Market 30.5% 38.5% 11.9% 9.5% 9.6% 100.0% % of Market Able 11.7% 1.5% 4.2% Acre 0.0% 22.5% 8.7% Able Adam 3.3% 5.7% 0.2% 1.7% Acre Aft 17.3% 1.696 Adam Agape 5.39 0.196 2.0% 1.9% Aft Total 20.3% 24.1% 5.7% 17.596 2.0% 18.0% Agape Total Baker 10.7% 0.0% 3.3% Bead 0.0% 16.2% 6.2% Baker Bid 23.6% 2.8% Bead Bold 6.0% 4.0% 1.1% Bid Buddy 0.8% 9.0% 0.9% Bold Total 10.7% 16.2% 30.1% 4.0% 9.1% 14.3% Buddy Total Cake 14.2% 0.1% 4.4% Cedar 0.0% 16.996 6.5% Cake Cid 20.6% 2.5% Cedar Coat 0.3% 25.4% 2.5% Cid Cure 28.6% 2.7% Coat 14.396 17.1% 20.9% 25.4% 28.6% 18.8% Cure Total paze 15.3% 0.99% 0.1% 0.196 4.8% bell 0.0% 14.596 5.6% Daze pixie 20.6% 2.5% bell Pot 0.3% 25.6% 2.5% pacie pune 27.8% 2.7% pot Total 15.396 14.5% 21.9% 25.6% 28.0% 18.0% pune Total Eat 15.5% 0.4% 4.9% Ebb 0.0% 16.0% 8.2% Eat Echo 11.6% 0.6% 0.6% 3.7% Ebb Edge 2.4% 0.2% Echo F99 0.0% 3.0% 0.3% Edge Total 27.1% 16.4% 0.6% 2.4% 3.696 15.2% Egg Total Fast 12.3% 3.8% Feat 0.0% 11.8% 4.5% Fast Fist 20.7% 2.5% Feat Foam 0.1% 25.0% 2.4% Fist Fume 28.7% 2.8% Foam Total 12.3% 11.8% 20.8% 25.0% 28.7% 15.9% Eume Total CAPSTONE COURIER 20.5% 0.3% 3.7% 6.1% 2.4% 2.3% 2.7% 17.3% 24.1% Total 12.2% 15.8% 20.8% 24.1% 28.2% 28.2% 0.1% 12.9% 0.9% 12.6% 20.6% 0.3% 4.0% 4.9% 2.5% 2.3% 2.6% 16.3% 24.396 27.5% 27.7% 12.9% 12.6% 21.8% 24.3% 13.0% 0.3% 14.7% 10.6% 0.6% 0.6% 4.1% 5.7% 3.496 0.796 0.3% 14.1% 7.3% 23.7% 3.0% 3.6% 15.096 0.6% 7.3% 10.4% 10.4% 20.6% 0.1% 23.7% 3.2% 4.0% 2.5% 2.3% 2.7% 14.6% Page 10 10.4% 10.4% 20.7% 23.6% 28.4% 28.4% Perceptual Map for All Segments Perceptual map (at end of this year) Size 201 19 18 17 Elan 16 12 Edge 14 Els Bold 13 Agape Adam 12 1 BV 101 9 Drene 8 7 6 4 3 2 1 0 Performance 10 11 12 13 14 15 16 17 18 19 20 1 2 4 5 6 7 8 9 Name Able Acre Adam Aft Agape Andrews Pfmn Size 5.7 14.3 3.0 17.0 8.9 12.0 10.0 15.5 4.3 13.0 Revised Name 5/11/2022 Baker 11/12/2023 | Bead 4/4/2025 Bid 2/18/2025 | Bold 4/3/2022 Buddy Baldwin Pfmn Size 6.5 13.5 3.0 17.0 10.4 9.6 8.8 13.5 6.2 11.4 Revised Name 12/5/2022 Cake 5/24/2016 Cedar 12/18/2022 Cid 7/27/2022 | Coat 9/18/2022 Cure Chester Pfmn Size 13.6 3.0 17.0 10.2 9.8 11.8 13.9 5.4 8.6 Revised 8/20/2022 1/29/2021 11/15/2022 11/3/2022 9/10/2022 Name Daze Dell Dixie Dot Dune Pfmn 5.5 3.0 Digby Size 13.3 17.0 9.8 13.9 8.6 Pfmn 6.8 3.0 10.2 11.8 5.8 Revised Name 8/22/2022 | Eat 5/24/2016 Ebb 12/3/2022 Echo 11/13/2022 Edge 11/13/2022 Egg Erie Size 14.5 17.0 13.6 15.5 13.4 Revised Name 4/8/2022 Fast 1/15/2022 Feat 7/20/2022 Fist 6/30/2018 Foam 12/24/2022 Fume Fox Pfmn 5.5 3.0 10.2 11.8 5.4 11.0 Ferris Size 14.5 17.0 9.8 14.2 8.4 9.0 Revised 4/22/2022 7/27/2025 12/22/2022 11/11/2022 11/9/2022 12/12/2022 9.4 6.9 CAPSTONE COURIER Page 11 Top CAPSTONE HR/TOM Report C121835_071 Round: 2 December 31, 2022 HUMAN RESOURCES SUMMARY Needed Complement Complement 1st Shift Complement 2nd Shift Complement Andrews 640 840 556 84 Baldwin 632 832 517 115 Chester 788 788 850 138 Digby 805 805 878 127 Erie 562 562 523 39 Ferris 740 740 541 199 Overtime %6 Turnover Rate New Employees Separated Employees Recruiting Spend Training Hours Productivity Index 0.096 8.196 52 189 $2.700 50 100.49 0.096 8.9% 56 105 $2.000 30 100.0% 0.0% 9.196 99 0 $2.000 25 100.0% 0.0% 8.996 181 0 $2,200 30 0.0% 9.1% 51 145 $2.000 25 100.096 0.096 8.99 129 0 $2.500 30 100.0% 100.0% Recruiting Cost Separation Cost Training Cost Total HR Admin Cost $192 $945 $640 $1.777 $168 $520 $379 $1.074 $297 SO $394 $691 $580 SO $483 $1,063 $153 $723 $281 $1.157 $451 SO $444 $895 Labor Contract Next Year Wages Benefits Profit Sharing Annual Raise $23.15 2.500 2.09 5.09 $23.15 2.500 2.09 5.09 $23.15 2.500 2.096 5.0% $23.15 2.500 2.096 5.0% $23.15 2.500 2.0% 5.0% $23.15 2.500 2.0% 5.0% Starting Negotiation Position Wages Benefits Profit Sharing Annual Raise Ceiling Negotiation Position Wages Benefits Profit Sharing Annual Raise Adjusted Labor Demands Wages Benefits Profit Sharing Annual Raise Strike Days TQM SUMMARY Baldwin Andrews Chester Digby Erie Ferrie Process Mgt Budgets Last Year CPI Systems sc sc so SO $0 SO SO SO $0 SO SO SO SO SO SO SO SO SO SO SO $0 SO SO SO SO SO SO SO SO SO SO SO SO Vendor/JIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs TQM Budgets Last Year Benchmarking Quality Function Deployment Effort CCE/6 Sigma Training GEMI TQEM Sustainability Initiatives Total Expenditures SO SO SO SO $0 SO SO SO SO SO SO SO SO SO SO SO SO SO SO SO sc SC sc sc sc SO SO Cumulative Impacts Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction Admin Costs Demand Increase CAPSTONFA GOURIFR 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.0096 0.0096 0.00% 0.0096 0.0096 0.00% 0.0096 0.00% 0.0096 0.00% 0.0096 0.00% 0.00% 0.0096 0.00% 0.00% 0.00% 0.0096 0.00% 0.0095 0.009 0.0098 0.00 0.009 Pane 17
