Hi there,

Currently I got a question about Capsim round 1-3, Can anyone HELP me? The Courier has been uploaded here!

Round: 0 Dec. 31, 2017 C93614_022 Andrews Zhao Yongheng Baldwin Chester Digby Erie Ferris Selected Financial Statistics ROS Asset Turnover ROA Leverage ROE Emergency Loan Sales EBIT Profits Cumulative Profit SG&A / Sales Contrib. Margin % CAPSTONE COURIER Andrews 4.0% 1.05 4.2% 2.0 8.5% $0 $101,073,437 $11,996,365 $4,082,256 $4,082,256 8.9% 28.3% Baldwin 4.0% 1.05 4.2% 2.0 8.5% $0 $101,073,437 $11,996,365 $4,082,256 $4,082,256 8.9% 28.3% Chester 4.0% 1.05 4.2% 2.0 8.5% $0 $101,073,437 $11,996,365 $4,082,256 $4,082,256 8.9% 28.3% Digby 4.0% 1.05 4.2% 2.0 8.5% $0 $101,073,437 $11,996,365 $4,082,256 $4,082,256 8.9% 28.3% Erie 4.0% 1.05 4.2% 2.0 8.5% $0 $101,073,437 $11,996,365 $4,082,256 $4,082,256 8.9% 28.3% Ferris 4.0% 1.05 4.2% 2.0 8.5% $0 $101,073,437 $11,996,365 $4,082,256 $4,082,256 8.9% 28.3% Page 1 Round: 0 C93614_022 Dec. 31, 2017 Stock & Bonds Stock Market Summary Company Close Change Shares Andrews Baldwin Chester Digby Erie Ferris $34.04 $34.04 $34.04 $34.04 $34.04 $34.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 MarketCap ($M) $68 $68 $68 $68 $68 $68 Book Value EPS Dividend Yield P/E $23.92 $23.92 $23.92 $23.92 $23.92 $23.92 $2.04 $2.04 $2.04 $2.04 $2.04 $2.04 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 5.9% 5.9% 5.9% 5.9% 5.9% 5.9% 16.7 16.7 16.7 16.7 16.7 16.7 Bond Market Summary Company Andrews Series# Face Yield Close$ S&P 11.4S2019 $6,950,000 12.9S2021 $13,900,000 14.4S2023 $20,850,000 11.5% 12.4% 13.0% 99.49 103.67 111.20 B B B 11.4S2019 $6,950,000 12.9S2021 $13,900,000 14.4S2023 $20,850,000 11.5% 12.4% 13.0% 99.49 103.67 111.20 B B B 11.4S2019 $6,950,000 12.9S2021 $13,900,000 14.4S2023 $20,850,000 11.5% 12.4% 13.0% 99.49 103.67 111.20 B B B Baldwin Company Digby Series# Face Yield Close$ S&P 11.4S2019 $6,950,000 12.9S2021 $13,900,000 14.4S2023 $20,850,000 11.5% 12.4% 13.0% 99.49 103.67 111.20 B B B 11.4S2019 $6,950,000 12.9S2021 $13,900,000 14.4S2023 $20,850,000 11.5% 12.4% 13.0% 99.49 103.67 111.20 B B B 11.4S2019 $6,950,000 12.9S2021 $13,900,000 14.4S2023 $20,850,000 11.5% 12.4% 13.0% 99.49 103.67 111.20 B B B Erie Chester Ferris Next Year's Prime Rate7.40% CAPSTONE COURIER Page 2 Round: 0 C93614_022 Dec. 31, 2017 Financial Summary Cash Flow Statement Survey CashFlows from operating activities Net Income(Loss) Adjustment for noncash items: Depreciation Extraordinary gains/losses/writeoffs Changes in current assets and liablilities Accounts payable Inventory Accounts Receivable Net cash from operations Andrews Baldwin Chester Digby Erie Ferris $4,082 $4,082 $4,082 $4,082 $4,082 $4,082 $7,587 $0 $7,587 $0 $7,587 $0 $7,587 $0 $7,587 $0 $7,587 $0 $3,583 ($8,617) ($307) $6,327 $3,583 ($8,617) ($307) $6,327 $3,583 ($8,617) ($307) $6,327 $3,583 ($8,617) ($307) $6,327 $3,583 ($8,617) ($307) $6,327 $3,583 ($8,617) ($307) $6,327 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 $0 $0 $0 $0 $0 $0 ($4,000) $0 $0 $0 $0 $0 $0 $0 ($4,000) $0 $0 $0 $0 $0 $0 $0 ($4,000) $0 $0 $0 $0 $0 $0 $0 ($4,000) $0 $0 $0 $0 $0 $0 $0 ($4,000) $0 $0 $0 $0 $0 $0 $0 ($4,000) $0 $0 $0 $0 $0 $0 $0 Net cash from financing activities ($4,000) ($4,000) ($4,000) ($4,000) ($4,000) ($4,000) Net change in cash position Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets $2,327 Andrews $3,327 $8,307 $8,617 $20,252 $2,327 Baldwin $3,327 $8,307 $8,617 $20,252 $2,327 Chester $3,327 $8,307 $8,617 $20,252 $2,327 Digby $3,327 $8,307 $8,617 $20,252 $2,327 Erie $3,327 $8,307 $8,617 $20,252 $2,327 Ferris $3,327 $8,307 $8,617 $20,252 Plant and equipment Accumulated Depreciation Total Fixed Assets $113,800 ($37,933) $75,867 $113,800 ($37,933) $75,867 $113,800 ($37,933) $75,867 $113,800 ($37,933) $75,867 $113,800 ($37,933) $75,867 $113,800 ($37,933) $75,867 Total Assets $96,119 $96,119 $96,119 $96,119 $96,119 $96,119 Accounts Payable Current Debt Long Term Debt Total Liabilities $6,583 $0 $41,700 $48,283 $6,583 $0 $41,700 $48,283 $6,583 $0 $41,700 $48,283 $6,583 $0 $41,700 $48,283 $6,583 $0 $41,700 $48,283 $6,583 $0 $41,700 $48,283 Common Stock Retained Earnings Total Equity $18,360 $29,476 $47,836 $18,360 $29,476 $47,836 $18,360 $29,476 $47,836 $18,360 $29,476 $47,836 $18,360 $29,476 $47,836 $18,360 $29,476 $47,836 Total Liabilities & Owners Equity $96,119 $96,119 $96,119 $96,119 $96,119 $96,119 Andrews $101,073 $72,513 $7,587 $8,978 $0 $11,996 $5,588 $2,243 $83 $4,082 Baldwin $101,073 $72,513 $7,587 $8,978 $0 $11,996 $5,588 $2,243 $83 $4,082 Chester $101,073 $72,513 $7,587 $8,978 $0 $11,996 $5,588 $2,243 $83 $4,082 Digby $101,073 $72,513 $7,587 $8,978 $0 $11,996 $5,588 $2,243 $83 $4,082 Erie $101,073 $72,513 $7,587 $8,978 $0 $11,996 $5,588 $2,243 $83 $4,082 Ferris $101,073 $72,513 $7,587 $8,978 $0 $11,996 $5,588 $2,243 $83 $4,082 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 CAPSTONE COURIER Page 3 Round: 0 C93614_022 Dec. 31, 2017 Production Analysis Price $28.00 $21.00 $38.00 $33.00 $33.00 Material Cost $11.59 $7.81 $15.98 $15.87 $13.62 Labor Cost $7.49 $7.12 $8.57 $8.57 $8.57 Contr. Marg. 29% 27% 33% 23% 30% 2nd Shift & Over time 0% 30% 0% 0% 0% 14.2 16.7 11.7 15.2 10.7 $28.00 $21.00 $38.00 $33.00 $33.00 $11.59 $7.81 $15.98 $15.87 $13.62 $7.49 $7.12 $8.57 $8.57 $8.57 29% 27% 33% 23% 30% 0% 30% 0% 0% 0% 4.0 5.0 3.0 3.0 3.0 1,800 1,400 900 600 600 66% 129% 45% 73% 63% 4.7 2.2 7.2 8.6 3.2 14.2 16.7 11.7 15.2 10.7 $28.00 $21.00 $38.00 $33.00 $33.00 $11.59 $7.81 $15.98 $15.87 $13.62 $7.49 $7.12 $8.57 $8.57 $8.57 29% 27% 33% 23% 30% 0% 30% 0% 0% 0% 4.0 5.0 3.0 3.0 3.0 1,800 1,400 900 600 600 66% 129% 45% 73% 63% 17500 14000 23000 25000 19000 4.7 2.2 7.2 8.6 3.2 14.2 16.7 11.7 15.2 10.7 $28.00 $21.00 $38.00 $33.00 $33.00 $11.59 $7.81 $15.98 $15.87 $13.62 $7.49 $7.12 $8.57 $8.57 $8.57 29% 27% 33% 23% 30% 0% 30% 0% 0% 0% 4.0 5.0 3.0 3.0 3.0 1,800 1,400 900 600 600 66% 129% 45% 73% 63% 3.1 4.6 1.7 2.5 2.6 17500 14000 23000 25000 19000 4.7 2.2 7.2 8.6 3.2 14.2 16.7 11.7 15.2 10.7 $28.00 $21.00 $38.00 $33.00 $33.00 $11.59 $7.81 $15.98 $15.87 $13.62 $7.49 $7.12 $8.57 $8.57 $8.57 29% 27% 33% 23% 30% 0% 30% 0% 0% 0% 4.0 5.0 3.0 3.0 3.0 1,800 1,400 900 600 600 66% 129% 45% 73% 63% 3.1 4.6 1.7 2.5 2.6 17500 14000 23000 25000 19000 4.7 2.2 7.2 8.6 3.2 14.2 16.7 11.7 15.2 10.7 $28.00 $21.00 $38.00 $33.00 $33.00 $11.59 $7.81 $15.98 $15.87 $13.62 $7.49 $7.12 $8.57 $8.57 $8.57 29% 27% 33% 23% 30% 0% 30% 0% 0% 0% 4.0 5.0 3.0 3.0 3.0 1,800 1,400 900 600 600 66% 129% 45% 73% 63% Unit Inven Revision Age tory Date Dec.31 189 11/21/2014 3.1 39 5/25/2013 4.6 40 4/18/2016 1.7 78 6/30/2015 2.5 62 5/25/2015 2.6 Name Able Acre Adam Aft Agape Primary Segment Trad Low High Pfmn Size Units Sold 999 1,763 366 358 314 MTBF 17500 14000 23000 25000 19000 Pfmn Coord 4.7 2.2 7.2 8.6 3.2 Size Coord 14.2 16.7 11.7 15.2 10.7 Baker Bead Bid Bold Buddy Trad Low High Pfmn Size 999 1,763 366 358 314 189 11/21/2014 39 5/25/2013 40 4/18/2016 78 6/30/2015 62 5/25/2015 3.1 4.6 1.7 2.5 2.6 17500 14000 23000 25000 19000 4.7 2.2 7.2 8.6 3.2 Cake Cedar Cid Coat Cure Trad Low High Pfmn Size 999 1,763 366 358 314 189 11/21/2014 39 5/25/2013 40 4/18/2016 78 6/30/2015 62 5/25/2015 3.1 4.6 1.7 2.5 2.6 17500 14000 23000 25000 19000 Daze Dell Dixie Dot Dune Trad Low High Pfmn Size 999 1,763 366 358 314 189 11/21/2014 39 5/25/2013 40 4/18/2016 78 6/30/2015 62 5/25/2015 3.1 4.6 1.7 2.5 2.6 Eat Ebb Echo Edge Egg Trad Low High Pfmn Size 999 1,763 366 358 314 189 11/21/2014 39 5/25/2013 40 4/18/2016 78 6/30/2015 62 5/25/2015 Fast Feat Fist Foam Fume Trad Low High Pfmn Size 999 1,763 366 358 314 189 11/21/2014 39 5/25/2013 40 4/18/2016 78 6/30/2015 62 5/25/2015 CAPSTONE COURIER Auto mation Next Round 4.0 5.0 3.0 3.0 3.0 Capacity Next Round 1,800 1,400 900 600 600 Plant Utiliz. 66% 129% 45% 73% 63% Page 4 Traditional Segment Analysis C93614_022 Round: 0 Dec. 31, 2017 Traditional Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 7,387 |7,387 |32.4% Next Year's Segment Growth Rate |6.3% Traditional Customer Buying Criteria Expectations Ideal Age = 2.0 $20.00 30.00 Pfmn 4.2 Size 14.7 MTBF 1400019000 1. Age 2. Price 3. Ideal Position 4. Reliability Name Able Baker Cake Daze Eat Fast Acre Bead Cedar Dell Ebb Feat Market Share 13% 13% 13% 13% 13% 13% 4% 4% 4% 4% 4% 4% Units Sold to Seg 961 961 961 961 961 961 270 270 270 270 270 270 CAPSTONE COURIER Importance 47% 23% 21% 9% Top Products in Traditional Segment Revision Date 11/21/2014 11/21/2014 11/21/2014 11/21/2014 11/21/2014 11/21/2014 5/25/2013 5/25/2013 5/25/2013 5/25/2013 5/25/2013 5/25/2013 Stock Out Pfmn Coord 4.7 4.7 4.7 4.7 4.7 4.7 2.2 2.2 2.2 2.2 2.2 2.2 Size Coord 14.2 14.2 14.2 14.2 14.2 14.2 16.7 16.7 16.7 16.7 16.7 16.7 Cust. List Age Promo Aware Price MTBF Dec.31 Budget ness $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% $21.00 14000 4.60 $900 52% $21.00 14000 4.60 $900 52% $21.00 14000 4.60 $900 52% $21.00 14000 4.60 $900 52% $21.00 14000 4.60 $900 52% $21.00 14000 4.60 $900 52% Cust. Dec. Sales Access Cust Budget ibility Survey $1,000 54% 18 $1,000 54% 18 $1,000 54% 18 $1,000 54% 18 $1,000 54% 18 $1,000 54% 18 $900 54% 4 $900 54% 4 $900 54% 4 $900 54% 4 $900 54% 4 $900 54% 4 Page 5 Low End Segment Analysis C93614_022 Round: 0 Dec. 31, 2017 Low End Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 8,960 |8,960 |39.3% Next Year's Segment Growth Rate |13.1% Low End Customer Buying Criteria Expectations $15.00 25.00 Ideal Age = 7.0 Pfmn 0.9 Size 18.0 MTBF 1200017000 1. Price 2. Age 3. Ideal Position 4. Reliability Name Acre Bead Cedar Dell Ebb Feat Market Share 17% 17% 17% 17% 17% 17% Units Sold to Seg 1,493 1,493 1,493 1,493 1,493 1,493 CAPSTONE COURIER Importance 53% 24% 16% 7% Top Products in Low End Segment Revision Date 5/25/2013 5/25/2013 5/25/2013 5/25/2013 5/25/2013 5/25/2013 Stock Out Pfmn Coord 2.2 2.2 2.2 2.2 2.2 2.2 Size Coord 16.7 16.7 16.7 16.7 16.7 16.7 Cust. List Age Promo Aware Price MTBF Dec.31 Budget ness $21.00 14000 4.60 $900 52% $21.00 14000 4.60 $900 52% $21.00 14000 4.60 $900 52% $21.00 14000 4.60 $900 52% $21.00 14000 4.60 $900 52% $21.00 14000 4.60 $900 52% Cust. Dec. Sales Access Cust Budget ibility Survey $900 40% 12 $900 40% 12 $900 40% 12 $900 40% 12 $900 40% 12 $900 40% 12 Page 6 High End Segment Analysis C93614_022 Round: 0 Dec. 31, 2017 High End Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 2,554 |2,554 |11.2% Next Year's Segment Growth Rate |19.1% High End Customer Buying Criteria Expectations Pfmn 8.1 Size 10.8 Ideal Age = 0.0 MTBF 2000025000 $30.00 40.00 1. Ideal Position 2. Age 3. Reliability 4. Price Name Adam Bid Cid Dixie Echo Fist Aft Bold Coat Dot Edge Foam Market Share 14% 14% 14% 14% 14% 14% 2% 2% 2% 2% 2% 2% Units Sold to Seg 366 366 366 366 366 366 41 41 41 41 41 41 CAPSTONE COURIER Importance 43% 29% 19% 9% Top Products in High End Segment Revision Date 4/18/2016 4/18/2016 4/18/2016 4/18/2016 4/18/2016 4/18/2016 6/30/2015 6/30/2015 6/30/2015 6/30/2015 6/30/2015 6/30/2015 Stock Out Pfmn Coord 7.2 7.2 7.2 7.2 7.2 7.2 8.6 8.6 8.6 8.6 8.6 8.6 Size Coord 11.7 11.7 11.7 11.7 11.7 11.7 15.2 15.2 15.2 15.2 15.2 15.2 Cust. List Age Promo Aware Price MTBF Dec.31 Budget ness $38.00 23000 1.70 $800 49% $38.00 23000 1.70 $800 49% $38.00 23000 1.70 $800 49% $38.00 23000 1.70 $800 49% $38.00 23000 1.70 $800 49% $38.00 23000 1.70 $800 49% $33.00 25000 2.50 $700 46% $33.00 25000 2.50 $700 46% $33.00 25000 2.50 $700 46% $33.00 25000 2.50 $700 46% $33.00 25000 2.50 $700 46% $33.00 25000 2.50 $700 46% Cust. Dec. Sales Access Cust Budget ibility Survey $800 48% 21 $800 48% 21 $800 48% 21 $800 48% 21 $800 48% 21 $800 48% 21 $700 48% 2 $700 48% 2 $700 48% 2 $700 48% 2 $700 48% 2 $700 48% 2 Page 7 Performance Segment Analysis C93614_022 Round: 0 Dec. 31, 2017 Performance Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 1,915 |1,915 |8.4% Next Year's Segment Growth Rate |16.0% Performance Customer Buying Criteria Expectations MTBF 2200027000 Pfmn 8.6 Size 15.7 $25.00 35.00 Ideal Age = 1.0 1. Reliability 2. Ideal Position 3. Price 4. Age Name Aft Bold Coat Dot Edge Foam Able Baker Cake Daze Eat Fast Market Share 17% 17% 17% 17% 17% 17% 0% 0% 0% 0% 0% 0% Units Sold to Seg 317 317 317 317 317 317 2 2 2 2 2 2 CAPSTONE COURIER Importance 43% 29% 19% 9% Top Products in Performance Segment Revision Date 6/30/2015 6/30/2015 6/30/2015 6/30/2015 6/30/2015 6/30/2015 11/21/2014 11/21/2014 11/21/2014 11/21/2014 11/21/2014 11/21/2014 Stock Out Pfmn Coord 8.6 8.6 8.6 8.6 8.6 8.6 4.7 4.7 4.7 4.7 4.7 4.7 Size Coord 15.2 15.2 15.2 15.2 15.2 15.2 14.2 14.2 14.2 14.2 14.2 14.2 Cust. List Age Promo Aware Price MTBF Dec.31 Budget ness $33.00 25000 2.50 $700 46% $33.00 25000 2.50 $700 46% $33.00 25000 2.50 $700 46% $33.00 25000 2.50 $700 46% $33.00 25000 2.50 $700 46% $33.00 25000 2.50 $700 46% $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% Cust. Dec. Sales Access Cust Budget ibility Survey $700 37% 20 $700 37% 20 $700 37% 20 $700 37% 20 $700 37% 20 $700 37% 20 $1,000 37% 0 $1,000 37% 0 $1,000 37% 0 $1,000 37% 0 $1,000 37% 0 $1,000 37% 0 Page 8 Size Segment Analysis C93614_022 Round: 0 Dec. 31, 2017 Size Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 1,984 |1,984 |8.7% Next Year's Segment Growth Rate |15.0% Size Customer Buying Criteria Expectations Pfmn 3.2 Size 10.3 Ideal Age = 1.5 MTBF 1600021000 $25.00 35.00 1. Ideal Position 2. Age 3. Reliability 4. Price Name Agape Buddy Cure Dune Egg Fume Able Baker Cake Daze Eat Fast Market Share 15% 15% 15% 15% 15% 15% 1% 1% 1% 1% 1% 1% Units Sold to Seg 307 307 307 307 307 307 24 24 24 24 24 24 CAPSTONE COURIER Importance 43% 29% 19% 9% Top Products in Size Segment Revision Date 5/25/2015 5/25/2015 5/25/2015 5/25/2015 5/25/2015 5/25/2015 11/21/2014 11/21/2014 11/21/2014 11/21/2014 11/21/2014 11/21/2014 Stock Out Pfmn Coord 3.2 3.2 3.2 3.2 3.2 3.2 4.7 4.7 4.7 4.7 4.7 4.7 Size Coord 10.7 10.7 10.7 10.7 10.7 10.7 14.2 14.2 14.2 14.2 14.2 14.2 Cust. List Age Promo Aware Price MTBF Dec.31 Budget ness $33.00 19000 2.60 $700 46% $33.00 19000 2.60 $700 46% $33.00 19000 2.60 $700 46% $33.00 19000 2.60 $700 46% $33.00 19000 2.60 $700 46% $33.00 19000 2.60 $700 46% $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% $28.00 17500 3.10 $1,000 55% Cust. Dec. Sales Access Cust Budget ibility Survey $700 42% 27 $700 42% 27 $700 42% 27 $700 42% 27 $700 42% 27 $700 42% 27 $1,000 42% 2 $1,000 42% 2 $1,000 42% 2 $1,000 42% 2 $1,000 42% 2 $1,000 42% 2 Page 9 Round: 0 C93614_022 Dec. 31, 2017 Market Share Actual Market Share in Units Trad 7,387 32.4% Low 8,960 39.3% Able Acre Adam Aft Agape Total 13.0% 3.6% 16.7% 16.7% 16.7% Baker Bead Bid Bold Buddy Total 13.0% 3.6% 16.7% 16.7% 16.7% Cake Cedar Cid Coat Cure Total 13.0% 3.6% 16.7% 16.7% 16.7% Daze Dell Dixie Dot Dune Total 13.0% 3.6% 16.7% 16.7% 16.7% Eat Ebb Echo Edge Egg Total 13.0% 3.6% 16.7% 16.7% 16.7% Fast Feat Fist Foam Fume Total 13.0% 3.6% 16.7% Industry Unit Sales % of Market 16.7% CAPSTONE COURIER 16.7% High 2,554 11.2% Pfmn 1,915 8.4% Size 1,984 8.7% 0.4% 0.1% 1.2% 14.3% 1.6% 0.3% 16.7% 0.4% 14.3% 1.6% 0.3% 16.7% 0.4% 14.3% 1.6% 0.3% 16.7% 0.4% 14.3% 1.6% 0.3% 16.7% 0.4% 14.3% 1.6% 0.3% 16.7% 0.4% 14.3% 1.6% 0.3% 16.7% 16.5% 16.7% 15.5% 16.7% 0.1% 1.2% 16.5% 16.7% 15.5% 16.7% 0.1% 1.2% 16.5% 16.7% 15.5% 16.7% 0.1% 1.2% 16.5% 16.7% 15.5% 16.7% 0.1% 1.2% 16.5% 16.7% 15.5% 16.7% 0.1% 1.2% 16.5% 16.7% 15.5% 16.7% Potential Market Share in Units Total 22,800 Units Demanded 100.0% % of Market Trad 7,387 32.4% Low 8,960 39.3% 4.4% Able 7.7% Acre 1.6% Adam 1.6% Aft 1.4% Agape 16.7% Total 13.0% 3.7% 16.7% 4.4% Baker 7.7% Bead 1.6% Bid 1.6% Bold 1.4% Buddy 16.7% Total 13.0% 3.7% 16.7% 4.4% Cake 7.7% Cedar 1.6% Cid 1.6% Coat 1.4% Cure 16.7% Total 13.0% 3.7% 16.7% 4.4% Daze 7.7% Dell 1.6% Dixie 1.6% Dot 1.4% Dune 16.7% Total 13.0% 3.7% 16.7% 4.4% Eat 7.7% Ebb 1.6% Echo 1.6% Edge 1.4% Egg 16.7% Total 13.0% 3.7% 16.7% 4.4% Fast 7.7% Feat 1.6% Fist 1.6% Foam 1.4% Fume 16.7% Total 13.0% 3.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% High 2,554 11.2% Pfmn 1,915 8.4% 0.5% 14.3% 1.6% 0.3% 16.7% 16.5% 16.7% 0.5% 14.3% 1.6% 0.3% 16.7% 16.5% 16.7% 16.5% 16.7% 16.5% 16.7% 15.5% 16.7% 15.5% 16.7% 15.5% 16.7% 15.5% 16.7% 1.2% 16.5% 16.7% 0.5% 14.3% 1.6% 0.3% 16.7% 4.4% 7.7% 1.6% 1.6% 1.4% 16.7% 1.2% 0.5% 14.3% 1.6% 0.3% 16.7% 1.2% 1.2% 0.5% 14.3% 1.6% 0.3% 16.7% Total 22,800 100.0% 1.2% 0.5% 14.3% 1.6% 0.3% 16.7% Size 1,984 8.7% 15.5% 16.7% 1.2% 16.5% 16.7% 15.5% 16.7% 4.4% 7.7% 1.6% 1.6% 1.4% 16.7% 4.4% 7.7% 1.6% 1.6% 1.4% 16.7% 4.4% 7.7% 1.6% 1.6% 1.4% 16.7% 4.4% 7.7% 1.6% 1.6% 1.4% 16.7% 4.4% 7.7% 1.6% 1.6% 1.4% 16.7% Page 10 Round: 0 C93614_022 Dec. 31, 2017 Perceptual Map Andrews Name Able Acre Adam Aft Agape Pfmn 4.7 2.2 7.2 8.6 3.2 Name Daze Dell Dixie Dot Dune Pfmn 4.7 2.2 7.2 8.6 3.2 Size 14.2 16.7 11.7 15.2 10.7 Digby Size 14.2 16.7 11.7 15.2 10.7 CAPSTONE COURIER Baldwin Revised Name 11/21/2014 Baker 5/25/2013 Bead 4/18/2016 Bid 6/30/2015 Bold 5/25/2015 Buddy Pfmn 4.7 2.2 7.2 8.6 3.2 Revised Name 11/21/2014 Eat 5/25/2013 Ebb 4/18/2016 Echo 6/30/2015 Edge 5/25/2015 Egg Pfmn 4.7 2.2 7.2 8.6 3.2 Size 14.2 16.7 11.7 15.2 10.7 Erie Size 14.2 16.7 11.7 15.2 10.7 Revised 11/21/2014 5/25/2013 4/18/2016 6/30/2015 5/25/2015 Name Cake Cedar Cid Coat Cure Revised 11/21/2014 5/25/2013 4/18/2016 6/30/2015 5/25/2015 Name Fast Feat Fist Foam Fume Chester Pfmn 4.7 2.2 7.2 8.6 3.2 Size 14.2 16.7 11.7 15.2 10.7 Ferris Pfmn 4.7 2.2 7.2 8.6 3.2 Size 14.2 16.7 11.7 15.2 10.7 Revised 11/21/2014 5/25/2013 4/18/2016 6/30/2015 5/25/2015 Revised 11/21/2014 5/25/2013 4/18/2016 6/30/2015 5/25/2015 Page 11 Round: 0 C93614_022 Dec. 31, 2017 HR/TQM Report HUMAN RESOURCES SUMMARY Needed Complement Complement 1st Shift Complement 2nd Shift Complement Andrews 701 700 640 60 Baldwin 701 700 640 60 Chester 701 700 640 60 Digby 701 700 640 60 Erie 701 700 640 60 Ferris 701 700 640 60 Overtime Percent Turnover Rate New Employees Separated Employees Recruiting Spend Training Hours Productivity Index 0.2% 10.0% 70 0 $0 0 100.0% 0.2% 10.0% 70 0 $0 0 100.0% 0.2% 10.0% 70 0 $0 0 100.0% 0.2% 10.0% 70 0 $0 0 100.0% 0.2% 10.0% 70 0 $0 0 100.0% 0.2% 10.0% 70 0 $0 0 100.0% $70 $0 $0 $70 $70 $0 $0 $70 $70 $0 $0 $70 $70 $0 $0 $70 $70 $0 $0 $70 $70 $0 $0 $70 $21.00 2,500 2.0% 5.0% $21.00 2,500 2.0% 5.0% $21.00 2,500 2.0% 5.0% $21.00 2,500 2.0% 5.0% $21.00 2,500 2.0% 5.0% $21.00 2,500 2.0% 5.0% Baldwin Chester Digby Erie Ferris $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 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% Recruiting Cost Separation Cost Training Cost Total HR Admin Cost Labor Contract Next Year Wages Benefits Profit Sharing Annual Raise 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 Process Mgt Budgets Last Year CPI Systems VendorJIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs TQM Budgets Last Year Benchmarking Quality Function Deployment Effort CCE/6 Sigma Training GEMI TQEM Sustainability Initiatives Total Expenditures Cumulative Impacts Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction Admin Costs Demand Increase CAPSTONE COURIER Andrews Page 12 Annual Report Annual Report Andrews C93614_022 Balance Sheet DEFINITIONS: Common Size: The common size column simply represents each item as a percentage of total ASSETS Cash assets for that year. Cash: Your endofyear cash position. Accounts Receivable: Reflects the lag between Account Receivable delivery and payment of your products. Inventories: The Inventory current value of your inventory across all products. A zero indicates your company stocked out. Unmet demand Total Current Assets would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Plant & Equipment Deprec: The total accumulated depreciation from your Accumulated Depreciation plant. Accts Payable: What the company currently owes suppliers for materials and services. Current Debt: The Total Fixed Assets debt the company is obligated to pay during the next year Total Assets of operations. It includes emergency loans used to keep LIABILITIES & OWNERS your company solvent should you run out of cash during EQUITY 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 Accounts Payable invested by shareholders in the company. Retained Current Debt Earnings: The profits that the company chose to keep Long Term Debt instead of paying to shareholders as dividends. Total Liabilities Common Stock Retained Earnings Total Equity Total Liab. & O. Equity 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 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 Round: 0 Dec. 31, 2017 $3,327 $8,307 $8,617 $20,251 $113,800 ($37,933) $75,867 $96,119 $6,583 $0 $41,700 $48,283 $18,360 $29,476 $47,836 $96,119 2017 $4,082 $7,587 $0 $3,583 ($8,617) ($307) $6,327 $0 ($4,000) $0 $0 $0 $0 $0 ($4,000) $2,327 $3,327 Page 13 Andrews Annual Report Round: 0 Dec. 31, 2017 C93614_022 2017 Income Statement (Product Name) $0 2017 Total $101,073 Common Size 100.0% $0 $0 $0 $0 $0 $0 $0 $0 $28,932 $42,546 $1,034 $72,513 28.6% 42.1% 1.0% 71.7% $0 $0 $0 $28,561 28.3% $720 $0 $700 $700 $80 $2,200 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $7,587 $0 $4,100 $4,100 $778 $16,564 7.5% 0.0% 4.1% 4.1% 0.8% 16.4% $899 $0 $0 $0 $11,996 11.9% $0 $11,996 $0 $5,588 $2,243 $83 $4,082 0.0% 11.9% 0.0% 5.5% 2.2% 0.1% 4.0% Able Acre Adam Aft Agape Sales $27,979 $37,027 $13,894 $11,817 $10,356 $0 $0 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $7,489 $11,967 $441 $19,897 $12,557 $14,348 $71 $26,977 $3,132 $6,001 $121 $9,254 $3,067 $5,829 $231 $9,127 $2,688 $4,401 $169 $7,258 $0 $0 $0 $0 Contribution Margin $8,082 $10,051 $4,640 $2,689 $3,099 Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $2,640 $0 $1,000 $1,000 $215 $4,855 $2,427 $0 $900 $900 $285 $4,512 $1,080 $0 $800 $800 $107 $2,787 $720 $0 $700 $700 $91 $2,211 Net Margin $3,227 $5,539 $1,853 $478 Other Definitions: Sales: Unit Sales times list price. Direct Labor: Labor costs incurred to produce the product EBIT that was sold. Inventory Carry Cost: the cost unsold goods in inventory. Depreciation: Calculated on Short Term Interest straightline. 15year depreciation of plant value. R&D Costs: R&D department expenditures for each Long Term Interest product. Admin: Administration overhead is estimated at 1.5% of sales. Promotions: The promotion budget Taxes 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 Profit Sharing brokerage firms to issue new stocks or bonds plus consulting fees your instructor might assess. Writeoffs Net Profit 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 Page 14