A firm is evaluating the alternative of manufacturing a part that is currently being outsourced from a supplier. The relevant information is provided below: For in-house manufacturing: Annual fixed cost = $75,000 Variable cost per part = $110   For purchasing from supplier: Purchase price per part = $140   For this information, use the Break-Even Excel template to find the best decision if the demand is 7,000. Round your answers to the nearest dollar. Total cost of production: $  ___________ Total cost of outsourcing: $  ___________ The best decision is to ________ (manufacture in house or outsource?). Determine the break-even quantity for which the firm would be indifferent between manufacturing the part in-house or outsourcing it. Use the Excel Goal Seek tool. Round your answer to the nearest whole number.  ________ parts

MARKETING 2018
19th Edition
ISBN:9780357033753
Author:Pride
Publisher:Pride
Chapter6: Target Markets: Segmentation And Evaluation
Section: Chapter Questions
Problem 4SC
icon
Related questions
Question

A firm is evaluating the alternative of manufacturing a part that is currently being outsourced from a supplier. The relevant information is provided below:

For in-house manufacturing:

Annual fixed cost = $75,000
Variable cost per part = $110

 

For purchasing from supplier:

Purchase price per part = $140

 

  1. For this information, use the Break-Even Excel template to find the best decision if the demand is 7,000. Round your answers to the nearest dollar.

    Total cost of production: $  ___________
    Total cost of outsourcing: $  ___________

    The best decision is to ________ (manufacture in house or outsource?).

  2. Determine the break-even quantity for which the firm would be indifferent between manufacturing the part in-house or outsourcing it. Use the Excel Goal Seek tool. Round your answer to the nearest whole number.

     ________ parts

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MARKETING 2018
MARKETING 2018
Marketing
ISBN:
9780357033753
Author:
Pride
Publisher:
CENGAGE L