Need some help with this question, please help with the cell referencing formulas that i need to enter for each cell. Thanks!

1 inction: SUM; Formula: Add. Divide. Subtract. Multiply; Cell Referencing 2 3 Using Excel For Incremental Analysis for Elimination ofa Product Line 4 Required: Provide input into cells shaded in yellow in this template. Use 5 PROBLEM mathematical formulas with cell references to the Problem or work area as 6_ Cawley Company makes three models of tasers. Information on the three indicated. Use the SUM function with cell references to add amounts as L products is given below. indicated. B {T Tingler Shocker Stunner 10 Sales $ 300,000 $ 500,000 $ 200,000 a. Compute current net income for Cawley Company. 17 Variable expenses 150,000 200,000 145,000 1; Contribution margin 150,000 300,000 55,000 Current net income ' 1E Fixed expenses 120,000 230,000 95,000 1: Net income $ 30,000 $ 70,000 $ (40,000)_ b. Compute net income by product line and in total for Cawley Company if 1.: the company discontinues the Stunner product line. (Hint: Allocate the 13 Fixed expenses consist of common costs allocated to the three products $300,000 common costs to the two remaining product lines based on 1L based on relative sales, as well as direct xed expenses unique to each their relative sales.) 15; model. The common costs will be incurred regardless of how many models 11 are produced. The direct xed expenses would be eliminated if that model is Tingler Shocker 23 phased out. These xed expenses are presented here. Common 95t allocation 21 22 Allocated xed common costs $ 300,000 Tingler Shocker Total 2; Direct xed expenses: Sales ' ' ' 24 Tingler 30,000 Variable expenses ' ' V 2E Shocker 80,000 Contribution margin ' ' ' 26 Stunner 35,000 Fixed expenses ' ' ' 2i Net income ' ' V 25; James Watt, an executive with the company, feels the Stunner line should be 29_ discontinued to increase the company's net income. c. Should Cawley eliminate the Stunner product line? Why or why not? 30 31_ Cawiey ' the Stunner product line 3: 3: because eliminating will cause V 34_ 3.: An elimination would result in ' of contribution 36_ 3L margin of ' with a ' 38_ 31 of xed expenses. 40_ 41 A