Hello, could you please help me with Part a) and b) of the problem 4-3 in the picture below? If possible, could you please compute it in excel?

Thank you very much.

what will be the impact on co PROBLEM 4-3. High-Low, Break-Even Rykor Electronics produces a high-end compact disc player that sells for $1,200. Total operating expenses for the past 12 months are as follows: Units Produced and Sold Cost 00:000, AS August 125 $107,670 September 008. JA 145 116,990 00.098 ASE October sonhas 150 124,500 November 160 126,500 60.09a December blocof 165 134,700 00 090 January 140 112,400 February 145 120,600 March 135 110,400 April 130 111,140 May 135 114,200 a diw alsow Saiful doswing June 145 116,700 182 - 0858 x A X SP July 140 115,760 toq o) agro-Required lagiraq nolim a. Use the high-low method to estimate fixed and variable costs. b. Based on these estimates, calculate the break-even level of sales in units. c. Calculate the margin of safety for the coming August assuming estimated sales of 150 units. d. Estimate total profit assuming production and sales of 150 units. e. Comment on the limitations of the high-low method in estimating costs for Rykor KEODS at so Electronics