Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit Check my work Use Apple's financial statements in Appendix A to answer the following. Required: 10 1. Using fiscal 2017 as the base year, compute trend percents for fiscal years 2017, 2018, and 2019 for total net sales, total cost of sales, points operating income, other income (expense) net, provision for income taxes, and net income. Skipped 2. Compute common-size percents for fiscal years 2018 and 2019 for the following categories of assets: (a) total current assets; (b) property, plant and equipment, net; and (c) accounts receivable, net. 3. Using current assets as a percent of total assets to measure liquidity, did Apple's asset makeup become more liquid or less liquid in 2019? eBook Complete this question by entering your answers in the tabs below. Print Required 1 Required 2 Required 3 References Using fiscal 2017 as the base year, compute trend percents for fiscal years 2017, 2018, and 2019 for total net sales, total cost of sales, operating income, other income (expense) net, provision for income taxes, and net income. (Input all the values as positive numbers. Enter your answers in millions. Round your percentage answers to 1 decimal place.) Fiscal 2019 Fiscal 2018 Fiscal 2017 Net Sales % % % Cost of sales % Operating income % % Other income (expense) % 1% Provision for income taxes Net income Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit Check my work Use Apple's financial statements in Appendix A to answer the following. Required: 10 1. Using fiscal 2017 as the base year, compute trend percents for fiscal years 2017, 2018, and 2019 for total net sales, total cost of sales, points operating income, other income (expense) net, provision for income taxes, and net income. Skipped 2. Compute common-size percents for fiscal years 2018 and 2019 for the following categories of assets: (a) total current assets; (b) property, plant and equipment, net; and (c) accounts receivable, net. 3. Using current assets as a percent of total assets to measure liquidity, did Apple's asset makeup become more liquid or less liquid in 2019? eBook Complete this question by entering your answers in the tabs below. Print Required 1 Required 2 Required 3 References Compute common-size percents for fiscal years 2018 and 2019 for the following categories of assets: (a) total current assets; (b) property, plant and equipment, net; and (c) accounts receivable, net. (Enter your answers in millions. Round your percentage answers to 1 decimal place.) 2019 2018 Total current assets % Property, plant and equipment, net % Accounts receivable, net Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit Check my work 2 Key figures for Apple and Google follow. $ millions Apple Google 10 Cash and equivalents $ 48, 844 18, 498 point Accounts receivable, net 22, 926 25, 326 Inventories , 106 999 Skipped Retained earnings 45, 898 152, 122 Cost of sales 161, 782 71, 896 Revenues 260, 17 161, 857 Total assets 338 , 516 275, 909 eBook Required: 1. Compute common-size percents for each company using the data given. 2. If Google paid a dividend, would retained earnings as a percent of total assets increase or decrease? Print 3. Which company has the better gross margin ratio on sales? Complete this question by entering your answers in the tabs below. References Required 1 Required 2 Required 3 Compute common-size percents for each company using the data given. (Input all the values as positive numbers. Enter your answers in millions. Round your percentage answers to 1 decimal place. $ millions Apple Google Cash and equivalents % Accounts receivable, net % Inventories 1% Retained earnings % Cost of sales % Revenues Total assets Required 1 Required 2 > Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit Check my work 3 Key figures for Samsung follow (in $ millions). Cash and equivalents $ 23, 069 Cost of sales $ 126, 336 10 Accounts receivable, net 30, 144 Revenues 197, 691 point Inventories 22,966 Total assets 302, 511 Retained earnings 218, 440 Skipped Required: 1. Compute common-size percents for Samsung using the data given. 2. What is Samsung's gross margin ratio on sales? 3. Does Samsung's gross margin ratio outperform or underperform the industry average of 25%? eBook Complete this question by entering your answers in the tabs below. Print Required 1 Required 2 Required 3 References comp Required 1 R size percents for Samsung using the data given. (Input all the values as positive numbers. Enter your answere Round your percentage answers to 1 decimal place.) $ millions Samsung Cash and equivalents Accounts receivable, net Inventories Retained earnings Cost of sales Revenues Total assets Required 1 Required 2 > Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit Check my work 3 Key figures for Samsung follow (in $ millions). Cash and equivalents $ 23, 069 Cost of sales $ 126, 336 10 Accounts receivable, net 30, 144 Revenues 197, 691 point Inventories 22,966 Total assets 302, 511 Retained earnings 218, 440 Skipped Required: 1. Compute common-size percents for Samsung using the data given. 2. What is Samsung's gross margin ratio on sales? 3. Does Samsung's gross margin ratio outperform or underperform the industry average of 25%? eBook Complete this question by entering your answers in the tabs below. Print Required 1 Required 2 Required 3 References What is Samsung's gross margin ratio on sales? (Round your intermediate computations and final answer to 1 decimal place.) What is Samsung's gross margin ratio on sales? % Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 4 1. Compute and interpret financial ratios that managers use to assess liquidity. 2. Compute and interpret financial ratios that managers use for asset management purposes. 3. Compute and interpret financial ratios that managers use for debt management purposes. 15 point Skipped eBook Print References X All answers must be entered as a ormula. Click OK to begin OK Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 4 1. Compute and interpret financial ratios that managers use to assess liquidity. 2. Compute and interpret financial ratios that managers use for asset management purposes 3. Compute and interpret financial ratios that managers use for debt management purposes. 15 points X H 5 . 2 . Selected Financial Ratios - Excel ? 6 - 5 X Skipped FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 4 Tables Illustrations Apps for Recommended" PivotChart Power Sparklines Filters Links Symbols eBook Office - Charts View Apps Charts Reports A x v fx Recent financial statements for Zimmer, Inc. are as follows Print H Recent financial statements for Zimmer, Inc. are as follows: References Zimmer Company Zimmer Company Comparative Balance Sheet Income Statement This Year Last Year This Year 5 Assets Current assets: 7 Cash 310,000 Sales (all on account) $4,980,000 Marketable securities 20,000 80,000 Cost of goods sold 2.988.000 Accounts receivable, net 775,000 700,000 Gross margin 1,992,000 Inventory 925,000 750,000 Selling and administrative expenses 11 Other current assets 325-080 195,000 Operating expenses 985,500 12 Total current assets 2,635,000 2,035,000 Depreciation and amortization 410.500 13 Plant and equipment, net 1,975,000 1,800,000 General and administrative expenses 150.000 4 Other assets 75,000 100,000 Total selling and administrative expenses 1,546.000 15 Total assets 4.685.000 $ 3.935.000 Net operating income 446,000 16 Liabilities and Stockholders' Equity Interest expense 60,000 7 Current Liabilities: Net income before taxes 386,000 Accounts payable 250,000 $ 225,000 Income taxes 135,100 19 Short-term bank loans 750,000 600,000 Net income $ 250.900 20 Accrued payables 550,000 395,000 21 Other current liabilities 275,000 223.400 Additional information: 22 Total current liabilities ,825,000 1,443,400 Dividend per share paid in current year 1.00 23 Bonds payable, 10% 575.000 400.000 Market price of shares at year end 42.00 24 Total liabilities 2400.000 1,843.400 Par value of common stock per share 20.00 25 Stockholders' equity: 26 Common stock 1,150,000 1,150,000 Number of shares outstanding 27 Retained earning 1.135,000 941.600 8 Total stockholders' equity 2.285,000 2,091.600 ... Sheet1 READY B U -+ -+ 30% Attempt(s) Hint Show Me Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 4 1. Compute and interpret financial ratios that managers use to assess liquidity. 2. Compute and interpret financial ratios that managers use for asset management purposes 3. Compute and interpret financial ratios that managers use for debt management purposes. 15 points X H 5 . 2 . Selected Financial Ratios - Excel ? 6 - 5 X Skipped FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 4 Tables Illustrations Apps for Recommended" PivotChart Power Sparklines Filters Links Symbols eBook Office - Charts View Apps Charts Reports A x v fx Recent financial statements for Zimmer, Inc. are as follows Print H 25 Stockholders' equity: References 26 Common stock 1,150,000 1,150,000 Number of shares outstanding 27 Retained earnings 1.135,000 941.60 28 Total stockholders' equity 2.285,000 2.091.600 29 Total liabilities and stockholders' equity 4.685 000 $ 3.935 000 30 31 Required: 32 Compute the following ratios for the current year only: 33 Gross margin percentage 34 C 5 Acid-test ratio (rounded to two decimal places) 36 A 37 Accounts receivable turnover (rounded to two decimal places) Average collection carest whole day) 38 Inventory turnover ratio (rounded to two decimal places) 9 Average sales period (rounded to the nearest whole day) 40 D Debt-to-equity ratio (rounded to two decimal places) 1 Times interest earned (rounded to two decimal places) Book value per share (rounded to two decimal places) Earnings per share (rounded to two decimal places) 44 Dividend payout ratio (rounded to three decimal places) 45 Dividend yield ratio (rounded to three decimal places) 46 Price-earnings ratio (rounded to two decimal places) 47 48 49 .. Sheet1 ... READY 8:3 W -+ -+ 30% Attempt(s) Hint Show Me Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 5 1. Use ratios to analyze a company's liquidity and solvency. 15 points eBook Print References X All answers must be entered as a formula. Click OK to begin. OK Next Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 5 1. Use ratios to analyze a company's liquidity and solvency. 15 Calculate Select Ratios - Excel ? 0 - 5X points FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 6 Calibri - 11 - A" A E % Paste BIU - - - A - Alignment Number Conditional Format as Cell Cells Editing Book Formatting " Table " Styles Clipboard Font Styles Al Print X V fx Condensed financial statements for Games Galore are summarized below: 2 Condensed financial statements for Games Galore are summarized below: References 3 Balance Sheet 2016 2015 4 Cash S 185,000 $ 143,000 5 Accounts Receivable, Net 80,000 59,000 6 Inventory 104,000 34.000 7Prepaid Insurance 11,900 5,880 Total Current Assets 380 900 41,880 9 Property and Equipment, Net 10 Total Assets 514,500 895,400 $ 40 1-860 748,880 Current Liabilities 85,300 $ 96,800 13 Long-term Liabilities 284,000 24.000 Total Liabilities 369,300 320.800 15 Contributed Capital 299,000 299,000 16 Retained Earnings 227,100 129,080 7 Total Stockholders' Equity $26,100 428,080 18 Total Liabilities and Stockholders' Equity 895,400 $ 748.880 19 20 Income Statement 21 Net Sales (all on account) $ 3,031,000 22 Cost of Goods Sold 1,949,000 23 Gross Profit 082,000 24 Operating Expenses 891.400 25 Income from Operations 190,600 26 Interest Expense 14,500 27 Income before Income Tax Expense 76,100 28 Income Tax Expense 47,000 29 Net Income S 129,100 30 31 Required: ... Sheet1 ... + READY + 20% Attempt(s) Hint Show Me Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 5 1. Use ratios to analyze a company's liquidity and solvency. 15 Calculate Select Ratios - Excel ? 6 - 5X points FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri - 11 - A" A' E % Paste BIU - - - A - Alignment Number Conditional Format as Cell Cells Editing Book Formatting ~ Table . Styles Clipboard Font Styles Print vix V fx Condensed financial statements for Games Galore are summarized below: Income from Operations 190,600 6 Interest Expense 14,500 References 27 Income before Income Tax Expense 16,100 8 Income Tax Expense 47,000 9 Net Income 129,100 30 31 Required: 32 Compute the following liquidity ratios for 2016. Rou 33 required number of decimal places USING THE EXCEL. 34 ROUND FUNCTION (fx). 5 Current ratio (rounded to one decimal place) to 1 36 Receivables turnover (rounded to two decimal places) times Days to collect (rounded to the nearest whole day) days 39 Inventory turnover (rounded to two decimal places) times Days' sales in inventory (rounded to the nearest day) days 40 1 Compute the following Solvency Ratios for 2016. Again, USE 2 THE EXCEL ROUND FUNCTION (fx). 13 Debt to assets (rounded to two decimal places 44 Times interest earned (rounded to one decimal place) times 45 46 Compute the following Profitability Ratios for 2016. Again, USE 47 THE EXCEL ROUND FUNCTION (fx). Profit margin ratio (rounded to one decimal place) percent Gross margin ratio (rounded to one decimal place) percent 50 51 52 ... Sheet1 ... + READY 83 0 -+ + 20% Attempt(s) Hint Show Me Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 6 . Use vertical analysis to compare profitability. 15 points eBook Print References X All answers must be entered as a formula. Click OK to begin. OK Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 6 . Use vertical analysis to compare profitability. 15 Perform Vertical Analysis - Excel ? 0 - 5 X points FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri - 11 - A" A' E % Paste BIU - - - A - Alignment Number Conditional Format as Cell Book Cells Editing Formatting ~ Table . Styles ~ Clipboard Font Styles Al Print 1 X fx Lake Athletics sells two distinct product lines: Apparel and Equipment. 1 Lake Athletics sells two distinct product lines: Apparel and Equipment. References The income statement for each product line appears below. LAKE ATHLETICS Income Statement For the Year Ended December 31, 20X1 Apparel 8 Equipment Amount Percent Amount Percent 9 Net sales $3, 150,000 $5,550,000 10 Cost of goods sold ,400,000 2,720,000 11 Gross profit 1,750,000 2,830,000 12 Operating expenses 800,000 875,000 13 Operating income 50,000 ,955,000 14 Other income 20,000 10,000 15 Income before tax 970,000 965,000 16 Income tax expense 41,250 491,000 17 Net income 728,750 1,474,750 18 19 Required: 20 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns 21 for both product lines above. Express each amount as a percentage of net sales. 22 Note: You should use absolute references in the divisors of all formulas. 23 2. Use the Excel IF function and the completed vertical analysis above to answer each of the 24 questions below: Sheet1 1 ... + READY - + 100% Attempt(s) Hint Show Me Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 6 . Use vertical analysis to compare profitability. 15 Perform Vertical Analysis - Excel ? 0 - 5 X points FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri - 11 - A" A E % Paste BIU - -LA- Alignment Number Conditional Format as Cell Book Cells Editing Formatting " Table . Styles Clipboard Font Styles Print 1 X fx Lake Athletics sells two distinct product lines: Apparel and Equipment. D 9 Net sales $3,150,000 $5,550,000 References 10 Cost of goods sold 1,400,000 2,720,000 11 Gross profit 1,750,000 ,830,000 12 Operating expenses 300,000 375,000 13 Operating income 30,000 1,953,000 14 Other income 20,000 10,000 15 Income before tax 70,000 1,965,000 16 Income tax expense 241,250 491,000 17 Net income $728,750 $1,474,750 18 19 Required: 20 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns 21 for both product lines above. Express each amount as a percentage of net sales. 22 Note: You should use absolute references in the divisors of all formulas. 23 2. Use the Excel IF function and the completed vertical analysis above to answer each of the questions below: Which product line has the highest gross profit %? Which product line has the highest net income %? .. Sheet1 ... + READY 80 0 -- + -+ 100% Attempt(s) Hint Show Me Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 7 1. Determine the break-even point. 2. Compute the margin of safety and explain its significance. 3. Compute the degree of operating leverage at a particular level of sales and explain how it can be used to predict changes in net operating income. 15 points eBook Print References X All answers must be entered as a ormula. Click OK to begin OK Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 7 1. Determine the break-even point. 2. Compute the margin of safety and explain its significance. 3. Compute the degree of operating leverage at a particular level of sales and explain how it can be used to predict changes in net operating income. 15 points X H 5 . 2 . CVP Analysis - Excel ? 0 - 5 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Book Calibri - 11 - A" A' Paste BIU - - - A - Alignment Number Conditional Format as Cell Formatting " Table Styles - Cells Editing Print Clipboard Font Styles Al x v fx Given the following information complete a CVP analysis References B D 1 Given the following information complete a CVP analysis for JPL, Inc.: 4 Unit sales 11,200 units 5 Selling price per unit $75 per unit 6 Variable expenses per unit $45 per unit 7 Fixed expenses $210,000 Use the data to answer the following. 0 1 1. Compute the CM ratio and variable expense ratio 12 Selling price per unit per unit 13 Variable expenses per unit per unit 14 Contribution margin per unit per unit 16 CM ratio 7 Variable expense ratio 18 19 2. Compute the break-even point 20 Break-even in unit sales units 21 Break-even in dollar sales 23 3. Compute the margin of safety 24 Margin of safety in dollars .. Sheet1 + READY 8: B J -- -+ 100% Attempt(s) Hint Show Me Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 7 1. Determine the break-even point. 2. Compute the margin of safety and explain its significance. 3. Compute the degree of operating leverage at a particular level of sales and explain how it can be used to predict changes in net operating income. 15 points CVP Analysis - Excel ? 0 - 5 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri Book - 11 - A" A' Paste BIU - - - A - Alignment Number Conditional Format as Cell Editing Formatting ~ Table Styles ~ Cells Print Clipboard Font Styles Al x v fx Given the following information complete a CVP analysis References B C D 13 Variable expenses per unit per unit 4 Contribution margin per unit per unit 16 CM ratio 17 Variable expense ratio 18 19 2. Compute the break-even point 20 Break-even in unit sales units 21 Break-even in dollar sales 22 23 3. Compute the margin of safety 24 Margin of safety in dollars 25 Margin of safety percentage 26 4. Compute the degree of operating leverage 28 Sales 29 Variable expenses 30 Contribution margin 31 Fixed expenses 32 Net operating income 33 34 Degree of operating leverage 36 ... Sheet1 ... + READY -+ 100% Attempt(s) Hint Show Me Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 8 1. Prepare a sales budget, including a schedule of expected cash collections. 2. Prepare a direct materials budget, including a schedule of expected cash disbursements for purchases of materials. 3. Prepare a cash budget. 20 points eBook Print References X All answers must be entered as a ormula. Click OK to begin OK Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 8 1. Prepare a sales budget, including a schedule of expected cash collections. 2. Prepare a direct materials budget, including a schedule of expected cash disbursements for purchases of materials. 3. Prepare a cash budget. 20 points XI H 5 . 2 . Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel ? 5 - 5 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Book Calibri - 11 - A" A' Paste BIU - - - A - Alignment Number Conditional Format as Cell Formatting . Table * Styles Cells Editing Print Clipboard Font Styles Al x v fx S&P Enterprises needs a cash budget for March. The following information is References B D 1 S & P Enterprises needs a cash budget for March. The following information is available. 2 Data January February March 4 Actual January and February and expected March sales: 5 Cash sales $ 1,600 $ 3,750 $ 5,10 Sales on account 25,000 30,000 40,000 7 Total Sales S 26.600 $ 33.750 $ 45,100 Accounts Receivable Collections: 10 Month of sale 15% Month following sal 60% Second month following sale 22% Uncollectible 3% 15 Accounts payable for inventory purchases, March 1 balance $10,500 16 Budgeted inventory purchases in March $23,500 17 Inventory payments: 18 Month of purchase 60% 19 Month following purchase 40% 20 21 Total budgeted selling & administrative expenses in March $12,50 22 Budgeted selling & administrative depreciation in March $3,200 23 4 Other hudnated each dichureamente in March ... Budget Data Schedules and Cash Budget READY -+ 100% Attempt(s) Hint Show Me Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit 8 1. Prepare a sales budget, including a schedule of expected cash collections. 2. Prepare a direct materials budget, including a schedule of expected cash disbursements for purchases of materials. 3. Prepare a cash budget. 20 points Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel ? 2 - 5 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Book Calibri - 11 - A" A' Paste BIU - - - A - Alignment Number Conditional Format as Cell Styles ~ Cells Editing Formatting ~ Table Print Clipboard Font Styles Al x v fx S&P Enterprises needs a cash budget for March. The following information is References B D Equipment purchases $14,00 Dividends to be paid $2,000 28 Minimum cash balance to be maintained $10,000 29 March 1 cash balance $11,500 30 March 1 outstanding borrowings SO 31 March 1 interest due SO $3 The company has a line of credit available to bolster the cash balance as needed. 34 5 When preparing budgets, the company maintains their data on a separate sheet from the actual budget and schedules. 36 7 Click the Schedules and Cash Budget tab to prepare the following: 38 1. Schedule of expected cash collections for March. 39 2. Schedule of expected cash disbursements for inventory purchases for March. 40 3. Cash budget for March. Indicate in the financing section any borrowing that will be needed in March. Assume that 41 any interest will not be paid until the following month. ... Budget Data Schedules and Cash Budget READY 8: B U -- -+ 100% Attempt(s) Hint Show Me Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit Prepare a make or buy analysis 15 points eBook Print References X All answers must be entered as a formula. Click OK to begin. OK Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit Prepare a make or buy analysis. XI H 5 . C . Prepare a make or buy analysis - Excel ? 6 - FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 15 Calibri - 11 - A" A ' % points Paste BIU - - - A - Alignment Number Conditional Format as Cell Cells Editing Formatting * Table . Styles Clipboard Font Styles Book Al 1 x v fx Alanco, Inc. manufactures a variety of products and is currently maunfacturing B G Print 1 Alanco, Inc. manufactures a variety of products and is currently maunfacturing all of its own component parts. 2 An outside supplier has offered to sell one of those components to Alanco. To evaluate this offer, the following 3 information has been gathered relating to the cost of producing the component internally References Direct materials 4.00 Direct labor 6.00 7 Variable manufacturing overhead 2.00 8 Fixed manufacturing overhead, traceable* 5.00 Fixed manufacturing overhead, common but allocated 8.00 10 Total cost 25.00 12 Supplier price 21.00 14 Units used per year 12,000 15 16 *Fixed manufacturing overhead, traceable is composed of two items: Depreciation of equipment (no resale value) 30% Supervisor salary 70% 1. Assuming the company has no alternative use for the facilities now being used to produce the component, complete the following analysis to determine if the outside supplier's offer should be accepted. 22 23 Per Unit Differential Cost 12,000 units ... Sheet1 ... + READY 100% Attempt(s) Hint Show Me Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit Prepare a make or buy analysis. xI H 5 . C . Prepare a make or buy analysis - Excel ? 6 - FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 15 Calibri - 11 - A" A ' % points Paste BIU - - - A - Alignment Number Conditional Format as Cell Cells Editing Formatting ~ Table * Styles Clipboard Font Styles Book Al 1 X fx Alanco, Inc. manufactures a variety of products and is currently maunfacturing B G H Print 19 20 1. Assuming the company has no alternative use for the facilities now being used to produce the component, complete the following analysis to determine if the outside supplier's offer should be accepted. References Per Unit Differential Cost 12,000 units Make Buy Make Buy Cost of purchasing Direct materials 28 Direct labor 29 Variable manufacturing overhead 30 Fixed manufacturing overhead, traceable 31 Fixed manufacturing overhead, common 32 Total costs 33 $4 Based on this analysis, write an if statement to determine if Alanco should make or buy the component. 35 36 Alanco should the component 37 38 39 ... Sheet1 ... + READY 8 0 U -- -+ 100% Attempt(s) Hint Show Me