Excel problem post answer for each question. (include excel forumla).

Cell Styles Sx. indicated. Use the Sum function with col references to add amounts as Indicated awley Company makes throe models of tasons Information on the three oducts is given below. Tingler Shocker Stunner Sies $ 300,000 $500,000 $200,000 Variable expenses 150,000 200.000 145,000 Contribution margin 150,000 300.000 55,000 Food expenses 120.000 230.000 95.000 Not income 330.000 30.000 40.000 Fixed expenses consist of common costs alocated to the three products ased on relative sales, as well as directed expenses unique to each model. The common costs will be incurred regardless of how many models are produced. The direct foxed expenses would be eliminated that model is $ 300,000 Allocated food common costs Directed expenses Tingler Shocker Stunner 30.000 80,000 35,000 a. Compute cumont not income for Cawley Company Current not income $ 30,000 b. Compute net income by product ine 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 ines based on thakal Tngler Shocker Common cost allocation 80.000 Tingler Shocker Tota! Sales $ 300,000 $ 500,000 $ 800,000 Variable expenses 150.000 200.000 350.000 Contribution margin 150.000 300.000 450.000 Faced expenses 80.000 80.000 Not Income c. Should Cawley eliminate the Stunner product ine? Why or why not? Caway should not liminate the Stunner product Ine because olminating will cause net income to decline An elimination would result in a loss of contribution margin of $ 55,000 with a smaller decreto James Watt, an executive with the company, feels the Stunner line should be discontinued to increase the comoany's net income of foxed expenses Enter Answer + Ready IERLUUUR Vicar