A company asked one of their analysis team to analyze and create models that help decidewhether they should manufacture a particular product or outsource its production. The different components are given below:
Fixed Cost, FC = $25,000
Material Cost per Unit, MC = $2.15
Labor Cost per Unit, LC = $2.00
Outsourcing Cost per Unit, O = $4.50
Note that per-unit material and labor cost together make up the variable cost per unit.
- Using the spreadsheet model, construct a one-way data table with production volume as the column input and savings due to outsourcing as the output. Breakeven occurs when profit goes from a positive to a negative value, that is, breakeven is when total outsource cost = total cost, yielding savings due to outsourcing equal to zero. Vary production volume from 0 to 100,000 in increments of 10,000. In which interval of production volume does breakeven occur?
- Use Goal Seek to find the exact breakeven point. Assign Set cell: equal to the location of savings due to outsourcing, To value: = 0, and By changing cell: equal to the location of the production volume in your model.
Step by step solution:
You might also like to view...
To promote its Centrino wireless chip, Intel launched a global ad campaign that features different combinations of celebrities. These celebrities were chosen because they are widely recognized in the key world markets
This type of strategy is referred to as: A) product-communications extension. B) product extension-communications adaptation. C) product adaptation-communications extension. D) product-communication adaptation. E) product invention.
Under the ____________________ inventory system, the inventory account is updated after each purchase or sale
Fill in the blank(s) with correct word
Generally accepted accounting principles encompass the conventions, rules, and procedures necessary to define accepted accounting practice at a particular time
Indicate whether the statement is true or false
Being adaptable means being purposeful in designing communication to achieve a specific outcome
Indicate whether the statement is true or false.