Question

In: Operations Management

McVay Industries (MI) produces ice cream supplies including bowls, scoops and shake makers. MI made $605,000...

McVay Industries (MI) produces ice cream supplies including bowls, scoops and shake makers. MI made $605,000 of pre-tax profit last year.  They are looking for ways to improve profitability and are considering outsourcing production of their shake makers. Juan Hernandez, the controller, compiled the following information.

Bowls

Scoops

Shake Makers

TOTAL

Units Manufactured and sold

2,000,000

500,000

100,000

DM per unit

$0.50

$1.25

$5.00

DL per unit

$0.10

$0.50

$4.00

VMOH per unit

$0.15

$0.25

$5.00

FMOH per unit (based on current production)

$0.40

$0.50

$5.00

Total Cost per unit

$1.15

$2.50

$19.00

Selling Price

$2.00

$4.00

$25.00

Gross Profit per Unit

$0.85

$1.50

$6.00

Total Sales

$4,000,000

$2,000,000

$2,500,000

$8,500,000

Total COGS

$2,300,000

$1,250,000

$1,900,000

$5,450,000

Total Gross Profit

$1,700,000

$750,000

$600,000

$3,050,000

Total Variable (selling) costs

($300,000)

($100,000)

($125,000)

($525,000)

SG&A Fixed Costs – Direct*

($400,000)

($200,000)

($100,000)

($700,000)

SG&A Fixed Costs – Common**

($680,000)

($300,000)

($240,000)

($1,220,000)

            Pre-Tax Profit

$320,000

$150,000

$135,000

$605,000

*   Direct SG&A Fixed Costs can be eliminated if the specific product is outsourced.

** Common  SG&A Fixed Costs can not be eliminated even if the specific product is outsourced.

If the shake maker is outsourced, fixed manufacturing overhead costs of $100,000 to lease machinery related to shake maker production could be eliminated.  Assume that direct fixed SG&A expenses relate directly to the shake makers line and could be completely eliminated if the shake maker product line is dropped.

Additionally, if the shake maker is outsourced, the company would have idle capacity and could produce and sell an additional 150,000 bowls (for the same selling price of $2 per bowl).  

Question: What is the maximum amount MI should pay for the shake maker from an independent supplier (price per unit) to be no worse off financially? Show your work please.

Solutions

Expert Solution

As per the data given in the question if the shake maker is dropped, then the profit from $605,000 drops to $230,000 since the common SG&A Fixed costs can not be eliminated if the shake makers is dropped even.

Bowls Scoops Shake Makers Total
Units Manufactured and sold            2,000,000                500,000                            -  
DM per unit $                   0.50 $                   1.25 $                   0.50
DL per unit $                   0.10 $                   0.50 $                   0.10
VMOH per unit $                   0.15 $                   0.25 $                   0.15
FMOH per unit (based on current production) $                   0.40 $                   0.50 $                   0.40
Total Cost per unit $                   1.15 $                   2.50 $                   1.15
Selling Price $                   2.00 $                   4.00 $                   2.00
Gross Profit per Unit $                   0.85 $                   1.50 $                   0.85
Total Sales $ 4,000,000.00 $ 2,000,000.00 $                       -   $    6,000,000.00
Total COGS $ 2,300,000.00 $ 1,250,000.00 $                       -   $    3,550,000.00
Total Gross Profit $ 1,700,000.00 $      750,000.00 $                       -   $    2,450,000.00
Total Variable (selling) Costs $   (300,000.00) $   (100,000.00) $                       -   $     (400,000.00)
SG&A Fixed Costs - Direct $   (400,000.00) $   (200,000.00) $                       -   $     (600,000.00)
SG&A Fixed Costs - Common $   (680,000.00) $   (300,000.00) $   (240,000.00) $ (1,220,000.00)
Pre Tax Profit $      320,000.00 $      150,000.00 $   (240,000.00) $       230,000.00

If the shake maker is dropped and in idle capacity of shake maker, an additional bowls to be made then also the profit of the company comes to $335,000.

Bowls Scoops Additional Bowls Total
Units Manufactured and sold            2,000,000                500,000                150,000
DM per unit $                   0.50 $                   1.25 $                   0.50
DL per unit $                   0.10 $                   0.50 $                   0.10
VMOH per unit $                   0.15 $                   0.25 $                   0.15
FMOH per unit (based on current production) $                   0.40 $                   0.50 $                   0.40
Total Cost per unit $                   1.15 $                   2.50 $                   1.15
Selling Price $                   2.00 $                   4.00 $                   2.00
Gross Profit per Unit $                   0.85 $                   1.50 $                   0.85
Total Sales $ 4,000,000.00 $ 2,000,000.00 $      300,000.00 $    6,300,000.00
Total COGS $ 2,300,000.00 $ 1,250,000.00 $      172,500.00 $    3,722,500.00
Total Gross Profit $ 1,700,000.00 $      750,000.00 $      127,500.00 $    2,577,500.00
Total Variable (selling) Costs $   (300,000.00) $   (100,000.00) $      (22,500.00) $     (422,500.00)
SG&A Fixed Costs - Direct $   (400,000.00) $   (200,000.00) $                       -   $     (600,000.00)
SG&A Fixed Costs - Common $   (680,000.00) $   (300,000.00) $   (240,000.00) $ (1,220,000.00)
Pre Tax Profit $      320,000.00 $      150,000.00 $   (135,000.00) $       335,000.00

