Reference no: EM132231728
General Blast Inc. makes plastic components for toy vehicles and has estimated the following for a new design of one of its truck models.
Fixed cost = $42,000 Variable cost per unit = $2.20
General Blast Inc. is considering outsourcing its production to one of its subcontractors for $3.73 per unit. The company anticipates that the demand for the new product would be 20,000 units and would like to compare the costs of manufacturing the new plastic component in-house with those of outsourcing its production to its subcontractor. The management of General Blast Inc. would like to do that for various production quantities.
1. Build an influence diagram that illustrates how to calculate the savings/loss from outsourcing.
2. Using a spreadsheet model, what will be the resulting savings/loss if the company decides to make 20,000 units of the new product?
3. Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit is zero. Vary production volume from 0 to 100,000 in increments of 10,000. In which interval of production volume does breakeven occur? Answer to the nearest whole number.
4. Using the appropriate Excel tool, find the exact breakeven point. Answer to the nearest whole number.
Note: You need to be able to interpret the results