please read the instructions and complete the incorrect answers in red!! the question is clear if you just read!

Function: SUM; Formula: Add, Divide, 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 aiven 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 indicated. a. Compute current net income for Cawley Company. Sales Variable expenses Contribution margin Fixed expenses Net income Tingler Shocker Stunner $ 300,000 $ 500,000 $ 200,000 150,000 200,000 145,000 150,000 300,000 55,000 120,000 230,000 95,000 $ 30,000 $ 70,000 $ (40,000) Current net income $ 60,000 b. Compute net income by product line and in total for Cawley Company if the company discontinues the Stunner product line. (Hint: Allocate the $300,000 common costs to the two remaining product lines based on their relative saleel Fixed expenses consist of common costs allocated to the three products based on relative sales, as well as direct fixed expenses unique to each model. The common costs will be incurred regardless of how many models are produced. The direct fixed expenses would be eliminated if that model is nhacad aut Thaca tivad avnanens are nrncantad har Common cost allocation Tinaler Shocker $ 330,000 $ 380,000 $ 300,000 $ $ Allocated fixed common costs Direct fixed expenses: Tingler Shocker Stunner 30,000 80,000 35,000 Sales Variable expenses Contribution margin Fixed expenses Net income Tingler Shocker 300,000 500,000 150,000 200,000 150,000 300,000 112,500 187.500 7,500 IE $ 32,500 Total 800,000 350,000 450,000 300,000 40,000 $ $ James Watt, an executive with the company, feels the Stunner line should be discontinued to increase the company's net income c. Should Cawley eliminate the Stunner product line? Why or why not? 1 Cawley should not eliminate the Stunner product line because eliminating will cause net income to decline 1 An elimination would result in a loss of contribution margin of S40,000 with a Larger increase of fixed expenses