So if the company wants to maintain the same level of profit $605,000 and also wants to outsource the shake business then also company has to make sure they could even earn the same profit of $135,000 which they were earning from shake business.

In order to earn $135,000 from the additional bowls from idle capacity then they must sell the additional bowl at $3.80 per unit so that they can cover the fixed costs as well.


Related Solutions

McVay Industries (MI) produces ice cream supplies including bowls, scoops and shake makers. MI made $605,000...
McVay Industries (MI) produces ice cream supplies including bowls, scoops and shake makers. MI made $605,000 of pre-tax profit last year.  They are looking for ways to improve profitability and are considering outsourcing production of their Bowls. Juan Hernandez, the controller, compiled the following information. Bowls Scoops Shake Makers TOTAL Units Manufactured and sold 2,000,000 500,000 100,000 DM per unit $0.50 $1.25 $5.00 DL per unit $0.10 $0.50 $4.00 VMOH per unit $0.15 $0.25 $5.00 FMOH per unit (based on current...
McVay Industries (MI) produces ice cream supplies including bowls, scoops and shake makers. MI made $605,000...
McVay Industries (MI) produces ice cream supplies including bowls, scoops and shake makers. MI made $605,000 of pre-tax profit last year.  They are looking for ways to improve profitability and are considering outsourcing production of their Bowls. Juan Hernandez, the controller, compiled the following information. Bowls Scoops Shake Makers TOTAL Units Manufactured and sold 2,000,000 500,000 100,000 DM per unit $0.50 $1.25 $5.00 DL per unit $0.10 $0.50 $4.00 VMOH per unit $0.15 $0.25 $5.00 FMOH per unit (based on current...
THE SCENARIO: 31 Scoops Ice Cream a new concept in gourmet ice cream is finishing up...
THE SCENARIO: 31 Scoops Ice Cream a new concept in gourmet ice cream is finishing up its business plan for upcoming Venture Capital rounds and just needs to complete its break-even analysis to be done. In order to get started with its ice cream business, it will need to purchase some state-of-the-art ice-cream manufacturing equipment valued at $50,000, which they will be able to purchase at a 30% discount. In addition, they will need to rent several store locations for...
Question 2 – Comprehensive problem: Scoops Ahoy, Inc. is a manufacturer that produces ice cream. Its...
Question 2 – Comprehensive problem: Scoops Ahoy, Inc. is a manufacturer that produces ice cream. Its relevant range of production for 2019 is 101,000 to 106,000 pints of ice cream. When it produces and sells 104,000 pints, its average costs per unit are as follows: Average cost per pint Direct materials $ 0.35 Direct labor $ 1.19 Variable manufacturing overhead $ 0.23 Fixed manufacturing overhead $ 0.27 Variable selling and administrative expenses $ 0.09 Fixed selling and administrative expenses $...
Convince yourself that I will buy 4 scoops of ice cream and 3 slices of pizza....
Convince yourself that I will buy 4 scoops of ice cream and 3 slices of pizza. When the price went down, I bought more - This is where the law of demand comes from? Note: Minimum 2-3 paragraph answer is required, it's a long question.
The ice cream store cool stuff sells exotic ice creams, including Tropical Cream and Green Mango....
The ice cream store cool stuff sells exotic ice creams, including Tropical Cream and Green Mango. Cool Stuff has been varying the prices of these two flavors over the past 16 quarters and has recorded the sales data. The table shows the quantity sold of Tropical Cream, Q, given the price of a half-gallon of Tropical Cream, P, and the price of the other flavor, Green Mango, Po. Use these data to estimate the demand function for Tropical Cream. Are...
The ice cream store cool stuff sells exotic ice creams, including Tropical Cream and Green Mango....
The ice cream store cool stuff sells exotic ice creams, including Tropical Cream and Green Mango. Cool Stuff has been varying the prices of these two flavors over the past 16 quarters and has recorded the sales data. The table shows the quantity sold of Tropical Cream, Q, given the price of a half-gallon of Tropical Cream, P, and the price of the other flavor, Green Mango, Po. Use these data to estimate the demand function for Tropical Cream. Now...
IcyPop Inc. is an ice cream manufacturing company. It produces two major types of ice-cream products:...
IcyPop Inc. is an ice cream manufacturing company. It produces two major types of ice-cream products: FruityGo and BerryWafers. You have been brought on as an Analyst, with your first task being to ascertain the most appropriate method of assigning overhead costs to its FruityGo and BerryWafers products. The following information relates to these products for the year just ended for its two main production departments. Mixing Packaging Budgeted Overhead $400,000 $80,000 Budgeted Direct Labour Hours: FruityGo 1,000 5,000 BerryWafers...
1. The Frosty Delights Ice-cream House currently rents an ice-cream machine for $50,000 per year, including...
1. The Frosty Delights Ice-cream House currently rents an ice-cream machine for $50,000 per year, including all maintenance expenses. It is considering purchasing a machine instead, and is comparing two options: I. Purchase the machine it is currently renting for $150,000. This machine will require $20,000 per year in ongoing maintenance expense. II. Purchase a more advanced machine for $250,000. This machine will require $15,000 per year in ongoing maintenance expense and lower annual packaging costs by $10,000. Additionally, the...
Are these simple or complex carbohydrates? banana Drumstick ice cream Protein shake quinoa French fries oatmeal...
Are these simple or complex carbohydrates? banana Drumstick ice cream Protein shake quinoa French fries oatmeal Brown rice yogurt blueberries Mangos, raw Steamed broccoli Cheeseburger, onions
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT