Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

All else constant, what would Baldwin?s SG&A/Sales ratio be if the company had spent an additional $1,500,000 for Bolt?s promotional budget and $750,000 for Bolt?s

All else constant, what would Baldwin?s SG&A/Sales ratio be if the company had spent an additional $1,500,000 for Bolt?s promotional budget and $750,000 for Bolt?s sales budget?Select: 1

11.0%
12.9%
14.8%

15.6%

Currently Digby is paying a dividend of $13.92 (per share). If this dividend were raised by $3.64, given its current stock price what would be the Dividend Yield?
Select: 1
9.6%
$3.64
$17.56
12.1%

Your Competitive Intelligence team reports that a wave of product liability lawsuits is likely to cause Baldwin to pull the product Best entirely off the market this year. Assume Baldwin scraps all capacity and inventory this round, completely writing off those assets and escrowing the proceeds to a settlement fund, and assume these lawsuits will have no effect on any other products of Baldwin or other companies. Without Baldwin's product Best how much can the industry currently produce in the Core segment? Consider only products primarily in the Core segment last year. Ignore current inventories. Figures in thousands (000).
Select: 1
7,678
6,130
9,706
8,728
8,357
8,656
12,260

Currently Ark is charged $4,600,000 Depreciation on the Income Statement of Andrews. Andrews is planning for an increase in this depreciation. On the financial statements of Andrews will this?
Select: 1
Have no impact on the Net Cash from Operations as depreciation appears in both Cash Flow and the Income Statement.
Increase Net Cash from Operations on the Cash Flow Statement.
Just impact the Balance Sheet.
Decrease Net Cash from Operations on the Cash Flow Statement.

Chester Corp. is downsizing the size of their workforce by 10% (to the nearest person) next year from various strategic initiatives.How much will the company pay in separation costs if each worker receives $5,000 when separated?
Select: 1
$80,000
$1,820,000
$200,000
$728,000

In the Month of March, Chester received orders of 93 units at a price of $15.00 for their product City. Chester uses the accrual method of accounting and offers 30 day credit terms. Chester delivers 93 units in April. They received payment for 47 units in March, and 47 units in April. In the March income statement, how much revenue is recognized on the March income statement from this order? How much in the April Income statement? (Answer in thousands)
Select: 1
0, $698
$1,395 , 0
0, $1,395
$698 , $698

Assume Baldwin is producing 1,840 units of Bolt next year. What would Bolt's plant utilization be?
Select: 1
117.30%
112.70%
115.00%
111.39%

Baldwin's balance sheet has $66,683,000 in equity. Further, the company is expecting net income of 4,000,000 next year, and also expecting to pay $5,000,000 in dividends. If there is no new stock issued what will be Baldwin's book value?
Select: 1
$75,683,000
$65,683,000
$21,973,000
$31,973,000

