I would appreciate help with the following questions as well as explanation of how the questions are solved. Thanks! In the Month of March, Baldwin Corporation received orders of 149 units at a price of $15.00 for their product Bead. Baldwin uses the accrual method of accounting and offers 30 day credit terms. Baldwin delivers 100 units in March and the balance of 50 units in April. They received payment for 50 units in March, 50 units in April, and 50 units in May. How much revenue is recognized on the March income statement from this order? How much in the April Income statement? (Answer in thousands) Select: 1 0 , $2,235 $1,500 , $750 $2,235 , 0 $750 , $750 Your Competitive Intelligence team is predicting that the Baldwin Company will invest in adding capacity to their Buzz product this year. Assume Baldwin's product Buzz invests in increasing its capacity by 10% this year. Because of this new information, your company anticipates all other products in the Core segment will increase their capacity by the same amount. How much can the industry produce in the Core segment the next year? Consider only products primarily in the Core segment last year. Ignore current inventories. Figures in thousands (000). Select: 1 11,968 7,488 7,641 8,638 8,467 9,617 4,290 Last year Acre charged $2,728,000 Depreciation on the Income Statement of Andrews. If Acre sold a fully depreciated piece of equipment at a loss, the effect on Andrews's financial statements would be (all other items remaining equal): Select: 1 Increase Net Cash from operations Just impact the Balance Sheet No impact on Net Cash from operations Decrease Net Cash from operations on the Cash Flow Statement Assume Baldwin Corp. is downsizing the size of their workforce by 15% (to the nearest person) next year from various strategic initiatives. Baldwin 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 $1,326,510 $546,210 $96,390 $234,090 Assume Baldwin is producing 1,275 units of Bid next year. What would Bid's plant utilization be? Select: 1 73.50% 99.02% 76.50% 75.00% Baldwin's balance sheet has $84,444,000 in equity. If next year, assets decrease by $4,000,000 and liabilities increase by $2,000,000, what will be Baldwin's book value? Select: 1 $78,444,000 $86,444,000 $82,444,000 $32,904,000 All else constant, what would Baldwin?s SG&A/Sales ratio be if the company had spent an additional $1,500,000 for Bid?s promotional budget and $750,000 for Bid?s sales budget? Select: 1 10.1% 11.5% 12.1% 8.6% Currently Digby is paying a dividend of $18.97 (per share). If this dividend were raised by $3.64, given its current stock price what would be the Dividend Yield? Select: 1 12.0% $22.61 $3.64 10.1%
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 3:27 PM COMP-XM INQUIRER 2 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top " Round: 4 Dec. 31, 2017 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 15.3% 0.68 10.4% 1.3 14.0% $0 $159,956,901 $44,315,608 $24,499,284 $74,843,303 11.7% 44.6% Baldwin 6.3% 0.77 4.9% 2.4 11.7% $0 $155,581,419 $29,786,063 $9,857,760 $14,247,181 10.1% 42.9% Chester 5.4% 0.80 4.3% 2.2 9.5% $0 $194,413,249 $32,230,140 $10,518,560 $18,424,945 11.1% 39.7% Digby 18.2% 1.41 25.6% 1.7 43.4% $0 $264,502,980 $82,550,144 $48,025,556 $107,687,092 5.4% 43.0% Page 1 10/3/2014 3:27 PM COMP-XM INQUIRER 3 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Round: 4 Stocks & Bonds Season Sherman December 31 , 2017 Stock Market Summary Company Andrews Baldwin Chester Digby Close $122.48 $37.90 $47.01 $188.10 Change $10.41 $13.15 $11.70 $68.61 Shares 2,469,723 3,319,586 3,173,876 1,869,923 MarketCap ($M) $303 $126 $149 $352 Book Value $71.06 $25.44 $34.72 $59.23 EPS $9.92 $2.97 $3.31 $25.68 Dividend $3.50 $2.85 $0.57 $18.97 Yield 2.9% 7.5% 1.2% 10.1% P/E 12.3 12.8 14.2 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 11.1% 11.5% 10.9% 10.7% 10.9% 100.73 103.11 100.00 97.93 100.00 AA AA AA AA AA 12.5S2021 12.5S2022 12.5S2023 12.9S2024 13.4S2025 14.2S2026 $14,425,304 $7,963,435 $9,569,958 $14,262,838 $33,400,581 $4,040,318 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 12.4S2021 12.0S2023 12.6S2024 13.1S2025 13.8S2026 $637,453 $15,610,279 $17,788,546 $34,233,153 $20,980,308 12.9% 12.9% 13.3% 13.5% 13.8% 95.90 92.96 94.82 96.73 100.00 CCC CCC CCC CCC CCC 11.2S2023 11.5S2024 11.6S2025 12.6S2026 $1,063,194 $1,377,976 $18,062,270 $11,777,452 11.7% 11.9% 12.0% 12.4% 95.52 96.38 96.56 101.58 BBB BBB BBB BBB Andrews Baldwin Chester Digby Next Year's Prime Rate 9.00% COMP-XM INQUIRER Page 2 10/3/2014 3:27 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: 4 December 31, 2017 Season Sherman Andrews Baldwin Chester Digby $24,499 $9,858 $10,519 $48,026 $7,640 $0 $16,427 ($773) $17,875 ($824) $10,617 ($168) ($265) $9,705 ($106) $41,473 ($1,676) $7,778 ($620) $30,993 $14 ($621) ($936) $26,025 $1,782 ($2,693) ($3,109) $54,453 ($15,516) $0 $0 $0 ($8,644) $10,000 ($14,042) $0 $0 $0 $6,000 $0 ($9,474) $0 $0 $0 ($9,885) ($29,504) $27,634 $0 ($1,812) $0 $0 $0 ($12,997) ($27,076) $33,967 $0 ($35,478) $0 ($3,712) $0 ($6,941) ($19,573) $32,040 $0 ($6,686) ($21,229) ($7,917) ($33,664) $19,271 $9,764 $18,108 $20,790 Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets Andrews $164,482 $13,147 $2,363 $179,993 Baldwin $48,544 $12,788 $5,499 $66,830 Chester $51,560 $15,979 $13,355 $80,895 Digby $60,361 $21,740 $16,801 $98,901 Plant and equipment Accumulated Depreciation Total Fixed Assets $114,600 ($58,610) $55,990 $246,400 ($110,884) $135,516 $268,120 ($106,049) $162,071 $159,260 ($70,639) $88,621 Total Assets $235,983 $202,346 $242,966 $187,523 Accounts Payable Current Debt Long Term Debt Total Liabilities $6,458 $6,000 $48,018 $60,476 $6,605 $27,634 $83,662 $117,902 $9,558 $33,967 $89,250 $132,775 $12,453 $32,040 $32,281 $76,774 Common Stock Retained Earnings Total Equity $67,349 $108,158 $175,507 $49,540 $34,904 $84,444 $54,765 $55,426 $110,190 $10,279 $100,470 $110,749 Total Liabilities & Owners' Equity $235,983 $202,346 $242,966 $187,523 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 $159,957 $88,555 $7,640 $18,736 $711 $44,316 $5,855 $13,461 $500 $24,499 Baldwin $155,581 $88,803 $16,427 $15,691 $4,876 $29,786 $14,311 $5,416 $201 $9,858 Chester $194,413 $117,273 $17,875 $21,665 $5,370 $32,230 $15,717 $5,779 $215 $10,519 Digby $264,503 $150,838 $10,617 $14,256 $6,241 $82,550 $7,157 $26,388 $980 $48,026 COMP-XM INQUIRER Page 3 10/3/2014 3:27 PM COMP-XM INQUIRER 5 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Production Analysis Round: 4 December 31, 2017 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,761 1,768 1,046 1,271 200 0 0 0 8/21/2017 11/13/2017 9/19/2017 7/28/2017 1.6 1.3 1.5 1.9 20000 22000 24000 26000 9.5 12.2 13.5 15.9 10.4 7.9 3.4 6.4 $18.80 $24.00 $36.99 $35.99 $7.21 $9.47 $12.04 $12.33 $4.50 $4.41 $6.75 $6.71 36% 44% 50% 46% 100% 81% 100% 95% 9.5 8.5 8.5 8.5 930 800 528 514 198% 179% 198% 193% Bead Bid Buzz Buddy Thrift Thrift Core Core 1,791 1,816 2,147 2,084 163 172 72 125 6/10/2017 6/10/2017 12/14/2017 12/14/2017 2.6 2.6 1.6 1.6 17000 17000 18000 20000 9.8 10.0 12.5 13.2 10.2 10.0 6.8 7.3 $15.00 $15.00 $23.00 $25.00 $6.69 $6.82 $9.03 $9.64 $1.36 $1.28 $4.59 $4.36 45% 44% 41% 44% 16% 0% 70% 39% 10.0 10.0 8.0 8.0 1,550 1,700 1,150 1,400 115% 99% 168% 138% Cedar Cid Coat Cure Camp Cent Thrift Thrift Nano Elite Core Core 1,214 1,463 1,575 1,190 1,613 1,806 128 132 349 229 41 26 12/19/2016 12/7/2014 12/21/2017 12/21/2017 12/14/2017 12/14/2017 3.2 4.1 1.0 1.0 1.0 1.0 14000 16000 18000 20000 16000 16000 9.5 10.4 14.6 18.0 12.4 12.1 10.5 9.6 2.4 5.2 7.4 7.8 $15.00 $17.00 $28.00 $34.00 $19.00 $20.00 $5.93 $7.14 $11.83 $12.62 $8.63 $8.38 $1.23 $1.23 $6.08 $5.50 $4.27 $4.47 49% 45% 35% 46% 32% 37% 0% 0% 95% 32% 48% 78% 10.0 10.0 7.0 7.0 8.0 8.0 1,250 1,500 950 950 1,050 1,040 83% 89% 193% 130% 146% 176% Dell Dixie Dot Dune Nano Elite Nano Elite 2,176 1,782 1,617 1,895 102 0 465 281 9/13/2017 8/21/2017 8/13/2017 8/21/2017 1.3 1.6 1.4 1.3 23000 25000 23000 25000 15.3 18.4 15.7 18.2 2.2 4.7 1.9 4.4 $34.00 $34.00 $37.00 $37.00 $13.04 $13.82 $13.28 $13.83 $6.63 $6.63 $6.29 $6.04 42% 40% 45% 45% 100% 100% 58% 37% 7.0 7.0 7.0 7.0 1,150 850 1,200 1,350 198% 198% 157% 136% COMP-XM INQUIRER Page 4 10/3/2014 3:27 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: 4 December 31, 2017 Thrift Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 7,754 7,754 25.8% 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.5 Size 10.5 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 Cent Camp Buzz Market Share 22% 22% 21% 15% 12% 4% 3% 1% 0% Units Sold to Seg 1,711 1,693 1,644 1,171 901 329 206 96 3 COMP-XM INQUIRER Revision Date Stock Out 6/10/2017 6/10/2017 8/21/2017 12/19/2016 12/7/2014 11/13/2017 YES 12/14/2017 12/14/2017 12/14/2017 Pfmn Coord 9.8 10.0 9.5 9.5 10.4 12.2 12.1 12.4 12.5 Size Coord 10.2 10.0 10.4 10.5 9.6 7.9 7.8 7.4 6.8 List Price $15.00 $15.00 $18.80 $15.00 $17.00 $24.00 $20.00 $19.00 $23.00 MTBF 17000 17000 20000 14000 16000 22000 16000 16000 18000 Age Dec.31 2.65 2.60 1.64 3.25 4.11 1.31 0.96 0.96 1.56 Promo Cust. AwareBudget ness $1,300 83% $1,300 83% $1,700 100% $1,200 72% $1,200 72% $1,700 100% $1,200 62% $1,200 67% $1,300 83% Sales Cust. AccessBudget ibility $1,600 83% $1,600 83% $1,900 89% $1,000 78% $1,000 78% $1,900 89% $900 78% $900 78% $1,400 83% Dec. Cust. Survey 69 67 65 46 36 3 2 0 0 Page 5 10/3/2014 3:27 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: 4 December 31, 2017 Core Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 9,788 9,788 32.6% 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.8 Size 7.2 Price Age Reliability Ideal Position Importance 46% 20% 18% 16% Perceptual Map for Core Segment Top Products in Core Segment Name Buzz Buddy Cent Camp Adam Cid Bid Acre Bead Agape Cedar Aft Market Share 22% 21% 16% 16% 15% 6% 1% 1% 1% 1% 0% 0% Units Sold to Seg 2,138 2,074 1,600 1,517 1,439 562 123 117 80 59 43 35 COMP-XM INQUIRER Revision Date Stock Out 12/14/2017 12/14/2017 12/14/2017 12/14/2017 11/13/2017 YES 12/7/2014 6/10/2017 8/21/2017 6/10/2017 7/28/2017 YES 12/19/2016 9/19/2017 YES Pfmn Coord 12.5 13.2 12.1 12.4 12.2 10.4 10.0 9.5 9.8 15.9 9.5 13.5 Size Coord 6.8 7.3 7.8 7.4 7.9 9.6 10.0 10.4 10.2 6.4 10.5 3.4 List Price $23.00 $25.00 $20.00 $19.00 $24.00 $17.00 $15.00 $18.80 $15.00 $35.99 $15.00 $36.99 MTBF 18000 20000 16000 16000 22000 16000 17000 20000 17000 26000 14000 24000 Age Dec.31 1.56 1.57 0.96 0.96 1.31 4.11 2.60 1.64 2.65 1.87 3.25 1.52 Promo Cust. AwareBudget ness $1,300 83% $1,300 83% $1,200 62% $1,200 67% $1,700 100% $1,200 72% $1,300 83% $1,700 100% $1,300 83% $1,700 100% $1,200 72% $1,700 100% Sales Cust. AccessBudget ibility $1,400 81% $1,400 81% $900 73% $900 73% $1,900 73% $1,000 73% $1,600 81% $1,900 73% $1,600 81% $1,900 73% $1,000 73% $1,900 73% Dec. Cust. Survey 53 52 39 37 63 10 3 0 2 1 0 0 Page 6 10/3/2014 3:27 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: 4 December 31, 2017 Nano Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 6,170 6,170 20.6% Next Year's Segment Growth Rate 14.0% Nano Customer Buying Criteria 1. 2. 3. 4. Expectations Pfmn 14.7 Size 2.1 $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 Dune Buzz Buddy Market Share 32% 25% 25% 16% 2% 0% 0% 0% Units Sold to Seg 1,956 1,555 1,555 973 104 19 5 3 COMP-XM INQUIRER Revision Date Stock Out 9/13/2017 8/13/2017 12/21/2017 9/19/2017 YES 7/28/2017 YES 8/21/2017 12/14/2017 12/14/2017 Pfmn Coord 15.3 15.7 14.6 13.5 15.9 18.2 12.5 13.2 Size Coord 2.2 1.9 2.4 3.4 6.4 4.4 6.8 7.3 List Price $34.00 $37.00 $28.00 $36.99 $35.99 $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.52 1.87 1.35 1.56 1.57 Promo Cust. AwareBudget ness $1,400 92% $1,400 92% $1,200 73% $1,700 100% $1,700 100% $1,400 91% $1,300 83% $1,300 83% Sales Cust. AccessBudget ibility $1,100 80% $1,000 80% $2,400 74% $1,900 75% $1,900 75% $1,000 80% $1,400 12% $1,400 12% Dec. Cust. Survey 66 51 56 47 4 0 0 0 Page 7 10/3/2014 3:27 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: 4 December 31, 2017 Elite Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment % of Total Industry 6,303 6,303 21.0% 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 17.9 Size 5.3 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 Dot Aft Coat Buddy Market Share 30% 28% 19% 18% 3% 1% 1% 0% 0% Units Sold to Seg 1,876 1,782 1,190 1,109 220 62 38 20 7 COMP-XM INQUIRER Revision Date Stock Out 8/21/2017 8/21/2017 YES 12/21/2017 7/28/2017 YES 9/13/2017 8/13/2017 9/19/2017 YES 12/21/2017 12/14/2017 Pfmn Coord 18.2 18.4 18.0 15.9 15.3 15.7 13.5 14.6 13.2 Size Coord 4.4 4.7 5.2 6.4 2.2 1.9 3.4 2.4 7.3 List Price $37.00 $34.00 $34.00 $35.99 $34.00 $37.00 $36.99 $28.00 $25.00 MTBF 25000 25000 20000 26000 23000 23000 24000 18000 20000 Age Dec.31 1.35 1.63 1.03 1.87 1.27 1.36 1.52 1.02 1.57 Promo Cust. AwareBudget ness $1,400 91% $1,400 92% $1,200 72% $1,700 100% $1,400 92% $1,400 92% $1,700 100% $1,200 73% $1,300 83% Sales Cust. AccessBudget ibility $1,000 87% $1,000 87% $2,400 74% $1,900 80% $1,100 87% $1,000 87% $1,900 80% $2,400 74% $1,400 5% Dec. Cust. Survey 50 54 37 39 0 0 0 0 0 Page 8 10/3/2014 3:27 PM COMP-XM INQUIRER 10 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Market Share Report Round: 4 December 31, 2017 Season Sherman Actual Market Share in Units Potential Market Share in Units Thrift 7,754 25.8% Core 9,788 32.6% Nano 6,170 20.6% Elite 6,303 21.0% Total 30,014 100.0% Acre Adam Aft Agape Total 21.2% 4.3% 1.2% 14.7% 0.4% 0.6% 16.9% 15.8% 1.7% 17.4% 0.6% 17.6% 18.2% 5.9% 5.9% 3.5% 4.2% 19.5% Acre Adam Aft Agape Total Bead Bid Buzz Buddy Total 22.1% 21.8% 0.0% 0.1% 0.1% 0.1% 0.1% 0.1% 6.0% 6.0% 7.2% 6.9% 26.1% Bead Bid Buzz Buddy Total 21.7% 21.5% 43.9% 0.8% 1.3% 21.9% 21.2% 45.1% 43.2% 0.7% 1.1% 20.3% 19.6% 41.8% Cedar Cid Coat Cure Camp Cent Total 15.1% 11.6% 0.4% 5.8% 25.2% 19.2% Cedar Cid Coat Cure Camp Cent Total 0.4% 5.3% 0.3% 18.9% 4.0% 4.9% 5.3% 4.0% 5.4% 6.0% 29.5% 14.8% 11.4% 25.2% 31.7% 3.5% 28.3% 1.0% 29.8% 62.5% 7.3% 5.9% 5.4% 6.3% 24.9% Dell Dixie Dot Dune Total Industry Unit Sales % of Market 25.4% 1.2% 2.6% 30.6% Dell Dixie Dot Dune Total COMP-XM INQUIRER 15.5% 16.4% 38.0% 25.2% 0.3% 57.2% Units Demanded % of Market Thrift 7,754 25.8% Core 9,788 32.6% Nano 6,170 20.6% Elite 6,303 21.0% Total 30,014 100.0% 20.8% 6.0% 1.1% 20.9% 0.3% 0.6% 22.9% 17.7% 2.0% 19.6% 0.6% 20.6% 21.2% 5.7% 8.3% 3.9% 4.9% 22.9% 0.1% 0.1% 0.1% 5.8% 5.9% 6.6% 6.4% 24.8% 24.6% 0.3% 17.7% 24.6% 18.0% 30.8% 3.5% 28.7% 1.0% 27.5% 60.7% 26.8% 1.2% 2.6% 30.1% 14.4% 15.2% 35.3% 0.1% 24.5% 0.3% 55.7% 4.0% 4.7% 5.1% 3.7% 5.0% 5.6% 28.1% 7.1% 6.0% 5.2% 5.8% 24.2% Page 9 10/3/2014 3:27 PM COMP-XM INQUIRER 11 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Perceptual Map Round: 4 December 31, 2017 Season Sherman Perceptual Map for All Segments Andrews Name Acre Adam Aft Agape Pfmn 9.5 12.2 13.5 15.9 Name Dell Dixie Dot Dune Size 10.4 7.9 3.4 6.4 Pfmn 15.3 18.4 15.7 18.2 Baldwin Revised 8/21/2017 11/13/2017 9/19/2017 7/28/2017 Name Bead Bid Buzz Buddy Pfmn 9.8 10.0 12.5 13.2 Size 10.2 10.0 6.8 7.3 Chester Revised 6/10/2017 6/10/2017 12/14/2017 12/14/2017 Name Cedar Cid Coat Cure Camp Cent Pfmn 9.5 10.4 14.6 18.0 12.4 12.1 Size 10.5 9.6 2.4 5.2 7.4 7.8 Revised 12/19/2016 12/7/2014 12/21/2017 12/21/2017 12/14/2017 12/14/2017 Digby COMP-XM INQUIRER Size 2.2 4.7 1.9 4.4 Revised 9/13/2017 8/21/2017 8/13/2017 8/21/2017 Page 10 10/3/2014 3:27 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: 4 December 31, 2017 HUMAN RESOURCES SUMMARY Needed Complement Complement 1st Shift Complement 2nd Shift Complement Andrews 373 373 192 181 Baldwin 306 306 220 87 Chester 495 495 322 173 Digby 641 641 376 265 Overtime% Turnover Rate New Employees Separated Employees Recruiting Spend Training Hours Productivity Index 0.0% 6.7% 25 62 $5,000 80 115.6% 0.0% 8.0% 24 125 $2,500 40 118.6% 0.0% 6.0% 30 90 $5,000 80 130.2% 0.0% 10.0% 82 0 $0 0 100.0% Recruiting Cost Separation Cost Training Cost Total HR Admin Cost $151 $310 $597 $1,058 $85 $627 $245 $958 $179 $448 $792 $1,419 $82 $0 $0 $82 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 Baldwin Chester Digby Process Mgt Budgets Last Year CPI Systems Vendor/JIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs $0 $0 $0 $0 $0 $0 $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 $0 $0 $0 $0 $0 $0 $0 $750 $750 $5,500 $1,500 $0 $0 $0 $6,000 $0 $0 $1,250 $1,250 $6,250 11.64% 13.86% 40.01% 60.02% 13.97% 10.20% 4.39% 0.00% 34.91% 10.57% 6.07% 0.28% 0.00% 60.02% 2.35% 9.48% 14.00% 40.01% 0.00% 12.78% Cumulative Impacts Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction Admin Costs Demand Increase COMP-XM INQUIRER Page 11 10/3/2014 3:27 PM COMP-XM INQUIRER 13 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... PRINT 10/3/2014 3:27 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: 8 Dec. 31, 2017 C59559 ASSETS $145,211 $13,041 $12,067 76.3% $170,319 48.6% -24.8% $99,084 ($50,970) $55,990 23.7% $48,114 $235,983 Cash Accounts Receivable Inventory 2017 Common Size 69.7% 5.6% 1.0% 100.0% $218,434 2.7% 2.5% 20.3% $6,722 $0 $48,018 25.6% $54,740 28.5% 45.8% $63,272 $100,421 $164,482 $13,147 $2,363 Total Current Assets $179,992 Plant & Equipment Accumulated Depreciation $114,600 ($58,610) Total Fixed Assets Total Assets 2016 LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $6,458 $6,000 $48,018 Total Liabilities Common Stock Retained Earnings $60,476 $67,349 $108,158 Total Equity $175,507 74.4% $163,693 Total Liab. & O. Equity $235,983 100.0% $218,434 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 $24,499 $7,640 $0 ($265) $9,705 ($106) 2016 $22,753 $6,606 ($1,633) ($273) ($1,098) $1,214 $41,473 $27,569 ($15,516) $6,936 ($8,644) $10,000 ($14,042) $0 $0 $6,000 $0 $37,730 ($9,432) $13,387 $0 ($11,300) ($6,686) $19,271 $164,482 $30,384 $64,889 $145,211 Page 1 10/3/2014 3:27 PM COMP-XM INQUIRER 15 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 10/3/2014 3:27 PM COMP-XM INQUIRER 16 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report Andrews Round: 8 Dec. 31, 2017 C59559 2017 Income Statement Aft Agape Na Na $38,677 $45,748 $0 $0 Na $0 Na $0 2017 Total $159,957 Common Size 100.0% $7,984 $15,757 $0 $23,742 $7,059 $12,144 $0 $19,204 $8,825 $15,703 $0 $24,528 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $31,944 $56,327 $284 $88,555 20.0% 35.2% 0.2% 55.4% $12,018 $18,690 $19,474 $21,220 $0 $0 $0 $0 $71,402 44.6% Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $2,728 $646 $1,700 $1,900 $312 $7,285 $2,133 $879 $1,700 $1,900 $399 $7,011 $1,408 $726 $1,700 $1,900 $364 $6,098 $1,371 $580 $1,700 $1,900 $431 $5,981 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $7,640 $2,830 $6,800 $7,600 $1,505 $26,376 4.8% 1.8% 4.3% 4.8% 0.9% 16.5% Net Margin $4,733 $11,679 $13,376 $15,239 $0 $0 $0 $0 $45,026 28.1% $711 $44,316 $540 $5,315 $13,461 $500 $24,499 0.4% 27.7% 0.3% 3.3% 8.4% 0.3% 15.3% (Product Name:) Sales Acre $33,100 Adam $42,432 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $8,075 $12,723 $284 $21,082 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 3:27 PM COMP-XM INQUIRER 17 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 10/3/2014 3:27 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 2017 Common Size 24.0% 6.3% 2.7% $48,544 $12,788 $5,499 Total Current Assets $66,831 Plant & Equipment Accumulated Depreciation 2016 $38,780 $12,167 $13,277 33.0% $64,224 121.8% -54.8% $246,400 ($110,884) $246,400 ($94,458) Total Fixed Assets $135,516 67.0% $151,942 Total Assets $202,346 100.0% $216,166 3.3% 13.7% 41.3% $8,281 $29,504 $94,320 58.3% $132,105 24.5% 17.2% $49,540 $34,521 LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $6,605 $27,634 $83,662 Total Liabilities Common Stock Retained Earnings $117,901 $49,540 $34,904 Total Equity $84,444 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. 41.7% $84,061 $202,346 Total Liab. & O. Equity 100.0% $216,166 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: 8 Dec. 31, 2017 C59559 2017 $9,858 $16,427 ($773) ($1,676) $7,778 ($620) 2016 $1,166 $16,427 $0 $427 ($8,068) $296 $30,993 $10,248 $0 ($22,500) ($9,474) $0 $0 $0 ($9,885) ($1,870) $0 $10,704 $0 $4,040 $0 ($13,256) ($21,229) $9,764 $48,544 $1,488 ($10,763) $38,780 Page 1 10/3/2014 3:27 PM COMP-XM INQUIRER 19 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 10/3/2014 3:27 PM COMP-XM INQUIRER 20 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report Baldwin Round: 8 Dec. 31, 2017 C59559 2017 Income Statement Buzz Buddy Na Na $49,379 $52,101 $0 $0 Na $0 Na $0 2017 Total $155,581 Common Size 100.0% $2,789 $12,366 $172 $15,327 $9,862 $19,370 $118 $29,351 $9,121 $20,064 $210 $29,395 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $24,463 $63,680 $660 $88,803 15.7% 40.9% 0.4% 57.1% $12,128 $11,917 $20,029 $22,706 $0 $0 $0 $0 $66,779 42.9% Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $4,753 $446 $1,300 $1,600 $288 $8,387 $5,213 $446 $1,300 $1,600 $292 $8,851 $2,913 $966 $1,300 $1,400 $529 $7,108 $3,547 $966 $1,300 $1,400 $558 $7,771 $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,824 $5,200 $6,000 $1,667 $32,117 10.6% 1.8% 3.3% 3.9% 1.1% 20.6% Net Margin $3,741 $3,066 $12,920 $14,935 $0 $0 $0 $0 $34,662 22.3% $4,876 $29,786 $3,427 $10,884 $5,416 $201 $9,858 3.1% 19.1% 2.2% 7.0% 3.5% 0.1% 6.3% (Product Name:) Sales Bead $26,858 Bid $27,243 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $2,691 $11,880 $160 $14,731 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 3:27 PM COMP-XM INQUIRER 21 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 10/3/2014 3:27 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: 8 Dec. 31, 2017 C59559 ASSETS Cash Accounts Receivable Inventory 2017 Common Size 21.2% 6.6% 5.5% $51,560 $15,979 $13,355 Total Current Assets $80,894 Plant & Equipment Accumulated Depreciation 2016 $33,452 $15,043 $12,734 33.3% $61,229 110.4% -43.6% $268,120 ($106,049) $268,120 ($88,174) Total Fixed Assets $162,071 66.7% $179,946 Total Assets $242,966 100.0% $241,175 3.9% 14.0% 36.7% $9,544 $27,076 $103,071 54.6% $139,691 22.5% 22.8% $54,765 $46,719 LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $9,558 $33,967 $89,250 Total Liabilities Common Stock Retained Earnings $132,775 $54,765 $55,426 Total Equity $110,191 45.4% $101,484 Total Liab. & O. Equity $242,966 100.0% $241,175 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 $10,519 $17,875 ($824) $14 ($621) ($936) 2016 $2,828 $17,875 $0 $2,115 ($2,630) ($3,389) $26,025 $16,799 $0 ($50,860) ($1,812) $0 $0 $0 ($12,997) $6,892 $0 $18,523 $0 $20,980 $0 ($6,686) ($7,917) $18,108 $51,560 $32,818 ($1,243) $33,452 Page 1 10/3/2014 3:27 PM COMP-XM INQUIRER 23 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 10/3/2014 3:27 PM COMP-XM INQUIRER 24 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report Chester Round: 8 Dec. 31, 2017 C59559 2017 Income Statement Coat Cure Camp Cent $44,108 $40,451 $30,645 $36,119 Na $0 Na $0 2017 Total $194,413 Common Size 100.0% $2,486 $11,024 $146 $13,655 $9,637 $18,285 $743 $28,665 $6,689 $14,841 $496 $22,026 $7,047 $13,688 $63 $20,798 $8,077 $14,801 $39 $22,917 $0 $0 $0 $0 $0 $0 $0 $0 $35,609 $80,062 $1,603 $117,273 18.3% 41.2% 0.8% 60.3% $8,999 $11,224 $15,442 $18,425 $9,847 $13,202 $0 $0 $77,140 39.7% Period Costs: Depreciation SG&A: R&D Promotions Sales Admin Total Period $3,833 $0 $1,200 $1,000 $184 $6,217 $4,600 $0 $1,200 $1,000 $251 $7,051 $2,153 $985 $1,200 $2,400 $445 $7,183 $2,153 $985 $1,200 $2,400 $408 $7,146 $2,660 $966 $1,200 $900 $309 $6,035 $2,475 $966 $1,200 $900 $365 $5,905 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $17,875 $3,902 $7,200 $8,600 $1,963 $39,539 9.2% 2.0% 3.7% 4.4% 1.0% 20.3% Net Margin $2,782 $4,173 $8,259 $11,279 $3,812 $7,297 $0 $0 $37,601 19.3% $5,370 $32,230 $4,144 $11,573 $5,779 $215 $10,519 2.8% 16.6% 2.1% 6.0% 3.0% 0.1% 5.4% (Product Name:) Cedar $18,210 Cid $24,879 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $1,673 $7,423 $115 $9,211 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 3:27 PM COMP-XM INQUIRER 25 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 10/3/2014 3:27 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: 8 Dec. 31, 2017 C59559 ASSETS Cash Accounts Receivable Inventory 2017 Common Size 32.2% 11.6% 9.0% $60,361 $21,740 $16,801 Total Current Assets $98,902 2016 $39,571 $18,631 $14,107 52.7% $72,309 84.9% -37.7% $159,260 ($60,021) $88,621 47.3% $99,239 $187,523 Plant & Equipment Accumulated Depreciation 100.0% $171,548 6.6% 17.1% 17.2% $10,672 $19,573 $39,390 40.9% $69,635 5.5% 53.6% $10,668 $91,245 $159,260 ($70,639) Total Fixed Assets Total Assets LIABILITIES & OWNERS' EQUITY Accounts Payable Current Debt Long Term Debt $12,453 $32,040 $32,281 Total Liabilities Common Stock Retained Earnings $76,774 $10,279 $100,470 Total Equity $110,749 59.1% $101,913 Total Liab. & O. Equity $187,523 100.0% $171,548 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 $48,026 $10,617 ($168) $1,782 ($2,693) ($3,109) 2016 $31,227 $10,617 $0 $401 $8,137 ($4,178) $54,453 $46,205 $0 ($37,500) ($35,478) $0 ($3,712) $0 ($6,941) $12,467 $0 $0 ($765) $11,777 $0 ($10,833) ($33,664) $20,790 $60,361 $179 $8,884 $39,571 Page 1 10/3/2014 3:27 PM COMP-XM INQUIRER 27 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... 10/3/2014 3:27 PM COMP-XM INQUIRER 28 of 28 http://ww2.capsim.com/cgi-bin/CpCGIReports2011.exe?XM=1&student... Top Annual Report (Product Name:) Digby $70,098 $0 $0 Na $0 Na $0 2017 Total $264,503 Common Size 100.0% $11,853 $24,556 $0 $36,408 $10,345 $21,511 $1,098 $32,953 $11,881 $26,315 $681 $38,877 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $48,497 $100,325 $2,016 $150,838 18.3% 37.9% 0.8% 57.0% $31,376 $24,179 $26,889 $31,221 $0 $0 $0 $0 $113,665 43.0% $2,911 $710 $1,400 $1,100 $541 $6,661 $1,927 $645 $1,400 $1,000 $443 $5,414 $2,720 $623 $1,400 $1,000 $437 $6,180 $3,060 $645 $1,400 $1,000 $512 $6,617 $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,622 $5,600 $4,100 $1,934 $24,873 4.0% 1.0% 2.1% 1.6% 0.7% 9.4% $24,715 $18,764 $20,709 $24,603 $0 $0 $0 $0 $88,792 33.6% $6,241 $82,550 $3,300 $3,857 $26,388 $980 $48,026 2.4% 31.2% 1.2% 1.5% 10.0% 0.4% 18.2% Dixie $60,587 Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $14,419 $27,943 $237 $42,599 Contribution Margin Net Margin 2017 Income Statement Dot Dune Na Na $59,843 Sales Dell $73,976 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: 8 Dec. 31, 2017 C59559 Other EBIT Short Term Interest LongTerm Interest Taxes Profit Sharing Net Profit Page 2 10/3/2014 3:27 PM
