Question

1 Approved Answer

Posted on Jun 26, 2024

1.Digby's balance sheet has $86,494,000 in equity. If next year, assets decrease by $4,000,000 and liabilities increase by $2,000,000, what will be Digby's book value?

1.Digby's balance sheet has $86,494,000 in equity. If next year, assets decrease by $4,000,000 and liabilities increase by $2,000,000, what will be Digby's book value? Select: 1 $32,712,000 $84,494,000 $80,494,000 $88,494,000 2. Which company has the least efficient SG&A/Sales ratio? Digby Chester Andrews Baldwin 3.Your Competitive Intelligence team reports that a wave of product liability lawsuits is likely to cause Digby to pull the product Drum entirely off the market this year. Assume Digby 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 Digby or other companies. Without Digby's product Drum 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 5085 4383 10170 7475 8452 9602 8625 4. In the Month of March, Baldwin received orders of 102 units at a price of $15.00 for their product Bit. Baldwin uses the accrual method of accounting and offers 30 day credit terms. Baldwin delivers 102 units in April. They received payment for 51 units in March, and 51 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 $1,530 , 0 0, $1,530 0, $765 $765 , $765 5. Assume Baldwin is paying a dividend of $1.50 (per share). If this dividend stayed the same, but the stock price rose by 10% what would be the dividend yield? Select 1 3.21% 3.53% 2.88% 31.21% 6. Last year Ark charged $3,751,333 Depreciation on the Income Statement of Andrews. If early this year Ark sold all its depreicable assets for their book value, the effect on Andrews's financial statements would be (all other items remaining equal): Select 1 No impact on Net Cash from operations Decrease Net Cash from operations on the Cash Flow Statement Increase Net Cash from operations Just impact the Balance Sheet 7. Assume Digby Corp. is downsizing the size of their workforce by 10% (to the nearest person) next year from various strategic initiatives. Digby is planning to conduct exit interviews to learn more about how they can improve in processes and increase productivity. The exit interviews are estimated to cost $100 per employee in additional to normal separation costs of $5000. How much will the company pay in separation costs if these exit interviews are implemented next year? Select 1 $198,900 $1,790,100 $81,900 $737,100 8. The Baldwin company wants to decrease its plant utilization for Bolt by 15%. How many units would need to be produced next year to meet this production goal? Ignore impact of accounts payable on plant utilization. Select 1 1570 2079 1847 2312 COMP-XM INQUIRER Page Page Page Page 1 2 3 4 Front Page Stocks & Bonds Financial Summary Production Analysis Annual Report Andrews Page Page Page Page 5 6 7 8 Thrift Segment Analysis Core Segment Analysis Nano Segment Analysis 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 Top " Round: 4 Dec. 31, 2017 Student: Yiming Wang Andrews Yiming Wang Baldwin Yiming Wang Chester Digby Selected Financial Statistics Andrews 11.6% 1.07 12.4% 1.9 23.0% $0 $205,495,261 $46,047,480 $23,779,541 $70,001,491 11.4% 43.8% ROS Asset Turnover ROA Leverage (Assets/Equity) ROE Emergency Loan Sales EBIT Profits Cumulative Profit SG&A / Sales Contrib. Margin % Baldwin 4.4% 0.78 3.4% 2.2 7.6% $0 $182,525,519 $27,845,738 $8,095,265 $14,060,879 11.7% 39.6% Chester 17.3% 1.45 25.1% 1.7 41.8% $0 $241,212,899 $71,909,551 $41,813,850 $92,635,782 5.9% 42.4% Digby 4.8% 0.73 3.5% 2.4 8.5% $0 $151,194,139 $26,063,653 $7,326,397 $11,946,753 10.1% 41.7% Page 1 COMP-XM INQUIRER Top Round: 4 Stocks & Bonds Yiming Wang December 31 , 2017 Stock Market Summary Company Andrews Baldwin Chester Close Change Shares $116.72 $42.55 $163.92 $14.19 $10.23 $60.25 2,038,643 3,147,780 1,856,943 MarketCap Book Value ($M) $238 $50.65 $134 $33.89 $304 $53.85 EPS Dividend Yield P/E $11.66 $2.57 $22.52 $8.00 $0.00 $15.27 6.9% 0.0% 9.3% 10.0 16.5 7.3 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER Digby $35.30 $10.73 3,356,933 $119 $25.77 $2.18 $2.14 6.1% 16.2 Bond Market Summary Company Andrews Series# Face Yield Close$ S&P 11.2S2020 11.9S2021 10.9S2024 11.2S2026 11.8S2027 $4,762,431 $7,072,000 $14,000,000 $30,000,000 $12,000,000 11.6% 12.2% 11.9% 12.2% 12.5% 96.21 97.31 91.54 91.73 94.53 BB BB BB BB BB 11.9S2023 12.5S2024 13.1S2025 13.8S2026 $14,750,579 $17,785,485 $35,198,836 $19,221,223 12.9% 13.2% 13.5% 13.8% 92.57 94.39 96.73 100.00 CCC CCC CCC CCC 11.2S2023 11.5S2024 11.7S2025 12.6S2026 $2,996,108 $1,278,536 $17,495,801 $8,095,568 11.7% 11.9% 12.0% 12.3% 95.91 96.83 97.53 102.11 BBB BBB BBB BBB 12.5S2021 12.5S2022 12.5S2023 12.9S2024 13.4S2025 14.2S2026 $11,708,620 $7,987,653 $9,474,381 $14,417,355 $34,603,544 $6,818,656 13.1% 13.2% 13.3% 13.6% 13.8% 14.1% 95.35 94.52 93.80 94.87 96.76 100.49 CC CC CC CC CC CC Baldwin Chester Digby Next Year's Prime Rate 9.00% Page 2 COMP-XM INQUIRER Top Financial Summary Cash Flow Statement Survey Cash flows from operating activities Net Income (Loss) Adjustment for non-cash items: Depreciation Extraordinary gains/losses/writeoffs Changes in current assets and liabilities: Accounts payable Inventory Accounts receivable Net cash from operations 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 Net cash from financing activities Net change in cash position Round: 4 December 31, 2017 Yiming Wang Andrews Baldwin Chester Digby $23,780 $8,095 $41,814 $7,326 $13,471 ($75) $17,663 ($916) $9,937 ($169) $16,950 ($895) $2,383 ($20,643) ($2,179) $16,736 $1,298 ($13,413) ($829) $11,897 $532 $698 ($3,455) $49,357 $1,118 ($18,833) ($180) $5,488 ($19,200) $0 $0 $0 ($16,309) $0 ($1,000) $12,000 ($4,000) $0 $10,000 $0 $0 $288 $0 $0 ($14,388) ($25,865) $31,928 $0 ($28,358) $0 ($3,799) $0 ($5,046) ($20,369) $25,886 $0 ($7,193) $0 $0 $0 ($12,480) ($28,901) $27,830 $0 $691 ($1,773) ($8,037) $3,860 ($31,686) $17,671 ($20,744) ($15,256) http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets Plant and equipment Accumulated Depreciation Total Fixed Assets Total Assets Andrews $16,987 $16,890 $24,181 $58,058 $221,260 ($87,272) $133,988 $192,046 Baldwin $39,425 $15,002 $21,889 $76,316 $264,940 ($105,752) $159,188 $235,504 Chester $43,966 $19,826 $23,099 $86,891 $149,060 ($69,072) $79,988 $166,879 Digby $32,854 $12,427 $20,979 $66,260 $254,252 ($112,589) $141,663 $207,923 Accounts Payable Current Debt Long Term Debt Total Liabilities Common Stock Retained Earnings Total Equity Total Liabilities & Owners' Equity $10,946 $10,000 $67,834 $88,780 $12,772 $90,494 $103,266 $192,046 $9,953 $31,928 $86,956 $128,837 $53,692 $52,976 $106,668 $235,504 $11,129 $25,886 $29,866 $66,881 $10,566 $89,432 $99,998 $166,879 $8,589 $27,830 $85,010 $121,429 $51,782 $34,712 $86,494 $207,923 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 $205,495 $115,431 $13,471 $23,445 $7,100 $46,047 $8,717 $13,066 $485 $23,780 Baldwin $182,526 $110,304 $17,663 $21,399 $5,315 $27,846 $15,137 $4,448 $165 $8,095 Chester $241,213 $138,872 $9,937 $14,280 $6,213 $71,910 $6,268 $22,975 $853 $41,814 Digby $151,194 $88,178 $16,950 $15,209 $4,793 $26,064 $14,562 $4,025 $150 $7,326 Page 3 COMP-XM INQUIRER Top Production Analysis Round: 4 December 31, 2017 Yiming Wang Production Information 2nd Shift & Name Ark Ant Ace Awe Acs Ads Bit Primary Segment Core Nano Elite Thrift Thrift Unit Units Inven Age Pfmn Size Sold tory Revision Date Dec.31 MTBF Coord Coord 2,187 1,526 1,662 1,695 0 0 1,221 585 257 95 781 0 0 413 9/12/2016 3/11/2017 3/11/2017 5/15/2017 2/17/2018 3/6/2018 12/19/2016 2.5 1.6 1.6 1.8 0.0 0.0 3.2 22000 24000 26000 20000 0 0 14000 11.0 12.3 15.0 7.7 0.0 0.0 8.8 9.5 5.0 7.7 12.1 0.0 0.0 11.2 Auto mation Capacity Material Labor Contr. OverNext Next Price Cost Cost Marg. time Round Round $26.00 $36.00 $38.00 $18.00 $0.00 $0.00 $15.00 $9.10 $11.67 $12.21 $6.57 $0.00 $0.00 $5.93 $5.90 $6.54 $6.74 $4.35 $0.00 $0.00 $1.36 40% 47% 49% 35% 0% 0% 48% 69% 15% 24% 58% 0% 0% 32% 7.0 6.0 6.0 8.0 7.0 6.0 10.0 1,655 1,483 1,369 1,585 300 300 1,250 Plant Utiliz. 168% 114% 123% 156% 0% 0% 131% http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER Bolt Buzz Brat Baker Bead City Cozy Cute Crimp Dim Dome Drum Drat Thrift Nano Elite Core Core Nano Elite Nano Elite Thrift Thrift Core Core 1,446 1,449 1,029 1,545 1,736 2,005 1,692 1,490 1,633 1,796 1,820 2,052 1,990 634 194 238 239 195 347 101 347 368 382 556 313 639 12/7/2014 12/21/2017 12/21/2017 12/14/2017 12/14/2017 9/13/2017 8/21/2017 8/13/2017 8/21/2017 6/10/2017 6/1/2017 12/14/2017 12/14/2017 4.1 1.0 1.0 1.0 1.0 1.3 1.6 1.4 1.3 2.6 2.6 1.6 1.6 16000 18000 20000 16000 16000 23000 25000 23000 25000 17000 17000 18000 20000 9.7 13.9 17.3 11.7 11.4 14.6 17.7 15.0 17.5 9.1 9.3 11.8 12.5 10.3 3.1 5.9 8.1 8.5 2.9 5.4 2.6 5.1 10.9 10.7 7.5 8.0 $17.00 $28.00 $34.00 $19.00 $20.00 $34.00 $34.00 $37.00 $37.00 $15.00 $15.00 $23.00 $25.00 $7.14 $11.83 $12.62 $8.63 $8.38 $13.04 $13.82 $13.28 $13.83 $6.69 $6.82 $9.03 $9.64 $1.37 $5.77 $5.33 $4.40 $4.48 $6.63 $6.63 $6.09 $5.90 $1.44 $1.43 $4.76 $4.73 46% 35% 36% 61% 46% 24% 31% 73% 36% 88% 41% 100% 39% 100% 45% 41% 44% 28% 45% 35% 44% 31% 40% 100% 41% 93% 10.0 7.0 7.0 8.0 8.0 7.0 7.0 7.0 7.0 10.0 10.0 8.0 8.0 1,550 900 850 1,040 1,040 1,100 800 1,100 1,250 1,631 1,831 1,150 1,350 134% 160% 122% 171% 186% 198% 198% 140% 127% 134% 130% 198% 191% Page 4 COMP-XM INQUIRER Top Thrift Market Segment Analysis Thrift Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry Round: 4 December 31, 2017 7,743 7,743 25.8% Next Year's Segment Growth Rate Yiming Wang 11.0% 1. 2. 3. 4. Thrift Customer Buying Criteria Expectations Price $14.00 - 26.00 Reliability MTBF 14000-20000 Ideal Position Pfmn 8.8 Size 11.2 Age Ideal Age = 3.0 Importance 55% 20% 15% 10% Perceptual Map for Thrift Segment Top Products in Thrift Segment Market Name Share Dim 22% Dome 22% Awe 22% Bit 15% Bolt 12% Ark 3% Units Sold to Seg 1,722 1,705 1,695 1,179 907 229 Revision Stock Date Out 6/10/2017 6/1/2017 5/15/2017 12/19/2016 12/7/2014 9/12/2016 Pfmn Coord 9.1 9.3 7.7 8.8 9.7 11.0 Size Coord 10.9 10.7 12.1 11.2 10.3 9.5 List Price $15.00 $15.00 $18.00 $15.00 $17.00 $26.00 MTBF 17000 17000 20000 14000 16000 22000 Age Dec.31 2.65 2.61 1.80 3.25 4.11 2.54 Promo Budget $1,300 $1,300 $2,000 $1,200 $1,200 $2,000 Cust. Awareness 83% 83% 100% 72% 72% 100% Cust. Sales AccessBudget ibility $1,600 83% $1,600 83% $2,000 92% $1,000 78% $1,000 78% $2,000 92% Dec. Cust. Survey 69 67 63 46 36 13 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER Bead Baker Drum 3% 1% 0% 207 96 3 12/14/2017 12/14/2017 12/14/2017 11.4 11.7 11.8 8.5 8.1 7.5 $20.00 $19.00 $23.00 16000 16000 18000 0.96 0.96 1.56 $1,200 $1,200 $1,300 62% 67% 83% $900 $900 $1,400 78% 78% 83% 2 0 0 Page 5 COMP-XM INQUIRER Top Core Market Segment Analysis Core Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry Round: 4 December 31, 2017 9,775 9,775 32.6% Next Year's Segment Growth Rate Yiming Wang 10.0% 1. 2. 3. 4. Core Customer Buying Criteria Expectations Price $20.00 - 32.00 Age Ideal Age = 2.0 Reliability MTBF 16000-22000 Ideal Position Pfmn 12.1 Size 7.9 Importance 46% 20% 18% 16% Perceptual Map for Core Segment Top Products in Core Segment Name Drum Drat Ark Bead Baker Bolt Dome Dim Ant Bit Market Share 21% 20% 20% 16% 15% 6% 1% 1% 0% 0% Units Sold to Seg 2,044 1,982 1,959 1,529 1,449 539 115 74 43 42 Revision Stock Date Out 12/14/2017 12/14/2017 9/12/2016 12/14/2017 12/14/2017 12/7/2014 6/1/2017 6/10/2017 3/11/2017 12/19/2016 Pfmn Coord 11.8 12.5 11.0 11.4 11.7 9.7 9.3 9.1 12.3 8.8 Size Coord 7.5 8.0 9.5 8.5 8.1 10.3 10.7 10.9 5.0 11.2 List Price $23.00 $25.00 $26.00 $20.00 $19.00 $17.00 $15.00 $15.00 $36.00 $15.00 MTBF 18000 20000 22000 16000 16000 16000 17000 17000 24000 14000 Age Dec.31 1.56 1.57 2.54 0.96 0.96 4.11 2.61 2.65 1.63 3.25 Promo Budget $1,300 $1,300 $2,000 $1,200 $1,200 $1,200 $1,300 $1,300 $2,500 $1,200 Cust. Awareness 83% 83% 100% 62% 67% 72% 83% 83% 100% 72% Cust. Sales AccessBudget ibility $1,400 81% $1,400 81% $2,000 74% $900 73% $900 73% $1,000 73% $1,600 81% $1,600 81% $2,500 74% $1,000 73% Dec. Cust. Survey 53 52 44 39 37 10 3 2 3 0 Page 6 COMP-XM INQUIRER Top Nano Market Segment Analysis Yiming Wang Round: 4 December 31, 2017 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER Nano Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 6,162 6,162 20.6% Next Year's Segment Growth Rate 14.0% 1. 2. 3. 4. Nano Customer Buying Criteria Expectations Ideal Position Pfmn 14.0 Size 2.8 Price $28.00 - 40.00 Age Ideal Age = 1.0 Reliability MTBF 18000-24000 Importance 35% 27% 20% 18% Perceptual Map for Nano Segment Top Products in Nano Segment Name City Cute Buzz Ant Ace Crimp Drum Drat Market Share 29% 23% 23% 23% 1% 0% 0% 0% Units Sold to Seg 1,809 1,435 1,432 1,416 45 17 4 3 Revision Stock Date Out 9/13/2017 8/13/2017 12/21/2017 3/11/2017 3/11/2017 8/21/2017 12/14/2017 12/14/2017 Pfmn Size Coord Coord 14.6 2.9 15.0 2.6 13.9 3.1 12.3 5.0 15.0 7.7 17.5 5.1 11.8 7.5 12.5 8.0 List Price $34.00 $37.00 $28.00 $36.00 $38.00 $37.00 $23.00 $25.00 MTBF 23000 23000 18000 24000 26000 25000 18000 20000 Age Dec.31 1.27 1.36 1.02 1.63 1.62 1.35 1.56 1.57 Promo Budget $1,400 $1,400 $1,200 $2,500 $2,500 $1,400 $1,300 $1,300 Cust. Awareness 92% 92% 73% 100% 100% 91% 83% 83% Cust. Sales AccessBudget ibility $1,100 80% $1,000 80% $2,400 74% $2,500 89% $2,500 89% $1,000 80% $1,400 12% $1,400 12% Dec. Cust. Survey 66 51 56 39 0 0 0 0 Page 7 COMP-XM INQUIRER Top Elite Market Segment Analysis Elite Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry Round: 4 December 31, 2017 6,295 6,295 21.0% Next Year's Segment Growth Rate Yiming Wang 16.0% http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER 1. 2. 3. 4. Elite Customer Buying Criteria Expectations Age Ideal Age = 0.0 Price $30.00 - 42.00 Ideal Position Pfmn 17.2 Size 6.0 Reliability MTBF 20000-26000 Importance 34% 24% 22% 20% Perceptual Map for Elite Segment Top Products in Elite Segment Name Cozy Ace Crimp Brat City Ant Cute Buzz Drat Market Share 27% 26% 26% 16% 3% 1% 1% 0% 0% Units Sold to Seg 1,692 1,617 1,616 1,029 196 67 54 18 6 Revision Stock Date Out 8/21/2017 3/11/2017 8/21/2017 12/21/2017 9/13/2017 3/11/2017 8/13/2017 12/21/2017 12/14/2017 Pfmn Size Coord Coord 17.7 5.4 15.0 7.7 17.5 5.1 17.3 5.9 14.6 2.9 12.3 5.0 15.0 2.6 13.9 3.1 12.5 8.0 List Price $34.00 $38.00 $37.00 $34.00 $34.00 $36.00 $37.00 $28.00 $25.00 MTBF 25000 26000 25000 20000 23000 24000 23000 18000 20000 Age Dec.31 1.63 1.62 1.35 1.03 1.27 1.63 1.36 1.02 1.57 Promo Budget $1,400 $2,500 $1,400 $1,200 $1,400 $2,500 $1,400 $1,200 $1,300 Cust. Awareness 92% 100% 91% 72% 92% 100% 92% 73% 83% Cust. Sales AccessBudget ibility $1,000 87% $2,500 92% $1,000 87% $2,400 74% $1,100 87% $2,500 92% $1,000 87% $2,400 74% $1,400 5% Dec. Cust. Survey 54 38 50 37 0 0 0 0 0 Page 8 COMP-XM INQUIRER Top Market Share Report Yiming Wang Round: 4 December 31, 2017 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER Actual Market Share in Units Thrift Core Nano Elite Industry Unit Sales % of Market Ark Ant Ace Awe Total Bit Bolt Buzz Brat Baker Bead Total City Cozy Cute Crimp Total Dim Dome Drum Drat Total 7,743 9,775 6,162 Potential Market Share in Units Thrift Core Nano Elite Total 6,295 29,974 25.8% 32.6% 20.6% 21.0% 3.0% 20.0% 0.4% 23.0% 1.1% 0.7% 25.7% 21.9% 24.8% 20.5% 23.7% 26.8% 15.2% 0.4% 11.7% 5.5% 23.2% 0.3% 16.3% 1.2% 14.8% 2.7% 15.6% 30.9% 36.4% 23.2% 16.6% 29.4% 3.1% 26.9% 23.3% 0.9% 0.3% 25.7% 52.9% 56.5% 22.2% 0.8% 22.0% 1.2% 0.0% 20.9% 0.1% 20.3% 0.0% 0.1% 44.3% 43.1% 0.1% 0.1% 100.0% 7.3% 5.1% 5.5% 5.7% 23.6% 4.1% 4.8% 4.8% 3.4% 5.2% 5.8% 28.1% 6.7% 5.6% 5.0% 5.5% 22.8% 6.0% 6.1% 6.8% 6.6% 25.6% Units Demanded % of Market Ark Ant Ace Awe Total Bit Bolt Buzz Brat Baker Bead Total City Cozy Cute Crimp Total Dim Dome Drum Drat Total 7,743 Total 9,775 6,162 6,295 29,974 25.8% 32.6% 20.6% 21.0% 100.0% 3.0% 20.0% 0.4% 23.0% 0.7% 1.1% 25.7% 23.7% 26.8% 23.2% 0.3% 16.3% 23.2% 29.4% 16.6% 3.1% 26.9% 0.9% 25.7% 56.5% 21.9% 24.8% 15.2% 11.7% 1.2% 2.7% 30.9% 20.5% 0.4% 5.5% 14.8% 15.6% 36.4% 23.3% 0.3% 52.9% 22.2% 22.0% 44.3% 0.8% 1.2% 20.9% 20.3% 43.1% 0.1% 0.1% 0.1% 0.1% 7.3% 5.1% 5.5% 5.7% 23.6% 4.1% 4.8% 4.8% 3.4% 5.2% 5.8% 28.1% 6.7% 5.6% 5.0% 5.4% 22.8% 6.0% 6.1% 6.8% 6.6% 25.6% Page 9 COMP-XM INQUIRER Top Perceptual Map Yiming Wang Round: 4 December 31, 2017 Perceptual Map for All Segments http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER Name Ark Ant Ace Awe Name Dim Dome Drum Drat Andrews Size 9.5 5.0 7.7 12.1 Revised 9/12/2016 3/11/2017 3/11/2017 5/15/2017 Digby Size 10.9 10.7 7.5 8.0 Revised 6/10/2017 6/1/2017 12/14/2017 12/14/2017 Pfmn 11.0 12.3 15.0 7.7 Pfmn 9.1 9.3 11.8 12.5 Name Bit Bolt Buzz Brat Baker Bead Pfmn 8.8 9.7 13.9 17.3 11.7 11.4 Baldwin Size 11.2 10.3 3.1 5.9 8.1 8.5 Revised 12/19/2016 12/7/2014 12/21/2017 12/21/2017 12/14/2017 12/14/2017 Name City Cozy Cute Crimp Pfmn 14.6 17.7 15.0 17.5 Chester Size 2.9 5.4 2.6 5.1 Revised 9/13/2017 8/21/2017 8/13/2017 8/21/2017 Page 10 COMP-XM INQUIRER Top HR/TQM Report Yiming Wang Round: 4 December 31, 2017 HUMAN RESOURCES SUMMARY Needed Complement Complement 1st Shift Complement 2nd Shift Complement Overtime% Turnover Rate Andrews 707 707 508 199 Baldwin 490 490 315 176 Chester 575 575 351 223 Digby 390 390 221 168 0.1% 6.7% 0.0% 6.1% 0.0% 10.0% 0.0% 8.0% http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER New Employees Separated Employees Recruiting Spend Training Hours Productivity Index 196 0 $4,000 80 114.6% 30 45 $5,000 80 131.3% 57 42 $0 0 100.0% 31 20 $2,500 40 118.5% Recruiting Cost Separation Cost Training Cost Total HR Admin Cost $978 $0 $1,131 $2,109 $178 $224 $785 $1,187 $57 $212 $0 $270 $109 $101 $312 $521 Labor Contract Next Year Wages Benefits Profit Sharing Annual Raise $31.04 2,500 2.0% 5.0% $31.04 2,500 2.0% 5.0% $31.04 2,500 2.0% 5.0% $31.04 2,500 2.0% 5.0% 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 Andrews 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 Baldwin Chester Digby $500 $1,000 $500 $500 $1,000 $500 $1,500 $1,500 $0 $0 $0 $1,500 $0 $0 $1,250 $1,250 $1,250 $0 $1,250 $1,250 $0 $1,500 $0 $0 $500 $1,000 $500 $500 $6,500 $1,500 $0 $0 $0 $6,000 $0 $0 $1,250 $1,250 $6,250 $0 $0 $750 $750 $5,500 10.74% 11.58% 40.01% 60.02% 13.26% 6.07% 0.28% 0.00% 60.02% 2.35% 9.48% 14.00% 40.01% 0.00% 12.78% 10.20% 4.39% 0.00% 34.91% 10.57% Page 11 COMP-XM INQUIRER PRINT Annual Report Top Annual Report Andrews Round: 4 Dec. 31, 2017 C59559 Balance Sheet ASSETS 2017 2016 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER DEFINITIONS:Common Size: The common size column simply represents each item as a percentage of total assets for that year. Cash: Your end-of-year cash position. Accounts Receivable: Reflects the lag between delivery and payment of your products. Inventories: The current value of your inventory across all products. A zero indicates your company stocked out. Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for materials and services. Current Debt: The debt the company is obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company's long term debt is in the form of bonds, and this 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 instead of paying to shareholders as dividends. Common Size 8.8% 8.8% 12.6% $18,760 $14,711 $3,538 $58,058 30.2% 115.2% -45.4% $37,009 $202,060 ($73,802) Total Fixed Assets $133,988 69.8% $128,258 Total Assets $192,046 100.0% $165,267 5.7% 5.2% 35.3% $8,562 $0 $59,909 $88,780 46.2% 6.7% 47.1% $68,471 $12,906 $83,890 Total Equity $103,266 53.8% $96,796 Total Liab. & O. Equity $192,046 100.0% $165,267 Cash Accounts Receivable Inventory $16,987 $16,890 $24,181 Total Current Assets Plant & Equipment Accumulated Depreciation $221,260 ($87,272) LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $10,946 $10,000 $67,834 Total Liabilities Common Stock Retained Earnings $12,772 $90,494 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 2017 $23,780 $13,471 ($75) $2,383 ($20,643) ($2,179) $16,736 Net cash from financing activities Net change in cash position Closing cash position ($10,242) $0 $0 $30,000 $0 ($11,300) $691 ($1,773) $16,987 Change in current debt (net) ($60,060) ($16,309) $0 ($1,000) $12,000 ($4,000) $10,000 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 $31,261 ($19,200) Accounts Receivable 2016 $18,506 $13,471 $0 $1,071 ($3,011) $1,224 $8,458 ($20,341) $18,760 Page 1 Annual Report Top Annual Report Andrews Round: 4 Dec. 31, 2017 C59559 2017 Income Statement (Product Name:) Sales Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable Ark Ant Ace Awe Acs Ads Na Na $56,873 $54,942 $63,175 $30,506 $0 $0 $0 $0 2017 Common Total Size $205,495 100.0% $12,905 $20,405 $1,069 $34,379 $10,060 $18,284 $572 $28,916 $11,262 $20,793 $220 $32,275 $7,370 $11,450 $1,040 $19,861 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $41,598 $70,932 $2,902 $115,431 20.2% 34.5% 1.4% 56.2% http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER Contribution Margin Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $22,494 $26,025 $30,899 $10,645 $0 $0 $0 $0 $90,064 43.8% $3,751 $0 $2,000 $2,000 $743 $8,494 $2,966 $193 $2,500 $2,500 $718 $8,877 $2,738 $193 $2,500 $2,500 $825 $8,757 $4,015 $375 $2,000 $2,000 $398 $8,788 $0 $1,000 $0 $0 $0 $1,000 $0 $1,000 $0 $0 $0 $1,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $13,471 $2,762 $9,000 $9,000 $2,684 $36,916 6.6% 1.3% 4.4% 4.4% 1.3% 18.0% $0 $0 Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit $53,148 $7,100 $46,047 $1,040 $7,677 $13,066 $485 $23,780 25.9% 3.5% 22.4% 0.5% 3.7% 6.4% 0.2% 11.6% Net Margin $14,000 $17,148 $22,143 $1,857 ($1,000) ($1,000) 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 straight-line 15-year 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. Write-offs 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. Page 2 Annual Report PRINT Annual Report Top Annual Report Baldwin C59559 Round: 4 Dec. 31, 2017 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER Balance Sheet 2017 Common Size 16.7% 6.4% 9.3% $35,565 $14,173 $8,475 $76,316 32.4% 112.5% -44.9% $58,213 $264,940 ($88,089) Total Fixed Assets $159,188 67.6% $176,851 Total Assets $235,504 100.0% $235,064 4.2% 13.6% 36.9% $8,655 $25,865 $102,260 $128,837 54.7% 22.8% 22.5% $136,780 $53,404 $44,881 Total Equity $106,668 45.3% $98,285 Total Liab. & O. Equity DEFINITIONS:Common Size: The common size column simply represents each item as a percentage of total assets for that year. Cash: Your end-of-year cash position. Accounts Receivable: Reflects the lag between delivery and payment of your products. Inventories: The current value of your inventory across all products. A zero indicates your company stocked out. Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for materials and services. Current Debt: The debt the company is obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company's long term debt is in the form of bonds, and this 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 instead of paying to shareholders as dividends. ASSETS $235,504 100.0% $235,064 Cash Accounts Receivable Inventory $39,425 $15,002 $21,889 Total Current Assets Plant & Equipment Accumulated Depreciation $264,940 ($105,752) LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $9,953 $31,928 $86,956 Total Liabilities Common Stock Retained Earnings $53,692 $52,976 2016 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 2017 $8,095 $17,663 ($916) $1,298 ($13,413) ($829) $11,897 Net cash from financing activities Net change in cash position Closing cash position $0 $17,809 $0 $19,221 $0 ($8,410) ($8,037) $3,860 $39,425 Change in current debt (net) ($45,780) $0 $288 $0 $0 ($14,388) $6,063 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 $18,772 $0 Accounts Receivable 2016 $1,483 $17,663 $0 $1,445 $1,216 ($3,036) $28,621 $1,612 $35,565 Page 1 Annual Report Top Annual Report Baldwin Round: 4 Dec. 31, 2017 C59559 2017 Income Statement (Product Name:) Sales Bit Bolt Buzz Brat Baker Bead Na Na $18,313 $24,575 $40,585 $34,972 $29,362 $34,719 $0 $0 2017 Common Total Size $182,526 100.0% http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable Contribution Margin Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $1,664 $7,500 $372 $9,536 $1,986 $10,639 $664 $13,289 $8,543 $16,921 $410 $25,874 $5,673 $12,876 $516 $19,065 $6,807 $13,059 $369 $20,235 $7,780 $14,227 $296 $22,304 $0 $0 $0 $0 $0 $0 $0 $0 $32,454 $75,223 $2,627 $110,304 17.8% 41.2% 1.4% 60.4% $8,777 $11,286 $14,711 $15,907 $9,127 $12,414 $0 $0 $72,222 39.6% $3,833 $0 $1,200 $1,000 $170 $6,204 $4,753 $0 $1,200 $1,000 $229 $7,182 $2,040 $985 $1,200 $2,400 $377 $7,002 $1,927 $985 $1,200 $2,400 $325 $6,837 $2,635 $966 $1,200 $900 $273 $5,974 $2,475 $966 $1,200 $900 $323 $5,864 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $17,663 $3,902 $7,200 $8,600 $1,697 $39,062 9.7% 2.1% 3.9% 4.7% 0.9% 21.4% $0 $0 Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit $33,160 $5,315 $27,846 $3,895 $11,242 $4,448 $165 $8,095 18.2% 2.9% 15.3% 2.1% 6.2% 2.4% 0.1% 4.4% Net Margin $2,574 $4,104 $7,709 $9,071 $3,153 $6,551 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 straight-line 15-year 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. Write-offs 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. Page 2 Annual Report PRINT Annual Report http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER Top Annual Report Chester Round: 4 Dec. 31, 2017 C59559 Balance Sheet DEFINITIONS:Common Size: The common size column simply represents each item as a percentage of total assets for that year. Cash: Your end-of-year cash position. Accounts Receivable: Reflects the lag between delivery and payment of your products. Inventories: The current value of your inventory across all products. A zero indicates your company stocked out. Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for materials and services. Current Debt: The debt the company is obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company's long term debt is in the form of bonds, and this 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 instead of paying to shareholders as dividends. ASSETS $26,295 $16,371 $23,798 $86,891 52.1% 89.3% -41.4% $66,464 $149,060 ($59,135) $79,988 47.9% $89,925 $166,879 100.0% $156,389 6.7% 15.5% 17.9% $10,597 $20,369 $35,081 $66,881 40.1% 6.3% 53.6% $66,047 $11,030 $79,311 $99,998 59.9% $90,341 $166,879 Cash Accounts Receivable Inventory 2017 Common Size 26.3% 11.9% 13.8% 100.0% $156,389 $43,966 $19,826 $23,099 Total Current Assets Plant & Equipment Accumulated Depreciation $149,060 ($69,072) Total Fixed Assets Total Assets LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $11,129 $25,886 $29,866 Total Liabilities Common Stock Retained Earnings $10,566 $89,432 Total Equity Total Liab. & O. Equity 2016 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 2017 $41,814 $9,937 ($169) $532 $698 ($3,455) 2016 $24,965 $9,937 $0 $1,807 ($8,125) ($2,896) $49,357 $25,688 $0 ($30,400) ($28,358) $0 ($3,799) $0 ($5,046) $5,517 ($1,660) $0 ($2,150) $8,096 $0 ($8,279) ($31,686) $17,671 $43,966 ($3,993) ($8,705) $26,295 Page 1 Annual Report Top Annual Report Chester C59559 Round: 4 Dec. 31, 2017 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER 2017 Income Statement City Cozy Cute Crimp Na Na Na Na Sales Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $68,173 $57,513 $55,113 $60,414 $0 $0 $0 $0 2017 Common Total Size $241,213 100.0% $13,489 $25,777 $816 $40,082 $11,277 $23,380 $249 $34,906 $9,348 $19,907 $818 $30,073 $10,184 $22,739 $889 $33,812 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $44,298 $91,803 $2,772 $138,872 18.4% 38.1% 1.1% 57.6% Contribution Margin Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $28,091 $22,607 $25,040 $26,602 $0 $0 $0 $0 $102,340 42.4% $2,797 $710 $1,400 $1,100 $553 $6,560 $1,813 $645 $1,400 $1,000 $467 $5,325 $2,493 $623 $1,400 $1,000 $447 $5,964 $2,833 $645 $1,400 $1,000 $490 $6,369 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $9,937 $2,622 $5,600 $4,100 $1,958 $24,218 4.1% 1.1% 2.3% 1.7% 0.8% 10.0% $0 $0 Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit $78,123 $6,213 $71,910 $2,718 $3,550 $22,975 $853 $41,814 32.4% 2.6% 29.8% 1.1% 1.5% 9.5% 0.4% 17.3% (Product Name:) Net Margin $21,531 $17,282 $19,076 $20,234 $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 straight-line 15-year 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. Write-offs 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. Page 2 Annual Report PRINT http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER Annual Report Top Annual Report Digby Round: 4 Dec. 31, 2017 C59559 Balance Sheet DEFINITIONS:Common Size: The common size column simply represents each item as a percentage of total assets for that year. Cash: Your end-of-year cash position. Accounts Receivable: Reflects the lag between delivery and payment of your products. Inventories: The current value of your inventory across all products. A zero indicates your company stocked out. Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for materials and services. Current Debt: The debt the company is obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company's long term debt is in the form of bonds, and this 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 instead of paying to shareholders as dividends. ASSETS 2017 Common Size 15.8% 6.0% 10.1% $48,110 $12,247 $2,147 $66,260 31.9% 122.3% -54.1% $62,504 $254,252 ($95,639) Total Fixed Assets $141,663 68.1% $158,613 Total Assets $207,923 100.0% $221,117 4.1% 13.4% 40.9% $7,470 $28,901 $98,385 $121,429 58.4% 24.9% 16.7% $134,756 $51,782 $34,579 $86,494 41.6% $86,361 $207,923 100.0% $221,117 Cash Accounts Receivable Inventory $32,854 $12,427 $20,979 Total Current Assets Plant & Equipment Accumulated Depreciation $254,252 ($112,589) LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $8,589 $27,830 $85,010 Total Liabilities Common Stock Retained Earnings $51,782 $34,712 Total Equity Total Liab. & O. Equity 2016 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 2017 $7,326 $16,950 ($895) $1,118 ($18,833) ($180) 2016 $1,425 $16,950 $0 ($350) $2,486 ($24) $5,488 $20,487 $0 ($20,449) ($7,193) $0 $0 $0 ($12,480) ($1,071) $0 $10,225 $0 $6,819 $0 ($15,087) ($20,744) ($15,256) $32,854 $1,957 $1,994 $48,110 Page 1 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER Top Annual Report Digby Round: 4 Dec. 31, 2017 C59559 2017 Income Statement (Product Name:) 2017 Common Total Size $151,194 100.0% Dim Dome Drum Drat Na Na Na Na Sales Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $26,944 $27,304 $47,191 $49,756 $0 $0 $0 $0 $2,585 $11,850 $368 $14,803 $2,595 $12,260 $545 $15,401 $9,777 $18,280 $514 $28,571 $9,409 $18,904 $1,090 $29,403 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $24,366 $61,294 $2,518 $88,178 16.1% 40.5% 1.7% 58.3% Contribution Margin Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $12,141 $11,903 $18,620 $20,352 $0 $0 $0 $0 $63,016 41.7% $5,002 $446 $1,300 $1,600 $216 $8,563 $5,615 $422 $1,300 $1,600 $218 $9,155 $2,913 $966 $1,300 $1,400 $378 $6,957 $3,420 $966 $1,300 $1,400 $398 $7,484 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $16,950 $2,800 $5,200 $6,000 $1,210 $32,159 11.2% 1.9% 3.4% 4.0% 0.8% 21.3% $0 $0 Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit $30,856 $4,793 $26,064 $3,451 $11,111 $4,025 $150 $7,326 20.4% 3.2% 17.2% 2.3% 7.3% 2.7% 0.1% 4.8% Net Margin $3,578 $2,748 $11,663 $12,868 $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 straight-line 15-year 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. Write-offs 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. http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM] COMP-XM INQUIRER Annual Report Page 2 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?studentKey=1059586&simid=C59559&round=8&Report=CapCourier|AnnReport[5/2/2014 5:20:28 PM]