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. |
eBook Cox Electric makes electronic components and has estimated the following for a new design of...
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 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 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 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 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 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 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 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 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. 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)...