Cox Electric makes electronic components and has estimated the following for a new design of one of its products:Fixed Cost$3,000Material cost per unit$0.15Labor cost per unit =$0.10Revenue per unit = $0.65Production Volume = 12,000Per-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 bysubtracting 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 from 5,000 to 50,000 in increments of 5,000. In which interval of production volumedoes breakeven occur?tounits=(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 productionvolume in your model.

Break-Even Point-The Break-Even Point expressed in units is calculated by dividing total fixed costs…

Answered: -unit material and labor cost together…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

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 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 from 5,000 to 50,000 in increments of 5,000. In which interval of production volume does breakeven occur? to units (b) Use Goal Seek to find the exact breakeven point. Assign Set cell:…
Cox Electric makes electronic components and has estimated the following for a new design of one of its products. . Fixed cost = $12,750 • Material cost per unit = $0.16 • Labor cost per unit = $0.12 • Revenue per unit = $0.62 Note that fixed cost s incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost from total revenue. Construct an appropriate spreadsheet model to find the profit based on a given production level and use the spreadsheet model to answer these 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 = the total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in increments of…
Cox Electric makes electronic components and has estimated the following for a new design of one of its products. Fixed cost = $12,350 • Material cost per unit = $0.16 •Labor cost per unit = $0.12 •Revenue per unit = $0.66 Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost from total revenue. Construct an appropriate spreadsheet model to find the profit based on a given production level and use the spreadsheet model to answer these 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 = the total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in increments of 10,000.…
Cox Electric makes electronic components and has estimated the following for a new design of one of its products. • Fixed cost = $12,350 • Material cost per unit = $0.16 Labor cost per unit = $0.12 • Revenue per unit = $0.66 Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost from total revenue. Construct an appropriate spreadsheet model to find the profit based on a given production level and use the spreadsheet model to answer these 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 = the total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in increments of 10,000.…
Cox Electric makes electronic components and has estimated the following for a new design of one of its products. • Fixed cost = $12,350 • Material cost per unit = $0.16 • Labor cost per unit = $0.12 • Revenue per unit = $0.66 Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost from total revenue. Construct an appropriate spreadsheet model to find the profit based on a given production level and use the spreadsheet model to answer these 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 = the total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in increments of…
Cox Electric makes electronic components and has estimated the following for a new design of one of its products: Fixed cost = $10,000 Material cost per unit = $ 0.15 Labor cost per unit = $ 0.10 Revenue per unit = $ 0.65 These data are given in the file CoxElectric. Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming Cox Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost rom total revenue. Create a spreadsheet model and construct a 1-way table and determine the breakeven point (use intervals of 10,000 units). Group of answer choices 20,000 - 30,000 10,000 - 20,000 30,000 - 40,000 25,000 30,000 20,000
Cox Electric makes electronic components and has estimated the following for a new design of one of its products. Fixed cost = $23,750 • Material cost per unit = $0.17 • Labor cost per unit = $0.11 • Revenue per unit = $0.66 Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost from total revenue. Construct an appropriate spreadsheet model to find the profit based on a given production level and use the spreadsheet model to answer these 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 = the total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in increments of 10,000.…
Vista Company manufactures electronic equipment. It currently purchases the special switches used in each of its products from an outside supplier. The supplier charges Vista $1.45 per switch. Vista’s CEO is considering purchasing either machine A or machine B so the company can manufacture its own switches. The projected data are as follows: Machine A Machine B Annual fixed costs $ 108,900 $ 145,000 Variable cost per switch 0.46 0.20 Required: 1. For each machine, what is the minimum number of switches that Vista must make annually for total costs to equal outside purchase cost? 2. What volume level would produce the same total costs regardless of the machine purchased? 3. What is the most profitable alternative for producing 150,000 switches per year and what is the total cost of that alternative?
Hint(s) Check My Work Cox Electric makes electronic components and has estimated the following for a new design of one of its products: Fixed Cost $9,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 that 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 from 5,000 to 50,000 in increments of 5,000. In which interval of production volume does breakeven occur? to units (b) Use Goal Seek to find the exact…
Burnem Inc. manufactures thumb drives and sells them to a distributor. Burnem's total cost and total revenue (in dollars) for x thumb drives are given by the following equations. Total cost = 6(x + 4716) and Total revenue = 15x (a) How many thumb drives must Burnem sell to break even? X = thumb drives (b) What is the selling price of each item? $ (c) What are the fixed costs? $ (d) What is the marginal profit per item? $
Grove Audio is considering the introduction of a new model of wireless speakers with the following price and cost characteristics. Sales price $ 439.00 per unit Variable costs 199.00 per unit Fixed costs 687,000 per year Assume that the projected number of units sold for the year is 4,200. Consider requirements (b), (c), and (d) independently of each other. Required: What will the operating profit be? What is the impact on operating profit if the sales price decreases by 20 percent? Increases by 10 percent? What is the impact on operating profit if variable costs per unit decrease by 10 percent? Increase by 20 percent? Suppose that fixed costs for the year are 20 percent lower than projected, and variable costs per unit are 10 percent higher than projected. What impact will these cost changes have on operating profit for the year? Will profit go up? Down? By how much?
One company makes watches and delivers them in a wooden case. You buy each case for $ 58. The company is considering manufacturing the cases with a fixed cost of $ 3,360 and a variable cost of $ 46 per case. a) How many cases must the company manufacture to be at a point of equilibrium?b) What is the total cost of these kits? Note: Establish the necessary equations and solve them, take as variable "x" the number of kits and as variable "y" the total cost

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS