Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

In referring to Foundation FastTrack, describe the progression of your Capsim company during Competitive Rounds 1 through 3 relative to the following: I. Your Product

In referring to Foundation FastTrack, describe the progression of your Capsim company during Competitive Rounds 1 through 3 relative to the following:

I. Your Product Pay particular attention to the sections on the low-tech segment, high-tech segment, and perceptual map.

i. Where is your product positioned? (Low-tech? High-tech?)

ii. Does your product fit the consumers desires for the product segment?

iii. How did the release data of your product impact its performance?

II. Production Analysis Pay particular attention to the sections on R&D, capacity, and funding your plant improvements.

i. What is your production schedule?

ii. How did capacity for your product(s) change over the years?

iii. How did automation change over the years? What impact did it have on your organization?

iv. Did you discontinue a product?

III. Market Segmentation Pay particular attention to the sections on market segmentation, pricing, the low-tech segment, the high-tech segment, and the contribution margin.

i. What is the price of your product?

ii. What was your promotional budget?

iii. What was your sales budget?

iv. What was the sales forecast for each product?

v. What were the accounts receivable (A/R) and accounts payable (A/P) implications of the decisions?

IV. Financial Performance

i. How did you pay for your R&D expenses?

ii. How did you pay for marketing expenses?

iii. How did you fund your production activities?

iv. Did you buy back stock?

v. Did you retire bonds?

vi. Did you take an emergency loan?

vii. Did you pay dividends?

