Capsim Performance/Assessment Report 2Only complete two sections, these are highlighted. I have attached the performance for Andrews Teams for years 1-4. Andrews has two products, Able and Asher. P
Round: 3 Dec. 31, 2021 F95459 Andrews Baldwin Chester Digby Erie Ferris Selected Financial Statistics Andrews Baldwin Chester DigbyErieFerris ROS 12.0%4.4%10.4% 3.8%11.5% 4.5% Asset Turnover 1.85 0.91 1.52 1.20 1.25 1.00 ROA 22.2%4.0%15.7% 4.6%14.4% 4.5% Leverage 1.6 1.6 1.7 2.1 1.3 2.0 ROE 35.0%6.6%27.0% 9.5%18.1% 9.0% Emergency Loan $0$0$0 $1,134,868 $0$0 Sales $129,141,664 $54,324,114 $94,005,889 $38,540,261 $41,694,146 $42,712,836 EBIT $26,206,887 $5,833,881 $17,442,234 $3,946,579 $8,071,818 $5,053,168 Profits $15,527,759 $2,416,702 $9,731,510 $1,482,512 $4,793,946 $1,905,497 Cumulative Profit $29,978,795 $18,282,144 $23,245,004 $876,196 $16,102,558 $12,862,136 SG&A / Sales 8.4%17.5% 15.9%19.5% 6.4%17.3% Contrib. Margin % 32.2%37.8%38.1%33.9%28.0%34.0%FOUNDATION ® FAST TRACK Page 1 Stock & Bonds F95459 Round: 3 Dec. 31, 2021 Stock Market Summary Company Close Change Shares MarketCap $M Book Value EPS Dividend
Depreciation $3,887 $4,187 $3,040 $1,440 $960 $1,881 E [traordinary gains/losses/writeoffs $0 $0 $0 $0 $0 $196 Changes in current assets and liablilities Accounts payable $2,559 $1,336 $1,904 $2,457 $80 $549 Inventory $0 $3,825 $2,535 $10,835 $1,482 $7,336 Accounts Receivable $3,999 $369 $2,830 $967 $170 $820 Net cash from operations $17,975 $9,461 $9,311 $4,488 $4,362 $3,082 Cash flows from investing activities Plant improvements net $22,000 $24,600 $11,520 $4,500 $0 $1,792 Cash flows from financing activities Dividends paid $0 $0 $0 $0 $0 $761 Sales of common stock $4,000 $5,000 $0 $0 $0 $0 Purchase of common stock $0 $0 $0 $498 $0 $0 Cash from long term debt issued $10,000 $15,000 $8,886 $2,700 $0 $0 Early retirement of long term debt $0 $0 $0 $0 $0 $0 Retirement of current debt $1,967 $867 $867 $867 $867 $11,073 Cash from current debt borrowing $3,000 $0 $0 $500 $0 $10,082 Cash from emergency loan $0 $0 $0 $1,135 $0 $0 Net cash from financing activities $15,033 $19,133 $8,019 $2,970 $867 $1,752 Net change in cash position $11,009 $3,994 $5,811 $6,018 $3,495 $6,627 Balance Sheet Survey Andrews Baldwin Chester Digby Erie Ferris Cash $13,419 $4,297 $17,125 $0 $21,741 $7,259 Accounts Receivable $10,614 $3,721 $7,727 $3,168 $3,427 $3,511 Inventory $0 $2,004 $2,535 $10,835 $1,482 $10,551 Total Current Assets $24,033 $10,022 $27,386 $14,003 $26,650 $21,321 Plant and equipment $58,310 $62,800 $45,600 $26,100 $14,400 $28,215 Accumulated Depreciation $12,375 $12,803 $11,096 $7,959 $7,680 $6,738 Total Fi [ed Assets $45,935 $49,997 $34,504 $18,141 $6,720 $21,477 Total Assets $69,969 $60,019 $61,890 $32,143 $33,370 $42,798 Accounts Payable $7,197 $2,444 $4,965 $2,878 $2,574 $2,815 Current Debt $3,000 $0 $0 $1,635 $0 $10,082 Long Term Debt $15,433 $20,933 $20,818 $12,013 $4,333 $8,784 Total Liabilities $25,630 $23,377 $25,783 $16,526 $6,907 $21,681 Common Stock $6,323 $10,323 $4,823 $6,957 $2,323 $4,173 Retained Earnings $38,016 $26,319 $31,282 $8,660 $24,139 $16,943 Total Equity $44,339 $36,642 $36,105 $15,617 $26,463 $21,116 Total Liabilities & Owners Equity $69,969 $60,019 $61,890 $32,143 $33,370 $42,798 Income Statement Survey Andrews Baldwin Chester Digby Erie Ferris Sales $129,142 $54,324 $94,006 $38,540 $41,694 $42,713 Variable Costs Labor,Material,Carry $87,558 $33,797 $58,175 $25,483 $30,012 $28,175 Depreciation $3,887 $4,187 $3,040 $1,440 $960 $1,881 SGA R&D,Promo,Sales,Admin $10,790 $9,507 $14,904 $7,528 $2,650 $7,408 Other Fees,Writeoffs,TQM,Bonuses $700 $1,000 $444 $142 $0 $196 EBIT $26,207 $5,834 $17,442 $3,947 $8,072 $5,053 Interest Short term,Long term $1,830 $2,040 $2,165 $1,619 $546 $2,062 Ta [es $8,532 $1,328 $5,347 $815 $2,634 $1,047 Profit Sharing $317 $49 $199 $30 $98 $39 Net Profit $15,528 $2,417 $9,732 $1,483 $4,794 $1,905 FOUNDATION ® FAST TRACK Page 3 Production Analysis F95459 Round: 3 Dec. 31, 2021 Name PrimarySegment UnitsSold UnitInventory Revision Date AgeDec.31 MTBF PfmnCoord SizeCoord Price Material Cost Labor Cost Contr.Marg. 2ndShift& Over-time AutomationNe [tRound Capacity Ne [tRound PlantUtiliz. Able Low 2,772 0 5/18/2021 2.5 21000 6.8 13.2 $36.00 $12.94 $10.51 34% 100% 6.0 1,500 198% Asher Low 743 0 5/23/2021 1.2 21000 7.9 12.0 $39.50 $15.26 $14.02 25% 100% 4.0 605 198% Baker Low 1,277 86 12/24/2021 1.3 20000 9.5 11.5 $38.00 $17.12 $6.17 39% 0% 6.0 1,200 95% B2 +igh 149 0 3/15/2021 0.8 20000 8.5 12.2 $39.00 $15.39 $10.55 32% 88% 5.2 1,000 149% Cake Low 1,399 106 4/13/2021 1.8 22500 7.8 12.6 $40.50 $15.01 $8.28 41% 90% 5.5 850 188% Cars Low 594 0 5/22/2021 1.2 21000 6.2 13.6 $36.50 $11.94 $10.46 38% 100% 5.0 500 198% Cookie +igh 387 0 5/6/2021 0.7 23000 8.4 11.9 $40.50 $16.46 $11.95 29% 100% 4.0 400 129% Daze +igh 923 414 6/26/2021 2.2 23000 8.7 11.5 $41.75 $17.17 $9.09 34% 50% 4.5 900 149% Drake 0 0 4/14/2022 0.0 0 0.0 0.0 $0.00 $0.00 $0.00 0% 0% 1.0 450 0% Eat Low 1,226 61 11/21/2015 6.1 21000 6.4 13.6 $34.00 $12.14 $11.64 28% 63% 3.0 800 161% Fast +igh 624 384 10/7/2021 1.5 22000 9.3 10.4 $44.00 $18.58 $9.81 33% 21% 4.0 746 119% Feast +igh 347 0 5/21/2021 0.6 22000 8.9 10.9 $44.00 $17.67 $10.04 36% 64% 4.0 600 99% FOUNDATION ® FAST TRACK Page 4 Low Tech Segment Analysis F95459 Round: 3 Dec. 31, 2021 Low Tech Statistics Total Industry Unit Demand 6,708 Actual Industry Unit Sales _6,708 Segment % of Total Industry _64.3% Ne [t
Aware- ness Sales Budget Cust.
Access- ibility Dec.
Cust Survey Able 38% 2,549 5/18/2021
Aware- ness Sales Budget Cust.
Access- ibility Dec.
Cust Survey Baker 16% 606 12/24/2021 9.5 11.5 $38.00 20000 1.28 $1,600 100% $1,600 65% 36 Fast 15% 570 10/7/2021 9.3 10.4 $44.00 22000 1.45 $1,500 93% $1,275 54% 33 Daze 15% 555 6/26/2021 8.7 11.5 $41.75 23000 2.20 $1,120 79% $2,850 79% 27 Cake 13% 497 4/13/2021 7.8 12.6 $40.50 22500 1.83 $2,500 100% $1,400 75% 19 Feast 9% 345 5/21/2021
