6-1 Discussion: Debrief Rounds 4, 5, and 6 In this discussion topic, debrief Competitive Rounds 4, 5, and 6. What did you learn from your decisions and rationale for the solutions you implemented in R
Round: 4 Dec. 31, 2023 F111151_010 Andrews Rashel Hafiz Baldwin Chester Digby Erie Ferris Selected Financial Statistics Andrews Baldwin Chester Digby Erie Ferris ROS 13.4% 8.2% 7.4% 9.7% 3.0% 6.9% Asset Turnover 1.08 1.28 1.19 1.36 1.21 1.58 ROA 14.5% 10.4% 8.8% 13.2% 3.7% 10.9% Leverage 1.9 2.1 2.0 2.0 2.2 2.1 ROE 27.8% 22.1% 17.6% 26.9% 8.0% 22.6% Emergency Loan $3,154,655 $0 $0 $0 $0 $0 Sales $88,203,935 $77,342,722 $61,752,510 $74,755,007 $54,260,869 $60,994,214 EBIT $22,667,045 $12,778,245 $9,672,080 $13,949,214 $4,889,485 $8,354,582 Profits $11,829,413 $6,316,840 $4,563,357 $7,281,800 $1,635,228 $4,212,146 Cumulative Profit $32,683,430 $24,340,552 $13,990,919 $25,403,651 $11,197,642 $14,816,018 SG&A / Sales 11.8% 10.1% 9.9% 10.7% 10.2% 14.0% Contrib. Margin % 45.6% 34.4% 39.1% 35.5% 34.2% 36.7% FOUNDATION ® FAST TRACK Page 1 Stoc N & Bonds F111151_010 Round: 4 Dec. 31, 2023 Stoc N Mar Net Summary Com Sany Close Change Shares Mar NetCa S $M Boo N 9aluePer Share EPS DividendDe Sreciation $4,271 $2,907 $2,917 $2,547 $2,643 $1,667 E [traordinary gains/losses/writeoffs $0 $0 $0 $0 $0 $0 Changes in current assets and liablilities Accounts Sayable $884 $193 $223 $90 $347 $1,240 Inventory $6,314 $2,915 $710 $2,239 $1,187 $2,756 Accounts Receivable $1,867 $11 $1,024 $273 $773 $1,579 Net cash from o Serations $7,035 $6,127 $5,970 $7,406 $2,664 $2,783 Cash flows from investing activities Plant im Srovements net $15,636 $7,944 $1,900 $3,960 $3,181 $2,200 Cash flows from financing activities Dividends Said $0 $6,039 $1,991 $7,306 $2,740 $3,731 Sales of common stoc N $0 $0 $0 $0 $0 $0 Purchase of common stoc N $0 $0 $0 $0 $0 $0 Cash from long term debt issued $11,779 $2,892 $1,101 $670 $1,334 $1,476 Early retirement of long term debt $0 $0 $0 $0 $0 $0 Retirement of current debt $7,833 $9,820 $6,095 $9,964 $5,979 $6,632 Cash from current debt borrowing $1,500 $13,586 $7,674 $13,569 $8,517 $7,791 Cash from emergency loan $3,155 $0 $0 $0 $0 $0 Net cash from financing activities $8,601 $619 $689 $3,031 $1,132 $1,096 Net change in cash Sosition $0 $1,198 $4,759 $414 $615 $513 Balance Sheet Survey Andrews Baldwin Chester Digby Erie Ferris Cash $0 $12,918 $12,107 $12,220 $7,654 $7,699 Accounts Receivable $10,874 $6,357 $5,076 $6,144 $4,460 $5,013 Inventory $22,110 $10,966 $4,840 $11,334 $5,961 $8,124 Total Current Assets $32,985 $30,240 $22,023 $29,698 $18,075 $20,836 Plant and e Tui Sment $64,068 $43,604 $43,758 $38,200 $39,646 $25,000 Accumulated De Sreciation $15,638 $13,246 $13,732 $12,792 $13,003 $7,150 Total Fi [ed Assets $48,430 $30,358 $30,026 $25,408 $26,644 $17,850 Total Assets $81,415 $60,599 $52,049 $55,106 $44,719 $38,686 Accounts Payable $2,831 $4,299 $2,584 $3,362 $2,281 $3,320 Current Debt $6,388 $15,146 $9,407 $14,660 $10,251 $9,524 Total Current Liabilities $9,219 $19,445 $11,991 $18,022 $12,532 $12,844 Long Term Debt $29,653 $12,550 $14,104 $10,010 $11,834 $7,180 Total Liabilities $38,872 $31,995 $26,095 $28,032 $24,365 $20,025 Common Stoc N $2,271 $4,785 $5,917 $4,030 $4,855 $2,846 Retained Earnings $40,272 $23,818 $20,037 $23,043 $15,498 $15,815 Total E Tuity $42,543 $28,603 $25,954 $27,073 $20,354 $18,662 Total Liabilities & Owners E Tuity $81,415 $60,599 $52,049 $55,106 $44,719 $38,686 Income Statement Survey Andrews Baldwin Chester Digby Erie Ferris Sales $88,204 $77,343 $61,753 $74,755 $54,261 $60,994 9ariable Costs Labor,Material,Carry $48,000 $50,711 $37,601 $48,210 $35,724 $38,614 Contribution Margin $40,204 $26,632 $24,152 $26,545 $18,537 $22,380 De Sreciation $4,271 $2,907 $2,917 $2,547 $2,643 $1,667 SGA R&D,Promo,Sales,Admin $10,427 $7,802 $6,107 $8,015 $5,537 $8,535 Other Fees, :riteoffs,T 4M,Bonuses $2,839 $3,145 $5,455 $2,034 $5,467 $3,824 EBIT $22,667 $12,778 $9,672 $13,949 $4,889 $8,355 Interest Short term,Long term $4,097 $2,862 $2,508 $2,518 $2,322 $1,742 Ta [es $6,500 $3,471 $2,507 $4,001 $898 $2,314 Profit Sharing $241 $129 $93 $149 $33 $86 Net Profit $11,829 $6,317 $4,563 $7,282 $1,635 $4,212 FOUNDATION ® FAST TRACK Page 3 Production Analysis F111151_010 Round: 4 Dec. 31, 2023 Name PrimarySegment UnitsSold UnitInventory Revision Date AgeDec.31 MTBF PfmnCoord SizeCoord Price Material Cost Labor Cost Contr.Marg. 2ndShift& Over time AutomationNe [tRound Ca Sacity Ne [tRound PlantUtiliz. Able Low 1,649 642 1/15/2023 2.5 19900 6.5 13.5 $36.00 $10.60 $4.98 52% 64% 8.0 1,400 163% A_GB1 High 627 400 1/29/2023 1.9 21000 9.4 10.6 $46.00 $16.45 $11.33 33% 32% 2.3 715 132% Ba Ner Low 1,521 309 4/16/2023 2.4 19800 7.0 13.6 $33.40 $11.22 $9.43 35% 45% 5.0 1,150 144% Bold High 626 161 5/30/2023 1.3 22400 8.8 10.1 $42.35 $17.18 $10.36 33% 56% 4.0 650 155% Ca Ne Low 1,492 165 7/28/2022 3.3 17000 5.8 13.4 $25.20 $8.91 $5.43 39% 53% 7.5 950 152% Cent Low 649 106 8/16/2023 1.0 20000 7.3 11.3 $37.20 $13.10 $9.17 40% 79% 4.5 419 178% Daze Low 1,365 290 6/15/2023 2.3 19000 7.2 13.0 $34.00 $11.73 $9.55 35% 33% 4.8 1,050 133% Dabble High 630 183 6/29/2023 1.2 22000 9.7 10.6 $45.00 $17.40 $10.45 36% 17% 3.8 600 116% Eat Low 1,126 229 5/28/2023 2.0 16500 6.9 13.5 $27.60 $9.63 $6.95 37% 28% 5.6 899 127% East Low 786 102 1/8/2023 1.8 16500 6.2 12.8 $29.50 $9.70 $9.77 31% 71% 5.6 497 170% Fast High 712 197 7/10/2023 1.5 22000 10.0 9.7 $44.00 $18.06 $9.91 35% 50% 4.5 500 149% Feast High 674 100 7/10/2023 1.0 22000 9.6 10.2 $44.00 $17.21 $9.37 39% 25% 4.5 600 124% FOUNDATION ® FAST TRACK Page 4 Low Tech Segment Analysis F111151_010 Round: 4 Dec. 31, 2023 Low Tech Statistics Total Industry Unit Demand 7,379 Actual Industry Unit Sales _7,379 Segment % of Total Industry _62.2% Ne [t
Aware ness Sales Budget Cust.
Access ibility Dec.
Cust Survey Able 19% 1,429 1/15/2023 6.5 13.5 $36.00 19900 2.52 $1,500 100% $3,000 74% 32 Ca Ne 19% 1,417 7/28/2022 5.8 13.4 $25.20 17000 3.34 $1,025 63% $1,150 51% 28 Ba Ner 18% 1,336 4/16/2023 7.0 13.6 $33.40 19800 2.42 $1,350 88% $1,350 48% 29 Daze 16% 1,171 6/15/2023 7.2 13.0 $34.00 19000 2.30 $1,450 95% $1,450 45% 24 Eat 13% 986 5/28/2023 6.9 13.5 $27.60 16500 1.98 $1,000 57% $1,000 47% 21 East 8% 621 1/8/2023 6.2 12.8 $29.50 16500 1.80 $1,000 50% $1,000 47% 15 Cent 5% 380 8/16/2023 7.3 11.3 $37.20 20000 1.01 $1,025 54% $1,150 51% 8 Bold 0% 34 5/30/2023 8.8 10.1 $42.35 22400 1.28 $1,350 68% $1,350 48% 1 Feast 0% 5 7/10/2023 9.6 10.2 $44.00 22000 1.04 $1,500 67% $1,500 13% 0 FOUNDATION ® FAST TRACK Page 5 High Tech Segment Analysis F111151_010 Round: 4 Dec. 31, 2023 High Tech Statistics Total Industry Unit Demand 4,479 Actual Industry Unit Sales _4,479 Segment % of Total Industry _37.8% Ne [t
Aware ness Sales Budget Cust.
Access ibility Dec.
Cust Survey Fast 16% 712 7/10/2023 10.0 9.7 $44.00 22000 1.46 $1,500 98% $1,500 67% 38 Feast 15% 670 7/10/2023 9.6 10.2 $44.00 22000 1.04 $1,500 67% $1,500 67% 34 Dabble 14% 630 6/29/2023 9.7 10.6 $45.00 22000 1.21 $1,450 75% $1,450 73% 32 A_GB1 14% 627 1/29/2023 9.4 10.6 $46.00 21000 1.90 $1,500 93% $2,000 87% 25 Bold 13% 593 5/30/2023 8.8 10.1 $42.35 22400 1.28 $1,350 68% $1,350 64% 28 Cent 6% 269 8/16/2023 7.3 11.3 $37.20 20000 1.01 $1,025 54% $1,150 45% 14 Able 5% 219 1/15/2023 6.5 13.5 $36.00 19900 2.52 $1,500 100% $3,000 87% 6 Daze 4% 194 6/15/2023 7.2 13.0 $34.00 19000 2.30 $1,450 95% $1,450 73% 11 Ba Ner 4% 186 4/16/2023 7.0 13.6 $33.40 19800 2.42 $1,350 88% $1,350 64% 7 East 4% 165 1/8/2023 6.2 12.8 $29.50 16500 1.80 $1,000 50% $1,000 39% 5 Eat 3% 140 5/28/2023 6.9 13.5 $27.60 16500 1.98 $1,000 57% $1,000 39% 6 Ca Ne 2% 75 7/28/2022 5.8 13.4 $25.20 17000 3.34 $1,025 63% $1,150 45% 1 FOUNDATION ® FAST TRACK Page 6 Mar Net Share F111151_010 Round: 4 Dec. 31, 2023 Actual Mar Net Share in Units Potential Mar Net Share in Units Low High Total Low High Total Industry Unit Sales 7,379 4,479 11,858 Units Demanded 7,379 4,479 11,858 % of Mar Net 62.2% 37.8% 100.0% % of Mar Net 62.2% 37.8% 100.0% Able 19.4% 4.9% 13.9% Able 19.4% 4.9% 13.9% A_GB1 14.0% 5.3% A_GB1 14.0% 5.3% Total 19.4% 18.9% 19.2% Total 19.4% 18.9% 19.2% Ba Ner 18.1% 4.2% 12.8% Ba Ner 18.1% 4.1% 12.8% Bold 0.5% 13.2% 5.3% Bold 0.5% 13.2% 5.3% Total 18.6% 17.4% 18.1% Total 18.6% 17.4% 18.1% Ca Ne 19.2% 1.7% 12.6% Ca Ne 19.2% 1.7% 12.6% Cent 5.1% 6.0% 5.5% Cent 5.2% 6.0% 5.5% Total 24.4% 7.7% 18.1% Total 24.4% 7.7% 18.1% Daze 15.9% 4.3% 11.5% Daze 15.9% 4.3% 11.5% Dabble 14.1% 5.3% Dabble 14.1% 5.3% Total 15.9% 18.4% 16.8% Total 15.9% 18.4% 16.8% Eat 13.4% 3.1% 9.5% Eat 13.4% 3.1% 9.5% East 8.4% 3.7% 6.6% East 8.4% 3.7% 6.6% Total 21.8% 6.8% 16.1% Total 21.8% 6.8% 16.1% Fast 15.9% 6.0% Fast 15.9% 6.0% Feast 14.9% 5.7% Feast 15.0% 5.7% Total 30.8% 11.7% Total 30.8% 11.7% FOUNDATION ® FAST TRACK Page 7 Perce Stual Ma S F111151_010 Round: 4 Dec. 31, 2023 Andrews Baldwin Chester Name Pfmn Size Revised Name Pfmn Size Revised Name Pfmn Size Revised Able 6.5 13.5 1/15/2023 Ba Ner 7.0 13.6 4/16/2023 Ca Ne 5.8 13.4 7/28/2022 A_GB1 9.4 10.6 1/29/2023 Bold 8.8 10.1 5/30/2023 Cent 7.3 11.3 8/16/2023 Digby Erie Ferris Name Pfmn Size Revised Name Pfmn Size Revised Name Pfmn Size Revised Daze 7.2 13.0 6/15/2023 Eat 6.9 13.5 5/28/2023 Fast 10.0 9.7 7/10/2023 Dabble 9.7 10.6 6/29/2023 East 6.2 12.8 1/8/2023 Feast 9.6 10.2 7/10/2023 FOUNDATION ® FAST TRACK Page 8 HR/T 4M Re Sort F111151_010 Round: 4 Dec. 31, 2023 HUMAN RESOURCES SUMMAR < Andrews Baldwin Chester Digby Erie Ferris Needed Com Slement 307 366 237 358 269 244 Com Slement 307 366 237 358 269 244 1st Shift Com Slement 211 246 145 282 184 179 2nd Shift Com Slement 96 120 92 75 85 65 Overtime Percent 0.1% 0.0% 0.0% 0.0% 0.0% 0.0% Turnover Rate 6.4% 8.6% 8.4% 8.5% 8.8% 8.4% New Em Sloyees 20 32 22 30 64 102 Se Sarated Em Sloyees 79 44 0 14 0 0 Recruiting S Send $5,000 $2,000 $1,800 $2,700 $2,200 $3,000 Training Hours 80 30 40 34 25 40 Productivity Inde [ 114.4% 104.4% 105.5% 105.2% 103.6% 106.7% Recruiting Cost $118 $95 $60 $112 $204 $408 Se Saration Cost $396 $218 $0 $69 $0 $0 Training Cost $491 $219 $190 $243 $134 $195 Total HR Admin Cost $1,005 $532 $250 $425 $339 $603 Stri Ne Days T 4M SUMMAR < Andrews Baldwin Chester Digby Erie Ferris Process Mgt Budgets Last