Homework Answers
| 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 Answer to:
eBook Cox Electric makes electronic components and has estimated the following for a new design of...
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)...
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...
(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...
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)...
Most questions answered within 3 hours.
-
Required information
[The following information applies to the questions
displayed below.]
In 2019, Alliant Corporation acquired...
asked 9 minutes ago -
How much must I invest today if I want to withdraw 1/3 of my
original investment...
asked 2 hours ago -
What is meant by a “term premium”?
What can explain such a premium? Is it a...
asked 3 hours ago -
23. Which molecule has only covalent bonds? A. CO2 B. Al2O3 C.
Mg3N2
24. The octet...
asked 4 hours ago -
the
total pressure for a mixture of N2O4 and NO2 is 2.20 atm. If Kp=
7.10...
asked 4 hours ago -
Delaware Corp. prepared a master budget that included $22,385
for direct materials, $28,600 for direct labor,...
asked 4 hours ago -
For pesticide HCB (hexachlorobenzene), its logarithmic partition
coefficient log Kow is 5.6. What would be the...
asked 4 hours ago -
A chemist requires 0.422 mil Na2CO3 for a reaction. How many
grams does this correspond to?
asked 4 hours ago -
If the vapor pressure of carvone is approximately 9.4 torr at 99
°C, approximately how much...
asked 4 hours ago -
A juice bottling company is carrying out a test at 10%
significance that the mean population...
asked 4 hours ago -
What is the reflectivity (in percent) needed to keep water at a
temperature near its freezing...
asked 4 hours ago -
Suppose that the average surface temperature of Earth is 300K.
Assume this is uniform over its...
asked 5 hours ago