could you please help me answer it with the excel explanation/calculations. Thank you!
37 x fx =SUM(C11+C10+F12) Function: SUM: Formula: Add, Divido, Subtract, Multiply: Cell Referencing Using Excel For Incremental Analysis for Elimination of a Product Line PROBLEM Cawley Company makes three models of tasers Information on the three products is alven below. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work area as indicated. Use the SUM function with cell references to add amounts as Indicator a Compute current net income for Cawley Company Current not income 60.000 b. Compute net income by product line and in total for Cawley Company the company discontinues the Stunner product line. (Hint: Allocate the $300,000 common costs to the two remaining product lines based on their relative ale Common cost allocation Tingler $ 112.500 Shocker 5 187.500 Tingler Shocker Stunner Sales $ 300,000 $ 500,000 $ 200,000 1 Variable expenses 150,000 200,000 145,000 2 Contribution margin 150,000 300,000 55,000 Fixed expenses 120,000 230,000 95,000 4 Net incomo $30,000$ 70,000$ 1407000) Fixed expenses consist of common costs alocated to the three products 7 based on relative sales, as well as direct fixed expenses unique to each 18 model. The common costs will be incurred regardless of how many models 19 are produced. The direct fixed expenses would be eliminated if that model is 20 There RAREA LA 21 22 Allocated foxed common costs $ 300,000 23 Direct foed expenses 24 Tingler 30,000 25 Shocker 80,000 26 Stunner 22 35,000 25 James Watt, an executive with the company, feels the Stunner line should 29 be discontinued to increase the company's net income 30 31 22 33 34 35 36 27 BE 39 40 41 42 Tingler Shocker Total Sales is 300,000 IS 500,000 800.000 Variable expenses 150.000 200,000 350.000 Contribution margin 150 000 300.000 450.000 Fixed expenses Net Income c. Should Cawley eliminate the Stunner product ine? Why or why not? Cawley should not eliminate the Stunner product line because eliminating will cause net income to decine An olimination would result in los of contrbution margin of $ 450,000 with a maller decrease of fixed expenses