Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Capsim Help! I cannot get these answers to change to completed. I am not sure if I have some right or if I am completely

image text in transcribed

Capsim Help! I cannot get these answers to change to completed. I am not sure if I have some right or if I am completely off! Please HELP!!!!

image text in transcribed Round: 0 Dec. 31, 2016 F81569 Andrews 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 % Andrews 6.1% 1.95 11.9% 1.6 19.4% $0 $40,799,953 $4,556,099 $2,493,706 $2,493,706 6.5% 20.0% FOUNDATION FAST TRACK Baldwin 6.1% 1.95 11.9% 1.6 19.4% $0 $40,799,953 $4,556,099 $2,493,706 $2,493,706 6.5% 20.0% Chester 6.1% 1.95 11.9% 1.6 19.4% $0 $40,799,953 $4,556,099 $2,493,706 $2,493,706 6.5% 20.0% Digby 6.1% 1.95 11.9% 1.6 19.4% $0 $40,799,953 $4,556,099 $2,493,706 $2,493,706 6.5% 20.0% Erie 6.1% 1.95 11.9% 1.6 19.4% $0 $40,799,953 $4,556,099 $2,493,706 $2,493,706 6.5% 20.0% Ferris 6.1% 1.95 11.9% 1.6 19.4% $0 $40,799,953 $4,556,099 $2,493,706 $2,493,706 6.5% 20.0% Page 1 Stock & Bonds Round: 0 Dec. 31, 2016 F81569 Stock Market Summary Company Close Change Shares Andrews Baldwin Chester Digby Erie Ferris $11.17 $11.17 $11.17 $11.17 $11.17 $11.17 $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) $22 $22 $22 $22 $22 $22 Book Value EPS Dividend Yield P/E $6.43 $6.43 $6.43 $6.43 $6.43 $6.43 $1.25 $1.25 $1.25 $1.25 $1.25 $1.25 $0.50 $0.50 $0.50 $0.50 $0.50 $0.50 4.5% 4.5% 4.5% 4.5% 4.5% 4.5% 8.9 8.9 8.9 8.9 8.9 8.9 Bond Market Summary Company Andrews Series# Face Yield Close$ S&P 11.0S2018 12.0S2020 13.0S2022 $866,667 $1,733,333 $2,600,000 10.8% 11.3% 11.5% 101.74 BBB 106.34 BBB 113.07 BBB 11.0S2018 12.0S2020 13.0S2022 $866,667 $1,733,333 $2,600,000 10.8% 11.3% 11.5% 101.74 BBB 106.34 BBB 113.07 BBB 11.0S2018 12.0S2020 13.0S2022 $866,667 $1,733,333 $2,600,000 10.8% 11.3% 11.5% 101.74 BBB 106.34 BBB 113.07 BBB Baldwin Company Digby Series# Face Yield Close$ S&P 11.0S2018 12.0S2020 13.0S2022 $866,667 $1,733,333 $2,600,000 10.8% 11.3% 11.5% 101.74 106.34 113.07 BBB BBB BBB 11.0S2018 12.0S2020 13.0S2022 $866,667 $1,733,333 $2,600,000 10.8% 11.3% 11.5% 101.74 106.34 113.07 BBB BBB BBB 11.0S2018 12.0S2020 13.0S2022 $866,667 $1,733,333 $2,600,000 10.8% 11.3% 11.5% 101.74 106.34 113.07 BBB BBB BBB Erie Chester Ferris Next Year's Prime Rate7.00% FOUNDATION FAST TRACK Page 2 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 Acounts payable Inventory Accounts Receivable Net cash from operations F81569 Round: 0 Dec. 31, 2016 Andrews Baldwin Chester Digby Erie Ferris $2,494 $2,494 $2,494 $2,494 $2,494 $2,494 $960 $0 $960 $0 $960 $0 $960 $0 $960 $0 $960 $0 $853 ($2,352) $3,647 $5,602 $853 ($2,352) $3,647 $5,602 $853 ($2,352) $3,647 $5,602 $853 ($2,352) $3,647 $5,602 $853 ($2,352) $3,647 $5,602 $853 ($2,352) $3,647 $5,602 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 ($1,000) $0 $0 $0 $0 $0 $0 $0 ($1,000) $0 $0 $0 $0 $0 $0 $0 ($1,000) $0 $0 $0 $0 $0 $0 $0 ($1,000) $0 $0 $0 $0 $0 $0 $0 ($1,000) $0 $0 $0 $0 $0 $0 $0 ($1,000) $0 $0 $0 $0 $0 $0 $0 Net cash from financing activities ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) $4,602 Andrews $5,602 $3,353 $2,352 $11,307 $4,602 Baldwin $5,602 $3,353 $2,352 $11,307 $4,602 Chester $5,602 $3,353 $2,352 $11,307 $4,602 Digby $5,602 $3,353 $2,352 $11,307 $4,602 Erie $5,602 $3,353 $2,352 $11,307 $4,602 Ferris $5,602 $3,353 $2,352 $11,307 Plant and equipment Accumulated Depreciation Total Fixed Assets $14,400 ($4,800) $9,600 $14,400 ($4,800) $9,600 $14,400 ($4,800) $9,600 $14,400 ($4,800) $9,600 $14,400 ($4,800) $9,600 $14,400 ($4,800) $9,600 Total Assets $20,907 $20,907 $20,907 $20,907 $20,907 $20,907 $2,853 $0 $5,200 $8,053 $2,853 $0 $5,200 $8,053 $2,853 $0 $5,200 $8,053 $2,853 $0 $5,200 $8,053 $2,853 $0 $5,200 $8,053 $2,853 $0 $5,200 $8,053 Common Stock Retained Earnings Total Equity $2,323 $10,531 $12,854 $2,323 $10,531 $12,854 $2,323 $10,531 $12,854 $2,323 $10,531 $12,854 $2,323 $10,531 $12,854 $2,323 $10,531 $12,854 Total Liabilities & Owners Equity $20,907 $20,907 $20,907 $20,907 $20,907 $20,907 Andrews $40,800 $32,647 $960 $2,637 $0 $4,556 $641 $1,370 $51 $2,494 Baldwin $40,800 $32,647 $960 $2,637 $0 $4,556 $641 $1,370 $51 $2,494 Chester $40,800 $32,647 $960 $2,637 $0 $4,556 $641 $1,370 $51 $2,494 Digby $40,800 $32,647 $960 $2,637 $0 $4,556 $641 $1,370 $51 $2,494 Erie $40,800 $32,647 $960 $2,637 $0 $4,556 $641 $1,370 $51 $2,494 Ferris $40,800 $32,647 $960 $2,637 $0 $4,556 $641 $1,370 $51 $2,494 Net change in cash position Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets Account Payable CurrentDebt Long Term Debt Total Liabilities 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 FOUNDATION FAST TRACK Page 3 Round: 0 Dec. 31, 2016 F81569 Production Analysis MTBF 21000 Pfmn Coord 6.4 Size Coord Price 13.6 $34.00 Material Labor Cost Cost $16.17 $10.11 Contr. Marg. 20% 2nd Shift & Over time 63% 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% 87 11/21/2013 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% 1,200 87 11/21/2013 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Low 1,200 87 11/21/2013 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Low 1,200 87 11/21/2013 3.1 21000 6.4 13.6 $34.00 $16.17 $10.11 20% 63% 3.0 800 161% Unit Inven Revision Age tory Date Dec.31 87 11/21/2013 3.1 Name Able Primary Segment Low Units Sold 1,200 Baker Low 1,200 87 11/21/2013 Cake Low 1,200 Daze Low Eat Fast FOUNDATION FAST TRACK Auto mation Next Round 3.0 Capacity Next Round 800 Plant Utiliz. 161% Page 4 Low Tech Segment Analysis F81569 Round: 0 Dec. 31, 2016 Low Tech Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 5,040 |5,040 |70.0% Next Year's Segment Growth Rate |10.0% Low Tech Customer Buying Criteria 1. Price 2. Age 3. Reliability 4. Ideal Position Name Able Baker Cake Daze Eat Fast Market Share 17% 17% 17% 17% 17% 17% Expectations $15.00 35.00 Ideal Age = 3.0 MTBF 1400020000 Pfmn 4.8 Size 15.2 Units Sold to Seg 840 840 840 840 840 840 Importance 41% 29% 21% 9% Top Products in Low Tech Segment Revision Date 11/21/2013 11/21/2013 11/21/2013 11/21/2013 11/21/2013 11/21/2013 FOUNDATION FAST TRACK Stock Out Pfmn Coord 6.4 6.4 6.4 6.4 6.4 6.4 Size Coord 13.6 13.6 13.6 13.6 13.6 13.6 Cust. List Age Promo Aware Price MTBF Dec.31 Budget ness $34.00 21000 3.10 $1,000 55% $34.00 21000 3.10 $1,000 55% $34.00 21000 3.10 $1,000 55% $34.00 21000 3.10 $1,000 55% $34.00 21000 3.10 $1,000 55% $34.00 21000 3.10 $1,000 55% Cust. Dec. Sales Access Cust Budget ibility Survey $1,000 40% 18 $1,000 40% 18 $1,000 40% 18 $1,000 40% 18 $1,000 40% 18 $1,000 40% 18 Page 5 High Tech Segment Analysis F81569 Round: 0 Dec. 31, 2016 High Tech Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 2,160 |2,160 |30.0% Next Year's Segment Growth Rate |20.0% High Tech Customer Buying Criteria 1. Ideal Position 2. Age 3. Price 4. Reliability Name Able Baker Cake Daze Eat Fast Market Share 17% 17% 17% 17% 17% 17% Expectations Pfmn 7.4 Size 12.6 Ideal Age = 0.0 $25.00 45.00 MTBF 1700023000 Units Sold to Seg 360 360 360 360 360 360 Importance 33% 29% 25% 13% Top Products in High Tech Segment Revision Date 11/21/2013 11/21/2013 11/21/2013 11/21/2013 11/21/2013 11/21/2013 FOUNDATION FAST TRACK Stock Out Pfmn Coord 6.4 6.4 6.4 6.4 6.4 6.4 Size Coord 13.6 13.6 13.6 13.6 13.6 13.6 Cust. List Age Promo Aware Price MTBF Dec.31 Budget ness $34.00 21000 3.10 $1,000 55% $34.00 21000 3.10 $1,000 55% $34.00 21000 3.10 $1,000 55% $34.00 21000 3.10 $1,000 55% $34.00 21000 3.10 $1,000 55% $34.00 21000 3.10 $1,000 55% Cust. Dec. Sales Access Cust Budget ibility Survey $1,000 41% 16 $1,000 41% 16 $1,000 41% 16 $1,000 41% 16 $1,000 41% 16 $1,000 41% 16 Page 6 Market Share F81569 Actual Market Share in Units Industry Unit Sales % of Market Low 5,040 70.0% High 2,160 30.0% Able Total 16.7% 16.7% 16.7% 16.7% Baker Total 16.7% 16.7% Cake Total Round: 0 Dec. 31, 2016 Potential Market Share in Units Low 5,040 70.0% High 2,160 30.0% Total 7,200 100.0% 16.7% Able 16.7% Total 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% Baker 16.7% Total 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% Cake 16.7% Total 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% Daze Total 16.7% 16.7% 16.7% 16.7% 16.7% Daze 16.7% Total 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% Eat Total 16.7% 16.7% 16.7% 16.7% 16.7% Eat 16.7% Total 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% Fast Total 16.7% 16.7% 16.7% 16.7% 16.7% Fast 16.7% Total 16.7% 16.7% 16.7% 16.7% 16.7% 16.7% FOUNDATION FAST TRACK Total 7,200 Units Demanded 100.0% % of Market Page 7 Perceptual Map Andrews Name Able Pfmn 6.4 Name Daze Pfmn 6.4 Size 13.6 Digby Size 13.6 FOUNDATION FAST TRACK Round: 0 Dec. 31, 2016 F81569 Baldwin Revised Name 11/21/2013 Baker Pfmn 6.4 Revised Name 11/21/2013 Eat Pfmn 6.4 Size 13.6 Erie Size 13.6 Revised 11/21/2013 Name Cake Revised 11/21/2013 Name Fast Chester Pfmn 6.4 Size 13.6 Ferris Pfmn 6.4 Size 13.6 Revised 11/21/2013 Revised 11/21/2013 Page 8 HR/TQM Report F81569 Round: 0 Dec. 31, 2016 HUMAN RESOURCES SUMMARY Needed Complement Complement 1st Shift Complement 2nd Shift Complement Andrews 250 248 154 94 Baldwin 250 248 154 94 Chester 250 248 154 94 Digby 250 248 154 94 Erie 250 248 154 94 Ferris 250 248 154 94 Overtime Percent Turnover Rate New Employees Separated Employees Recruiting Spend Training Hours Productivity Index 1.3% 10.1% 25 0 $0 0 100.0% 1.3% 10.1% 25 0 $0 0 100.0% 1.3% 10.1% 25 0 $0 0 100.0% 1.3% 10.1% 25 0 $0 0 100.0% 1.3% 10.1% 25 0 $0 0 100.0% 1.3% 10.1% 25 0 $0 0 100.0% $25 $0 $0 $25 $25 $0 $0 $25 $25 $0 $0 $25 $25 $0 $0 $25 $25 $0 $0 $25 $25 $0 $0 $25 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 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 FOUNDATION FAST TRACK Andrews Page 9 Annual Report Annual Report Andrews F81569 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 CurrentDebt 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, 2016 $5,602 $3,353 $2,352 $11,307 $14,400 ($4,800) $9,600 $20,907 $2,853 $0 $5,200 $8,053 $2,323 $10,531 $12,854 $20,907 2016 $2,494 $960 $0 $853 ($2,352) $3,647 $5,602 $0 ($1,000) $0 $0 $0 $0 $0 ($1,000) $4,602 $5,602 Page 10 Andrews Annual Report Round: 0 Dec. 31, 2016 F81569 2016 Income Statement Sales $40,800 $0 $0 $0 $0 $0 $0 $0 2016 Total $40,800 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $12,138 $20,227 $282 $32,647 $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 $12,138 $20,227 $282 $32,647 29.8% 49.6% 0.7% 80.0% Contribution Margin $8,153 $0 $0 $0 $0 $0 $0 $0 $8,153 20.0% Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $960 $0 $1,000 $1,000 $637 $3,597 $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 $960 $0 $1,000 $1,000 $637 $3,597 2.4% 0.0% 2.5% 2.5% 1.6% 8.8% Net Margin $4,556 $0 $0 $0 $0 $0 $0 $0 $4,556 11.2% $0 $4,556 $0 $641 $1,370 $51 $2,494 0.0% 11.2% 0.0% 1.6% 3.4% 0.1% 6.1% (Product Name) Able 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 Common Size 100.0% Page 11

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Financial Management Core Concepts

Authors: Raymond Brooks

4th Edition

134730417, 134730410, 978-0134730417

More Books

Students also viewed these Finance questions