Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Price Of Football Understanding Football Club Finance

Authors: Kieran Maguire

3rd Edition

1788216830, 978-1788216838

More Books

Students also viewed these Accounting questions

Question

4. How would you deal with the store manager?

Answered: 1 week ago