Please complete the excel sheet.

18:22 ...85GE Penguin Portal E47 E4-12 P4- made 18:22 ..185GE Penguin Portal E4-7 E4-12 P4-9 xech 1: CT Anas. From TEXTIBOOK PAGE take Stevens Murma ha estatute that linedcm per variables per deler sales The selling met dater Required What is the prior permissione Big Selling pee per le sue Walpole of sales Ce mardi 310 Hei What level of seeded for this profiter Solenged 31 c. For the methode chemarea antipate ale expected over Expected pidit Cmidwing for you to consultare 412 Determine the fire the kids.com 1. Teori 5365.000 Tham 2 Vanbiddine 50 25 porade 3. The desene incromes Come on the BES from the above analyses in question 1,2,3 18:22 ..15GE Penguin Portal E4-7 E4-12 P4-9 Werche 7 Stergrup points) Roof Office Spending there betwem.com Solid May OGO S10.00 $10.00 A 512375055350 re SRO 23.00 Bowl Prepare where of verkeer Place you yraph bor in between parts and hand over the Scarpe Scarpe Cher there appears to be in the bed sheet was appear to be listedicated with water and captains Your posted to be in completences with redde Problem 4-High-Lw. Profit Equation (1 points) Crux, Inc. produces amplifiers. Each unit sells for on production sales and costs for 2020: 5900 Below is information Production Production Costa Selling and Admin Costs April Sales in it January 105 February 117 March 92 106 May 115 June 125 July 12K August 132 September 13 October 126 November 124 December 10% Total 1.421 Average costruit 588.860 97.600 83.007 89.000 96,200 103,500 105,670 108.550 112.97% 104.200 102,750 91.050 S1.183.165 5833.1941 $23.570 25,200 22,495 23,720 24.950 26,250 36,690 27.200 28.030 26,400 26,150 21.990 $304,645 $214 38776 Required Use the high-low method to identify the fixed and variable cost components for both production costs and selling and administrative costs Production costs: (Use Production costs and Production Costs Sales in units) Variable cost per unit Fixed costs per month month costs 12 month costs Selling and administrative costs (Use Selling and administrative costs and Produetion Costs Sales in units) Variable cost per unit Fixed costs per month 12 month costs month costs 1.650 units b. The company estimates that production and sales in 2021 will be Based on this estimate, forecast income before taxes for 2021 Sales price per unit is indicated in the beginning above information Sales Less production costs Variable Fixed Less selling and administrative costs: Variable Fixed Income (los) E4-7 E4-12 P4-9 Exercise 4-1. CVP Analysis, Profit Equation - SEE TEXTBOOK PAGE 4-33. (16 points) Lake Stevens Marina has estimated that fixed costs per month are S350.000 variable cost per dollar of sales is 50.30 The selling price per dollar of sales is and S1.00 Required a. What is the break-even point per month in sales dollars given the following information? Selling price per dollar of sales Variable cost per dollar of sales Contribution margin per dollar of sales Break-even point $70,000 b. What level of sales is needed for a monthly profit of Sales required $1,000,000 What is the c. For the month of July, the marina anticipates sales of expected level of profit? Expected profit What if? Consider the following after you have completed the requirements of E4-12. Determine the effect on the break-even point in sales dollars considering each of the following independently 1. Total fixed costs increase to 365,000 Break-even point 2. Variable costs decline to S0.25 per sales dollar. Break-even point 3. The anticipated sales volume increases to $1,100,000 Break-even point Comment on the BEPs from the above analyses in questions 1,2,3. Exercise 4-7 Seattergraph (16 points) Reef Office Supplies is interested in estimating the relationship between customer service costs and sales. The following data are available: Customer Month Service Sales Cost May $9.900 $255,000 June $10,100 $210,000 July $10,690 $230,000 August $12,750 $255.000 September $13,830 $275,000 Required a. Prepare a scattergraph/scatterplot of customer service cost (vertical axis) and sales (horizontal axis). Place your graph here in between parts a. and b. Please read over the Scattergraph/Scatterplot additional help b. Comment on whether there appears to be a linear relation between cost and sales and whether any of the observations appear to be outliers. Indicate which month if any may be an outlier and explain why. Your responses need to be in complete sentences with proper grammar and spelling