viii. What is your cash percentage?

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Round: 3 Foundation FastTrack F115130_015 F15130_015 Dec. 31, 2023 Baldwin Chester Andrews Rashid Laroussi Digby Erie 76% 1.10 8.4% Ferris 7.3% 121 8.9% 19 20 20 16.7% Selected Financial Statistics Baldwin Chester Digby 11.7% 5.5% 10.8% 149 102 143 17.5% 56% 15.5% 2.0 1.9 33.1% 11.4% 30.2% SO $94, 159,695 $57,078,805 $89,268,300 $19,876,678 $7,652,605 $17,800,336 $11,042,234 $3,112,873 $9,661,011 $22.404,369 $12,280,097 $23,600,289 8.7% 11 004 98% 32 7% 30 7% 32 5% ROS Asset Turnover ROA Leverage (Assets Equity) ROE Emergency Loan Sales EBIT Profits Cumulative Profit SG&A / Sales Contrib. Margin % 18.0% Andrews 0.0% 0 55 -970% -0.8 -77.5% $30.014.080 $9.857.491 (S20.643,683) (517,539,113) ($34.491,708) 214.8% 17 0% SO SO $54,292,207 $8,814,490 S4,146,811 $12,620,981 10.5% 31.9% $51,051,094 $7,796,564 $3,741,295 $14,399,870 14 496 32 49 Percent of Sales F115130_015 $ Market Share F115130_015 100% Profit O Other O SGA Depr O Var Costs Andrews Baldwin Chester Digby Erie Ferris 2.77% 26.47% 16.05% 25.1% 15.26 % 14.35% -20% -40% Andrews Chester Digby Erie Ferris FOUNDATION FAST TRACK Page 1 Top Round: 3 Stocks & Bonds Fast Track F115130_015 December 31, 2023 PIE $2 Company Andrews Baldwin Chester Digby Close $1.00 $37.17 $19.58 $37.96 S20.81 $20.52 Change $0.00 $14.98 $1.412 $11.03 $3.74 (0.31) Stock Market Summary MarketCap Book Value Shares $M] Per Share 2.412.590 $938) 2.160,718 S80 $15.43 295.575 S45 $11.92 2.101,493 S80 $15.23 2.187,343 S46 S11.38 2,055,109 S42 $10.09 EPS ($7.27) $5.11 $1.36 S4.60 $1.90 $1.82 Dividend $0.00 $0.71 $0.00 $164 $0.24 SO 87 Yleld 0.0% 1.9% 0.0% 4.3% 1.2% 0.1 7.3 14.4 8.3 11.0 11.3 Erie Ferris Closing Stock Price F115130_015 Andrews Baldwin Chester Digby Erie Ferris 2021 2022 2023 2024 2025 2026 2027 Bond Market Summary Company Series# Face Yield Close$ S&P Andrews 12.0S2024 13.0S2026 10.082031 13.352033 $1,494,948 $2,600,000 $1,890,000 $1,439,000 12.1% 13.1% 11.9% 13.3% 98.85 99.30 84.33 100.00 DDD DDD DDD DDD Baldwin 12.082024 13.0S2026 10.082031 10.9S2032 11.1S2033 $1,733,333 $2,600,000 $2,480,000 $3,916,739 $1,063,876 11.9% 12.4% 10.5% 10.9% 11.0% 100.99 105.14 95.35 100.00 101.18 Chester 12.0S2024 13.082026 10.0S2031 10.752032 11.352033 $1,733.333 $2,600,000 $2,361,878 $4,464,959 $4,987,824 11.9% 12.5% 10.8% 11.1% 11.4% 100.54 103.88 92.90 96.18 99.42 Digby 12.0S2024 13.0S2026 10.082031 10.752032 $1,467,106 $2,600,000 $2,287,212 $3,702,476 11.9% 12.4% 10.6% 10.9% 100.81 104.64 94.36 97.79 Erie 12.0S2024 13.0S2026 10.082031 10.8S2032 11.252033 $1,733,333 $2,600,000 $2,361,878 $4,374,475 $1,811,820 11.9% 12.5% 10.7% 11.0% 11.2% 100.72 104.38 93.87 97.80 100.00 Ferris 12.0S2024 13.082026 10.082031 10.9S2032 $1,482,266 $2,600,000 $420,545 $2,156,844 11.9% 12.5% 10.8% 11.2% 100.54 103.88 92.90 97.27 Next Year's Prime Rate 7.00% FOUNDATION FAST TRACK Page 21 Top Fasttrack Financial Summary F115130_015 Round: 3 December 31, 2023 Andrews Baldwin Chester Digby Erie Ferris ($17,539) $11,042 $3,113 $9,661 $4,147 $3,741 $1,056 $2,614 $3,237 $2,511 $2,721 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 $1,593 ($229) $0 $0 $0 $4 $0 $297 ($4,520) $79 ($20,627) $1,281 ($4,495) ($1,825) $8,617 $624 ($3,319) ($788) $2,866 $262 ($11,395) ($847) $197 $916 ($8,651) (5866) ($1,732) $203 ($10,136) $441 ($4,388) ($4,240) ($7,740) ($15,528) ($5,520) ($8,660) ($1,400) $0 ($1,536) $0 $0 ($1,785) $0 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 $2,704 $0 $4,988 $0 ($528) $0 $0 $1,812 $0 $1,064 ($3,454) $0 $0 $0 ($270) ($9,511) $15,412 $0 $402 $0 $1,439 $0 ($9,266) $2,278 $30,014 $0 $0 $0 ($7,586) $12,401 $0 ($8,091) $9,518 $0 ($7,458) $8,643 $0 ($253) ($9,888) $11,190 $0 Net cash from financing activities $24,867 $4,344 $9,119 $2,177 $2,469 ($735) Net change in cash position Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets Andrews $0 $810 $4,812 $5,622 $5,221 Baldwin $22,200 $7,739 $4,495 $34,434 ($3.542) Chester $10,675 $4,691 $3,319 $18,685 ($3,147) Digby $16,376 $7,337 $11,395 $35,108 ($7,923) Erie $5,946 $4,462 $8,651 $19,060 ($6,523) Ferris $9,130 $4,196 $10,686 $24,013 Plant and equipment Accumulated Depreciation Total Fixed Assets $15,840 ($3,376) $12,464 $39,204 ($10,575) $28,629 $48,548 ($11,306) $37,242 $37,660 ($10,473) $27,187 $40,820 ($10,652) $30,168 $23,900 ($5,762) $18,138 Total Assets $18,086 $63,063 $55.927 $62,294 $49,228 $42, 151 Accounts Payable Current Debt Total Current Liabilities $996 $32,292 $33,288 $5,536 $12,401 $17,937 $2,909 $9,518 $12,427 $4,812 $15,412 $20,224 $2.809 $8,643 $11,452 $3.566 $11,190 $14,756 Long Term Debt Total Liabilities $7,424 $40,712 $11,794 $29,731 $16.148 $28,574 $10,057 $30,281 $12,882 $24,334 $6,660 $21,416 Common Stock Retained Earnings Total Equity $3,978 ($26,604) ($22,626) $4,427 $28.905 $33,332 $7,035 $20,317 $27,352 $3,830 $28,183 $32,013 $4,765 $20,130 $24,894 $3,277 $17,457 $20,734 Total Liabilities & Owners' Equity $18,086 $63,063 $55,927 $62,294 $49,228 $42,151 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 FOUNDATION FAST TRACK Andrews $9,857 $8,177 $1,680 $1,056 $21,176 $92 ($20,644) $6,340 ($9,444) $0 ($17,539) Baldwin $94,160 $63,396 $30,764 $2,614 $8,220 $53 $19,877 $2,542 $6.067 $225 $11,042 Chester $57,079 $39,544 $17,535 $3,237 $6,261 $385 $7,653 $2,766 $1,710 $64 $3,113 Digby $89,268 $60.231 $29,037 $2,511 $8,718 $8 $17,800 $2,634 $5,308 $197 $9,661 Erie $54,292 $36.965 $17,327 $2,721 $5,701 $91 $8,814 $2,305 $2,278 $85 $4,147 Ferris $51,051 $34,535 $16,516 $1,593 $7,351 ($226) $7,797 $1,923 $2,056 $76 $3,741 Page 3 Top foundation Production Analysis Fasttrack F115130_015 Round: 3 December Bounda; Production vs Capacity F115130_015 Andrews Baldwin Chester Digby Erie Ferris 0 200 400 600 800 2,400 2,600 2,800 1,000 1,200 Capacity 1,400 1,600 1,800 2,000 2,200 Production Production Information Unit Primary Units Inven Pfmn Size Name Segment Sold tory Revision Date Dec.31 MTBF Coord Coord 2nd Auto Shift & mation Capacity Material Labor Contr. Over- Next Next Plant Price Cost Cost Marg. time Round Round Utiliz. Low 394 Able A_Laro 0 422 3.2 3.0 A2 0 7 /1/2023 4/4/2026 5/23/2025 7/13/2025 6/17/2025 1.7 15000 1.1 14000 1.3 23000 1.0 27000 1.2 20000 6.3 3.0 8.9 10.4 4.5 13.7 $25.00 $10.14 $8.95 17.0 $30.00 $5.21 $6.71 11.1 $22.00 $0.00 $0.00 15.3 $35.00 $0.00 $0.00 9.8 $28.00 $0.00 $0.00 23% 0% 0% 0% 0% 100% 100% 0% 0% 0% 2.5 200 200 0 0 0 197% 197% 0% 0% 0% A3 Oo 3.1 2. A4 0 0 Baker Bold Low High 1,945 690 134 53 3/8/2022 9/2/2023 3.1 198006.5 1.0 22400 8.1 14.1 $33.40 10.9 $42.35 $11.41 $10.64 $17.03 $10.98 32% 35% 100% 67% 4.5 4.0 1,200 500 198% 166% 7.0 Cake Cent Low High 1,704 317 179 0 7/21/2023 5/5/2023 2.4 17000 0.7 20000 5.8 6.8 13.4 $26.20 $10.59 $7.89 12.3 $39.20 $13.60 $9.86 28% 39% 100% 100% 1,150 414 199% 130% 4.5 Daze Dabble Low High 1,791 6 30 297 165 1/8/2023 10/13/2023 3.1 19000 0.9 22000 6.6 9.0 13.6 $34.00 $11.74 $11.04 11.3 $45.00 $17.37 $10.67 30% 38% 100% 33% 4.2 3.2 1,200 199% 600 133% Eat East Low High 1,336 473 456 2 3 7/14/2023 /15/2023 2.4 16500 6.4 0.8 170006.2 13.7 $28.60 $10.69 $8.18 12.8 $34.00 $11.62 $10.60 31% 33% 100% 100% 5.6 4.0 1.050 199% 500 158% Fast Feast High High 738 422 371 1 10/7/2023 5/21/2023 1.5 22000 0.6 22000 9.3 8.9 10.4 $44.00 $18.58 $11.12 10.9 $44.00 $17.67 $10.38 31% 35% 100% 100% 4.0 4.0 550 198% 600 121% FOUNDATION FAST TRACK Page 4 lob Foundation Low Tech Market Segment Analysis FastTrack F115130_015 December 31, 2023 Accessibility F115130_015 Low Tech Low Tech Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 6,708 6,708 64.3% Andrews Baldwin Chester Digby Next Year's Segment Growth Rate 10.0% Erie Ferris Low Tech Customer Buying Criteria Expectations Importance 1. Price $15.00 - 35.00 41% 2. Age Ideal Age = 3.0 29% Reliability MTBF 14000-20000 21% 4. Ideal Position Pfmn 6.3 Size 13.7 Perceptual Map for Low Tech Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% 9% Actual vs Potential Market Share 2023 F115130_015 Low Tech 25% 20% 15% 10% 5% Andrews Baldwin Chester Digby Erie Femis Actual Potential 0 1 2 3 4 5 6 7 8 9 Performande 10 11 12 13 14 15 16 17 18 19 20 Top Products in Low Tech Segment Units Dec. Cust. Survey 28 26 Eat Market Sold to Revision Stock Name Share Seg Date Out Baker 25% 1.687 3/8/2022 Daze 23% 1,515 1/8/2023 Cake 23% 1,510 7/21/2023 18% 1,188 7/14/2023 Able 5% 329 7/1/2023 YES East 3% 230 3/15/2023 Cent 2% 5/5/2023 YES Bold 2% 101 9/2/2023 Fast 0% 10/7/2023 FOUNDATION FAST TRACK Pfmn Size Coord Coord 6.5 14.1 6.6 13.6 5.8 13.4 6.4 13.7 6.3 13.7 6.2 12.8 6.8 12.3 8.1 10.9 9.3 10.4 Cust. List Age Promo Aware- Price MTBF Dec.31 Budget ness $33.40 19800 3.13 $1,350 84% $34.00 19000 3.07 $1,450 90% $26.20 17000 2.35 $1.025 60% $28.60 16500 2.36 $875 53% $25.00 15000 1.73 $2,000100% $34.00 17000 0.80 $875 42% $39.20 20000 0.65 $1,025 47% $42.35 22400 0.98 $1,350 54% $44.00 22000 1.45 $1,500 93% Cust. Sales Access Budgetibility $1,350 47% $1,450 46% $1,025 42% $875 37% $2,000 62% $875 37% $1,025 42% $1,350 47% $1,275 19% 122 26 Page 5 Top High Tech Market Segment Analysis Fast Track F115130_015 01 Round: 3 Dec December 31, 2023 Accessibility F115130_015 High Tech High Tech Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 3,732 3,732 35.8% Next Year's Segment Growth Rate 20.0% Andrews Baldwin Chester Digby Erie Ferris High Tech Customer Buying Criteria Expectations Importance 1. Ideal Position Pfmn 9.5 Size 10.5 33% 2. Age Ideal Age = 0.0 29% 3. Price $25.00 - 45.00 25% 4. Reliability MTBF 17000-23000 13% 0% 20% 40% 60% 80% 100% Perceptual Map for High Tech Segment Perceptual map (at end of this year) Actual vs Potential Market Share 2023 F115130_015 High Tech Andrews Chester Baldwin Digby Ene Ferris Actual Potential 0 1 2 3 4 5 6 7 8 9 10 12 14 16 18 Top Products in High Tech Segment Dec Cust Survey 30 26 Units Market Sold to Revision Stock Name Share Seg Date Out Fast 19% 713 10/7/2023 Dabble 17% 630 10/13/2023 Bold 16% 588 9/2/2023 Feast 11% 421 5/21/2023 Daze 7% 276 1/8/2023 Baker 7% 258 3/8/2022 East 7% 243 3/15/2023 Cent 5% 195 5/5/2023 YES Cake 5% 194 7/21/2023 Eat 4% 148 7/14/2023 Able 2% 66 7/1/2023 YES FOUNDATION FAST TRACK Pfmn Size Coord Coord 9.3 10.4 9.0 11.3 8.1 10.9 8.9 10.9 6.6 13.6 6.5 14.1 6.2 12.8 6.8 12.3 5.8 13.4 6.4 13.7 6.3 13.7 Cust. List Age Promo Aware- Price MTBF Dec.31 Budget ness $44.00 22000 1.45 $1,500 93% $45.00 22000 0.93 $1,450 61% $42.35 22400 0.98 $1,350 54% $44.00 22000 0.61 $1,000 46% $34.00 19000 3.07 $1,450 90% $33.40 19800 3.13 $1,350 84% $34.00 17000 0.80 $875 42% $39.20 20000 0.65 $1,025 47% $26.20 17000 2.35 $1,025 60% $28.60 16500 2.36 $875 53% $25.00 15000 1.73 $2,000 100% Cust. Sales Access- Budgetibility $1,275 54% $1,450 66% $1.350 61% $1,275 54% $1,450 66% $1,350 61% $875 34% $1,025 40% $1,025 40% $875 34% $2.000 75% Page 6 Market Share Report FastTrack Round. 3 F115130_015 December 31, 2023 Market Share F115130_015 Units Sold vs Demand Chart F115130_015 6,000 5,000 30% 25% 20% 15% 10% 4,000 3,000 2,000 1.000 Andrews Chester Baldwin Digby Erie Femis Low Industry Unit Sales High Total Unit Demand Low High Actual Market Share in Units Low High Industry Unit 6,708 3,732 Sales % of Market 64.3% 35.8% Total 10,441 100.0% Potential Market Share in Units Low High Units Pemanded 6,708 3,732 % of 64.3% 35.8% Market Total 10,441 100.0% 4.9% Able Total 4.9% 1.8% 1.8% 3.8% 3.8% Able 22.8% 22.8% 8.2% 8.2% 17.6% 17.6% Total Baker Bold Total 25.1% 1.5% 26.7% 6.9% 15.8% 22.7% 18.6% 6.6% 25.2% Baker Bold Total 20.2% 1.3% 21.5% 6.1% 15.1% 21.1% 15.2% 6.2% 21.4% Cake Cent Total 22.5% 1.8% 24.3% 5.2% 5.2% 10.4% 16.3% 3.0% 19.4% Cake Cent Total 18.2% 2.0% 20.2% 4.6% 5.7% 10.4% 13.4% 3.3% 16.7% 22.6% Paze abble Total 7.4% 16.9% 24.3% 17.1% 6.0% 23.2% 18.0% 22.6% Paze Pabble Total 6.4% 15.4% 21.8% 13.9% 5.5% 19.4% 18.1% Sat East Total 17.7% 3.4% 21.1% 4.0% 6.5% 10.5% 12.8% 4.5% 17.3% Eat East 14.1% 3.0% 17.1% 3.5% 6.2% 9.6% 10.3% 4.1% 14.4% Total Fast Feast Total 0.4% 0.0% 0.4% 19.1% 11.3% 30.4% 7.1% 4.0% 11.1% 0.3% Fast Feast Total 16.8% 12.1% 28.9% 0.3% 6.2% 4.3% 10.5% Page 7 FOUNDATION FAST TRACK Perceptual Map FastTrack F115130_015 Round: 3 December 31, 2023 Perceptual Map for All Segments Perceptual map (at end of this year) A Laro A3 Baker CalDate East Cent Dabble Borceast Fast 0 1 2 3 4 5 6 7 8 9 Performance 10 11 12 13 14 15 16 17 18 19 20 Name Baldwin Pfmn Size 6.5 14.1 8.1 10.9 Andrews Pfmn Size 6.3 13.7 3.0 17.0 8.9 11.1 10.4 15.3 9.8 Able Chester Pfmn Size 5.8 13.4 6.8 12.3 Revised Name 3/8/2022 Cake 9/2/2023 Cent Revised 7/21/2023 5/5/2023 A_Laro A2 Revised Name 7/1/2023 Baker 4/4/2026 Bold 5/23/2025 7/13/2025 6/17/2025 14 4.5 Digby Name Pfmn Size Daze 6.6 13.6 Dabble 9.0 11.3 FOUNDATION FAST TRACK Revised Name 1/8/2023 Eat 10/13/2023 East Erie Pfmn Size 6.4 13.7 6.2 12.8 Revised Name 7/14/2023 Fast 3/15/2023 Feast Ferris Pfmn Size 9.3 10.4 8.9 10.9 Revised 10/7/2023 5/21/2023 Page 8 Top HR/TQM Report Fasttrack F115130_015 Round: 3 December 31, 2023 HUMAN RESOURCES SUMMARY Digby Ferris Andrews 101 Baldwin 495 495 Chester 292 Erie 319 268 292 Needed Complement Complement 1st Shift Complement 2nd Shift Complement 525 525 300 319 50 261 234 146 146 160 160 224 0.0% 100.0% 19.6% 0.0% 8.6% 144 0.0% 8.6% 151 8.4% 0.0% 8.6% 120 0.0% 8.2% 66 Overtime% Turnover Rate New Employees Separated Employees Recruiting Spend Training Hours Productivity Index 0 0 0 SO $2,000 $1,500 $2,500 $3,000 10 40 $2,000 30 102.4% 100.0% 102.3% 102.6% 102.4% 105.6% $10 $165 $452 $418 $88 $431 SO $0 SO $0 $66 Recruiting Cost Separation Cost Training Cost Total HR Admin Cost $10 $297 $315 $234 $399 $23 $224 $642 $214 $369 $728 $766 Strike Days TQM SUMMARY Baldwin Chester Andrews Digby Ferris Process Mgt Budgets Last Year CPI Systems Vendor/JIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs Cumulative Impacts Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction Admin Costs Demand Increase FOUNDATION FAST TRACK 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Page 9 Top FastTrack foundation Ethics Report F115130_015 December 31, 2023 Other (Fees, Writeoffs, etc.) Demand Factor Material Cost Impact Admin Cost Impact Productivity Impact Awareness Impact Accessibility Impact ETHICS SUMMARY The actual dollar impact. Example, $120 means Other increased by $120. The % of normal. 98% means demand fell 2%. The % of normal. 104% means matieral costs rose 4%. The % of normal. 103% means admin costs rose 3%. The % of normal. 104% means productivity increased by 4%. The % of normal. 105% means normal awareness was multiplied by 1.05. The % of normal. 98% means normal accessiblity was multiplied by 0.98. Normal means the value that would have been produced if the problem had not been presented. No Impact Andrews Baldwin Chester Digby Erie Ferris SO SO SO $0 100% 100% Total Other (Fees, Writeoffs, etc.) Demand Factor Material Cost Impact Admin Cost Impact Productivity Impact Awareness Impact Accessibility Impact FOUNDATION FAST TRACK SO 100% 100% 100% 100% 100% 100% SO 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% SO 100% 100% 100% 100% 100% 100% Page 10 Round: 3 Foundation FastTrack F115130_015 F15130_015 Dec. 31, 2023 Baldwin Chester Andrews Rashid Laroussi Digby Erie 76% 1.10 8.4% Ferris 7.3% 121 8.9% 19 20 20 16.7% Selected Financial Statistics Baldwin Chester Digby 11.7% 5.5% 10.8% 149 102 143 17.5% 56% 15.5% 2.0 1.9 33.1% 11.4% 30.2% SO $94, 159,695 $57,078,805 $89,268,300 $19,876,678 $7,652,605 $17,800,336 $11,042,234 $3,112,873 $9,661,011 $22.404,369 $12,280,097 $23,600,289 8.7% 11 004 98% 32 7% 30 7% 32 5% ROS Asset Turnover ROA Leverage (Assets Equity) ROE Emergency Loan Sales EBIT Profits Cumulative Profit SG&A / Sales Contrib. Margin % 18.0% Andrews 0.0% 0 55 -970% -0.8 -77.5% $30.014.080 $9.857.491 (S20.643,683) (517,539,113) ($34.491,708) 214.8% 17 0% SO SO $54,292,207 $8,814,490 S4,146,811 $12,620,981 10.5% 31.9% $51,051,094 $7,796,564 $3,741,295 $14,399,870 14 496 32 49 Percent of Sales F115130_015 $ Market Share F115130_015 100% Profit O Other O SGA Depr O Var Costs Andrews Baldwin Chester Digby Erie Ferris 2.77% 26.47% 16.05% 25.1% 15.26 % 14.35% -20% -40% Andrews Chester Digby Erie Ferris FOUNDATION FAST TRACK Page 1 Top Round: 3 Stocks & Bonds Fast Track F115130_015 December 31, 2023 PIE $2 Company Andrews Baldwin Chester Digby Close $1.00 $37.17 $19.58 $37.96 S20.81 $20.52 Change $0.00 $14.98 $1.412 $11.03 $3.74 (0.31) Stock Market Summary MarketCap Book Value Shares $M] Per Share 2.412.590 $938) 2.160,718 S80 $15.43 295.575 S45 $11.92 2.101,493 S80 $15.23 2.187,343 S46 S11.38 2,055,109 S42 $10.09 EPS ($7.27) $5.11 $1.36 S4.60 $1.90 $1.82 Dividend $0.00 $0.71 $0.00 $164 $0.24 SO 87 Yleld 0.0% 1.9% 0.0% 4.3% 1.2% 0.1 7.3 14.4 8.3 11.0 11.3 Erie Ferris Closing Stock Price F115130_015 Andrews Baldwin Chester Digby Erie Ferris 2021 2022 2023 2024 2025 2026 2027 Bond Market Summary Company Series# Face Yield Close$ S&P Andrews 12.0S2024 13.0S2026 10.082031 13.352033 $1,494,948 $2,600,000 $1,890,000 $1,439,000 12.1% 13.1% 11.9% 13.3% 98.85 99.30 84.33 100.00 DDD DDD DDD DDD Baldwin 12.082024 13.0S2026 10.082031 10.9S2032 11.1S2033 $1,733,333 $2,600,000 $2,480,000 $3,916,739 $1,063,876 11.9% 12.4% 10.5% 10.9% 11.0% 100.99 105.14 95.35 100.00 101.18 Chester 12.0S2024 13.082026 10.0S2031 10.752032 11.352033 $1,733.333 $2,600,000 $2,361,878 $4,464,959 $4,987,824 11.9% 12.5% 10.8% 11.1% 11.4% 100.54 103.88 92.90 96.18 99.42 Digby 12.0S2024 13.0S2026 10.082031 10.752032 $1,467,106 $2,600,000 $2,287,212 $3,702,476 11.9% 12.4% 10.6% 10.9% 100.81 104.64 94.36 97.79 Erie 12.0S2024 13.0S2026 10.082031 10.8S2032 11.252033 $1,733,333 $2,600,000 $2,361,878 $4,374,475 $1,811,820 11.9% 12.5% 10.7% 11.0% 11.2% 100.72 104.38 93.87 97.80 100.00 Ferris 12.0S2024 13.082026 10.082031 10.9S2032 $1,482,266 $2,600,000 $420,545 $2,156,844 11.9% 12.5% 10.8% 11.2% 100.54 103.88 92.90 97.27 Next Year's Prime Rate 7.00% FOUNDATION FAST TRACK Page 21 Top Fasttrack Financial Summary F115130_015 Round: 3 December 31, 2023 Andrews Baldwin Chester Digby Erie Ferris ($17,539) $11,042 $3,113 $9,661 $4,147 $3,741 $1,056 $2,614 $3,237 $2,511 $2,721 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 $1,593 ($229) $0 $0 $0 $4 $0 $297 ($4,520) $79 ($20,627) $1,281 ($4,495) ($1,825) $8,617 $624 ($3,319) ($788) $2,866 $262 ($11,395) ($847) $197 $916 ($8,651) (5866) ($1,732) $203 ($10,136) $441 ($4,388) ($4,240) ($7,740) ($15,528) ($5,520) ($8,660) ($1,400) $0 ($1,536) $0 $0 ($1,785) $0 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 $2,704 $0 $4,988 $0 ($528) $0 $0 $1,812 $0 $1,064 ($3,454) $0 $0 $0 ($270) ($9,511) $15,412 $0 $402 $0 $1,439 $0 ($9,266) $2,278 $30,014 $0 $0 $0 ($7,586) $12,401 $0 ($8,091) $9,518 $0 ($7,458) $8,643 $0 ($253) ($9,888) $11,190 $0 Net cash from financing activities $24,867 $4,344 $9,119 $2,177 $2,469 ($735) Net change in cash position Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets Andrews $0 $810 $4,812 $5,622 $5,221 Baldwin $22,200 $7,739 $4,495 $34,434 ($3.542) Chester $10,675 $4,691 $3,319 $18,685 ($3,147) Digby $16,376 $7,337 $11,395 $35,108 ($7,923) Erie $5,946 $4,462 $8,651 $19,060 ($6,523) Ferris $9,130 $4,196 $10,686 $24,013 Plant and equipment Accumulated Depreciation Total Fixed Assets $15,840 ($3,376) $12,464 $39,204 ($10,575) $28,629 $48,548 ($11,306) $37,242 $37,660 ($10,473) $27,187 $40,820 ($10,652) $30,168 $23,900 ($5,762) $18,138 Total Assets $18,086 $63,063 $55.927 $62,294 $49,228 $42, 151 Accounts Payable Current Debt Total Current Liabilities $996 $32,292 $33,288 $5,536 $12,401 $17,937 $2,909 $9,518 $12,427 $4,812 $15,412 $20,224 $2.809 $8,643 $11,452 $3.566 $11,190 $14,756 Long Term Debt Total Liabilities $7,424 $40,712 $11,794 $29,731 $16.148 $28,574 $10,057 $30,281 $12,882 $24,334 $6,660 $21,416 Common Stock Retained Earnings Total Equity $3,978 ($26,604) ($22,626) $4,427 $28.905 $33,332 $7,035 $20,317 $27,352 $3,830 $28,183 $32,013 $4,765 $20,130 $24,894 $3,277 $17,457 $20,734 Total Liabilities & Owners' Equity $18,086 $63,063 $55,927 $62,294 $49,228 $42,151 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 FOUNDATION FAST TRACK Andrews $9,857 $8,177 $1,680 $1,056 $21,176 $92 ($20,644) $6,340 ($9,444) $0 ($17,539) Baldwin $94,160 $63,396 $30,764 $2,614 $8,220 $53 $19,877 $2,542 $6.067 $225 $11,042 Chester $57,079 $39,544 $17,535 $3,237 $6,261 $385 $7,653 $2,766 $1,710 $64 $3,113 Digby $89,268 $60.231 $29,037 $2,511 $8,718 $8 $17,800 $2,634 $5,308 $197 $9,661 Erie $54,292 $36.965 $17,327 $2,721 $5,701 $91 $8,814 $2,305 $2,278 $85 $4,147 Ferris $51,051 $34,535 $16,516 $1,593 $7,351 ($226) $7,797 $1,923 $2,056 $76 $3,741 Page 3 Top foundation Production Analysis Fasttrack F115130_015 Round: 3 December Bounda; Production vs Capacity F115130_015 Andrews Baldwin Chester Digby Erie Ferris 0 200 400 600 800 2,400 2,600 2,800 1,000 1,200 Capacity 1,400 1,600 1,800 2,000 2,200 Production Production Information Unit Primary Units Inven Pfmn Size Name Segment Sold tory Revision Date Dec.31 MTBF Coord Coord 2nd Auto Shift & mation Capacity Material Labor Contr. Over- Next Next Plant Price Cost Cost Marg. time Round Round Utiliz. Low 394 Able A_Laro 0 422 3.2 3.0 A2 0 7 /1/2023 4/4/2026 5/23/2025 7/13/2025 6/17/2025 1.7 15000 1.1 14000 1.3 23000 1.0 27000 1.2 20000 6.3 3.0 8.9 10.4 4.5 13.7 $25.00 $10.14 $8.95 17.0 $30.00 $5.21 $6.71 11.1 $22.00 $0.00 $0.00 15.3 $35.00 $0.00 $0.00 9.8 $28.00 $0.00 $0.00 23% 0% 0% 0% 0% 100% 100% 0% 0% 0% 2.5 200 200 0 0 0 197% 197% 0% 0% 0% A3 Oo 3.1 2. A4 0 0 Baker Bold Low High 1,945 690 134 53 3/8/2022 9/2/2023 3.1 198006.5 1.0 22400 8.1 14.1 $33.40 10.9 $42.35 $11.41 $10.64 $17.03 $10.98 32% 35% 100% 67% 4.5 4.0 1,200 500 198% 166% 7.0 Cake Cent Low High 1,704 317 179 0 7/21/2023 5/5/2023 2.4 17000 0.7 20000 5.8 6.8 13.4 $26.20 $10.59 $7.89 12.3 $39.20 $13.60 $9.86 28% 39% 100% 100% 1,150 414 199% 130% 4.5 Daze Dabble Low High 1,791 6 30 297 165 1/8/2023 10/13/2023 3.1 19000 0.9 22000 6.6 9.0 13.6 $34.00 $11.74 $11.04 11.3 $45.00 $17.37 $10.67 30% 38% 100% 33% 4.2 3.2 1,200 199% 600 133% Eat East Low High 1,336 473 456 2 3 7/14/2023 /15/2023 2.4 16500 6.4 0.8 170006.2 13.7 $28.60 $10.69 $8.18 12.8 $34.00 $11.62 $10.60 31% 33% 100% 100% 5.6 4.0 1.050 199% 500 158% Fast Feast High High 738 422 371 1 10/7/2023 5/21/2023 1.5 22000 0.6 22000 9.3 8.9 10.4 $44.00 $18.58 $11.12 10.9 $44.00 $17.67 $10.38 31% 35% 100% 100% 4.0 4.0 550 198% 600 121% FOUNDATION FAST TRACK Page 4 lob Foundation Low Tech Market Segment Analysis FastTrack F115130_015 December 31, 2023 Accessibility F115130_015 Low Tech Low Tech Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 6,708 6,708 64.3% Andrews Baldwin Chester Digby Next Year's Segment Growth Rate 10.0% Erie Ferris Low Tech Customer Buying Criteria Expectations Importance 1. Price $15.00 - 35.00 41% 2. Age Ideal Age = 3.0 29% Reliability MTBF 14000-20000 21% 4. Ideal Position Pfmn 6.3 Size 13.7 Perceptual Map for Low Tech Segment Perceptual map (at end of this year) 0% 20% 40% 60% 80% 100% 9% Actual vs Potential Market Share 2023 F115130_015 Low Tech 25% 20% 15% 10% 5% Andrews Baldwin Chester Digby Erie Femis Actual Potential 0 1 2 3 4 5 6 7 8 9 Performande 10 11 12 13 14 15 16 17 18 19 20 Top Products in Low Tech Segment Units Dec. Cust. Survey 28 26 Eat Market Sold to Revision Stock Name Share Seg Date Out Baker 25% 1.687 3/8/2022 Daze 23% 1,515 1/8/2023 Cake 23% 1,510 7/21/2023 18% 1,188 7/14/2023 Able 5% 329 7/1/2023 YES East 3% 230 3/15/2023 Cent 2% 5/5/2023 YES Bold 2% 101 9/2/2023 Fast 0% 10/7/2023 FOUNDATION FAST TRACK Pfmn Size Coord Coord 6.5 14.1 6.6 13.6 5.8 13.4 6.4 13.7 6.3 13.7 6.2 12.8 6.8 12.3 8.1 10.9 9.3 10.4 Cust. List Age Promo Aware- Price MTBF Dec.31 Budget ness $33.40 19800 3.13 $1,350 84% $34.00 19000 3.07 $1,450 90% $26.20 17000 2.35 $1.025 60% $28.60 16500 2.36 $875 53% $25.00 15000 1.73 $2,000100% $34.00 17000 0.80 $875 42% $39.20 20000 0.65 $1,025 47% $42.35 22400 0.98 $1,350 54% $44.00 22000 1.45 $1,500 93% Cust. Sales Access Budgetibility $1,350 47% $1,450 46% $1,025 42% $875 37% $2,000 62% $875 37% $1,025 42% $1,350 47% $1,275 19% 122 26 Page 5 Top High Tech Market Segment Analysis Fast Track F115130_015 01 Round: 3 Dec December 31, 2023 Accessibility F115130_015 High Tech High Tech Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 3,732 3,732 35.8% Next Year's Segment Growth Rate 20.0% Andrews Baldwin Chester Digby Erie Ferris High Tech Customer Buying Criteria Expectations Importance 1. Ideal Position Pfmn 9.5 Size 10.5 33% 2. Age Ideal Age = 0.0 29% 3. Price $25.00 - 45.00 25% 4. Reliability MTBF 17000-23000 13% 0% 20% 40% 60% 80% 100% Perceptual Map for High Tech Segment Perceptual map (at end of this year) Actual vs Potential Market Share 2023 F115130_015 High Tech Andrews Chester Baldwin Digby Ene Ferris Actual Potential 0 1 2 3 4 5 6 7 8 9 10 12 14 16 18 Top Products in High Tech Segment Dec Cust Survey 30 26 Units Market Sold to Revision Stock Name Share Seg Date Out Fast 19% 713 10/7/2023 Dabble 17% 630 10/13/2023 Bold 16% 588 9/2/2023 Feast 11% 421 5/21/2023 Daze 7% 276 1/8/2023 Baker 7% 258 3/8/2022 East 7% 243 3/15/2023 Cent 5% 195 5/5/2023 YES Cake 5% 194 7/21/2023 Eat 4% 148 7/14/2023 Able 2% 66 7/1/2023 YES FOUNDATION FAST TRACK Pfmn Size Coord Coord 9.3 10.4 9.0 11.3 8.1 10.9 8.9 10.9 6.6 13.6 6.5 14.1 6.2 12.8 6.8 12.3 5.8 13.4 6.4 13.7 6.3 13.7 Cust. List Age Promo Aware- Price MTBF Dec.31 Budget ness $44.00 22000 1.45 $1,500 93% $45.00 22000 0.93 $1,450 61% $42.35 22400 0.98 $1,350 54% $44.00 22000 0.61 $1,000 46% $34.00 19000 3.07 $1,450 90% $33.40 19800 3.13 $1,350 84% $34.00 17000 0.80 $875 42% $39.20 20000 0.65 $1,025 47% $26.20 17000 2.35 $1,025 60% $28.60 16500 2.36 $875 53% $25.00 15000 1.73 $2,000 100% Cust. Sales Access- Budgetibility $1,275 54% $1,450 66% $1.350 61% $1,275 54% $1,450 66% $1,350 61% $875 34% $1,025 40% $1,025 40% $875 34% $2.000 75% Page 6 Market Share Report FastTrack Round. 3 F115130_015 December 31, 2023 Market Share F115130_015 Units Sold vs Demand Chart F115130_015 6,000 5,000 30% 25% 20% 15% 10% 4,000 3,000 2,000 1.000 Andrews Chester Baldwin Digby Erie Femis Low Industry Unit Sales High Total Unit Demand Low High Actual Market Share in Units Low High Industry Unit 6,708 3,732 Sales % of Market 64.3% 35.8% Total 10,441 100.0% Potential Market Share in Units Low High Units Pemanded 6,708 3,732 % of 64.3% 35.8% Market Total 10,441 100.0% 4.9% Able Total 4.9% 1.8% 1.8% 3.8% 3.8% Able 22.8% 22.8% 8.2% 8.2% 17.6% 17.6% Total Baker Bold Total 25.1% 1.5% 26.7% 6.9% 15.8% 22.7% 18.6% 6.6% 25.2% Baker Bold Total 20.2% 1.3% 21.5% 6.1% 15.1% 21.1% 15.2% 6.2% 21.4% Cake Cent Total 22.5% 1.8% 24.3% 5.2% 5.2% 10.4% 16.3% 3.0% 19.4% Cake Cent Total 18.2% 2.0% 20.2% 4.6% 5.7% 10.4% 13.4% 3.3% 16.7% 22.6% Paze abble Total 7.4% 16.9% 24.3% 17.1% 6.0% 23.2% 18.0% 22.6% Paze Pabble Total 6.4% 15.4% 21.8% 13.9% 5.5% 19.4% 18.1% Sat East Total 17.7% 3.4% 21.1% 4.0% 6.5% 10.5% 12.8% 4.5% 17.3% Eat East 14.1% 3.0% 17.1% 3.5% 6.2% 9.6% 10.3% 4.1% 14.4% Total Fast Feast Total 0.4% 0.0% 0.4% 19.1% 11.3% 30.4% 7.1% 4.0% 11.1% 0.3% Fast Feast Total 16.8% 12.1% 28.9% 0.3% 6.2% 4.3% 10.5% Page 7 FOUNDATION FAST TRACK Perceptual Map FastTrack F115130_015 Round: 3 December 31, 2023 Perceptual Map for All Segments Perceptual map (at end of this year) A Laro A3 Baker CalDate East Cent Dabble Borceast Fast 0 1 2 3 4 5 6 7 8 9 Performance 10 11 12 13 14 15 16 17 18 19 20 Name Baldwin Pfmn Size 6.5 14.1 8.1 10.9 Andrews Pfmn Size 6.3 13.7 3.0 17.0 8.9 11.1 10.4 15.3 9.8 Able Chester Pfmn Size 5.8 13.4 6.8 12.3 Revised Name 3/8/2022 Cake 9/2/2023 Cent Revised 7/21/2023 5/5/2023 A_Laro A2 Revised Name 7/1/2023 Baker 4/4/2026 Bold 5/23/2025 7/13/2025 6/17/2025 14 4.5 Digby Name Pfmn Size Daze 6.6 13.6 Dabble 9.0 11.3 FOUNDATION FAST TRACK Revised Name 1/8/2023 Eat 10/13/2023 East Erie Pfmn Size 6.4 13.7 6.2 12.8 Revised Name 7/14/2023 Fast 3/15/2023 Feast Ferris Pfmn Size 9.3 10.4 8.9 10.9 Revised 10/7/2023 5/21/2023 Page 8 Top HR/TQM Report Fasttrack F115130_015 Round: 3 December 31, 2023 HUMAN RESOURCES SUMMARY Digby Ferris Andrews 101 Baldwin 495 495 Chester 292 Erie 319 268 292 Needed Complement Complement 1st Shift Complement 2nd Shift Complement 525 525 300 319 50 261 234 146 146 160 160 224 0.0% 100.0% 19.6% 0.0% 8.6% 144 0.0% 8.6% 151 8.4% 0.0% 8.6% 120 0.0% 8.2% 66 Overtime% Turnover Rate New Employees Separated Employees Recruiting Spend Training Hours Productivity Index 0 0 0 SO $2,000 $1,500 $2,500 $3,000 10 40 $2,000 30 102.4% 100.0% 102.3% 102.6% 102.4% 105.6% $10 $165 $452 $418 $88 $431 SO $0 SO $0 $66 Recruiting Cost Separation Cost Training Cost Total HR Admin Cost $10 $297 $315 $234 $399 $23 $224 $642 $214 $369 $728 $766 Strike Days TQM SUMMARY Baldwin Chester Andrews Digby Ferris Process Mgt Budgets Last Year CPI Systems Vendor/JIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs Cumulative Impacts Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction Admin Costs Demand Increase FOUNDATION FAST TRACK 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Page 9 Top FastTrack foundation Ethics Report F115130_015 December 31, 2023 Other (Fees, Writeoffs, etc.) Demand Factor Material Cost Impact Admin Cost Impact Productivity Impact Awareness Impact Accessibility Impact ETHICS SUMMARY The actual dollar impact. Example, $120 means Other increased by $120. The % of normal. 98% means demand fell 2%. The % of normal. 104% means matieral costs rose 4%. The % of normal. 103% means admin costs rose 3%. The % of normal. 104% means productivity increased by 4%. The % of normal. 105% means normal awareness was multiplied by 1.05. The % of normal. 98% means normal accessiblity was multiplied by 0.98. Normal means the value that would have been produced if the problem had not been presented. No Impact Andrews Baldwin Chester Digby Erie Ferris SO SO SO $0 100% 100% Total Other (Fees, Writeoffs, etc.) Demand Factor Material Cost Impact Admin Cost Impact Productivity Impact Awareness Impact Accessibility Impact FOUNDATION FAST TRACK SO 100% 100% 100% 100% 100% 100% SO 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% SO 100% 100% 100% 100% 100% 100% Page 10

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions