SIMMULATION EXPERT PLEASE SOLVE THIS QUESTION
capstone business simulation FOR ANDREW COMPANY
need help in decision
strategy- broad differentiator
need decisions for
- r and d
- marketing
- production
sending all the pictures of last year courier report
still if you need any more information about my company ANDREW PLEASE LET ME KNOW
DONT JUST TYPE QUESTION IS INCOMPLETE.
Round: 2 Size Segment Analysis COURIER - 14 Dec. 31, 2022 Size Statistics Accessibility C123593_029 Size Total Industry Unit Demand 2,776 2,77 Andrews Actual Industry Unit Sales Segment % of Total Industry 19.6% Baldwin Next Year's Segment Growth Rate 18.3% Chester Size Customer Buying Criteria Digby Expectations Importance Erie 1. Ideal Position Pfmn 5.4 Size 8.6 43% 29% Ferris 2. Age Ideal Age = 1.5 3. Reliability MTBF 16000-21000 19% 4. Price $24.00 - 34.00 9% 20% 40% 60%% 80% 100%% Perceptual Map for Size Actual vs Potential Market Share Perceptual map (at end of this year) 2022 C 123593_029 Size 20 18 20% 9/15 16 14 15% 12 10% Size 10 -Apaper QURE 5% 0% Erie Ferris Digby Chester Baldwin N Andrews 0 2 4 6 8 10 12 14 18 18 20 O Actual Potential Performance Top Products in Size Segment Cust Dec. Units Cust Market Sold to Revision Stock Pfmn Size List Age Promo Aware- Sales Access- Cust Share Seg Date Out Coord Coord Price MTBF Dec.31 Budget ness Budget ibility Survey Name 652 11/9/2022 5.4 8.4 $34.00 19000 1.48 $1,100 59% $1,235 39% 39 Fume 23% 23% $32.50 17000 37% 33 648 9/10/2022 8 6 1.56 $1,000 56% $1,206 Cure 5.4 8.6 $34.00 19000 1.50 $1,100 62% $1,368 42% 39 Dune 23% 633 11/13/2022 5.8 19% 535 5/10/2022 4.8 10.0 $34.39 17500 1.82 $1,000 72% $1,200 49% 16 Agape 28% Buddy 7% 204 9/18/2022 6.2 11.4 $34.00 1600 1.64 $1,300 72% $737 2% 12/24/2022 6.9 13.4 $34.00 19000 2.30 $1,050 56% $775 29% Egg 67 Able 1% 18 5/2/2022 6.2 13.7 $28.89 1460 9 $1,250 85% $1,350 49% Echo 1% 14 7/20/2022 6.4 13.6 $27.00 16000 1.40 $1,050 57% $775 29% 8/22/2022 6.8 13.3 $29.00 18100 1.84 $1,100 66% $1,440 42% Daze 0% $1,270 37% 0% 6.4 1.87 $1,100 66% Cake 8/26/2022 13.6 $26.50 14000Round: 2 Performance Segment Analysis COURIER Dec. 31, 2022 Performance Statistics Accessibility C123593_029 Performance Total Industry Unit Demand 2,749 Andrews Actual Industry Unit Sales 2,749 Segment % of Total Industry 19.5% Baldwin Chester Next Year's Segment Growth Rate 19.8% Performance Customer Buying Criteria Digby Expectations Importance Erie 1. Reliability MTBF 22000-27000 43% 2. Ideal Position Pfmn 11.4 Size 14.6 29% Ferris 3. Price $24.00 - 34.00 19% 4. Age Ideal Age = 1.0 9% 20%% 40% 60%% 80% 100% Perceptual Map for Performance Actual vs Potential Market Share Perceptual map (at end of this year) 2022 C 123593_029 Performance 20 18 25%% 16 Edget 14 Fast 15% 12 Size 10 10%% 0% Chester Baldwin 2 Andrews 8/15 2 4 6 8 10 12 14 16 18 20 O Actual Potential Performance Top Products in Performance Segment Cust. Dec. Units Cust. List Age Promo Aware- Cust Revision Sales Access- Market Sold to Stock Pfmn Size ness Budget ibility Survey Name Share Seg Date Out Coord Coord Price MTBF Dec.31 Budget 10.2 15.5 $34.39 1.95 $1,200 78% $1,200 41% 29 Aft 27% 740 3/6/2022 $1,368 38% 35 Dot 23% 624 11/13/2022 11.8 13.9 $34.00 27000 1.47 $1,100 62% 11.8 13.9 $32.50 27000 1.48 $1,000 56% $1,206 33% 34 Coat 23% 620 1/3/2022 1 1/1 1/2022 11.8 14.2 $34.00 27000 1.47 $1,100 59% $1,235 35% 35 Foam 22% 608 8.8 13.5 $34.00 22000 1.67 $1,300 72% $681 23% Bold 4% 98 7/27/2022 ovw 57 6/30/2018 YES 9.4 $34.00 25000 4.50 2% 15.5 $300 25% $155 17% Edge 0% 8/22/2022 6.8 13.3 $29.00 18100 1.84 $1,100 66% $1,440 38% DazeCOURIER 3 Round: 2 High End Segment Analysis Dec. 31, 2022 High End Statistics Accessibility C123593_029 High End Total Industry Unit Demand 3,448 Actual Industry Unit Sales 13,448 Andrews Segment % of Total Industry |11.9% Baldwin |16.2% Chester Next Year's Segment Growth Rate High End Customer Buying Criteria Digby Expectations Importance Erie 1. Ideal Position Pfmn 10.7 Size 9.3 43% Ideal Age = 0.0 29% Ferris 2. Age 3. Reliability MTBF 20000-25000 19% 4. Price $29.00 - 39.0 9% 0% 20% 40% 60% 80% 100% Perceptual Map for High End Actual vs Potential Market Share Perceptual map (at end of this year) 2022 C 123593_029 High End 20 18 25% 16 20% 14 be Fold Coat 15% 7/15 12 Bu Adam Size 10 10% 5% 0% A Erie Femis Digby Chester Baldwin N Andrews 0 2 4 6 8 10 12 14 16 18 20 O Actual Potential Performance Top Products in High End Segment Cust. Cust. Dec. Units Market Sold to Revision Stock Pfmn Size List Age Promo Aware- Sales Access- Cust Name Share Sec Date Out Coord Coord Price MTBF Dec.31 Budget ness Budget ibility Survey Bid 20% 696 12/18/2022 10.4 9.6 $39.00 23500 1.19 $1,250 71% $1,418 53% 38 4/4/2022 10.8 $38.89 22000 1.63 $1,400 85% $1,400 55% 9.1 15 Adam 19% 661 61% $1,235 44% 36 Fist 18% 611 12/22/2022 10.2 9.8 $39.00 25000 1.18 $1,100 10.2 9.8 $39.00 24000 3 $1,100 63% 18% 12/3/2022 $1,512 51% 36 Duck 610 58% $1,333 44% Cid 18% 609 11/15/2022 10.2 9.8 $37.50 23000 1.25 $1,000 72% $681 53% Bold 5% 174 7/27/2022 8.8 13.5 $34.00 22000 1.67 $1,300 1.84 $1,100 66% $1,440 51% Daze 1% 26 8/22/2022 6.8 13.3 $29.00 18100 Echo 1% 7/20/2022 6.4 13.6 $27.00 16000 1.40 $1,050 57% $775 26% ooo- 0- 01 8 17 9/18/2022 5.2 11.4 $34.00 16000 1.64 $1,300 72% $737 53% Buddy Dot 11/13/2022 $34.00 27000 1.47 $1,100 62% 51% 0% 11.8 13.9 $1,368 56% $1,206 44% Coat 0% 10 11/3/2022 11.8 13.9 $32.50 27000 1.48 $1,000 Able 13.7 $28.89 14600 55% 5/2/2022 1.99 $1,250 85% $1,350 0% 6.2Round: 2 Low End Segment Analysis COURIE -9 Dec. 31, 2022 Low End Statistics Accessibility C123593_029 Low End Total Industry Unit Demand 11,180 Andrews Actual Industry Unit Sales 11,180 Segment % of Total Industry 138.6% Baldwin Next Year's Segment Growth Rate 11.7% Chester Low End Customer Buying Criteria Digby Expectations mportance Erie 1. Price $14.00 - 24.00 53% 2. Age Ideal Age = 7.0 24% Ferris 3. Ideal Position Pfmn 2.7 Size 17.3 16% . Reliability MTBF 12000-17000 7% 20%% 40%% 60% 80%% 100%% Perceptual Map for Low End Actual vs Potential Market Share Perceptual map (at end of this year) 2022 C123593_029 Low End 20 20% 18 18% 16 16% 14 14% 12% 12 10% 10 8% 6% 4% 2% 0% Erie Ferris Digby Chester Baldwin N Andrews 2 4 6 8 10 12 14 16 18 20 O Actual Potential Performance Top Products in Low End Segment Units Cust. Cust. Dec. Market Sold to Revision Stock Pfmn Size List Age Promo Aware- Sales Access- Cust Name Share Seg Date Out Coord Coord Price MTBF Dec.31 Budget ness Budget ibility Survey Cedar 2,190 1/29/202 3.0 17.0 $19.50 12000 6.60 $1,100 64% $1,333 40% 25 20% 36% 23 Ebb 18% 2,056 1/15/2022 3.0 17.0 $19.50 12000 6.60 $1,050 62% $1,085 Bead 18% 1,999 5/24/2016 3.0 17.0 $21.00 14000 6.60 $1,300 74% $1,418 40% 23 42% 20 Dell 16% 1,761 5/24/2016 3.0 17.0 $21.50 14000 6.60 $1.100 64% $1,512 Acre 15% 1,673 1/8/2022 YES 3.0 17.0 $19.89 12500 6.60 $1,200 81% $1,200 47% 27 Feat 13% 1,449 7/27/2025 3.0 17.0 $22.00 13000 6.60 $1,100 64% $1,235 36% 17 Eat 0% 35 4/8/2022 5.5 14.5 $27.00 15500 2.09 $1,050 63% $1,085 36% 0 Cake 0% 8/26/2022 6.4 13.6 $26.50 14000 1.87 $1,100 66% $1,270 40%Round: 2 Traditional Segment Analysis COURIE Dec. 31, 2022 Traditional Statistics Accessibility C123593_029 Traditional Total Industry Unit Demand 8,80 Andrews Actual Industry Unit Sales 8,80 Segment % of Total Industry 30.49 Baldwin Next Year's Segment Growth Rate 19.2% Chester Traditional Customer Buying Criteria Digby Expectations mportance Erie 1. Age Ideal Age = 2.0 47% 2. Price .00 - 29.00 23% Ferris 3. Ideal Position Pfmn 6.4 Size 13. 21% 4. Reliability MTBF 14000-19000 9% 0% 20%% 40% 60%% 80%% 100%% Perceptual Map for Traditional Actual vs Potential Market Share Perceptual map (at end of this year) 2022 C 123593_029 Traditional 20 18 25%% 18 Eatt 20% 14 12 15% 10 10% 5% 0% Digby Ferris Chester Baldwin N Andrews 2 4 8 8 10 12 14 16 18 20 O Actual Potential Performance Top Products in Traditional Segment Cust. Dec. Units Cust Market Sold to Revision Stock Pfmn Size List Age Promo Aware- Sales Access- Cust ness Budget ibility Survey Name Share Seg Date Out Coord Coord Price MTBF Dec.31 Budget 5/2/2022 6.2 13.7 $28.89 14600 1.99 $1,250 85% $1,350 60% 38 Able 18% 1,567 16% 1,390 4/8/2022 5.5 14.5 $27.00 15500 2.09 $1,050 63% $1,085 54% 31 Eat $1,440 53% 36 Daze 15% 1,364 8/22/2022 6.8 13.3 $29.00 18100 1.84 $1,100 66% Cake 15% 1,286 8/26/2022 6.4 13.6 $26.50 14000 1.87 $1,100 66% $1,270 47% 35 Echo 13% 1,134 7/20/2022 6.4 13.6 $27.00 16000 1.40 $1,050 57% $775 54% 29 4/22/2022 5.5 14.5 $29.00 14000 2.08 $900 59% $1,235 48% 24 Fast 12% 1,10 6.5 $29.00 17000 1.76 $1,300 76% $1,418 53% 37 Baker 11% 96 12/5/2022 13.5 74% $1,418 53% Bead 0% 5/24/2016 3.0 17.0 $21.00 14000 6.60 $1,300 0% 5/24/2016 3.0 17.0 $21.50 14000 6.60 $1,100 64% $1,512 53% DellShift Auto Unit & mation Capacity Primary Units Inven Revision Age Pfmn Size Material Labor Contr. Over- Next Next Plant Name Segment Sold tory Date Dec.31 MTBF Coord Coord Price Cost Cost Marg time Round Round Utiliz. Able Trad 1,589 606 5/2/2022 2.0 14600 6.2 13.7 $28.89 $9.65 $8.24 27% 0% 4.2 1,750 25% Acre Low 1,673 0 1/8/2022 6.6 12500 3.0 17.0 $19.89 $5.93 $6.36 37% 21% 6.0 1,400 120% Adam High 661 55 4/4/2022 1.6 22000 9.1 10.8 $38.89 $14.62 $9.41 36% 0% 3.5 850 41% Aft Pfmn 740 11 3/6/2022 2.0 27000 10.2 15.5 $34.39 $14.97 $9.41 25% 0% 3.5 500 50% Agape Size 535 62 5/10/2022 1.8 17500 4.8 10.0 $34.39 $12.07 $9.41 35% 0% 3.0 600 99% Baker Trad 962 244 12/5/2022 1.8 17000 6.5 13.5 $29.00 $10.60 $7.05 39% 0% 5.0 1,300 84% Bead Low 2,000 121 5/24/2016 6.6 14000 3.0 17.0 $21.00 $6.38 $6.76 35% 46% 7.0 1,400 145% Bid High 696 129 12/18/2022 1.2 23500 10.4 9.6 $39.00 $16.26 $10.99 31% 56% 3.0 550 154% Bold High 273 58 7/27/2022 1.7 22000 8.8 13.5 $34.00 $13.29 $9.40 30% 0% 3.0 600 41% Buddy Size 220 53 9/18/2022 1.6 16000 6.2 11.4 $34.00 $11.26 $9.40 35% 0% 3.0 600 33% Cake Trad 1,305 197 8/26/2022 1.9 14000 6.4 13.6 $26.50 $9.61 $8.00 32% 40% 5.5 1,000 139% Cedar Low 2, 191 111 1/29/2021 6.6 12000 3.0 17.0 $19.50 $5.78 $6.23 36% 61% 7.5 1,400 159% Cid High 609 93 11/15/2022 1.3 23000 10.2 9.8 $37.50 $15.92 $9.40 33% 0% 3.0 600 99% 4/15 Coat Pfmn 629 23 11/3/2022 1.5 27000 11.8 13.9 $32.50 $16.38 $9.40 23% 0% 4.0 500 99% production Cure Size 648 52 9/10/2022 1.6 17000 5.4 8.6 $32.50 $12.94 $9.74 30% 8% 40 600 107% Daze Trad 1,395 194 8/22/2022 1.8 18100 6.8 13.3 $29.00 $11.17 $7.63 34% 21% 5.0 1,200 120% Dell Low 1,762 128 5/24/2016 6.6 14000 3.0 17.0 $21.50 $6.38 $6.49 38% 29% 7.0 1,400 127% Duck High 610 130 12/3/2022 1.2 24000 10.2 9.8 $39.00 $16.22 $10.43 32% 30% 3.0 550 129% Dot Pfmn 634 38 11/13/2022 1.5 27000 11.8 13.9 $34.00 $16.38 $9.40 26% 0% 3.0 600 99% Dune Size 633 77 11/13/2022 1.5 19000 5.8 8.6 $34.00 $13.65 $9.74 32% 8% 3.0 600 107% Doom 0 0 8/9/2023 0.0 0 0.0 0.0 $0.00 $0.00 $0.00 0% 0% 6.0 500 Eat Trad 1,426 205 4/8/2022 2.1 15500 5.5 14.5 $27.00 $9.21 $7.37 36% 11% 7.0 1,400 110% Ebb Low 2,056 139 1/15/2022 6.6 12000 3.0 17.0 $19.50 $5.78 $6.85 33% 54% 6.0 1,400 152% Echo Trad 1,165 114 7/20/2022 1.4 16000 6.4 13.6 $27.00 $10.21 $9.20 23% 33% 5.0 900 132% Edge Pfmn 57 0 6/30/2018 4.5 25000 9.4 15.5 $34.00 $13.87 $11.63 28% 99% 3.0 198% Egg Size 68 55 12/24/2022 2.3 19000 6.9 13.4 $34.00 $11.44 $9.40 30% 0% 30 600 8% Fast Trad 1, 100 277 4/22/2022 2.1 14000 5.5 14.5 $29.00 $8.76 $9.63 33% 56% 4.0 800 155% Feat Low 1,450 38 7/27/2025 6.6 13000 3.0 17.0 $22.00 $6.08 $8.72 31% 100% 6.0 700 198% Fist High 611 93 12/22/2022 1.2 25000 10.2 9.8 $39.00 $16.52 $10.14 33% 20% 3.0 500 119% Foam Pfmn 611 25 11/1 1/2022 1.5 27000 11.8 14.2 $34.00 $16.30 $8.23 29% 0% 4.0 600 99% Fume Size 652 59 11/9/2022 1.5 19000 5.4 $34.00 $13.67 $8.53 35% 8% 4.0 600 107% Fox 0 0 12/12/2022 0.0 25000 11.0 9.0 $39.00 $0.00 $0.00 0% 0% 5.5 500 0%Selected Financial Statistics Andrews Baldwin Chester Digby Erie Ferris ROS 4.3% 4.9% 6.4% 6.5% 5.2% 6.6% Asset Turnover 1.26 1.03 1.18 1.14 0.95 1.30 ROA 5.5% 5.0% 7.5% 7.5% 4.9% 8.5% Leverage 2.5 2.0 1.9 1.9 2.0 2.0 ROE 13.6% 10.1% 14.6% 14.5% 10.0% 16.70 Emergency Loan $0 $0 $0 $0 Sales $148,728,124 $113,805,476 $141,644,932 $145, 194,070 $1 30.5 EBIT $18,485,182 $14,824,049 $20,533,892 $21,513,488 $ 2/15 8,6 Profits $6,468,565 $5,530,522 $9,054,795 $9,465,699 $ . 58,58 Cumulative Profit $3,961,242 $15,803,937 $15,769,637 $17,661,607 $13,677,923 $17,515, SG&A / Sales 13.3% 15.0% 11.7% 13.3% 10.2% 14.2% Contribargin % 31.3% 34.7% 31.7% 33.3% 31.1% 32.3% Percent of Sales C123593_029 $ Market Share C123593_029 100% 90% O Var Cost 80% O Depr 70% O SGA 60% O Other Profit 50% 40% O Andrews 18.73 % 30% O Baldwin 14.33 % 20% O Chester 17.83 % O Digby 18.28 % 10% Erie 14.39 % 0% Ferris 16.44 % Andrews Chester Digby Erie Ferris CAPSTONE @ COURIER Page 1 COURIER Round: 2 Stock & Bonds Dec. 31, 2022 Stock Market Summary Book Value Company Close Change Shares MarketCap EPS Dividend Yield P/E ($M) Per Share Andrews $26.86 $25.86 2,000,000 $54 $23.86 $3.23 $0.00 0.0% 8.3 Baldwin $43.46 $1.18 2,046,274 $89 $26.70 $2.70 $3.17 7.3% 16.1 Chester $45.48 $10.09 2,069,36 $94 $29.87 $4.38 $0.04 0.1% 10.4 Digby $48.53 $10.34 2,101,850 $102 $31.04 $4.50 $0.00 0.0% 10.8 Erie $40.75 $3.25 2,128,085 $87 $27.77 $2.78 $1.28 3.1% 14.7 Ferris $46.78 $8.61 2,000,000 $94 $25.77 $4.29 $1.01 2.2% 10.9 Closing Stock Price C123593_029 $60 Andrews O Baldwin $50 V Chester $40 Digby 4 Erie $30 Ferris $20 $10 2020 2021 2022 2023 2024 2025 2026 2027 2028 Bond Market Summary Company Series# Face Yield Close$ S&P Company Series# Face field Closes S&P Andrews Digby 12.582024 $13,900,000 12.6% 98.83 CC 12.582024 $13,828,904 12.4% 100.67 14.082026 $20,850,000 13.7% 102.37 CC 14.082026 $20,850,000 13.2% 105.76 $18,500,000 12.5% 90.32 11.782032 $2,298,044 12.0% 97.75 13.582032 $5,500,000 13.3% 101.61 CC Erie Baldwin 12.582024 $13,900,000 12.5% 100.17 12.582024 $11,013,868 12.5% 100.34 14.0S2026 $20,850,000 13.4% 104.82 CO CO CO CO CO 14.0S2026 $20,850,000 13.3% 105.13 11.852032 $2,073,846 12.2% 96.67 Chester Ferris 12.582024 $13, 12.4% 100.67 12.582024 $4,339,156 12.4% 100.67 14.0S2026 $20,850,000 13.2% 105.76 14.0S2026 $20,850,000 13.2% 105.76
