Question

In: Statistics and Probability

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 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?

3. Using the appropriate Excel tool, find the exact breakeven point.

Please show how to solve all problems using Excel.

Solutions

Expert Solution

(1)
FC Units, x MC LC TC TR P = TR - TC
50000 70000 150500 140000 340500 525000 184500
(2)
FC Units, x MC LC TC TR P = TR - TC
50000 0 0 0 50000 0 -50000
50000 10000 21500 20000 91500 75000 -16500
50000 20000 43000 40000 133000 150000 17000
50000 30000 64500 60000 174500 225000 50500
50000 40000 86000 80000 216000 300000 84000
50000 50000 107500 100000 257500 375000 117500
50000 60000 129000 120000 299000 450000 151000
50000 70000 150500 140000 340500 525000 184500
50000 80000 172000 160000 382000 600000 218000
50000 90000 193500 180000 423500 675000 251500
50000 100000 215000 200000 465000 750000 285000
Breakeven occurs between 10000 and 20000 units of production
(3)
Let the breakeven volume be x units. Then, 50000 + 2.15x + 2x = 7.5x
Upon solving, we get x = 14925

orchestra answered 1 year ago
Next > < Previous

Related Solutions

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...
Cascade Company estimated the following variable and fixed cost for the only product it produces: Variable...
Cascade Company estimated the following variable and fixed cost for the only product it produces: Variable Cost Per Unit Fixed Cost Direct Materials $132.30 $ 0 Direct Labor $115.30 $ 0 Factory Overhead $24.50 $264,000 Sales Salaries and Commissions $12.70 $245,000 Advertising $0 $75,000 Travel $0 $39,500 Misc. Selling Expenses $6.70 $24,500 Office and Officer Salaries                       $0 $220,000 Supplies $6.30 $15,000 Misc. Administrative Expenses $2.20 $17,000 1) Prepare an estimated Contribution Margin Income Statement for the year ended December...
Cascade Company estimated the following variable and fixed cost for the only product it produces: Variable...
Cascade Company estimated the following variable and fixed cost for the only product it produces: Variable Cost Per Unit Fixed Cost Direct Materials $132.30 $ 0 Direct Labor $115.30 $ 0 Factory Overhead $24.50 $264,000 Sales Salaries and Commissions $12.70 $245,000 Advertising $0 $75,000 Travel $0 $39,500 Misc. Selling Expenses $6.70 $24,500 Office and Officer Salaries                       $0 $220,000 Supplies $6.30 $15,000 Misc. Administrative Expenses $2.20 $17,000 1. Prepare an estimated Contribution Margin Income Statement for the year ended December...
The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed...
The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed cost to begin the production of the product is $32,000. The variable cost for the product is expected to be between $19 and $28 with a most likely value of $26 per unit. The product will sell for $45 per unit. Demand for the product is expected to range from 300 to 1800 units, with 900 units the most likely demand. Let c =...
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...
A manufacturing process has a fixed cost of $300,000 per month. Each unit of product being...
A manufacturing process has a fixed cost of $300,000 per month. Each unit of product being produced contains $160 worth of material and $220 in labor. Each finished product will sell for $450. How many units must be sold each month to break even? What level of monthly revenue is necessary to break even? What is the expected profit for sales levels of 1,000, 2,500, and 5,000 units respectively.
Suppose that a company has estimated the average variable cost of producing its product to be...
Suppose that a company has estimated the average variable cost of producing its product to be $10. The firm’s total fixed cost is $100,000. If the company produces 1,000 units and its pricing strategy is to add a 35 percent markup, what price would the company charge?
A company has estimated fixed cost of $30,000 per month for 0 - 600,000 apples per...
A company has estimated fixed cost of $30,000 per month for 0 - 600,000 apples per month. The apples are sold in packs of 10 sold for $8 per pack. At 100% capacity the apples have a total variable cost of $30000 per month. 1) What is the yearly profit at the max capacity? 2) What is the break even production amount?
Accounting 122 Group Project 2 Cascade Company estimated the following variable and fixed cost for the...
Accounting 122 Group Project 2 Cascade Company estimated the following variable and fixed cost for the only product it produces: Variable Cost Per Unit Fixed Cost Direct Materials $132.30 $ 0 Direct Labor $115.30 $ 0 Factory Overhead $24.50 $264,000 Sales Salaries and Commissions $12.70 $245,000 Advertising $0 $75,000 Travel $0 $39,500 Misc. Selling Expenses $6.70 $24,500 Office and Officer Salaries                       $0 $220,000 Supplies $6.30 $15,000 Misc. Administrative Expenses $2.20 $17,000 Prepare an estimated Contribution Margin Income Statement for...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT