Question
In: Statistics and Probability
General Blast Inc. makes plastic components for toy vehicles and has estimated the following for a...
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.
Please show how to solve all problems using Excel.
Solutions
Expert Solution
sol:
given that
1.
2.
| Demand/ production level | 20,000 |
| Unit variable cost | $2.20 |
| Fixed cost | $42,000 |
| Unit cost of supply | $3.73 |
| Total production cost | $86,000 |
| Total outsourcing cost | $74,600 |
| Profit (Loss) by producing | $11,400 |
3.
The output of the data table
| Demand | Profit (Loss) by producing |
| 0 | $42,000 |
| 10,000 | $26,700 |
| 20,000 | $11,400 |
| 30,000 | ($3,900) |
| 40,000 | ($19,200) |
| 50,000 | ($34,500) |
| 60,000 | ($49,800) |
| 70,000 | ($65,100) |
| 80,000 | ($80,400) |
| 90,000 | ($95,700) |
| 100,000 | ($111,000) |
Therefore, in the range [20000, 30000], the breakeven occurs.
4.
Use the goal-seek function as shown to find the exact breakeven point.
Output
| Demand/ production level | 27,451 |
| Unit variable cost | $2.20 |
| Fixed cost | $42,000 |
| Unit cost of supply | $3.73 |
| Total production cost | $102,392 |
| Total outsourcing cost | $102,392 |
| Profit (Loss) by producing | $0 |
Therefore, the exact breakeven is at Demand/ production level = 27,451
orchestra answered 2 years agoRelated Solutions
Cox Electric makes electronic components and has estimated the following for a new design of one...
Cox Electric makes electronic components and has estimated the
following for a new design of one of its products:
Fixed Cost = $3,000
Material cost per unit = $0.15
Labor cost per unit = $0.10
Revenue per unit = $0.65
Production Volume = 12,000
Per-unit material and labor cost together make up the variable cost
per unit. Assuming that Cox Electric sells all it produces, build a
spreadsheet model that calculates the profit by subtracting the
fixed cost and total...
Cox Electric makes electronic components and has estimated the following for a new design of one...
Cox Electric makes electronic components and has estimated the
following for a new design of one of its products:
Fixed Cost = $15,000
Material cost per unit = $0.15
Labor cost per unit = $0.10
Revenue per unit = $0.65
Production Volume = 12,000
Per-unit material and labor cost together make up the variable
cost per unit. Assuming that Cox Electric sells all it produces,
build a spreadsheet model that calculates the profit by subtracting
the fixed cost and total...
The Fallen Flags Division of Block C Enterprises makes toy trucks and cars by a plastic...
The Fallen Flags Division of Block C Enterprises makes toy
trucks and cars by a plastic molding process. The panel truck
requires 3 minutes of molding time, 2 minutes of painting time and
1 minute of packing time. The pickup truck requires 2.5 minutes of
molding time, 3 minutes of painting time and 1 minute of packing
time. The car requires 1.5 minutes of molding time, 1.5 minutes of
painting time and 1 minutes of packing time. There are a...
The annual sales of American made vehicles (in 1000 vehicles) to foreign countries has been estimated...
The annual sales of American made vehicles (in 1000 vehicles) to
foreign countries has been estimated as follow:
E(Yi)=200.5 - 4.5X1 + 1.8X2i -
3.76X3 R2=0.73
(1.081)* (-2.73)*
(3.932)* (-5.03)* n=44,
F=18.56
Where E(Yi)= annual average number of vehicles sold
to foreign countries (in 1000 vehicles), X1=the annual
average price of all vehicles sold to foreign countries (in $100),
X2= average foreign per capita income (in $1000), and
X3 is a binary variable that assumes a value of 0...
Munoz, Inc., produces a special line of plastic toy racing cars. Munoz, Inc., produces the cars...
Munoz, Inc., produces a special line of plastic toy racing
cars. Munoz, Inc., produces the cars in batches. To manufacture a
batch of the cars, Munoz, Inc., must set up the machines and
molds. Setup costs are batch-level costs because they are
associated with batches rather than individual units of products. A
separate Setup Department is responsible for setting up machines
and molds for different styles of car.
Setup overhead costs consist of some costs that are variable and
some...
Tall Oak, Inc produces rulers from plastic resin. Tall Oak has estimated production and sales of...
Tall Oak, Inc produces rulers from plastic resin. Tall Oak has
estimated production and sales of rulers in units for the next 2
months as:
May
June
Estimated productiuon:
42,000 48,000
Estimated
sales:
50,000 36,000
Each ruler requires 0.25 pounds of resin. The cost of resin is
$4.50 per pound. Tall Oaks wants to have 20% of the next months
materials requirements on hand at the end of each month.
Prepare a direct materials purchases budget for...
A toy store has beginning inventory of 20 plastic bouncy balls at a cost of $1.05...
A toy store has beginning inventory of 20 plastic bouncy balls
at a cost of $1.05 each. During the year the toy store purchased 2
at $1.40; 4 at $2.00; 6 at $3.00; and 20 at $4.00. By the end of
the year, 25 balls were sold.
Calculate the following:
the number of plastic bouncy balls in stock at the end of the
year,
the cost of ending inventory under LIFO,
the cost of ending inventory under FIFO, and
the...
A toy store has beginning inventory of 20 plastic bouncy balls at a cost of $1.05...
A toy store has beginning inventory
of 20 plastic bouncy balls at a cost of $1.05 each. During the year
the toy store purchased 2 at $1.40; 4 at $2.00; 6 at $3.00; and 20
at $4.00. By the end of the year, 25 balls were sold.
Calculate the following:
the number of plastic bouncy
balls in stock at the end of the year,
the cost of ending inventory
under LIFO,
the cost of ending inventory
under FIFO, and
the...
A toy store has beginning inventory of 20 plastic bouncy balls at a cost of $1.05...
A toy store has beginning inventory
of 20 plastic bouncy balls at a cost of $1.05 each. During the year
the toy store purchased 2 at $1.40; 4 at $2.00; 6 at $3.00; and 20
at $4.00. By the end of the year, 25 balls were sold.
Calculate the following:
the number of plastic bouncy
balls in stock at the end of the year,
the cost of ending inventory
under LIFO,
the cost of ending inventory
under FIFO, and
the...
The Gatson manufacturing company has estimated the following components for a new product. Fixed cost =...
The Gatson manufacturing company has estimated the following
components for a new product. Fixed cost = $50,000 Material cost
per unit = $2.15 Labor cost per unit = $2.00 Revenue per unit =
$7.50 Round your answer to the nearest whole number.
1. Using a spreadsheet model, what will be the resulting profit
if the company decides to make 70,000 units of the new product?
2. Construct a one-way data table with production volume as the
column input and profit...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Enumerations Create an advanced enumeration to represent months (JANUARY – DECEMBER) called enuMonths Add internal properties...
- What is the minimum size of the automorphism group of a simple directed graph having more...
- The birthday paradox says that the probability (chance) that two people in a room will have...
- #include <iostream> #include "lib.hpp" using namespace std; int main() { // declare the bool bool...
- Why do we compare means instead of individual scores? for comparing average SAT test scores across...
- NPV Your division is considering two projects with the following cash flows (in millions): 0...
- The equivalent synchronous impedance of a 25kVA, 400V three-phase Y-connected synchronous generator is 0.05 + j1.6...
ADVERTISEMENT