image text in transcribed 7/25/2016 COMPXM INQUIRER Page 1 Front Page Page 2 Stocks & Bonds Page 3 Financial Summary Page 4 Production Analysis Annual Report Andrews Page 5 Thrift Segment Analysis Page 6 Core Segment Analysis Page 7 Nano Segment Analysis Page 8 Elite Segment Analysis Annual Report Baldwin Page 9 Market Share Page 10 Perceptual Map Page 11 HR/TQM Report Annual Report Chester Annual Report Digby PRINT http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport 1/24 7/25/2016 COMPXM INQUIRER Top " Ka Chun Chan Round: 4 Dec. 31, 2019 Student: Ka Chun Chan Andrews Ka Chun Chan Baldwin Digby Chester Selected Financial Statistics ROS Asset Turnover ROA Leverage (Assets/Equity) ROE Emergency Loan Sales EBIT Profits Cumulative Profit SG&A / Sales Contrib. Margin % Andrews 20.2% 1.07 21.6% 1.5 31.7% $11,968,377 $318,710,992 $111,792,302 $64,319,103 $119,536,053 13.8% 56.3% Baldwin 1.8% 0.70 1.3% 2.5 3.2% $0 $116,908,141 $15,489,971 $2,154,294 ($1,206,794) 12.9% 43.3% Chester 1.8% 0.71 1.3% 2.3 2.9% $0 $152,270,155 $18,591,366 $2,791,442 ($1,590,966) 13.8% 40.9% COMPXM INQUIRER http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport Digby 16.6% 1.41 23.3% 1.7 39.9% $0 $218,027,166 $62,633,941 $36,129,522 $80,945,287 6.4% 42.4% Page 1 2/24 7/25/2016 COMPXM INQUIRER Top Stocks & Bonds Round: 4 Ka Chun Chan December 31 , 2019 Stock Market Summary Company Andrews Baldwin Chester Digby Close $174.47 $21.33 $26.56 $145.66 Change $65.93 $5.58 $5.80 $52.07 Shares 2,461,449 3,177,249 3,455,520 1,839,809 MarketCap ($M) $429 $68 $92 $268 Book Value $82.38 $20.99 $27.39 $49.26 EPS $26.13 $0.68 $0.81 $19.64 Dividend $0.00 $1.83 $0.00 $13.92 Yield 0.0% 8.6% 0.0% 9.6% P/E 6.7 31.4 32.8 7.4 Bond Market Summary Company Andrews Baldwin Chester Digby Series# 11.2S2022 11.9S2023 12.9S2027 12.5S2023 12.5S2024 12.5S2025 12.9S2026 13.4S2027 11.9S2025 12.5S2026 13.2S2027 13.8S2028 11.2S2025 11.5S2026 11.8S2027 12.6S2028 Face $8,837,000 $7,072,000 $55,000,000 $13,017,958 $7,981,720 $9,473,587 $14,407,694 $28,588,075 $14,086,532 $17,783,553 $33,650,843 $20,215,586 $2,758,121 $1,307,561 $15,332,283 $8,206,093 Yield 11.3% 11.7% 12.0% 13.1% 13.3% 13.4% 13.7% 13.9% 12.9% 13.3% 13.6% 13.9% 11.7% 11.9% 12.1% 12.4% Close$ 99.52 101.54 107.61 95.07 94.19 93.42 94.46 96.31 92.20 93.98 96.74 99.50 95.52 96.38 97.54 101.58 S&P A A A CC CC CC CC CC CC CC CC CC BBB BBB BBB BBB Next Year's Prime Rate 9.00% COMPXM INQUIRER http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport Page 2 3/24 7/25/2016 COMPXM INQUIRER Top Financial Summary Cash Flow Statement Survey Cash flows from operating activities Net Income (Loss) Adjustment for noncash items: Depreciation Extraordinary gains/losses/writeoffs Changes in current assets and liabilities: Accounts payable Inventory Accounts receivable Net cash from operations Net cash from financing activities Net change in cash position Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets Plant and equipment Accumulated Depreciation Total Fixed Assets Total Assets Accounts Payable Current Debt Long Term Debt Total Liabilities Common Stock Retained Earnings Total Equity Total Liabilities & Owners' Equity 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 Andrews Baldwin Chester Digby $64,319 $23,834 $0 ($496) ($4,444) ($2,304) $80,908 ($88,000) $0 $0 $0 $0 $0 ($4,877) $0 $11,968 $2,154 $15,180 ($736) ($48) ($2,860) ($307) $13,383 $0 ($5,815) $0 $0 $0 ($9,559) ($26,769) $20,876 $0 $2,791 $17,396 ($1,063) $1,618 ($9,871) ($1,316) $9,555 $0 $0 $4,765 $0 $0 ($14,920) ($24,054) $24,825 $0 $36,130 $9,484 ($153) $3,919 ($17,741) ($3,680) $27,958 $7,092 $0 ($21,267) ($7,884) ($9,385) $170 ($26,809) $1,149 Andrews $0 $26,195 $22,192 $48,387 $357,512 ($108,662) $248,850 $297,237 Baldwin $26,214 $9,609 $10,906 $46,729 $227,700 ($107,829) $119,871 $166,600 Chester $27,565 $12,515 $17,217 $57,297 $260,940 ($104,992) $155,948 $213,246 Digby $36,587 $17,920 $25,878 $80,385 $142,260 ($67,759) $74,501 $154,886 $11,581 $11,968 $70,909 $94,459 $24,148 $178,630 $202,778 $297,237 $5,572 $20,876 $73,469 $99,917 $43,710 $22,973 $66,683 $166,600 $8,034 $24,825 $85,737 $118,596 $57,438 $37,212 $94,650 $213,246 $11,531 $25,127 $27,604 $64,262 $8,972 $81,652 $90,624 $154,886 Andrews $318,711 $139,125 $23,834 $43,950 $10 $111,792 $10,820 $35,340 $1,313 $64,319 Baldwin $116,908 $66,247 $15,180 $15,084 $4,908 $15,490 $12,108 $1,184 $44 $2,154 Chester $152,270 $89,943 $17,396 $20,941 $5,399 $18,591 $14,209 $1,534 $57 $2,791 Digby $218,027 $125,653 $9,484 $14,043 $6,214 $62,634 $5,916 $19,851 $737 $36,130 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 Round: 4 December 31, 2019 Ka Chun Chan COMPXM INQUIRER http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport $0 ($25,614) $0 ($2,527) $0 ($5,268) ($18,527) $25,127 $0 Page 3 4/24 7/25/2016 COMPXM INQUIRER Top Production Analysis Round: 4 December 31, 2019 Ka Chun Chan Production Information Primary Segment Name Ark Ant Ace Awe Apple Angle Amy Aron Bit Bolt Best Brat City Cozy Cute Crimp Cake Cedar Dim Dome Dug Drat Units Unit Inven Sold tory Core Nano Elite Thrift Core Core Thrift Elite 2,104 1,734 1,359 2,265 891 891 637 891 Thrift Thrift Core Core 22000 24000 26000 20000 22000 22000 20000 26000 11.2 14.2 14.2 9.0 11.6 11.6 8.0 14.5 9.0 3.8 7.2 11.5 8.3 8.3 11.1 7.4 2nd Shift & Over time $1.39 $1.47 $1.43 $1.47 $4.40 $4.40 $4.40 $4.40 50% 63% 63% 52% 53% 53% 49% 57% 59% 100% 75% 100% 100% 100% 100% 100% http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport 157% 198% 173% 198% 198% 198% 198% 198% 1,450 1,600 1,050 1,250 123% 111% 137% 119% 1,250 1,500 850 850 1,040 1,040 87% 89% 169% 140% 119% 133% 1,050 750 1,050 1,200 198% 198% 146% 165% 7.0 7.0 7.0 7.0 COMPXM INQUIRER 1,500 1,028 1,114 1,530 650 650 650 650 10.0 10.0 7.0 7.0 8.0 8.0 100% 100% 48% 67% Plant Utiliz. 10.0 10.0 8.0 8.0 0% 0% 71% 41% 20% 35% 41% 40% 45% 43% 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 Auto mation Capacity Next Next Round Round 24% 13% 38% 20% 49% 46% 36% 45% 34% 38% $6.63 $6.63 $6.17 $6.37 45% 44% 41% 44% $1.20 $1.20 $5.76 $5.48 $3.89 $4.05 $13.04 $13.82 $13.28 $13.83 Contr. Marg. $1.39 $1.34 $4.33 $4.13 $5.93 $7.14 $11.83 $12.62 $8.63 $8.38 $34.00 $34.00 $37.00 $37.00 Labor Cost $6.69 $6.82 $9.03 $9.64 $15.00 $17.00 $28.00 $34.00 $19.00 $20.00 3.8 6.3 3.5 6.0 $9.79 $13.09 $12.47 $7.70 $10.16 $10.16 $7.52 $12.52 $15.00 $15.00 $23.00 $25.00 12.1 11.2 4.0 6.8 9.0 9.4 13.8 16.9 14.2 16.7 $24.60 $39.00 $39.50 $19.00 $30.00 $30.00 $24.00 $38.00 Material Price Cost 11.8 11.6 8.4 8.9 8.0 8.9 13.1 16.5 10.9 10.6 23000 25000 23000 25000 8.3 8.5 11.0 11.7 14000 16000 18000 20000 16000 16000 1.3 1.6 1.4 1.3 Size Coord 17000 17000 18000 20000 3.2 4.1 1.0 1.0 1.0 1.0 9/13/2019 8/21/2019 8/13/2019 8/21/2019 MTBF Pfmn Coord 2.6 2.6 1.6 1.6 12/20/2018 12/6/2016 12/21/2019 12/21/2019 12/14/2019 12/14/2019 437 0 378 493 1.7 1.1 1.2 1.3 0.9 0.9 0.9 0.9 6/10/2019 6/10/2019 12/14/2019 12/14/2019 188 279 250 285 174 139 1,796 1,485 1,330 1,547 12/26/2019 12/26/2019 12/24/2019 12/24/2019 12/25/2019 12/25/2019 12/21/2019 12/25/2019 246 248 222 285 1,122 1,214 1,290 969 1,092 1,249 Nano Elite Nano Elite 1,652 1,665 1,421 1,379 Thrift Thrift Nano Elite Core Core 775 17 426 369 0 0 300 0 Revision Date Age Dec.31 Page 4 5/24 7/25/2016 COMPXM INQUIRER Top Thrift Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry Ka Chun Chan Thrift Statistics 7,746 7,746 25.8% Next Year's Segment Growth Rate 1. 2. 3. 4. Price Reliability Ideal Position Age Round: 4 December 31, 2019 11.0% Thrift Customer Buying Criteria Expectations $14.00 26.00 MTBF 1400020000 Pfmn 8.0 Size 12.1 Ideal Age = 3.0 Importance 55% 20% 15% 10% Perceptual Map for Thrift Segment Top Products in Thrift Segment Name Awe Bit Bolt City Cozy Amy Cedar Ark Cake Apple Angle Best Market Units Sold to Share Seg 21% 1,623 21% 1,598 20% 1,583 14% 1,094 11% 842 8% 609 2% 191 1% 99 1% 88 0% 9 0% 9 0% 3 Revision Date Stock Out 12/24/2019 6/10/2019 6/10/2019 12/20/2018 12/6/2016 12/21/2019 12/14/2019 12/26/2019 12/14/2019 12/25/2019 YES 12/25/2019 YES 12/14/2019 Pfmn Coord 9.0 8.3 8.5 8.0 8.9 8.0 10.6 11.2 10.9 11.6 11.6 11.0 Size Coord 11.5 11.8 11.6 12.1 11.2 11.1 9.4 9.0 9.0 8.3 8.3 8.4 List Price $19.00 $15.00 $15.00 $15.00 $17.00 $24.00 $20.00 $24.60 $19.00 $30.00 $30.00 $23.00 MTBF 20000 17000 17000 14000 16000 20000 16000 22000 16000 22000 22000 18000 Age Dec.31 1.30 2.65 2.60 3.25 4.11 0.92 0.96 1.68 0.96 0.88 0.88 1.56 Promo Cust. Aware Cust. Access Dec. Cust. Budget ness Sales Budget ibility Survey $1,600 100% $4,000 89% 58 $1,300 83% $1,600 83% 69 $1,300 83% $1,600 83% 67 $1,200 72% $1,000 78% 46 $1,200 72% $1,000 78% 36 $1,200 63% $2,000 89% 22 $1,200 62% $900 78% 2 $1,600 100% $3,800 89% 0 $1,200 67% $900 78% 0 $2,000 80% $1,700 89% 0 $2,000 76% $1,500 89% 0 $1,300 83% $1,400 83% 0 COMPXM INQUIRER http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport Page 5 6/24 7/25/2016 COMPXM INQUIRER Top Core Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry Ka Chun Chan Core Statistics 9,778 9,778 32.6% Next Year's Segment Growth Rate 1. 2. 3. 4. Price Age Reliability Ideal Position Round: 4 December 31, 2019 10.0% Core Customer Buying Criteria Expectations $20.00 32.00 Ideal Age = 2.0 MTBF 1600022000 Pfmn 11.3 Size 8.8 Importance 46% 20% 18% 16% Perceptual Map for Core Segment Top Products in Core Segment Name Ark Best Brat Cedar Cake Apple Angle Awe Cozy Bolt Bit Amy Market Units Sold to Share Seg 21% 2,006 14% 1,414 14% 1,371 11% 1,059 10% 1,004 9% 859 9% 859 7% 642 4% 372 1% 82 1% 53 0% 28 Revision Date Stock Out 12/26/2019 12/14/2019 12/14/2019 12/14/2019 12/14/2019 12/25/2019 YES 12/25/2019 YES 12/24/2019 12/6/2016 6/10/2019 6/10/2019 12/21/2019 Pfmn Coord 11.2 11.0 11.7 10.6 10.9 11.6 11.6 9.0 8.9 8.5 8.3 8.0 Size Coord 9.0 8.4 8.9 9.4 9.0 8.3 8.3 11.5 11.2 11.6 11.8 11.1 List Price $24.60 $23.00 $25.00 $20.00 $19.00 $30.00 $30.00 $19.00 $17.00 $15.00 $15.00 $24.00 MTBF 22000 18000 20000 16000 16000 22000 22000 20000 16000 17000 17000 20000 Age Dec.31 1.68 1.56 1.57 0.96 0.96 0.88 0.88 1.30 4.11 2.60 2.65 0.92 Promo Cust. Aware Cust. Access Dec. Cust. Budget ness Sales Budget ibility Survey $1,600 100% $3,800 98% 84 $1,300 83% $1,400 81% 53 $1,300 83% $1,400 81% 52 $1,200 62% $900 73% 39 $1,200 67% $900 73% 37 $2,000 80% $1,700 98% 36 $2,000 76% $1,500 98% 35 $1,600 100% $4,000 98% 42 $1,200 72% $1,000 73% 10 $1,300 83% $1,600 81% 3 $1,300 83% $1,600 81% 2 $1,200 63% $2,000 98% 13 COMPXM INQUIRER http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport Page 6 7/24 7/25/2016 COMPXM INQUIRER Top Nano Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry Ka Chun Chan Nano Statistics 6,164 6,164 20.6% Next Year's Segment Growth Rate 1. 2. 3. 4. Ideal Position Price Age Reliability Round: 4 December 31, 2019 14.0% Nano Customer Buying Criteria Expectations Pfmn 13.2 Size 3.7 $28.00 40.00 Ideal Age = 1.0 MTBF 1800024000 Importance 35% 27% 20% 18% Perceptual Map for Nano Segment Top Products in Nano Segment Name Ant Dim Dug Cute Ace Aron Drat Angle Apple Best Brat Market Units Sold to Share Seg 26% 1,626 26% 1,611 21% 1,278 21% 1,274 3% 185 2% 142 0% 15 0% 13 0% 13 0% 4 0% 2 Revision Date Stock Out 12/26/2019 9/13/2019 8/13/2019 12/21/2019 12/24/2019 12/25/2019 YES 8/21/2019 12/25/2019 YES 12/25/2019 YES 12/14/2019 12/14/2019 Pfmn Coord 14.2 13.8 14.2 13.1 14.2 14.5 16.7 11.6 11.6 11.0 11.7 Size Coord 3.8 3.8 3.5 4.0 7.2 7.4 6.0 8.3 8.3 8.4 8.9 List Price $39.00 $34.00 $37.00 $28.00 $39.50 $38.00 $37.00 $30.00 $30.00 $23.00 $25.00 MTBF 24000 23000 23000 18000 26000 26000 25000 22000 22000 18000 20000 Age Dec.31 1.09 1.27 1.36 1.02 1.23 0.91 1.35 0.88 0.88 1.56 1.57 Promo Cust. Aware Cust. Access Dec. Cust. Budget ness Sales Budget ibility Survey $1,600 100% $3,000 99% 64 $1,400 92% $1,100 80% 66 $1,400 92% $1,000 80% 51 $1,200 73% $2,400 74% 56 $1,500 100% $2,500 99% 19 $2,000 80% $1,000 99% 11 $1,400 91% $1,000 80% 0 $2,000 76% $1,500 99% 10 $2,000 80% $1,700 99% 10 $1,300 83% $1,400 12% 0 $1,300 83% $1,400 12% 0 COMPXM INQUIRER http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport Page 7 8/24 7/25/2016 COMPXM INQUIRER Top Elite Market Segment Analysis Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry Ka Chun Chan Elite Statistics 6,297 6,297 21.0% Next Year's Segment Growth Rate 1. 2. 3. 4. Age Price Ideal Position Reliability Round: 4 December 31, 2019 16.0% Elite Customer Buying Criteria Expectations Ideal Age = 0.0 $30.00 42.00 Pfmn 16.4 Size 6.9 MTBF 2000026000 Importance 34% 24% 22% 20% Perceptual Map for Elite Segment Top Products in Elite Segment Name Drat Dome Ace Crimp Aron Dim Ant Dug Cute Apple Angle Brat Market Units Sold to Share Seg 24% 1,532 24% 1,485 19% 1,173 15% 969 12% 750 3% 185 2% 108 1% 52 0% 17 0% 10 0% 10 0% 6 Revision Date Stock Out 8/21/2019 8/21/2019 YES 12/24/2019 12/21/2019 12/25/2019 YES 9/13/2019 12/26/2019 8/13/2019 12/21/2019 12/25/2019 YES 12/25/2019 YES 12/14/2019 Pfmn Coord 16.7 16.9 14.2 16.5 14.5 13.8 14.2 14.2 13.1 11.6 11.6 11.7 Size Coord 6.0 6.3 7.2 6.8 7.4 3.8 3.8 3.5 4.0 8.3 8.3 8.9 List Price $37.00 $34.00 $39.50 $34.00 $38.00 $34.00 $39.00 $37.00 $28.00 $30.00 $30.00 $25.00 MTBF 25000 25000 26000 20000 26000 23000 24000 23000 18000 22000 22000 20000 Age Dec.31 1.35 1.63 1.23 1.03 0.91 1.27 1.09 1.36 1.02 0.88 0.88 1.57 Promo Cust. Aware Cust. Access Dec. Cust. Budget ness Sales Budget ibility Survey $1,400 91% $1,000 87% 50 $1,400 92% $1,000 87% 54 $1,500 100% $2,500 100% 47 $1,200 72% $2,400 74% 37 $2,000 80% $1,000 100% 51 $1,400 92% $1,100 87% 0 $1,600 100% $3,000 100% 0 $1,400 92% $1,000 87% 0 $1,200 73% $2,400 74% 0 $2,000 80% $1,700 100% 7 $2,000 76% $1,500 100% 7 $1,300 83% $1,400 5% 0 COMPXM INQUIRER http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport Page 8 9/24 7/25/2016 COMPXM INQUIRER Top Market Share Report Industry Unit Sales % of Market Ark Ant Ace Awe Apple Angle Amy Aron Total Bit Bolt Best Brat Total City Cozy Cute Crimp Cake Cedar Total Dim Dome Dug Drat Total Round: 4 December 31, 2019 Ka Chun Chan Actual Market Share in Units Thrift 7,746 Core 9,778 Nano 6,164 Elite 6,297 Total 29,984 25.8% 32.6% 20.6% 21.0% 100.0% 1.3% 20.5% 21.0% 0.1% 0.1% 7.9% 6.6% 8.8% 8.8% 0.3% 30.3% 20.6% 20.4% 0.0% 26.4% 3.0% 1.7% 18.6% 0.2% 0.2% 0.2% 0.2% 44.9% 2.3% 32.1% 11.9% 32.6% 7.0% 5.8% 4.5% 7.5% 3.0% 3.0% 2.1% 3.0% 35.9% 41.1% 0.6% 0.8% 14.5% 14.0% 29.9% 0.1% 0.0% 0.1% 0.1% 0.1% 5.5% 5.5% 4.7% 4.6% 20.4% 14.1% 10.9% 0.3% 3.8% 20.7% 1.1% 2.5% 28.6% 10.3% 10.8% 25.2% 0.3% 15.4% 20.7% 15.7% 3.7% 4.0% 4.3% 3.2% 3.6% 4.2% 23.1% 26.1% 2.9% 23.6% 0.8% 24.3% 51.7% 6.0% 5.0% 4.4% 5.2% 20.5% 20.7% 0.2% 47.1% Units Demanded % of Market Ark Ant Ace Awe Apple Angle Amy Aron Total Bit Bolt Best Brat Total City Cozy Cute Crimp Cake Cedar Total Dim Dome Dug Drat Total Potential Market Share in Units Thrift 7,746 Core 9,778 Nano 6,164 Elite 6,297 Total 29,984 25.8% 32.6% 20.6% 21.0% 100.0% 1.3% 19.9% 21.0% 0.1% 0.1% 7.9% 6.4% 10.2% 9.8% 0.3% 26.4% 2.9% 1.6% 17.1% 0.3% 0.3% 0.2% 0.2% 30.4% 46.6% 3.5% 33.4% 17.5% 36.6% 6.8% 5.8% 4.2% 7.5% 3.5% 3.3% 2.1% 4.4% 37.6% 20.6% 20.4% 0.1% 41.1% 0.5% 0.8% 14.0% 13.6% 29.0% 0.1% 0.1% 0.1% 5.5% 5.5% 4.6% 4.5% 20.1% 14.1% 10.9% 0.3% 3.7% 20.3% 1.1% 2.5% 28.6% 10.0% 10.5% 24.4% 0.2% 14.1% 20.3% 14.3% 3.7% 4.0% 4.2% 3.0% 3.5% 4.1% 22.5% 25.6% 2.7% 23.3% 0.8% 22.2% 49.0% 5.8% 4.9% 4.3% 4.7% 19.8% 20.3% 0.2% 46.2% COMPXM INQUIRER http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport Page 9 10/24 7/25/2016 COMPXM INQUIRER Top Perceptual Map Round: 4 December 31, 2019 Ka Chun Chan Perceptual Map for All Segments Andrews Name Ark Ant Ace Awe Apple Angle Amy Aron Pfmn 11.2 14.2 14.2 9.0 11.6 11.6 8.0 14.5 Size 9.0 3.8 7.2 11.5 8.3 8.3 11.1 7.4 Baldwin Revised 12/26/2019 12/26/2019 12/24/2019 12/24/2019 12/25/2019 12/25/2019 12/21/2019 12/25/2019 Name Bit Bolt Best Brat Digby Name Dim Dome Dug Drat Pfmn 13.8 16.9 14.2 16.7 Size 3.8 6.3 3.5 6.0 Revised 9/13/2019 8/21/2019 8/13/2019 8/21/2019 Pfmn 8.3 8.5 11.0 11.7 Size 11.8 11.6 8.4 8.9 Chester Revised 6/10/2019 6/10/2019 12/14/2019 12/14/2019 Name City Cozy Cute Crimp Cake Cedar Pfmn 8.0 8.9 13.1 16.5 10.9 10.6 Size 12.1 11.2 4.0 6.8 9.0 9.4 Revised 12/20/2018 12/6/2016 12/21/2019 12/21/2019 12/14/2019 12/14/2019 COMPXM INQUIRER http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport Page 10 11/24 7/25/2016 COMPXM INQUIRER Top HR/TQM Report Round: 4 December 31, 2019 Ka Chun Chan HUMAN RESOURCES SUMMARY Needed Complement Andrews 357 Baldwin 250 Chester 405 Digby 591 Complement 357 250 405 591 1st Shift Complement 2nd Shift Complement 186 171 200 50 299 106 335 256 Overtime% 0.0% 0.0% 0.0% 0.0% Turnover Rate New Employees Separated Employees 6.2% 22 279 8.0% 20 52 6.2% 27 0 10.0% 194 0 $5,000 80 118.1% $2,500 40 118.9% $5,000 80 133.0% $0 0 100.0% $134 $1,395 $70 $258 $164 $0 $194 $0 $571 $2,100 $200 $528 $648 $813 $0 $194 $31.04 $31.04 $31.04 $31.04 2,500 2.0% 5.0% 2,500 2.0% 5.0% 2,500 2.0% 5.0% 2,500 2.0% 5.0% Recruiting Spend Training Hours Productivity Index 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 Vendor/JIT 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 Andrews Baldwin Chester Digby $1 $1 $1 $1 $1 $1 $1,250 $1,250 $0 $1,500 $0 $0 $1,500 $1,500 $0 $0 $0 $1,500 $0 $0 $1,250 $1,250 $1,250 $0 $1 $1 $1 $1 $10 $0 $0 $750 $750 $5,500 $1,500 $0 $0 $0 $6,000 $0 $0 $1,250 $1,250 $6,250 11.79% 14.00% 40.01% 60.02% 14.40% 10.20% 4.39% 0.00% 34.91% 10.57% 6.07% 0.28% 0.00% 60.02% 2.35% 9.48% 14.00% 40.01% 0.00% 12.78% COMPXM INQUIRER http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport Page 11 12/24 7/25/2016 COMPXM INQUIRER PRINT Annual Report http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport 13/24 7/25/2016 COMPXM INQUIRER Top Annual Report Andrews Round: 4 Dec. 31, 2019 C59559 Balance Sheet ASSETS DEFINITIONS: Common Size: The common size column simply represents each item as a percentage of total assets for that year. Cash: Your endofyear cash position. Accounts Receivable: Reflects the lag between delivery and payment of Cash your products. Inventories: The current value of your inventory Accounts Receivable across all products. A zero indicates your company stocked out. Inventory Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Deprec: Total Current Assets The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for Plant & Equipment materials and services. Current Debt: The debt the company is Accumulated Depreciation obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you Total Fixed Assets run out of cash during the year. Long Term Debt: The company's long term debt is in the form of bonds, and this Total Assets represents the total value of your bonds. Common Stock: The amount of capital invested by shareholders in the company. Retained Earnings: The profits that the company chose to keep LIABILITIES & OWNERS' EQUITY instead of paying to shareholders as dividends. Accounts Payable Current Debt Long Term Debt 2019 Common Size 0.0% 8.8% 7.5% $0 $23,891 $17,747 $48,387 16.3% 120.3% 36.6% $269,512 ($84,828) $248,850 83.7% $184,684 $297,237 100.0% $226,323 $11,581 $11,968 $70,909 3.9% 4.0% 23.9% $12,078 $4,877 $70,909 $24,148 $178,630 $94,458 31.8% 8.1% 60.1% $24,148 $114,311 $0 $26,195 $22,192 $357,512 ($108,662) 2018 $41,638 Total Liabilities Total Equity $202,778 68.2% $138,459 Total Liab. & O. Equity $297,237 100.0% $226,323 Common Stock Retained Earnings $87,864 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. Cash Flows from Operating Activities: Net Income (Loss) Depreciation Extraordinary gains/losses/writeoffs Accounts Payable Inventory Accounts Receivable Net cash from operations 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 Annual Report http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport 2019 $64,319 $23,834 $0 ($496) ($4,444) ($2,304) $80,908 ($88,000) $0 $0 $0 $0 $0 $7,092 $7,092 $0 $0 2018 $40,716 $17,967 $0 $3,919 $7,717 ($5,761) $64,559 ($44,624) $0 $0 $0 $0 $0 ($19,935) ($19,935) $0 $0 Page 1 14/24 7/25/2016 COMPXM INQUIRER Top Annual Report (Product Name:) Ark $51,766 $4,195 $20,461 $1,090 $25,747 Andrews Ant $67,622 $2,749 $22,419 $29 $25,198 Round: 4 Dec. 31, 2019 C59559 2019 Income Statement Ace Awe Apple Angle Sales $53,663 $43,037 $26,734 $26,734 Variable Costs: Direct Labor $2,466 $3,323 $3,922 $3,922 Direct Material $16,940 $16,838 $8,577 $8,577 Inventory Carry $730 $394 $0 $0 Total Variable $20,136 $20,555 $12,500 $12,500 Contribution Margin $26,020 $42,424 $33,527 $22,482 $14,235 $14,235 Period Costs: Depreciation $4,600 $3,153 $3,416 $4,692 $1,993 $1,993 SG&A: R&D $1,000 $1,000 $994 $994 $995 $995 Promotions $1,600 $1,600 $1,500 $1,600 $2,000 $2,000 Sales $3,800 $3,000 $2,500 $4,000 $1,700 $1,500 Admin $486 $635 $504 $404 $251 $251 Total Period $11,486 $9,387 $8,914 $11,690 $6,939 $6,739 Net Margin $14,534 $33,037 $24,613 $10,792 $7,295 $7,495 Definitions: Sales: Unit sales times list price. Direct Labor: Labor costs incurred to produce the product that was sold. Inventory Carry Cost: the cost to carry unsold goods in inventory. Depreciation: Calculated on straightline 15year depreciation of plant value. R&D Costs: R&D department expenditures for each product. Admin: Administration overhead is estimated at 1.5% of sales. Promotions: The promotion budget for each product. Sales: The sales force budget for each product. Other: Charges not included in other categories such as Fees, Write Offs, and TQM. The fees include money paid to investment bankers and brokerage firms to issue new stocks or bonds plus consulting fees your instructor might assess. Writeoffs 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 year's 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. 2019 Total $318,711 Common Size 100.0% $27,485 $108,977 $2,663 $139,125 8.6% 34.2% 0.8% 43.7% $19,238 $179,586 56.3% $1,993 $995 $2,000 $1,000 $318 $6,306 $23,834 $7,958 $13,500 $19,500 $2,992 $67,784 7.5% 2.5% 4.2% 6.1% 0.9% 21.3% $1,104 $12,932 Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit $111,802 35.1% $10 $111,792 $1,894 $8,926 $35,340 $1,313 $64,319 0.0% 35.1% 0.6% 2.8% 11.1% 0.4% 20.2% Amy $15,290 $2,984 $4,460 $420 $7,864 Aron $33,863 $3,922 $10,703 $0 $14,626 $7,426 $1,993 $985 $1,200 $2,000 $144 $6,322 Annual Report http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport Page 2 15/24 7/25/2016 COMPXM INQUIRER PRINT Annual Report http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport 16/24 7/25/2016 COMPXM INQUIRER Top Annual Report Baldwin Round: 4 Dec. 31, 2019 C59559 Balance Sheet ASSETS DEFINITIONS: Common Size: The common size column simply represents each item as a percentage of total assets for that year. Cash: Your endofyear cash position. Accounts Receivable: Reflects the lag between delivery and payment of Cash your products. Inventories: The current value of your inventory Accounts Receivable across all products. A zero indicates your company stocked out. Inventory Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Deprec: Total Current Assets The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for Plant & Equipment materials and services. Current Debt: The debt the company is Accumulated Depreciation obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you Total Fixed Assets run out of cash during the year. Long Term Debt: The company's long term debt is in the form of bonds, and this Total Assets represents the total value of your bonds. Common Stock: The amount of capital invested by shareholders in the company. Retained Earnings: The profits that the company chose to keep LIABILITIES & OWNERS' EQUITY instead of paying to shareholders as dividends. Accounts Payable Current Debt Long Term Debt $26,214 $9,609 $10,906 $227,700 ($107,829) 2019 Common Size 15.7% 5.8% 6.5% 2018 $34,098 $9,302 $8,046 $46,729 28.0% 136.7% 64.7% $227,700 ($92,649) $51,446 $119,871 72.0% $135,051 $166,600 100.0% $186,498 $5,572 $20,876 $73,469 3.3% 12.5% 44.1% $5,621 $26,769 $83,764 $43,710 $22,973 $99,917 60.0% 26.2% 13.8% $116,154 Total Liabilities Total Equity $66,683 40.0% $70,344 Total Liab. & O. Equity $166,600 100.0% $186,498 Common Stock Retained Earnings $43,710 $26,634 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. Cash Flows from Operating Activities: Net Income (Loss) Depreciation Extraordinary gains/losses/writeoffs Accounts Payable Inventory Accounts Receivable Net cash from operations 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 Annual Report http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport 2019 $2,154 $15,180 ($736) ($48) ($2,860) ($307) $13,383 $0 ($5,815) $0 $0 $0 ($9,559) ($5,893) ($21,267) ($7,884) $26,214 2018 ($3,766) $15,180 ($175) ($1,771) $1,080 $2,040 $12,587 ($12,200) $0 $6,561 $0 $0 ($1,595) ($14,362) ($9,397) ($9,010) $34,098 Page 1 17/24 7/25/2016 COMPXM INQUIRER Top Annual Report (Product Name:) Bolt $24,978 $2,399 $11,278 $245 $13,922 Round: 4 Dec. 31, 2019 C59559 2019 Income Statement Best Brat Na Na Sales $32,674 $34,479 $0 $0 Variable Costs: Direct Labor $6,120 $5,677 $0 $0 Direct Material $12,816 $13,254 $0 $0 Inventory Carry $355 $470 $0 $0 Total Variable $19,291 $19,401 $0 $0 Contribution Margin $11,144 $11,056 $13,383 $15,079 $0 $0 Period Costs: Depreciation $4,447 $4,907 $2,660 $3,167 $0 $0 SG&A: R&D $446 $446 $966 $966 $0 $0 Promotions $1,300 $1,300 $1,300 $1,300 $0 $0 Sales $1,600 $1,600 $1,400 $1,400 $0 $0 Admin $225 $227 $296 $313 $0 $0 Total Period $8,017 $8,479 $6,622 $7,145 $0 $0 Net Margin $3,127 $2,577 $6,760 $7,933 $0 $0 Definitions: Sales: Unit sales times list price. Direct Labor: Labor costs incurred to produce the product that was sold. Inventory Carry Cost: the cost to carry unsold goods in inventory. Depreciation: Calculated on straightline 15year depreciation of plant value. R&D Costs: R&D department expenditures for each product. Admin: Administration overhead is estimated at 1.5% of sales. Promotions: The promotion budget for each product. Sales: The sales force budget for each product. Other: Charges not included in other categories such as Fees, Write Offs, and TQM. The fees include money paid to investment bankers and brokerage firms to issue new stocks or bonds plus consulting fees your instructor might assess. Writeoffs 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 year's 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 Bit $24,777 $2,447 $10,946 $239 $13,633 Baldwin 2019 Total $116,908 Common Size 100.0% $16,644 $48,294 $1,309 $66,247 14.2% 41.3% 1.1% 56.7% $0 $50,662 43.3% $0 $0 $0 $0 $0 $0 $15,180 $2,824 $5,200 $6,000 $1,060 $30,264 13.0% 2.4% 4.4% 5.1% 0.9% 25.9% $0 $20,398 17.4% $4,908 $15,490 $2,609 $9,499 $1,184 $44 $2,154 4.2% 13.2% 2.2% 8.1% 1.0% 0.0% 1.8% Na $0 $0 $0 $0 $0 Na $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit PRINT http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport Page 2 18/24 7/25/2016 COMPXM INQUIRER Annual Report http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport 19/24 7/25/2016 COMPXM INQUIRER Top Annual Report Chester Round: 4 Dec. 31, 2019 C59559 Balance Sheet ASSETS DEFINITIONS: Common Size: The common size column simply represents each item as a percentage of total assets for that year. Cash: Your endofyear cash position. Accounts Receivable: Reflects the lag between delivery and payment of Cash your products. Inventories: The current value of your inventory Accounts Receivable across all products. A zero indicates your company stocked out. Inventory Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Deprec: Total Current Assets The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for Plant & Equipment materials and services. Current Debt: The debt the company is Accumulated Depreciation obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you Total Fixed Assets run out of cash during the year. Long Term Debt: The company's long term debt is in the form of bonds, and this Total Assets represents the total value of your bonds. Common Stock: The amount of capital invested by shareholders in the company. Retained Earnings: The profits that the company chose to keep LIABILITIES & OWNERS' EQUITY instead of paying to shareholders as dividends. Accounts Payable Current Debt Long Term Debt 2019 Common Size 12.9% 5.9% 8.1% $27,394 $11,199 $7,346 $57,297 26.9% 122.4% 49.2% $260,940 ($87,596) $155,948 73.1% $173,344 $213,246 100.0% $219,284 $8,034 $24,825 $85,737 3.8% 11.6% 40.2% $6,416 $24,054 $101,719 $57,438 $37,212 $118,596 55.6% 26.9% 17.5% $132,189 $27,565 $12,515 $17,217 $260,940 ($104,992) 2018 $45,939 Total Liabilities Total Equity $94,650 44.4% $87,094 Total Liab. & O. Equity $213,246 100.0% $219,284 Common Stock Retained Earnings $52,673 $34,421 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. Cash Flows from Operating Activities: Net Income (Loss) Depreciation Extraordinary gains/losses/writeoffs Accounts Payable Inventory Accounts Receivable Net cash from operations 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 Annual Report http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport 2019 $2,791 $17,396 ($1,063) $1,618 ($9,871) ($1,316) $9,555 $0 $0 $4,765 $0 $0 ($14,920) $771 ($9,385) $170 $27,565 2018 ($5,248) $17,396 $0 ($268) $3,854 ($799) $14,936 ($45,180) $0 $15,547 $0 $20,216 $0 ($8,177) $27,586 ($2,658) $27,394 Page 1 20/24 7/25/2016 COMPXM INQUIRER Top Annual Report (Product Name:) Cozy $20,638 $1,778 $9,079 $300 $11,157 Round: 4 Dec. 31, 2019 C59559 2019 Income Statement Cute Crimp Cake Cedar Sales $36,130 $32,945 $20,740 $24,988 Variable Costs: Direct Labor $7,480 $5,341 $4,275 $5,056 Direct Material $15,000 $12,021 $9,236 $10,242 Inventory Carry $523 $612 $258 $204 Total Variable $23,004 $17,974 $13,769 $15,503 Contribution Margin $8,292 $9,481 $13,126 $14,971 $6,971 $9,485 Period Costs: Depreciation $3,833 $4,600 $1,927 $1,927 $2,635 $2,475 SG&A: R&D $0 $0 $985 $985 $966 $966 Promotions $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 Sales $1,000 $1,000 $2,400 $2,400 $900 $900 Admin $137 $168 $294 $268 $169 $203 Total Period $6,170 $6,968 $6,805 $6,779 $5,870 $5,744 Net Margin $2,122 $2,513 $6,321 $8,191 $1,101 $3,741 Definitions: Sales: Unit sales times list price. Direct Labor: Labor costs incurred to produce the product that was sold. Inventory Carry Cost: the cost to carry unsold goods in inventory. Depreciation: Calculated on straightline 15year depreciation of plant value. R&D Costs: R&D department expenditures for each product. Admin: Administration overhead is estimated at 1.5% of sales. Promotions: The promotion budget for each product. Sales: The sales force budget for each product. Other: Charges not included in other categories such as Fees, Write Offs, and TQM. The fees include money paid to investment bankers and brokerage firms to issue new stocks or bonds plus consulting fees your instructor might assess. Writeoffs 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 year's 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 City $16,829 $1,487 $6,882 $168 $8,537 Chester 2019 Total $152,270 Common Size 100.0% $25,417 $62,460 $2,066 $89,943 16.7% 41.0% 1.4% 59.1% $0 $62,327 40.9% $0 $0 $0 $0 $0 $0 $17,396 $3,902 $7,200 $8,600 $1,239 $38,337 11.4% 2.6% 4.7% 5.6% 0.8% 25.2% $0 $23,991 15.8% $5,399 $18,591 $3,078 $11,131 $1,534 $57 $2,791 3.5% 12.2% 2.0% 7.3% 1.0% 0.0% 1.8% Na $0 $0 $0 $0 $0 Na $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit PRINT http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport Page 2 21/24 7/25/2016 COMPXM INQUIRER Annual Report http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport 22/24 7/25/2016 COMPXM INQUIRER Top Annual Report Digby Round: 4 Dec. 31, 2019 C59559 Balance Sheet ASSETS DEFINITIONS: Common Size: The common size column simply represents each item as a percentage of total assets for that year. Cash: Your endofyear cash position. Accounts Receivable: Reflects the lag between delivery and payment of Cash your products. Inventories: The current value of your inventory Accounts Receivable across all products. A zero indicates your company stocked out. Inventory Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Deprec: Total Current Assets The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for Plant & Equipment materials and services. Current Debt: The debt the company is Accumulated Depreciation obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you Total Fixed Assets run out of cash during the year. Long Term Debt: The company's long term debt is in the form of bonds, and this Total Assets represents the total value of your bonds. Common Stock: The amount of capital invested by shareholders in the company. Retained Earnings: The profits that the company chose to keep LIABILITIES & OWNERS' EQUITY instead of paying to shareholders as dividends. Accounts Payable Current Debt Long Term Debt $36,587 $17,920 $25,878 2019 Common Size 23.6% 11.6% 16.7% $142,260 ($67,759) $80,385 51.9% 91.8% 43.7% 2018 $35,438 $14,240 $8,137 $142,260 ($58,275) $57,815 $74,501 48.1% $83,985 $154,886 100.0% $141,801 $11,531 $25,127 $27,604 7.4% 16.2% 17.8% $7,612 $18,527 $33,025 $8,972 $81,652 $64,262 41.5% 5.8% 52.7% $59,164 Total Liabilities Total Equity $90,624 58.5% $82,636 Total Liab. & O. Equity $154,886 100.0% $141,801 Common Stock Retained Earnings $9,255 $73,381 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. Cash Flows from Operating Activities: Net Income (Loss) Depreciation Extraordinary gains/losses/writeoffs Accounts Payable Inventory Accounts Receivable Net cash from operations 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 Annual Report http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport 2019 $36,130 $9,484 ($153) $3,919 ($17,741) ($3,680) $27,958 $0 ($25,614) $0 ($2,527) $0 ($5,268) $6,600 ($26,809) $1,149 $36,587 2018 $21,125 $9,484 $0 ($987) $10,720 ($1,371) $38,971 ($29,700) ($1,738) $0 ($1,920) $8,206 $0 ($9,556) ($5,008) $4,263 $35,438 Page 1 23/24 7/25/2016 COMPXM INQUIRER Top Annual Report (Product Name:) Digby Dim Dome 2019 Income Statement Dug Drat Round: 4 Dec. 31, 2019 C59559 Na Na Sales $61,075 $50,498 $49,210 $57,244 $0 $0 Variable Costs: Direct Labor $12,055 $9,843 $8,289 $9,876 $0 $0 Direct Material $23,092 $20,392 $17,698 $21,302 $0 $0 Inventory Carry $1,025 $0 $887 $1,193 $0 $0 Total Variable $36,172 $30,235 $26,874 $32,372 $0 $0 Contribution Margin $24,904 $20,264 $22,336 $24,872 $0 $0 Period Costs: Depreciation $2,684 $1,700 $2,380 $2,720 $0 $0 SG&A: R&D $710 $645 $623 $645 $0 $0 Promotions $1,400 $1,400 $1,400 $1,400 $0 $0 Sales $1,100 $1,000 $1,000 $1,000 $0 $0 Admin $482 $398 $388 $452 $0 $0 Total Period $6,375 $5,143 $5,791 $6,217 $0 $0 Net Margin $18,528 $15,120 $16,545 $18,655 $0 $0 Definitions: Sales: Unit sales times list price. Direct Labor: Labor costs incurred to produce the product that was sold. Inventory Carry Cost: the cost to carry unsold goods in inventory. Depreciation: Calculated on straightline 15year depreciation of plant value. R&D Costs: R&D department expenditures for each product. Admin: Administration overhead is estimated at 1.5% of sales. Promotions: The promotion budget for each product. Sales: The sales force budget for each product. Other: Charges not included in other categories such as Fees, Write Offs, and TQM. The fees include money paid to investment bankers and brokerage firms to issue new stocks or bonds plus consulting fees your instructor might assess. Writeoffs 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 year's 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. 2019 Total $218,027 Common Size 100.0% $40,063 $82,484 $3,105 $125,653 18.4% 37.8% 1.4% 57.6% $0 $92,375 42.4% $0 $0 $0 $0 $0 $0 $9,484 $2,622 $5,600 $4,100 $1,720 $23,527 4.3% 1.2% 2.6% 1.9% 0.8% 10.8% $0 $68,848 31.6% $6,214 $62,634 $2,613 $3,302 $19,851 $737 $36,130 2.9% 28.7% 1.2% 1.5% 9.1% 0.3% 16.6% Na Na $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Annual Report http://ww2.capsim.com/cgibin/CpCGIReports2011.exe?studentKey=1333122&simid=C59559&round=8&Report=CapCourier|AnnReport Page 2 24/24

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

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions