You helped with a similar question previously and wanted to understand how you solved these, but there's no explanation? I want to understand how to do the problems correctly. So if you can include explanation that would be great. Chester has negotiated a new labor contract for the next round that will affect the cost for their product Cedar. Labor costs will go from $1.79 to $2.39 per unit. Assume all period and other variable costs remain the same. If Chester were to absorb the new labor costs without passing them on in the form of higher prices, how many units of product Cedar would need to be sold next round to break even on the product? Select: 1 1,068 922 856 888 Additional questions: The Baldwin Company currently has the following balances on their balance sheet: Total Liabilities $132,105 Common Stock $49,540 Retained Earnings $34,521 Suppose next year the Baldwin Company generates $36,500 in net profit and pays $15,000 in dividends and total liabilities and common stock remain unchanged. What must their total assets be next year? Select: 1 $84,061 $216,166 $237,666 $267,666 Assuming no brokerage fees, calculate the amount of cash needed to retire Baldwin's 12.5S2021 bond early. Select: 1 $15,841,880 $14,008,592 $14,665,611 The Baldwin company will continue to train their existing workforce at their current level to help reduce turnover and improve productivity next year. Employee training costs have increased to $30 per hour. How much would their training costs per employee be to the nearest dollar? Select: 1 $2,382 $1,182 $400 $1,200 Suppose you were hired as a consultant for a company that wants to penetrate the Comp-XM market. This company wants to pursue a niche cost leader strategy. From last year?s reports, which company would be the strongest competitor? Select: 1 Digby Baldwin Chester Andrews The Digby company will increase its automation for the Dot product by 2.0. Assuming no further change in capacity, how much will this investment in automation cost? Select: 1 $9,600,000 $16,800,000 $19,200,000 $8,400,000 If Chester Corp. were to buy all of it's shares outstanding at its current price, how much would it cost Chester Corp, excluding brokerage fees? Select: 1 $112 million $3 million $214 million $101 million Of Digby Corporation?s products, which earned the highest Net Margin as a percentage of its sales? Select: 1 Dell Dixie Dune Dot
COMP-XM INQUIRER 1 of 28 Page 1 Front Page Page 2 Stocks & Bonds Page 3 Financial Summary Page 4 Production Analysis Annual Report Andrews http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 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 10/3/2014 12:23 PM COMP-XM INQUIRER 2 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top " Round: 3 Dec. 31, 2016 Season Sherman Student: Season Sherman Andrews Season Sherman Baldwin Chester Digby Selected Financial Statistics ROS Asset Turnover ROA Leverage (Assets/Equity) ROE Emergency Loan Sales EBIT Profits Cumulative Profit SG&A / Sales Contrib. Margin % COMP-XM INQUIRER Andrews 14.3% 0.73 10.4% 1.3 13.9% $0 $158,670,888 $41,034,254 $22,753,042 $50,344,018 10.9% 48.2% Baldwin 0.8% 0.69 0.5% 2.6 1.4% $0 $148,033,256 $17,698,782 $1,166,312 $4,389,421 9.0% 36.3% Chester 1.5% 0.76 1.2% 2.4 2.8% $0 $183,019,543 $20,981,371 $2,828,465 $7,906,386 11.6% 37.2% Digby 13.8% 1.32 18.2% 1.7 30.6% $0 $226,671,178 $55,864,996 $31,227,258 $59,661,536 6.0% 38.4% Page 1 10/3/2014 12:23 PM COMP-XM INQUIRER 3 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Round: 3 Stocks & Bonds Season Sherman December 31 , 2016 Stock Market Summary Company Andrews Baldwin Chester Digby Close $112.08 $24.75 $35.31 $119.49 Change $25.50 ($1.82) $0.30 $40.37 Shares 2,505,788 3,319,586 3,173,876 1,900,990 MarketCap ($M) $281 $82 $112 $227 Book Value $65.33 $25.32 $31.97 $53.61 EPS $9.08 $0.35 $0.89 $16.43 Dividend $0.00 $0.00 $0.00 $0.00 Yield 0.0% 0.0% 0.0% 0.0% P/E 12.3 70.2 39.6 7.3 Bond Market Summary Company Series# Face Yield Close$ S&P 11.2S2020 11.9S2021 10.9S2024 10.5S2025 10.9S2026 $8,837,000 $7,072,000 $14,722,000 $4,000,000 $13,387,000 10.9% 11.3% 10.6% 10.4% 10.6% 102.51 105.63 102.63 100.57 103.02 AAA AAA AAA AAA AAA 11.3S2020 12.5S2021 12.5S2022 12.5S2023 12.9S2024 13.4S2025 14.2S2026 $10,417,600 $14,665,611 $7,963,435 $9,569,958 $14,262,838 $33,400,581 $4,040,318 12.2% 13.1% 13.2% 13.2% 13.5% 13.7% 13.9% 92.69 95.52 94.92 94.39 95.80 98.01 102.10 CC CC CC CC CC CC CC 11.2S2020 12.4S2021 12.0S2023 12.6S2024 13.1S2025 13.8S2026 $8,632,724 $5,825,802 $15,610,279 $17,788,546 $34,233,153 $20,980,308 12.0% 12.9% 12.9% 13.2% 13.4% 13.7% 92.95 95.84 93.05 95.30 97.49 101.06 CC CC CC CC CC CC 11.1S2022 11.2S2023 11.5S2024 11.6S2025 12.6S2026 $2,509,600 $5,662,814 $1,377,976 $18,062,270 $11,777,452 11.4% 11.5% 11.6% 11.7% 12.0% 97.51 97.70 99.00 99.46 105.15 BBB BBB BBB BBB BBB Andrews Baldwin Chester Digby Next Year's Prime Rate 9.00% COMP-XM INQUIRER Page 2 10/3/2014 12:23 PM COMP-XM INQUIRER 4 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 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: 3 December 31, 2016 Season Sherman Andrews Baldwin Chester Digby $22,753 $1,166 $2,828 $31,227 $6,606 ($1,633) $16,427 $0 $17,875 $0 $10,617 $0 ($273) ($1,098) $1,214 $27,569 $427 ($8,068) $296 $10,248 $2,115 ($2,630) ($3,389) $16,799 $401 $8,137 ($4,178) $46,205 $6,936 ($22,500) ($50,860) ($37,500) $0 $37,730 ($9,432) $13,387 $0 ($11,300) $0 $0 $0 $10,704 $0 $4,040 $0 ($42,760) $29,504 $0 $0 $18,523 $0 $20,980 $0 ($33,761) $27,076 $0 $0 $0 ($765) $11,777 $0 ($30,406) $19,573 $0 $30,384 $1,488 $32,818 $179 $64,889 ($10,763) ($1,243) $8,884 Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets Andrews $145,211 $13,041 $12,067 $170,320 Baldwin $38,780 $12,167 $13,277 $64,224 Chester $33,452 $15,043 $12,734 $61,229 Digby $39,571 $18,631 $14,107 $72,309 Plant and equipment Accumulated Depreciation Total Fixed Assets $99,084 ($50,970) $48,114 $246,400 ($94,458) $151,942 $268,120 ($88,174) $179,946 $159,260 ($60,021) $99,239 Total Assets $218,434 $216,166 $241,175 $171,548 Accounts Payable Current Debt Long Term Debt Total Liabilities $6,722 $0 $48,018 $54,740 $8,281 $29,504 $94,320 $132,105 $9,544 $27,076 $103,071 $139,691 $10,672 $19,573 $39,390 $69,635 Common Stock Retained Earnings Total Equity $63,272 $100,421 $163,694 $49,540 $34,521 $84,061 $54,765 $46,719 $101,484 $10,668 $91,245 $101,913 Total Liabilities & Owners' Equity $218,434 $216,166 $241,175 $171,548 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 $158,671 $82,137 $6,606 $17,329 $11,565 $41,034 $5,315 $12,502 $464 $22,753 Baldwin $148,033 $94,280 $16,427 $13,390 $6,237 $17,699 $15,868 $641 $24 $1,166 Chester $183,020 $115,023 $17,875 $21,166 $7,975 $20,981 $16,541 $1,554 $58 $2,828 Digby $226,671 $139,667 $10,617 $13,671 $6,850 $55,865 $6,843 $17,158 $637 $31,227 COMP-XM INQUIRER Page 3 10/3/2014 12:23 PM COMP-XM INQUIRER 5 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Production Analysis Round: 3 December 31, 2016 Season Sherman Production Information Name Primary Segment Units Unit Sold Inven tory Revision Date Age Dec.31 MTBF Pfmn Coord Size Coord Material Price Cost Labor Cost Contr. Marg. 2nd Shift & Overtime Auto mation Capacity Next Next Round Round Plant Utiliz. Acre Adam Aft Agape Thrift Core Nano Elite 1,592 1,423 1,038 920 119 332 0 281 5/21/2016 8/24/2016 6/5/2016 6/17/2016 1.9 1.5 1.8 2.3 20000 21000 23000 25700 8.4 10.9 12.7 15.1 10.4 8.9 4.8 7.4 $24.00 $29.00 $39.50 $41.50 $7.38 $9.06 $11.80 $12.45 $5.91 $4.43 $7.42 $7.46 44% 50% 51% 49% 86% 85% 89% 95% 8.0 8.0 6.5 6.5 930 800 528 514 184% 183% 188% 193% Bead Bid Buzz Buddy Thrift Thrift Core Core 2,056 2,148 1,595 1,770 172 305 288 278 6/10/2017 6/10/2017 12/16/2015 12/18/2015 3.7 3.6 2.1 2.1 17000 17000 18000 20000 8.8 9.0 11.9 12.6 11.2 11.0 7.5 8.0 $16.00 $16.00 $24.00 $24.00 $6.80 $6.96 $9.72 $10.36 $2.94 $2.92 $4.58 $4.51 37% 35% 38% 35% 45% 41% 67% 56% 10.0 10.0 8.0 8.0 1,550 1,700 1,150 1,400 144% 140% 165% 154% Cedar Cid Coat Cure Camp Cent Thrift Core Nano Elite Core Core 1,015 1,873 1,374 915 1,564 1,053 302 259 93 181 119 0 12/19/2016 12/7/2014 12/16/2016 12/16/2016 12/24/2016 2/10/2016 2.2 3.1 1.0 1.0 0.9 0.9 14000 16000 18000 20000 16000 16000 9.5 10.4 13.9 17.0 11.8 11.5 10.5 9.6 3.4 5.9 8.1 8.5 $17.00 $19.00 $30.00 $36.00 $21.00 $22.00 $6.82 $8.14 $12.74 $13.59 $9.31 $9.03 $1.79 $4.08 $6.97 $6.30 $5.67 $4.45 52% 33% 35% 44% 30% 38% 0% 40% 53% 13% 63% 100% 10.0 10.0 7.0 7.0 8.0 8.0 1,250 1,500 950 950 1,050 1,040 91% 139% 151% 111% 162% 176% Dell Dixie Dot Dune Nano Elite Nano Elite 1,814 1,461 1,459 1,658 0 99 201 344 11/4/2016 8/23/2016 7/2/2016 7/24/2016 1.2 1.9 1.3 1.3 23000 25000 23000 25000 14.5 17.3 15.0 17.1 3.5 5.5 3.0 5.2 $34.00 $34.00 $37.00 $37.00 $13.66 $14.56 $14.04 $14.57 $7.91 $6.69 $7.25 $7.40 38% 36% 41% 39% 100% 53% 40% 50% 7.0 7.0 7.0 7.0 1,150 850 1,200 1,350 198% 151% 139% 149% COMP-XM INQUIRER Page 4 10/3/2014 12:23 PM COMP-XM INQUIRER 6 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Thrift Market Segment Analysis Season Sherman Round: 3 December 31, 2016 Thrift Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 6,985 6,985 26.1% Next Year's Segment Growth Rate 11.0% Thrift Customer Buying Criteria 1. 2. 3. 4. Expectations $14.00 - 26.00 MTBF 14000-20000 Pfmn 9.0 Size 11.0 Ideal Age = 3.0 Price Reliability Ideal Position Age Importance 55% 20% 15% 10% Perceptual Map for Thrift Segment Top Products in Thrift Segment Name Bead Bid Acre Cedar Cid Adam Camp Cent Market Share 27% 27% 15% 14% 11% 3% 3% 0% Units Sold to Seg 1,880 1,879 1,035 990 755 213 201 31 COMP-XM INQUIRER Revision Date Stock Out 6/10/2017 6/10/2017 5/21/2016 12/19/2016 12/7/2014 8/24/2016 12/24/2016 2/10/2016 YES Pfmn Coord 8.8 9.0 8.4 9.5 10.4 10.9 11.8 11.5 Size Coord 11.2 11.0 10.4 10.5 9.6 8.9 8.1 8.5 List Price $16.00 $16.00 $24.00 $17.00 $19.00 $29.00 $21.00 $22.00 MTBF 17000 17000 20000 14000 16000 21000 16000 16000 Age Dec.31 3.74 3.64 1.93 2.25 3.11 1.51 0.88 0.89 Promo Cust. AwareBudget ness $1,250 78% $1,250 79% $1,600 100% $1,140 66% $1,140 67% $1,600 100% $1,140 58% $1,140 51% Sales Cust. AccessBudget ibility $1,400 75% $1,400 75% $1,850 81% $1,000 72% $1,000 72% $1,850 81% $900 72% $900 72% Dec. Cust. Survey 54 55 31 31 24 5 0 3 Page 5 10/3/2014 12:23 PM COMP-XM INQUIRER 7 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Core Market Segment Analysis Season Sherman Round: 3 December 31, 2016 Core Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 8,898 8,898 33.3% Next Year's Segment Growth Rate 10.0% Core Customer Buying Criteria 1. 2. 3. 4. Expectations $20.00 - 32.00 Ideal Age = 2.0 MTBF 16000-22000 Pfmn 12.0 Size 8.0 Price Age Reliability Ideal Position Importance 46% 20% 18% 16% Perceptual Map for Core Segment Top Products in Core Segment Name Buddy Buzz Camp Adam Cid Cent Acre Bid Bead Cedar Dell Market Share 19% 17% 15% 14% 13% 11% 6% 3% 2% 0% 0% Units Sold to Seg 1,676 1,480 1,363 1,210 1,118 1,022 557 269 176 24 3 COMP-XM INQUIRER Revision Date Stock Out 12/18/2015 12/16/2015 12/24/2016 8/24/2016 12/7/2014 2/10/2016 YES 5/21/2016 6/10/2017 6/10/2017 12/19/2016 11/4/2016 YES Pfmn Coord 12.6 11.9 11.8 10.9 10.4 11.5 8.4 9.0 8.8 9.5 14.5 Size Coord 8.0 7.5 8.1 8.9 9.6 8.5 10.4 11.0 11.2 10.5 3.5 List Price $24.00 $24.00 $21.00 $29.00 $19.00 $22.00 $24.00 $16.00 $16.00 $17.00 $34.00 MTBF 20000 18000 16000 21000 16000 16000 20000 17000 17000 14000 23000 Age Dec.31 2.10 2.09 0.88 1.51 3.11 0.89 1.93 3.64 3.74 2.25 1.24 Promo Cust. AwareBudget ness $1,250 78% $1,250 78% $1,140 58% $1,600 100% $1,140 67% $1,140 51% $1,600 100% $1,250 79% $1,250 78% $1,140 66% $1,350 87% Sales Cust. AccessBudget ibility $1,100 76% $1,100 76% $900 72% $1,850 68% $1,000 72% $900 72% $1,850 68% $1,400 76% $1,400 76% $1,000 72% $1,000 11% Dec. Cust. Survey 50 44 38 31 26 31 7 2 0 8 0 Page 6 10/3/2014 12:23 PM COMP-XM INQUIRER 8 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Nano Market Segment Analysis Season Sherman Round: 3 December 31, 2016 Nano Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 5,412 5,412 20.3% Next Year's Segment Growth Rate 14.0% Nano Customer Buying Criteria 1. 2. 3. 4. Expectations Pfmn 13.9 Size 3.2 $28.00 - 40.00 Ideal Age = 1.0 MTBF 18000-24000 Ideal Position Price Age Reliability Importance 35% 27% 20% 18% Perceptual Map for Nano Segment Top Products in Nano Segment Name Dell Dot Coat Aft Agape Buzz Dune Buddy Cure Dixie Market Share 26% 26% 23% 16% 2% 2% 2% 2% 1% 0% Units Sold to Seg 1,410 1,398 1,237 853 116 115 96 95 72 20 COMP-XM INQUIRER Revision Date Stock Out 11/4/2016 YES 7/2/2016 12/16/2016 6/5/2016 YES 6/17/2016 12/16/2015 7/24/2016 12/18/2015 12/16/2016 8/23/2016 Pfmn Coord 14.5 15.0 13.9 12.7 15.1 11.9 17.1 12.6 17.0 17.3 Size Coord 3.5 3.0 3.4 4.8 7.4 7.5 5.2 8.0 5.9 5.5 List Price $34.00 $37.00 $30.00 $39.50 $41.50 $24.00 $37.00 $24.00 $36.00 $34.00 MTBF 23000 23000 18000 23000 25700 18000 25000 20000 20000 25000 Age Dec.31 1.24 1.34 1.03 1.76 2.31 2.09 1.34 2.10 1.04 1.90 Promo Cust. AwareBudget ness $1,350 87% $1,350 87% $1,140 67% $1,500 100% $1,500 99% $1,250 78% $1,350 87% $1,250 78% $1,140 67% $1,350 87% Sales Cust. AccessBudget ibility $1,000 83% $900 83% $1,900 70% $1,800 81% $1,800 81% $1,100 18% $900 83% $1,100 18% $2,200 70% $1,000 83% Dec. Cust. Survey 62 48 46 33 3 2 0 1 0 0 Page 7 10/3/2014 12:23 PM COMP-XM INQUIRER 9 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Elite Market Segment Analysis Season Sherman Round: 3 December 31, 2016 Elite Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 5,434 5,434 20.3% Next Year's Segment Growth Rate 16.0% Elite Customer Buying Criteria 1. 2. 3. 4. Expectations Ideal Age = 0.0 $30.00 - 42.00 Pfmn 16.8 Size 6.1 MTBF 20000-26000 Age Price Ideal Position Reliability Importance 34% 24% 22% 20% Perceptual Map for Elite Segment Top Products in Elite Segment Name Dune Dixie Cure Agape Dell Aft Coat Dot Market Share 29% 27% 16% 15% 7% 3% 3% 1% Units Sold to Seg 1,562 1,442 843 804 400 185 137 61 COMP-XM INQUIRER Revision Date Stock Out 7/24/2016 8/23/2016 12/16/2016 6/17/2016 11/4/2016 YES 6/5/2016 YES 12/16/2016 7/2/2016 Pfmn Coord 17.1 17.3 17.0 15.1 14.5 12.7 13.9 15.0 Size Coord 5.2 5.5 5.9 7.4 3.5 4.8 3.4 3.0 List Price $37.00 $34.00 $36.00 $41.50 $34.00 $39.50 $30.00 $37.00 MTBF 25000 25000 20000 25700 23000 23000 18000 23000 Age Dec.31 1.34 1.90 1.04 2.31 1.24 1.76 1.03 1.34 Promo Cust. AwareBudget ness $1,350 87% $1,350 87% $1,140 67% $1,500 99% $1,350 87% $1,500 100% $1,140 67% $1,350 87% Sales Cust. AccessBudget ibility $900 87% $1,000 87% $2,200 69% $1,800 87% $1,000 87% $1,800 87% $1,900 69% $900 87% Dec. Cust. Survey 48 47 30 23 8 4 1 1 Page 8 10/3/2014 12:23 PM COMP-XM INQUIRER 10 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Market Share Report Actual Market Share in Units Thrift 6,985 26.1% Core 8,898 33.3% Acre Adam Aft Agape Total 14.8% 3.0% 6.3% 13.6% 17.9% 19.9% Bead Bid Buzz Buddy Total 26.9% 26.9% 53.8% 2.0% 3.0% 16.6% 18.8% 40.5% Cedar Cid Coat Cure Camp Cent Total 14.2% 10.8% 0.3% 12.6% Industry Unit Sales % of Market Dell Dixie Dot Dune Total COMP-XM INQUIRER 15.3% 11.5% 39.6% 0.0% 0.0% Potential Market Share in Units Nano 5,412 20.3% Elite 5,434 20.3% Total 26,729 100.0% 15.8% 2.1% 17.9% 3.4% 14.8% 18.2% 6.0% 5.3% 3.9% 3.4% 18.6% Acre Adam Aft Agape Total 18.0% 7.7% 8.0% 6.0% 6.6% 28.3% Bead Bid Buzz Buddy Total 27.0% 26.8% Cedar Cid Coat Cure Camp Cent Total Dell Dixie Dot Dune Total 2.1% 1.8% 3.9% 22.9% 1.3% 2.9% 0.5% 28.3% Round: 3 December 31, 2016 Season Sherman 2.5% 15.5% 24.2% 18.0% 3.8% 7.0% 5.1% 3.4% 5.8% 3.9% 29.2% 26.1% 0.4% 25.8% 1.8% 54.0% 7.4% 26.5% 1.1% 28.8% 63.8% 6.8% 5.5% 5.5% 6.2% 23.9% Units Demanded % of Market Thrift 6,985 26.1% Core 8,898 33.3% Nano 5,412 20.3% Elite 5,434 20.3% Total 26,729 100.0% 15.0% 3.0% 6.3% 13.6% 19.9% 19.1% 2.0% 21.1% 4.0% 14.6% 18.6% 6.0% 5.3% 4.7% 3.4% 19.4% 53.8% 2.0% 3.0% 16.6% 18.8% 40.4% 2.0% 1.6% 3.6% 14.1% 10.8% 0.3% 12.5% 7.7% 8.0% 5.9% 6.6% 28.2% 21.0% 1.2% 2.9% 0.4% 28.2% 2.5% 15.3% 15.3% 11.5% 39.6% 22.2% 17.9% 0.0% 27.2% 0.3% 23.8% 1.7% 53.1% 7.7% 26.2% 1.1% 28.4% 63.5% 3.8% 7.0% 4.8% 3.4% 5.8% 3.9% 28.7% 7.1% 5.4% 5.0% 6.1% 23.7% Page 9 10/3/2014 12:23 PM COMP-XM INQUIRER 11 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Perceptual Map Round: 3 December 31, 2016 Season Sherman Perceptual Map for All Segments Andrews Name Acre Adam Aft Agape Pfmn 8.4 10.9 12.7 15.1 Name Dell Dixie Dot Dune Size 10.4 8.9 4.8 7.4 Pfmn 14.5 17.3 15.0 17.1 Baldwin Revised 5/21/2016 8/24/2016 6/5/2016 6/17/2016 Name Bead Bid Buzz Buddy Pfmn 8.8 9.0 11.9 12.6 Size 11.2 11.0 7.5 8.0 Chester Revised 6/10/2017 6/10/2017 12/16/2015 12/18/2015 Name Cedar Cid Coat Cure Camp Cent Pfmn 9.5 10.4 13.9 17.0 11.8 11.5 Size 10.5 9.6 3.4 5.9 8.1 8.5 Revised 12/19/2016 12/7/2014 12/16/2016 12/16/2016 12/24/2016 2/10/2016 Digby COMP-XM INQUIRER Size 3.5 5.5 3.0 5.2 Revised 11/4/2016 8/23/2016 7/2/2016 7/24/2016 Page 10 10/3/2014 12:23 PM COMP-XM INQUIRER 12 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top HR/TQM Report Season Sherman Round: 3 December 31, 2016 HUMAN RESOURCES SUMMARY Needed Complement Complement 1st Shift Complement 2nd Shift Complement Andrews 435 435 231 204 Baldwin 432 432 284 148 Chester 585 585 408 177 Digby 623 623 390 233 Overtime% Turnover Rate New Employees Separated Employees Recruiting Spend Training Hours Productivity Index 0.0% 6.8% 30 112 $5,000 80 110.8% 0.0% 8.0% 34 11 $2,500 40 116.2% 0.0% 6.2% 121 0 $5,000 80 125.9% 0.0% 10.0% 62 46 $0 0 100.0% Recruiting Cost Separation Cost Training Cost Total HR Admin Cost $179 $560 $696 $1,435 $121 $56 $346 $522 $723 $0 $935 $1,658 $62 $228 $0 $290 Labor Contract Next Year Wages Benefits Profit Sharing Annual Raise $29.56 2,500 2.0% 5.0% $29.56 2,500 2.0% 5.0% $29.56 2,500 2.0% 5.0% $29.56 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 Baldwin Chester Digby $1,000 $1,500 $1,000 $1,000 $1,000 $1,000 $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 TQM Budgets Last Year Benchmarking Quality Function Deployment Effort CCE/6 Sigma Training GEMI TQEM Sustainability Initiatives Total Expenditures $1,000 $1,000 $1,000 $1,000 $10,500 $0 $0 $750 $750 $5,500 $1,500 $0 $0 $0 $6,000 $0 $0 $1,250 $1,250 $6,250 Cumulative Impacts Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction Admin Costs Demand Increase 11.64% 13.86% 40.01% 60.02% 13.97% 6.03% 1.78% 0.00% 16.23% 5.47% 1.41% 0.05% 0.00% 43.11% 0.45% 6.43% 13.93% 39.79% 0.00% 9.37% Process Mgt Budgets Last Year CPI Systems Vendor/JIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs COMP-XM INQUIRER Page 11 10/3/2014 12:23 PM COMP-XM INQUIRER 13 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... PRINT 10/3/2014 12:23 PM COMP-XM INQUIRER 14 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report 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. Andrews Round: 7 Dec. 31, 2016 C59559 ASSETS $80,322 $14,255 $10,969 78.0% $105,546 45.4% -23.3% $112,880 ($52,857) $48,114 22.0% $60,023 $218,434 Cash Accounts Receivable Inventory 2016 Common Size 66.5% 6.0% 5.5% 100.0% $165,569 3.1% 0.0% 22.0% $6,995 $11,300 $34,631 25.1% $52,926 29.0% 46.0% $29,777 $82,866 $145,211 $13,041 $12,067 Total Current Assets $170,319 Plant & Equipment Accumulated Depreciation $99,084 ($50,970) Total Fixed Assets Total Assets 2015 LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $6,722 $0 $48,018 Total Liabilities Common Stock Retained Earnings $54,740 $63,272 $100,421 Total Equity $163,693 74.9% $112,643 Total Liab. & O. Equity $218,434 100.0% $165,569 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 2016 $22,753 $6,606 ($1,633) ($273) ($1,098) $1,214 2015 $21,256 $7,525 ($2,037) ($841) $15,264 ($2,139) $27,569 $39,029 $6,936 ($9,688) $0 $37,730 ($9,432) $13,387 $0 ($11,300) $0 $0 ($6,000) $4,000 ($11,300) $11,300 $30,384 $64,889 $145,211 ($2,000) $27,341 $80,322 Page 1 10/3/2014 12:23 PM COMP-XM INQUIRER 15 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 10/3/2014 12:23 PM COMP-XM INQUIRER 16 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report (Product Name:) Andrews $38,194 $0 $0 Na $0 Na $0 2016 Total $158,671 Common Size 100.0% $7,073 $13,186 $568 $20,827 $7,788 $12,508 $0 $20,296 $7,127 $11,691 $689 $19,507 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $31,399 $49,290 $1,448 $82,137 19.8% 31.1% 0.9% 51.8% $16,701 $20,447 $20,699 $18,687 $0 $0 $0 $0 $76,534 48.2% $2,356 $392 $1,600 $1,850 $452 $6,651 $2,027 $656 $1,600 $1,850 $489 $6,621 $1,126 $434 $1,500 $1,800 $485 $5,346 $1,097 $469 $1,500 $1,800 $452 $5,317 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,606 $1,950 $6,200 $7,300 $1,879 $23,935 4.2% 1.2% 3.9% 4.6% 1.2% 15.1% $10,050 $13,826 $15,353 $13,370 $0 $0 $0 $0 $52,599 33.1% $11,565 $41,034 $0 $5,315 $12,502 $464 $22,753 7.3% 25.9% 0.0% 3.3% 7.9% 0.3% 14.3% Adam $41,274 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $9,411 $11,906 $191 $21,508 Contribution Margin Net Margin 2016 Income Statement Aft Agape Na Na $40,995 Sales Acre $38,209 Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period Round: 7 Dec. 31, 2016 C59559 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. Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 Annual Report PRINT 10/3/2014 12:23 PM COMP-XM INQUIRER 17 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 10/3/2014 12:23 PM COMP-XM INQUIRER 18 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report 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. Baldwin ASSETS Cash Accounts Receivable Inventory 2016 Common Size 17.9% 5.6% 6.1% $38,780 $12,167 $13,277 Total Current Assets $64,224 Plant & Equipment Accumulated Depreciation 2015 $49,543 $12,463 $5,209 29.7% $67,215 114.0% -43.7% $246,400 ($94,458) $223,900 ($78,031) Total Fixed Assets $151,942 70.3% $145,869 Total Assets $216,166 100.0% $213,084 3.8% 13.6% 43.6% $7,854 $42,760 $90,280 61.1% $140,894 22.9% 16.0% $38,836 $33,354 LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $8,281 $29,504 $94,320 Total Liabilities Common Stock Retained Earnings $132,105 $49,540 $34,521 Total Equity $84,061 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. 38.9% $72,190 $216,166 Total Liab. & O. Equity 100.0% $213,084 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 Round: 7 Dec. 31, 2016 C59559 2016 $1,166 $16,427 $0 $427 ($8,068) $296 2015 ($2,372) $14,927 $0 ($1,276) $6,037 $527 $10,248 $17,843 ($22,500) ($46,340) $0 $10,704 $0 $4,040 $0 ($13,256) $0 $11,327 $0 $33,401 ($11,300) $17,483 $1,488 ($10,763) $38,780 $50,911 $22,414 $49,543 Page 1 10/3/2014 12:23 PM COMP-XM INQUIRER 19 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 10/3/2014 12:23 PM COMP-XM INQUIRER 20 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report Baldwin Round: 7 Dec. 31, 2016 C59559 2016 Income Statement Buzz Buddy Na Na $38,274 $42,488 $0 $0 Na $0 Na $0 2016 Total $148,033 Common Size 100.0% $6,343 $15,492 $372 $22,206 $7,345 $16,061 $508 $23,913 $8,004 $18,937 $508 $27,448 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $27,746 $64,941 $1,593 $94,280 18.7% 43.9% 1.1% 63.7% $12,187 $12,166 $14,360 $15,040 $0 $0 $0 $0 $53,753 36.3% Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $4,753 $1,000 $1,250 $1,400 $309 $8,712 $5,213 $1,000 $1,250 $1,400 $323 $9,186 $2,913 $0 $1,250 $1,100 $359 $5,623 $3,547 $0 $1,250 $1,100 $399 $6,296 $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,427 $2,000 $5,000 $5,000 $1,390 $29,817 11.1% 1.4% 3.4% 3.4% 0.9% 20.1% Net Margin $3,475 $2,979 $8,738 $8,744 $0 $0 $0 $0 $23,936 16.2% $6,237 $17,699 $3,776 $12,091 $641 $24 $1,166 4.2% 12.0% 2.6% 8.2% 0.4% 0.0% 0.8% (Product Name:) Sales Bead $32,899 Bid $34,372 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $6,055 $14,452 $205 $20,712 Contribution Margin 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. Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 Annual Report PRINT 10/3/2014 12:23 PM COMP-XM INQUIRER 21 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 10/3/2014 12:23 PM COMP-XM INQUIRER 22 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report 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. Chester Round: 7 Dec. 31, 2016 C59559 ASSETS Cash Accounts Receivable Inventory 2016 Common Size 13.9% 6.2% 5.3% $33,452 $15,043 $12,734 Total Current Assets $61,229 Plant & Equipment Accumulated Depreciation 2015 $34,695 $11,653 $10,104 25.4% $56,452 111.2% -36.6% $268,120 ($88,174) $217,260 ($70,300) Total Fixed Assets $179,946 74.6% $146,960 Total Assets $241,175 100.0% $203,413 4.0% 11.2% 42.7% $7,430 $33,761 $82,091 57.9% $123,282 22.7% 19.4% $36,241 $43,891 LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $9,544 $27,076 $103,071 Total Liabilities Common Stock Retained Earnings $139,691 $54,765 $46,719 Total Equity $101,484 42.1% $80,132 Total Liab. & O. Equity $241,175 100.0% $203,413 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 2016 $2,828 $17,875 $0 $2,115 ($2,630) ($3,389) 2015 $879 $13,124 $0 $846 $1,760 ($1,819) $16,799 $14,790 ($50,860) ($51,960) $0 $18,523 $0 $20,980 $0 ($6,686) $0 $17,498 $0 $34,233 ($11,300) $12,051 $32,818 ($1,243) $33,452 $52,482 $15,313 $34,695 Page 1 10/3/2014 12:23 PM COMP-XM INQUIRER 23 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 10/3/2014 12:23 PM COMP-XM INQUIRER 24 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report Chester Round: 7 Dec. 31, 2016 C59559 2016 Income Statement Coat Cure Camp Cent $41,221 $32,948 $32,847 $23,167 Na $0 Na $0 2016 Total $183,020 Common Size 100.0% $7,697 $15,782 $389 $23,869 $9,493 $17,058 $215 $26,767 $5,941 $12,155 $428 $18,525 $8,876 $14,013 $209 $23,098 $4,684 $9,782 $0 $14,466 $0 $0 $0 $0 $0 $0 $0 $0 $38,601 $74,893 $1,528 $115,023 21.1% 40.9% 0.8% 62.8% $8,951 $11,717 $14,454 $14,424 $9,749 $8,702 $0 $0 $67,997 37.2% Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $3,833 $983 $1,140 $1,000 $225 $7,181 $4,600 $0 $1,140 $1,000 $464 $7,204 $2,153 $973 $1,140 $1,900 $538 $6,704 $2,153 $973 $1,140 $2,200 $430 $6,896 $2,660 $995 $1,140 $900 $428 $6,124 $2,475 $114 $1,140 $900 $302 $4,931 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $17,875 $4,039 $6,840 $7,900 $2,387 $39,040 9.8% 2.2% 3.7% 4.3% 1.3% 21.3% Net Margin $1,770 $4,513 $7,750 $7,527 $3,625 $3,771 $0 $0 $28,957 15.8% $7,975 $20,981 $3,357 $13,184 $1,554 $58 $2,828 4.4% 11.5% 1.8% 7.2% 0.8% 0.0% 1.5% (Product Name:) Cedar $17,250 Cid $35,586 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $1,910 $6,103 $286 $8,299 Contribution Margin Sales 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. Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 Annual Report PRINT 10/3/2014 12:23 PM COMP-XM INQUIRER 25 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 10/3/2014 12:23 PM COMP-XM INQUIRER 26 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report 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. Digby Round: 7 Dec. 31, 2016 C59559 ASSETS Cash Accounts Receivable Inventory 2016 Common Size 23.1% 10.9% 8.2% $39,571 $18,631 $14,107 Total Current Assets $72,309 2015 $30,687 $14,453 $22,245 42.2% $67,385 92.8% -35.0% $121,760 ($49,404) $99,239 57.8% $72,356 $171,548 Plant & Equipment Accumulated Depreciation 100.0% $139,740 6.2% 11.4% 23.0% $10,271 $30,406 $27,613 40.6% $68,290 6.2% 53.2% $10,783 $60,668 $159,260 ($60,021) Total Fixed Assets Total Assets LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $10,672 $19,573 $39,390 Total Liabilities Common Stock Retained Earnings $69,635 $10,668 $91,245 Total Equity $101,913 59.4% $71,451 Total Liab. & O. Equity $171,548 100.0% $139,740 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 2016 $31,227 $10,617 $0 $401 $8,137 ($4,178) 2015 $15,856 $8,117 $0 $2,451 ($10,617) ($2,024) $46,205 $13,784 ($37,500) ($27,800) $0 $0 ($765) $11,777 $0 ($10,833) $0 $1,984 $0 $18,062 ($11,300) $16,435 $179 $8,884 $39,571 $25,181 $11,164 $30,687 Page 1 10/3/2014 12:23 PM COMP-XM INQUIRER 27 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 10/3/2014 12:23 PM COMP-XM INQUIRER 28 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report (Product Name:) Digby $61,349 $0 $0 Na $0 Na $0 2016 Total $226,671 Common Size 100.0% $10,328 $21,393 $257 $31,979 $10,790 $20,660 $519 $31,969 $12,465 $24,348 $917 $37,729 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $47,970 $90,005 $1,693 $139,667 21.2% 39.7% 0.7% 61.6% $23,673 $17,710 $22,001 $23,620 $0 $0 $0 $0 $87,004 38.4% $2,911 $858 $1,350 $1,000 $511 $6,629 $1,927 $655 $1,350 $1,000 $411 $5,344 $2,720 $510 $1,350 $900 $447 $5,927 $3,060 $571 $1,350 $900 $508 $6,389 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $10,617 $2,595 $5,400 $3,800 $1,877 $24,289 4.7% 1.1% 2.4% 1.7% 0.8% 10.7% $17,044 $12,367 $16,074 $17,231 $0 $0 $0 $0 $62,715 27.7% $6,850 $55,865 $2,192 $4,650 $17,158 $637 $31,227 3.0% 24.6% 1.0% 2.1% 7.6% 0.3% 13.8% Dixie $49,689 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $14,387 $23,603 $0 $37,990 Contribution Margin Net Margin 2016 Income Statement Dot Dune Na Na $53,970 Sales Dell $61,663 Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period 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. Annual Report Round: 7 Dec. 31, 2016 C59559 Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 10/3/2014 12:23 PM
