Question

eBook Cox Electric makes electronic components and has estimated the following for a new design of one of its products: Fixed Cost = $19,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 variable cost from total revenue, and answer the following questions. (a) Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue = total cost, yielding a profit of zero vary production volume ron 5,000 to 50,000 in increments of 5,000 breakeven occur? n hich inter a of production volume does to units b) Use Goal Seek to find the exact breakeven point Assign Set cell: equal to the location of profit To value: = 0 and By changing cell: equal to the location of the production volume in your model.

0 0
Add a comment Improve this question Transcribed image text
Answer #1
a) Data table showing BEP:
Production Variable Cost (*0.25) Fixed Cost Total Cost Revenue (*0.65)
5000 1250 19000 20250 3250
10000 2500 19000 21500 6500
15000 3750 19000 22750 9750
20000 5000 19000 24000 13000
25000 6250 19000 25250 16250
30000 7500 19000 26500 19500
35000 8750 19000 27750 22750
40000 10000 19000 29000 26000
45000 11250 19000 30250 29250
50000 12500 19000 31500 32500
Production volume interval where breakeven occur is 45000 units to 50000 units.
b) Goal Seek for the exact Breakeven point :
Production Variable Cost (*0.25) Fixed Cost Total Cost Revenue (*0.65)
45000 11250 19000 30250 29250
45500 11375 19000 30375 29575
46000 11500 19000 30500 29900
46500 11625 19000 30625 30225
47000 11750 19000 30750 30550
47500 11875 19000 30875 30875 BREAK EVEN POINT
48000 12000 19000 31000 31200
48500 12125 19000 31125 31525
49000 12250 19000 31250 31850
49500 12375 19000 31375 32175
50000 12500 19000 31500 32500
BREAK EVEN PRODUCTION QUANTITY IS 47500 units.
Add a comment
Know the answer?
Add Answer to:
eBook Cox Electric makes electronic components and has estimated the following for a new design of...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Problem 10-02 Algo (What If Analysis) Question 5 of 22 Check My Work eBook Cox Electric makes ele...

    how do I figure this out using excel? Problem 10-02 Algo (What If Analysis) Question 5 of 22 Check My Work eBook Cox Electric makes electronic components and has estimated the following for a new design of one of its products: Fixed Cost $7,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...

  • please solve and and explain how it was done thank you C D E F G...

    please solve and and explain how it was done thank you C D E F G H I J K L Acme Shoe Company makes special-style shoes. It has a fixed cost of $1000 for production setup. The variable cost is $30 per pair and each pair sells for $40. 5 Known parameters: 6 Selling price per unit Fixed cost Variable cost per unit What is the breakeven revenue? 10 Input Data Number of units Is it possible to achieve...

  • Electric Car Maker Tesla makes 100,000 units of "2170 Cell" per year in its Nevada based...

    Electric Car Maker Tesla makes 100,000 units of "2170 Cell" per year in its Nevada based gigafactory for use in Model 3 Electric car. Data concerning the unit production costs of the "2170 Cell" are as below: Elon is considering whether its worth making the cell in its factory or outsource it. An outside supplier has offered to sell Tesla all of the "2170 Cell" it requires. If Tesla decides to discontinue making the cells, 25% of the above fixed...

  • Stone Corporation is a manufacturing company that makes small electric motors it sells for $45 per...

    Stone Corporation is a manufacturing company that makes small electric motors it sells for $45 per unit. The variable costs of production are $25 per motor, and annual fixed costs of production are $800,000 Required a. How many units of product must Stone make and sell to break even? b. How many units of product must Stone make and sell to earn a $120,000 profit? c. The marketing manager believes that sales would increase dramatically if the price were reduced...

  • IPort Products makes cases for portable music players in two processes, cutting and sewing. The cutting process has a ca...

    IPort Products makes cases for portable music players in two processes, cutting and sewing. The cutting process has a capacity of 100,000 units per year; sewing has a capacity of 120,000 units per year. Cost information follows. Inspection and testing costs $ 40,000 Scrap costs (all in the cutting dept.) 140,000 Demand is very strong. At a sales price of $12.00 per case, the company can sell whatever output it can produce. IPort Products can start only 100,000 units into...

  • A producer of electric motors is considering the addition of a new plant to absorb the...

    A producer of electric motors is considering the addition of a new plant to absorb the backlog of demand that now exists. The primary location being considered will have fixed costs of $1,156,235 per month and variable costs of $3,250 per unit produced. Each item is sold to retailers at a price that averages $5,750. a. What volume per month is required in order to break even? b.1. What profit would be realized on a monthly volume of 670 units?...

  • (Questions 22-24) A company asked one of their analysis team to create a model that helps decide whether they should the spreadsheet model illustrate how to calculate the difference in cost of m...

    (Questions 22-24) A company asked one of their analysis team to create a model that helps decide whether they should the spreadsheet model illustrate how to calculate the difference in cost of manufacturing and ular product or outsource its production. The following influence diagram and Difference in Cost and Total Total Cost Cost Outsourcing Cest per Unit Fixed Cost Cost Material cost Labor cost per unit per unit Parameters 360,000 0.5 3.5 5.5 Fixed cost of manufacturing Material cost per...

  • Black and Decker Corporation has the following information is for their standard and actual costs: Standard...

    Black and Decker Corporation has the following information is for their standard and actual costs: Standard Costs: Budgeted units of production - 9,000 (100% of capacity) Standard material per unit - 12 lbs. Standard material cost - $14.00 per pound Standard labor hours per unit - 12 Standard labor rate - $29.00 per hour Standard variable overhead rate - $7.50 per labor hour Budgeted fixed overhead - $729,000 Fixed overhead rate is based on budgeted labor hours at 100% capacity...

  • A manufacturer hires temporary workers in its production plant to produce electric cars. The fixed costs...

    A manufacturer hires temporary workers in its production plant to produce electric cars. The fixed costs are $300,000 for the depreciation of the facility and $80,000 for utilities. The only variable cost is $20 per hour of labor hired. The production of each car requires 50 hours of labor. Currently, the market price of the electric car is $20,000. TR (Total revenue) = _____Q + ______ Total Costs (TC)= _____Q + ______ Total Profit = TR-TC= _______Q - ______ Average...

  • Q7. Rose Manufacturing currently produces 4,000 bicycles per month and has the following per unit data....

    Q7. Rose Manufacturing currently produces 4,000 bicycles per month and has the following per unit data. Direct materials $25.00 Direct manufacturing labor $5.00 Variable manufacturing overhead $14.50 Fixed manufacturing overhead S12.50 Total manufacturing costs 57.00 Production capacity is up to 7000 units. Compute total manufacturing cost per unit when 5,000 bicycles are produced Example of answer: 2.10 Question 8 (5 points) Q8. The following displays Logan Company's operation results at a volume of 100,000 units. Sales $900,000 Variable Costs ($500,000)...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT