Capsim question

User Generated

NynnEbpxl1986

Business Finance

Description

Look at the report and answer the question.

There were lots of stockouts in the Traditional segment. What company missed out on the most unit sales due to stockout? What company benefited the most from the stockouts?

Unformatted Attachment Preview

Round: 5 Dec. 31, 2024 C103975 Andrews Tayler Esping Joshua Lindsey Katelyn O'Neal Madeline Smith Frank Smith II Gage Upshaw Baldwin Mitchell Fronczak Annabelle Sawyer Stacie Simpson Courtney Urban Noelle Yanuzzi Chester caleb diggs Victoria Guffey Thomas Kuhn Ansley Noel Jasmine Richburg Jordan Rogers Digby Sharay Byrd Caitlin Clark Katin Davis Vitor Galvao Karen Pincelli Izzo Deborah Vallia Erie Yarinette Deliz Maxwell Gray Alaa Huwaykim Mark Reid Julie Ritenour Tiffany Taylor Ferris Yhana Burbel Mary Kate McBurney John McCormack Kyle Schroeder Matthew Sullivan George Szatko Selected Financial Statistics ROS Asset Turnover ROA Leverage ROE Emergency Loan Sales EBIT Profits Cumulative Profit SG&A / Sales Contrib. Margin % CAPSTONE ® COURIER Andrews 12.5% 1.65 20.7% 1.5 31.4% $0 $333,654,636 $72,073,891 $41,811,769 $78,866,297 10.8% 38.7% Baldwin -12.6% 0.96 -12.1% 8.4 -101.7% $29,906,027 $115,672,791 ($7,550,683) ($14,603,490) ($42,743,507) 18.8% 27.8% Chester -1.3% 2.28 -3.0% 5.0 -14.9% $7,398,277 $146,085,017 $3,354,871 ($1,929,200) ($30,834,803) 19.9% 26.4% Digby 8.3% 1.67 13.8% 1.6 22.4% $0 $196,532,892 $30,118,960 $16,246,659 $27,928,934 15.9% 43.6% Erie 1.2% 1.33 1.6% 2.2 3.5% $0 $163,817,820 $10,874,996 $1,973,518 ($3,975,316) 16.3% 36.9% Ferris -1.1% 1.26 -1.4% 3.0 -4.2% $0 $142,224,986 $5,528,390 ($1,591,439) ($19,003,135) 14.6% 36.2% Page 1 Stock & Bonds C103975 Round: 5 Dec. 31, 2024 Stock Market Summary Company Andrews Baldwin Chester Digby Erie Ferris Close Change Shares $139.71 $1.00 $1.00 $63.28 $19.42 $9.40 $52.03 $0.00 $0.00 $25.25 $3.30 $6.67 2,279,970 3,750,114 2,000,000 2,205,105 3,455,836 2,575,100 MarketCap ($M) $319 $4 $2 $140 $67 $24 Book Value EPS Dividend Yield P/E $58.41 $3.83 $6.46 $32.92 $16.36 $14.83 $18.34 ($3.89) ($0.96) $7.37 $0.57 ($0.62) $0.00 $0.00 $0.00 $1.00 $0.00 $0.00 0.0% 0.0% 0.0% 1.6% 0.0% 0.0% 7.6 -0.3 -1.0 8.6 33.9 -15.2 Bond Market Summary Company Andrews Series# Face Yield Close$ S&P 14.0S2025 $20,850,000 11.3S2030 $18,994,000 12.2S2031 $5,000,000 13.2S2032 $2,000,000 12.4S2034 $4,000,000 13.8% 11.7% 12.1% 12.5% 12.2% 101.69 96.72 100.45 105.44 101.69 A A A A A 14.0S2025 $20,850,000 11.3S2030 $5,000,000 12.0S2031 $10,000,000 12.9S2032 $5,000,000 14.0S2033 $14,000,000 14.2% 13.6% 14.2% 14.8% 15.3% 98.45 83.33 84.56 87.32 91.65 DDD DDD DDD DDD DDD 14.0S2025 $20,850,000 13.0S2032 $9,000,000 15.2S2034 $5,590,000 14.2% 14.7% 15.6% 98.53 DDD 88.16 DDD 97.56 DDD Company Digby Face Yield Close$ S&P 14.0S2025 $20,850,000 11.3S2030 $15,000,000 13.8% 11.9% 101.33 95.14 BBB BBB 14.0S2025 $20,850,000 11.3S2030 $10,000,000 13.3S2031 $9,874,000 13.8S2033 $6,381,000 14.3S2034 $6,217,000 14.0% 12.7% 13.8% 14.1% 14.2% 99.83 88.78 96.16 98.04 100.52 CCC CCC CCC CCC CCC 14.0S2025 $20,850,000 11.3S2030 $1,500,000 12.9S2031 $27,824,000 14.6S2034 $8,897,000 14.1% 13.2% 14.3% 15.0% 98.96 85.32 90.49 97.01 C C C C Erie Baldwin Chester Series# Ferris Next Year's Prime Rate9.50% CAPSTONE ® COURIER Page 2 Financial Summary Cash Flow Statement Survey CashFlows from operating activities Net Income(Loss) Adjustment for non-cash items: Depreciation Extraordinary gains/losses/writeoffs Changes in current assets and liablilities Accounts payable Inventory Accounts Receivable Net cash from operations C103975 Round: 5 Dec. 31, 2024 Andrews Baldwin Chester Digby Erie Ferris $41,812 ($14,603) ($1,929) $16,247 $1,974 ($1,591) $14,803 $0 $5,813 ($22) $6,365 ($2,156) $10,139 $0 $8,521 ($1,346) $9,736 ($4) $2,960 ($21,128) ($2,862) $35,585 ($1,330) ($4,515) ($1,121) ($15,779) $2,094 $3,746 ($916) $7,204 ($273) ($3,096) ($417) $22,599 $995 $6,452 ($2,420) $14,176 $6,538 $0 ($4,748) $9,931 ($36,560) $480 ($427) ($90) ($8,902) ($8,688) $0 $0 $0 $4,000 $0 ($3,838) $0 $0 $0 $625 $0 $0 $0 ($30,232) $15,000 $29,906 $0 $0 $0 $5,590 $0 ($19,766) $0 $7,398 ($2,205) $0 ($4,413) $0 $0 ($13,900) $0 $0 $0 $9,279 $0 $6,217 $0 ($16,661) $5,000 $0 $0 $0 $0 $8,897 $0 ($13,900) $0 $0 $162 $15,299 ($6,777) ($20,518) $3,835 ($5,003) Net change in cash position Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets ($813) Andrews $8,602 $27,424 $27,857 $63,883 $0 Baldwin $0 $11,092 $59,455 $70,547 $0 Chester $0 $12,007 $11,650 $23,657 $1,991 Digby $9,550 $18,846 $16,458 $44,853 $9,110 Erie $31,332 $13,464 $9,534 $54,330 ($3,761) Ferris $18,700 $21,431 $0 $40,131 Plant and equipment Accumulated Depreciation Total Fixed Assets $222,040 ($83,635) $138,405 $89,450 ($39,230) $50,220 $95,478 ($54,961) $40,517 $152,090 ($79,302) $72,788 $127,818 ($59,439) $68,379 $146,040 ($73,244) $72,796 Total Assets $202,288 $120,766 $64,174 $117,641 $122,710 $112,927 Accounts Payable Current Debt Long Term Debt Total Liabilities $18,274 $0 $50,844 $69,118 $6,645 $44,906 $54,850 $106,401 $8,418 $7,398 $35,440 $51,256 $9,209 $0 $35,850 $45,059 $7,866 $5,000 $53,322 $66,188 $15,668 $0 $59,071 $74,739 Common Stock Retained Earnings Total Equity $30,327 $102,844 $133,171 $34,957 ($20,591) $14,366 $18,360 ($5,441) $12,919 $27,302 $45,281 $72,582 $35,104 $21,418 $56,522 $31,798 $6,390 $38,188 Total Liabilities & Owners Equity $202,288 $120,766 $64,174 $117,641 $122,710 $112,927 Income Statement Survey Sales Variable Costs(Labor,Material,Carry) Depreciation SGA(R&D,Promo,Sales,Admin) Other(Fees,Writeoffs,TQM,Bonuses) EBIT Interest(Short term,Long term) Taxes Profit Sharing Net Profit Andrews $333,655 $204,543 $14,803 $36,035 $6,200 $72,074 $6,435 $22,973 $853 $41,812 Baldwin $115,673 $83,464 $5,813 $21,762 $12,184 ($7,551) $14,916 ($7,863) $0 ($14,603) Chester $146,085 $107,557 $6,365 $29,084 ($276) $3,355 $6,323 ($1,039) $0 ($1,929) Digby $196,533 $110,920 $10,139 $31,288 $14,066 $30,119 $4,614 $8,927 $332 $16,247 Erie $163,818 $103,295 $8,521 $26,697 $14,429 $10,875 $7,777 $1,084 $40 $1,974 Ferris $142,225 $90,773 $9,736 $20,747 $15,440 $5,528 $7,977 ($857) $0 ($1,591) 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 Net cash from financing activities CAPSTONE ® COURIER Page 3 C103975 Production Analysis Primary Segment Trad Low High Pfmn Size High Size Units Sold 2,324 3,268 1,186 1,258 1,050 1,540 1,051 Unit Inven Revision Age tory Date Dec.31 288 11/3/2024 1.4 0 8/10/2023 5.5 242 10/25/2024 1.2 109 6/16/2024 1.5 339 6/12/2024 1.5 156 6/12/2024 1.4 245 6/5/2024 1.5 Baker Bid Bold Buddy Bill Trad High Pfmn Size 1,804 831 919 447 0 0 344 868 1,553 0 Cake Cedar Cid Coat Cure Crap Trad Low High Pfmn Size Size Daze Dell Dixie Dot Dune Dice Name Able Acre Adam Aft Agape Apple Ark MTBF 16000 12250 23000 26150 19000 22500 19000 Pfmn Coord 9.2 5.2 13.4 14.4 7.5 13.4 7.5 Size Coord 10.8 14.8 6.6 12.5 5.6 6.6 5.6 Price $27.00 $18.25 $37.50 $32.40 $32.50 $37.50 $32.50 Material Cost $9.00 $5.29 $13.71 $13.32 $11.43 $13.58 $11.43 Labor Cost $6.72 $4.45 $8.83 $8.42 $8.72 $9.92 $9.93 Contr. Marg. 43% 46% 40% 32% 35% 37% 32% 2nd Shift & Overtime 100% 94% 87% 73% 66% 70% 71% Round: 5 Dec. 31, 2024 Auto mation Next Round 6.4 8.0 4.2 4.4 4.1 3.2 3.2 Capacity Next Round 1,500 2,000 900 950 850 1,000 950 Plant Utiliz. 198% 192% 185% 171% 164% 168% 169% 7/10/2024 7/5/2024 6/28/2024 6/28/2024 2/4/2025 1.8 1.6 1.6 1.7 0.0 16500 25000 27000 21000 0 8.5 12.0 13.0 6.5 0.0 11.5 8.0 13.5 7.0 0.0 $23.00 $35.00 $32.99 $32.99 $0.00 $8.75 $13.43 $12.88 $11.28 $0.00 $6.68 $6.59 $7.77 $7.59 $0.00 33% 32% 25% 11% 0% 100% 0% 60% 47% 0% 6.5 5.5 5.5 5.5 1.0 800 700 750 750 225 198% 85% 158% 145% 0% 1,671 1,980 139 691 846 191 254 7/10/2024 0 9/4/2023 16 10/28/2023 113 8/16/2024 147 8/16/2024 0 5/8/2024 1.6 5.5 2.9 1.5 1.5 0.6 14500 12300 22222 25000 19000 17000 8.5 3.7 11.0 14.4 7.5 7.5 11.5 16.3 9.0 12.5 5.6 5.6 $26.75 $20.00 $38.00 $33.00 $32.50 $32.50 $9.10 $9.94 $4.79 $8.97 $0.00 $0.00 $14.58 $11.28 $12.80 $10.64 $12.21 $15.87 28% 30% 37% 21% 25% 13% 29% 54% 0% 27% 9% 100% 4.3 5.8 3.0 3.0 3.0 1.0 1,500 1,300 1 550 600 200 128% 152% 0% 125% 107% 127% Trad Low High Pfmn Size Low 1,873 2,445 438 963 634 1,337 0 0 70 116 604 0 10/5/2024 4/17/2025 4/17/2024 7/8/2024 9/9/2024 3/19/2023 1.7 9.6 2.2 1.5 1.4 3.9 19000 13000 23000 27000 19500 19500 8.5 3.0 11.6 13.6 7.2 4.1 11.5 17.0 8.4 13.0 6.0 16.3 $27.00 $19.50 $38.00 $33.50 $31.50 $22.00 $9.31 $3.99 $12.47 $13.09 $11.32 $6.33 $6.79 $3.71 $8.19 $9.88 $9.26 $5.75 42% 60% 45% 31% 28% 44% 29% 76% 0% 77% 37% 35% 5.0 8.0 3.0 3.0 3.0 6.0 1,400 1,400 600 605 600 1,000 127% 175% 66% 175% 136% 134% Eat Ebb Echo Edge Egg Edible Trad Low High Pfmn Size Pfmn 2,127 2,673 596 202 376 693 391 0 131 0 19 0 7/20/2024 8/7/2024 5/31/2024 9/16/2023 7/10/2024 1/29/2024 1.6 5.0 1.5 3.1 1.6 0.9 14000 12000 21000 26500 17500 25500 8.2 3.8 12.1 11.3 6.8 14.0 12.0 16.3 8.0 14.6 6.6 12.5 $24.50 $18.25 $37.50 $32.50 $31.50 $32.00 $7.86 $4.31 $12.48 $0.00 $10.64 $13.20 $8.38 $5.66 $8.06 $0.00 $9.21 $9.38 33% 46% 41% 24% 34% 29% 80% 93% 0% 0% 0% 52% 5.0 7.0 4.0 3.0 3.0 5.0 1,600 1,400 600 1 400 700 179% 191% 80% 0% 42% 139% Fast Feat Fist Future Low Low Trad High 701 3,090 1,721 673 0 0 0 0 1/18/2024 6/5/2024 4/3/2024 6/10/2024 3.8 5.1 2.2 1.0 12000 12000 14000 23000 6.1 3.7 8.9 12.5 13.9 16.3 11.1 7.9 $18.98 $18.98 $25.99 $38.00 $5.82 $6.56 $4.19 $7.24 $8.25 $8.58 $12.94 $11.81 34% 40% 33% 34% 0% 100% 72% 100% 5.5 6.1 5.0 3.0 1,950 1,700 1,100 620 39% 182% 156% 182% CAPSTONE ® COURIER Page 4 Traditional Segment Analysis C103975 Round: 5 Dec. 31, 2024 Traditional Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 11,471 |11,471 |27.5% Next Year's Segment Growth Rate |9.2% Traditional Customer Buying Criteria Expectations Ideal Age = 2.0 $17.50 - 27.50 Pfmn 8.5 Size 11.5 MTBF 14000-19000 1. Age 2. Price 3. Ideal Position 4. Reliability Importance 47% 23% 21% 9% Top Products in Traditional Segment Name Able Eat Baker Daze Fist Cake Fast Acre Market Share 20% 18% 16% 16% 15% 15% 1% 0% Units Sold to Seg 2,324 2,009 1,804 1,788 1,713 1,671 156 6 CAPSTONE ® COURIER Revision Date 11/3/2024 7/20/2024 7/10/2024 10/5/2024 4/3/2024 7/10/2024 1/18/2024 8/10/2023 Stock Out YES YES YES YES YES Pfmn Coord 9.2 8.2 8.5 8.5 8.9 8.5 6.1 5.2 Size Coord 10.8 12.0 11.5 11.5 11.1 11.5 13.9 14.8 List Price $27.00 $24.50 $23.00 $27.00 $25.99 $26.75 $18.98 $18.25 MTBF 16000 14000 16500 19000 14000 14500 12000 12250 Cust. Age Promo AwareDec.31 Budget ness 1.39 $1,400 100% 1.62 $2,000 100% 1.75 $1,400 100% 1.71 $2,000 100% 2.23 $1,400 100% 1.56 $2,000 100% 3.83 $1,400 100% 5.49 $1,400 100% Cust. Dec. Sales Access- Cust Budget ibility Survey $3,000 86% 44 $3,000 74% 53 $2,250 62% 66 $2,900 90% 72 $2,000 92% 61 $2,500 69% 42 $2,250 92% 3 $3,000 86% 0 Page 5 Low End Segment Analysis C103975 Round: 5 Dec. 31, 2024 Low End Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 15,581 |15,535 |37.3% Next Year's Segment Growth Rate |11.7% Low End Customer Buying Criteria Expectations $12.50 - 22.50 Ideal Age = 7.0 Pfmn 4.2 Size 15.8 MTBF 12000-17000 1. Price 2. Age 3. Ideal Position 4. Reliability Importance 53% 24% 16% 7% Top Products in Low End Segment Name Acre Feat Ebb Dell Cedar Dice Fast Eat Daze Market Share 21% 20% 17% 16% 13% 9% 4% 1% 1% Units Sold to Seg 3,261 3,090 2,673 2,445 1,980 1,337 545 118 85 CAPSTONE ® COURIER Revision Date 8/10/2023 6/5/2024 8/7/2024 4/17/2025 9/4/2023 3/19/2023 1/18/2024 7/20/2024 10/5/2024 Stock Out YES YES YES YES YES YES YES YES Pfmn Coord 5.2 3.7 3.8 3.0 3.7 4.1 6.1 8.2 8.5 Size Coord 14.8 16.3 16.3 17.0 16.3 16.3 13.9 12.0 11.5 List Price $18.25 $18.98 $18.25 $19.50 $20.00 $22.00 $18.98 $24.50 $27.00 MTBF 12250 12000 12000 13000 12300 19500 12000 14000 19000 Cust. Age Promo AwareDec.31 Budget ness 5.49 $1,400 100% 5.08 $1,400 100% 5.00 $2,000 100% 9.60 $1,800 100% 5.46 $2,000 100% 3.92 $1,800 100% 3.83 $1,400 100% 1.62 $2,000 100% 1.71 $2,000 100% Cust. Dec. Sales Access- Cust Budget ibility Survey $3,000 83% 33 $2,250 84% 34 $3,000 81% 35 $2,700 96% 16 $2,500 69% 23 $1,500 96% 20 $2,250 84% 16 $3,000 81% 0 $2,900 96% 0 Page 6 High End Segment Analysis C103975 Round: 5 Dec. 31, 2024 High End Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 5,410 |5,410 |13.0% Next Year's Segment Growth Rate |16.2% High End Customer Buying Criteria Expectations Pfmn 13.4 Size 6.6 Ideal Age = 0.0 MTBF 20000-25000 $27.50 - 37.50 1. Ideal Position 2. Age 3. Reliability 4. Price Importance 43% 29% 19% 9% Top Products in High End Segment Name Apple Adam Bid Future Echo Dixie Cid Fist Market Share 28% 22% 15% 12% 11% 8% 3% 0% Units Sold to Seg 1,540 1,186 831 673 596 438 139 7 CAPSTONE ® COURIER Revision Date 6/12/2024 10/25/2024 7/5/2024 6/10/2024 5/31/2024 4/17/2024 10/28/2023 4/3/2024 Stock Out YES YES Pfmn Coord 13.4 13.4 12.0 12.5 12.1 11.6 11.0 8.9 Size Coord 6.6 6.6 8.0 7.9 8.0 8.4 9.0 11.1 List Price $37.50 $37.50 $35.00 $38.00 $37.50 $38.00 $38.00 $25.99 MTBF 22500 23000 25000 23000 21000 23000 22222 14000 Cust. Age Promo AwareDec.31 Budget ness 1.35 $1,400 100% 1.23 $1,400 100% 1.58 $2,000 100% 0.98 $3,000 100% 1.47 $2,000 100% 2.20 $1,900 100% 2.85 $0 67% 2.23 $1,400 100% Cust. Dec. Sales Access- Cust Budget ibility Survey $2,250 96% 61 $2,250 96% 66 $2,250 55% 35 $2,000 74% 41 $2,000 65% 21 $2,500 72% 14 $0 38% 3 $2,000 74% 0 Page 7 Performance Segment Analysis C103975 Round: 5 Dec. 31, 2024 Performance Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 4,726 |4,726 |11.3% Next Year's Segment Growth Rate |19.8% Performance Customer Buying Criteria Expectations MTBF 22000-27000 Pfmn 14.4 Size 12.5 $22.50 - 32.50 Ideal Age = 1.0 1. Reliability 2. Ideal Position 3. Price 4. Age Importance 43% 29% 19% 9% Top Products in Performance Segment Name Aft Dot Bold Edible Coat Edge Market Share 27% 20% 19% 15% 15% 4% Units Sold to Seg 1,258 963 919 693 691 202 CAPSTONE ® COURIER Revision Date 6/16/2024 7/8/2024 6/28/2024 1/29/2024 8/16/2024 9/16/2023 Stock Out YES YES Pfmn Coord 14.4 13.6 13.0 14.0 14.4 11.3 Size Coord 12.5 13.0 13.5 12.5 12.5 14.6 List Price $32.40 $33.50 $32.99 $32.00 $33.00 $32.50 MTBF 26150 27000 27000 25500 25000 26500 Cust. Age Promo AwareDec.31 Budget ness 1.52 $1,400 100% 1.52 $2,000 100% 1.64 $2,000 100% 0.92 $2,000 70% 1.51 $2,500 100% 3.15 $0 59% Cust. Dec. Sales Access- Cust Budget ibility Survey $3,000 79% 63 $2,400 69% 50 $2,750 61% 45 $3,000 68% 42 $2,500 69% 35 $0 68% 16 Page 8 Size Segment Analysis C103975 Round: 5 Dec. 31, 2024 Size Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 4,596 |4,596 |11.0% Next Year's Segment Growth Rate |18.3% Size Customer Buying Criteria Expectations Pfmn 7.5 Size 5.6 Ideal Age = 1.5 MTBF 16000-21000 $22.50 - 32.50 1. Ideal Position 2. Age 3. Reliability 4. Price Importance 43% 29% 19% 9% Top Products in Size Segment Name Ark Agape Cure Dune Buddy Egg Crap Market Share 23% 23% 18% 14% 10% 8% 4% Units Sold to Seg 1,051 1,050 846 634 447 376 191 CAPSTONE ® COURIER Revision Date 6/5/2024 6/12/2024 8/16/2024 9/9/2024 6/28/2024 7/10/2024 5/8/2024 Stock Out YES Pfmn Coord 7.5 7.5 7.5 7.2 6.5 6.8 7.5 Size Coord 5.6 5.6 5.6 6.0 7.0 6.6 5.6 List Price $32.50 $32.50 $32.50 $31.50 $32.99 $31.50 $32.50 MTBF 19000 19000 19000 19500 21000 17500 17000 Cust. Age Promo AwareDec.31 Budget ness 1.47 $1,400 100% 1.49 $1,400 100% 1.49 $2,500 100% 1.38 $1,800 100% 1.70 $2,000 100% 1.58 $2,000 100% 0.64 $2,500 74% Cust. Dec. Sales Access- Cust Budget ibility Survey $2,250 93% 83 $2,250 93% 83 $2,500 80% 68 $2,500 74% 72 $2,300 58% 32 $2,000 57% 32 $2,500 80% 42 Page 9 Market Share C103975 Actual Market Share in Units Industry Unit Sales % of Market Trad 11,471 27.5% Low 15,535 37.2% Able Acre Adam Aft Agape Apple Ark Total 20.3% Baker Bid Bold Buddy Total 15.7% Cake Cedar Cid Coat Cure Crap Total 14.6% 14.6% 12.8% Daze Dell Dixie Dot Dune Dice Total 15.6% 0.5% 15.7% Eat Ebb Echo Edge Egg Edible Total 17.5% 17.5% 18.0% Fast Feat Fist Future Total 1.4% 3.5% 19.9% High 5,410 13.0% Pfmn 4,726 11.3% Size 4,596 11.0% 17.8% 22.9% 45.7% Baker Bid Bold Buddy Total 18.2% 9.7% 9.7% 4.3% 2.0% 2.2% 1.1% 9.6% Cake Cedar Cid Coat Cure Crap Total 12.8% 18.4% 4.2% 22.6% 4.0% 4.7% 0.3% 1.7% 2.0% 0.5% 13.2% 4.5% 5.9% 1.1% 2.3% 1.5% 3.2% 18.4% Daze Dell Dixie Dot Dune Dice Total 16.1% 5.1% 6.4% 1.4% 0.5% 0.9% 1.7% 16.0% Eat Ebb Echo Edge Egg Edible Total 15.2% 15.2% 18.6% 1.7% 7.4% 4.1% 1.6% 14.8% Fast Feat Fist Future Total 3.3% 8.1% 18.6% 26.6% 22.9% 28.5% 21.0% 50.4% 26.6% 15.4% 19.4% 15.7% 15.4% 19.4% 12.8% 2.6% 14.6% 2.6% 14.6% 8.1% 20.4% 13.8% 15.6% 8.6% 24.9% 8.1% 20.4% 13.8% 0.8% 17.2% 11.0% 4.3% 8.2% 14.9% 16.3% CAPSTONE ® COURIER 23.4% 11.0% 0.1% 12.4% 12.6% 14.7% 18.9% Trad Low 11,471 15,581 27.5% 37.3% Able Acre Adam Aft Agape Apple Ark Total 21.9% 20.3% Potential Market Share in Units Total 41,737 Units Demanded 100.0% % of Market 5.6% 7.8% 2.8% 3.0% 2.5% 3.7% 2.5% 28.0% 21.0% 8.2% Round: 5 Dec. 31, 2024 High 5,410 13.0% Pfmn 4,726 11.3% Size 4,596 11.0% 22.4% 44.8% 4.9% 6.0% 2.6% 2.8% 2.5% 3.3% 2.5% 24.6% 9.5% 9.5% 5.0% 1.8% 2.1% 1.0% 9.9% 18.0% 6.1% 24.2% 3.5% 5.0% 0.3% 1.6% 2.0% 0.7% 13.0% 16.2% 19.8% 25.0% 22.4% 25.6% 17.9% 16.2% 45.5% 25.0% 13.9% 18.2% 18.2% 13.9% 18.2% 13.5% 2.3% 13.7% 12.8% 13.5% 2.3% 13.7% 14.3% 7.3% 19.1% 13.5% 16.1% 10.7% 25.0% 7.3% 19.1% 13.5% 18.5% 9.9% 7.5% 8.0% 9.9% 16.6% 19.8% 26.7% 21.0% 21.1% 16.5% 24.0% Total 41,784 100.0% 8.0% 4.5% 5.3% 0.9% 2.2% 1.5% 4.0% 18.3% 4.2% 6.9% 1.3% 0.8% 0.9% 1.9% 16.0% 3.9% 7.0% 4.6% 2.7% 18.1% Page 10 Perceptual Map C103975 Andrews Name Able Acre Adam Aft Agape Apple Ark Pfmn 9.2 5.2 13.4 14.4 7.5 13.4 7.5 Name Daze Dell Dixie Dot Dune Dice Pfmn 8.5 3.0 11.6 13.6 7.2 4.1 Size 10.8 14.8 6.6 12.5 5.6 6.6 5.6 Digby CAPSTONE ® COURIER Size 11.5 17.0 8.4 13.0 6.0 16.3 Baldwin Revised 11/3/2024 8/10/2023 10/25/2024 6/16/2024 6/12/2024 6/12/2024 6/5/2024 Name Baker Bid Bold Buddy Pfmn 8.5 12.0 13.0 6.5 Revised 10/5/2024 4/17/2025 4/17/2024 7/8/2024 9/9/2024 3/19/2023 Name Eat Ebb Echo Edge Egg Edible Pfmn 8.2 3.8 12.1 11.3 6.8 14.0 Size 11.5 8.0 13.5 7.0 Erie Size 12.0 16.3 8.0 14.6 6.6 12.5 Round: 5 Dec. 31, 2024 Chester Revised 7/10/2024 7/5/2024 6/28/2024 6/28/2024 Name Cake Cedar Cid Coat Cure Crap Pfmn 8.5 3.7 11.0 14.4 7.5 7.5 Revised 7/20/2024 8/7/2024 5/31/2024 9/16/2023 7/10/2024 1/29/2024 Name Fast Feat Fist Future Pfmn 6.1 3.7 8.9 12.5 Size 11.5 16.3 9.0 12.5 5.6 5.6 Ferris Size 13.9 16.3 11.1 7.9 Revised 7/10/2024 9/4/2023 10/28/2023 8/16/2024 8/16/2024 5/8/2024 Revised 1/18/2024 6/5/2024 4/3/2024 6/10/2024 Page 11 HR/TQM Report C103975 Round: 5 Dec. 31, 2024 HUMAN RESOURCES SUMMARY Needed Complement Complement 1st Shift Complement 2nd Shift Complement Andrews 1,467 1,467 815 652 Baldwin 503 503 329 174 Chester 903 903 671 232 Digby 803 803 565 238 Erie 751 750 463 287 Ferris 773 772 448 324 Overtime Percent Turnover Rate New Employees Separated Employees Recruiting Spend Training Hours Productivity Index 0.0% 6.5% 244 0 $5,000 80 114.2% 0.1% 8.4% 42 187 $1,500 40 102.8% 0.0% 7.4% 321 0 $1,000 70 102.6% 0.0% 8.0% 64 122 $5,000 40 116.0% 0.2% 7.8% 121 0 $0 60 108.4% 0.1% 6.4% 371 0 $5,000 80 112.4% Recruiting Cost Separation Cost Training Cost Total HR Admin Cost $1,461 $0 $2,347 $3,809 $105 $935 $402 $1,443 $641 $0 $1,264 $1,905 $383 $610 $642 $1,635 $121 $0 $900 $1,021 $2,224 $0 $1,235 $3,460 Labor Contract Next Year Wages Benefits Profit Sharing Annual Raise $26.81 2,500 2.0% 5.0% $26.81 2,500 2.0% 5.0% $26.81 2,500 2.0% 5.0% $26.81 2,500 2.0% 5.0% $26.81 2,500 2.0% 5.0% $26.81 2,500 2.0% 5.0% Baldwin Chester Digby Erie Ferris 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 Andrews Process Mgt Budgets Last Year CPI Systems VendorJIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs $0 $0 $0 $0 $0 $1,500 $1,000 $1,800 $1,000 $1,000 $1,550 $1,275 $400 $100 $100 $100 $100 $100 $1,500 $1,500 $1,500 $1,000 $1,500 $500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 TQM Budgets Last Year Benchmarking Quality Function Deployment Effort CCE/6 Sigma Training GEMI TQEM Sustainability Initiatives Total Expenditures $1,500 $1,500 $1,500 $0 $6,000 $1,000 $1,550 $1,000 $1,000 $12,175 $100 $100 $400 $100 $1,600 $1,500 $2,000 $1,500 $1,500 $14,000 $1,500 $1,500 $1,500 $1,500 $15,000 $1,500 $1,500 $1,500 $1,500 $15,000 11.66% 13.97% 39.69% 60.02% 14.30% 10.67% 11.28% 40.01% 60.02% 12.56% 1.04% 5.21% 5.20% 0.00% 0.01% 11.73% 14.00% 40.01% 60.02% 13.33% 10.11% 9.50% 32.39% 58.72% 8.50% 11.80% 14.00% 40.01% 60.02% 14.40% Cumulative Impacts Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction Admin Costs Demand Increase CAPSTONE ® COURIER Page 12 Annual Report Annual Report Erie C103975 Balance Sheet DEFINITIONS: Common Size: The common size column simply represents each item as a percentage of total assets for that year. Cash: Your end-of-year cash position. Accounts Receivable: Reflects the lag between delivery and payment of your products. Inventories: The current value of your inventory across all products. A zero indicates your company stocked out. Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for materials and services. Current Debt: The debt the company is obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The companys long term debt is in the form of bonds, and this represents the total value of your bonds. Common Stock: The amount of capital invested by shareholders in the company. Retained Earnings: The profits that the company chose to keep instead of paying to shareholders as dividends. ASSETS Cash Account Receivable Inventory Total Current Assets $54,330 2024 Common Size 25.5% 11.0% 7.8% 44.3% $22,222 $11,045 $15,986 $49,253 $68,379 $122,710 104.0% -48.4% 55.7% 100.0% $120,800 ($54,147) $66,653 $115,906 $66,188 6.4% 4.1% 43.5% 53.9% $6,871 $16,661 $47,105 $70,637 $56,522 $122,710 28.6% 17.5% 46.1% 100.0% $25,825 $19,445 $45,270 $115,906 $31,332 $13,464 $9,534 Plant & Equipment Accumulated Depreciation Total Fixed Assets Total Assets LIABILITIES & OWNERS EQUITY $127,818 ($59,439) Accounts Payable Current Debt Long Term Debt Total Liabilities $7,866 $5,000 $53,322 Common Stock Retained Earnings Total Equity Total Liab. & O. Equity $35,104 $21,418 Cash Flow Statement The Cash Flow Statement examines what happened in the Cash Account during the year. Cash injections appear as positive numbers and cash withdrawals as negative numbers. The Cash Flow Statement is an excellent tool for diagnosing emergency loans. When negative cash flows exceed positives, you are forced to seek emergency funding. For example, if sales are bad and you find yourself carrying an abundance of excess inventory, the report would show the increase in inventory as a huge negative cash flow. Too much unexpected inventory could outstrip your inflows, exhaust your starting cash and force you to beg for money to keep your company afloat. Annual Report Round: 5 Dec. 31, 2024 Cash Flows from Operating Activities Net Income(Loss) Depreciation Extraordinary gains/losses/writeoffs Accounts Payable Inventory Accounts Receivable Net cash from operation Cash Flows from Investing Activities Plant Improvements Cash Flows from Financing Activities Dividends paid Sales of common stock Purchase of common stock Cash from long term debt Retirement of long term debt Change in current debt(net) Net cash from financing activities Net change in cash position Closing cash position 2023 2024 $1,974 $8,521 ($1,346) $995 $6,452 ($2,420) $14,176 2023 $1,940 $7,320 ($1,233) $562 $4,527 ($649) $12,466 ($8,902) ($13,860) $0 $9,279 $0 $6,217 $0 ($11,661) $3,835 $9,110 $31,332 $0 $4,717 $0 $6,381 ($13,900) $16,661 $13,859 $12,465 $22,222 Page 13 Annual Report Erie Round: 5 Dec. 31, 2024 C103975 2024 Income Statement (Product Name) $0 2024 Total $163,818 Common Size 100.0% $0 $0 $0 $0 $0 $0 $0 $0 $50,387 $51,764 $1,144 $103,295 30.8% 31.6% 0.7% 63.1% Eat Ebb Echo Edge Egg Edible Sales $52,103 $48,790 $22,344 $6,553 $11,848 $22,180 $0 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $17,822 $16,526 $758 $35,106 $15,138 $11,170 $0 $26,308 $5,072 $7,756 $340 $13,168 $2,255 $2,757 $0 $5,012 $3,601 $4,227 $47 $7,875 $6,498 $9,327 $0 $15,826 Contribution Margin $16,997 $22,482 $9,176 $1,541 $3,973 $6,354 $0 $0 $60,522 36.9% Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $2,773 $560 $2,000 $3,000 $475 $8,809 $3,173 $610 $2,000 $3,000 $445 $9,228 $880 $421 $2,000 $2,000 $204 $5,505 $1 $0 $0 $0 $60 $61 $480 $532 $2,000 $2,000 $108 $5,120 $1,213 $80 $2,000 $3,000 $202 $6,495 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $8,521 $2,202 $10,000 $13,000 $1,495 $35,218 5.2% 1.3% 6.1% 7.9% 0.9% 21.5% Net Margin $8,188 $13,254 $3,671 $1,480 ($1,147) ($141) $0 $0 $25,304 15.4% $14,429 $10,875 $645 $7,132 $1,084 $40 $1,974 8.8% 6.6% 0.4% 4.4% 0.7% 0.0% 1.2% Definitions: Sales: Unit Sales times list price. Direct Labor: Labor costs incurred to produce the product that was sold. Inventory Carry Cost: the cost unsold goods in inventory. Depreciation: Calculated on straight-line. 15-year depreciation of plant value. R&D Costs: R&D department expenditures for each product. Admin: Administration overhead is estimated at 1.5% of sales. Promotions: The promotion budget for each product. Sales: The sales force budget for each product. Other: Chargs not included in other categories such as Fees, Write offs, and TQM. The fees include money paid to investment bankers and brokerage firms to issue new stocks or bonds plus consulting fees your instructor might assess. Write-offs include the loss you might experience when you sell capacity or liquidate inventory as the result of eliminating a production line. If the amount appears as a negative amount, then you actually made money on the liquidation of capacity or inventory. EBIT: Earnings Before Interest and Taxes. Short Term Interest: Interest expense based on last years current debt, including short term debt, long term notes that have become due, and emergency loans, Long Term Interest: Interest paid on outstanding bonds. Taxes: Income tax based upon a 35% tax rate. Profit Sharing: Profits shared with employees under the labor contract. Net Profit: EBIT minus interest, taxes, and profit sharing. Annual Report Other EBIT Short Term Interest Long Term Interest Taxes Profit Sharing Net Profit Page 14
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

hello am done with your question 😖 feel free to send any corrections. goodbye.

Running head: BUSINESS

1

Business
Strategic Management
Student’s Name
Institution Affiliation
Instructor
Course
Date

STRATEGIC MANAGEMENT

2

Strategic management
The aim of most companies is to have a high-profit margin and this can be achieved if the
production level meet the ...


Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags