Mohave Corp, is considering eliminating a product from its Sand Trap line of bea
ID: 2438261 • Letter: M
Question
Mohave Corp, is considering eliminating a product from its Sand Trap line of beach umbrellas. This col ection is aimed at people who spend time on the beach or have an outdoor patio near the beach. Two products, the Indigo and Verde umbrellas, have impressive sales. However, sales for the Azul model have been dismal Mchave's information related to the Sand Trap line is shown below. Segmented Income Statement for Mohaves Sand Trap Beach Umbrela Products 000 $60,000 $30,000 $150,000 $26,000 $29,000 4,000 59,000 28,500 2.000 52 600 Sales revenue Variable cosis 34,000 31 28,000 91 Contribution margin Segment margin Net operating income (oe8) Less: Direct Fixed costs Common fixed costs 17,840 1 8,920 44,600 Allocated based on total sales revenue Mohave has determined that el minating the Azul model would cause sales of the Indigo and Verde models to increase by 10 percent and 15 percent, respectvely. Variable costs for these two models would increase proportionaiely. Although the direct fixed costs could be 0?minated, the common food costs are unavoidable. The common fixed costs would be redistributed to the remaining two products. Required: 1-a. Complete the table given belaw, if Mchave Corp drops the Azul line. (Do not round intermediate calculations. Round Common Fixed Costs to the nearest whole dollar.) Vorde Sales Revenue Variable Costs Contribution Margin Direct Fxed Costs Segment Margin Common Fued Costs Net operating income 1,900 2,500 4,400 1-b. Wl Mohave's net operating income increase or decrease if the Azul model is eliminated? By how much? Increase 2. Should Mohave drop the Azul model? O No YesExplanation / Answer
Requirement 1-a
Income Statement
Indigo
Verde
Total
Sales Revenue
$ 66,000.00
$ 69,000.00
$ 135,000.00
Variable Cost
$ 37,400.00
$ 35,650.00
$ 73,050.00
Contribution Margin
$ 28,600.00
$ 33,350.00
$ 61,950.00
Less: Direct Fixed Cost
$ 1,900.00
$ 2,500.00
$ 4,400.00
Segment margin
$ 26,700.00
$ 30,850.00
$ 57,550.00
Common Fixed Cost
$ 21,804.44
$ 22,795.56
$ 44,600.00
Net Operating Income
$ 4,895.56
$ 8,054.44
$ 12,950.00
Requirement 1-b
Current Income
$ 8,000.00
Income after discontinuing Azul
$ 12,950.00
Income Increased
$ 4,950.00
Change in Net Operating income by $4950 Increase.
Requirement 2
Yes Mohave should drop Azul Model.
Requirement 3-a
Change in Contribution Margin
Contribution Margin gained On Indigo
$ 2,600.00
Contribution Margin gained On verde
$ 4,350.00
Contribution Margin lost on Azul
$ (4,000.00)
Net Increase in contribution Margin
$ 2,950.00
Change in fixed Cost
$ -
Net Change in Profit if Azul is Eliminated
$ 2,950.00
Note- Net change in Fixed cost is Zero because no fixed cost is saved now. Overall Fixed cost is Increased by $2000 that is why profit is increased by $2950 Instead of $4950.
Working note for Part 3-a
Income Statement
Indigo
Verde
Total
Sales Revenue
$ 66,000.00
$ 69,000.00
$ 135,000.00
Variable Cost
$ 37,400.00
$ 35,650.00
$ 73,050.00
Contribution Margin
$ 28,600.00
$ 33,350.00
$ 61,950.00
Common Fixed Cost
$ 24,933.33
$ 26,066.67
$ 51,000.00
Net Operating Income
$ 3,666.67
$ 7,283.33
$ 10,950.00
Requirement 3-b
Yes Azul Model should be dropped.
The Net Income is still higher than income earned before.
Requirement 3-C
Change in Net Operating income by $2950 Increase.
Requirement 1-a
Income Statement
Indigo
Verde
Total
Sales Revenue
$ 66,000.00
$ 69,000.00
$ 135,000.00
Variable Cost
$ 37,400.00
$ 35,650.00
$ 73,050.00
Contribution Margin
$ 28,600.00
$ 33,350.00
$ 61,950.00
Less: Direct Fixed Cost
$ 1,900.00
$ 2,500.00
$ 4,400.00
Segment margin
$ 26,700.00
$ 30,850.00
$ 57,550.00
Common Fixed Cost
$ 21,804.44
$ 22,795.56
$ 44,600.00
Net Operating Income
$ 4,895.56
$ 8,054.44
$ 12,950.00
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.