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 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. units

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 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. units

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter7: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 58P: Polaris Inc. manufactures two types of metal stampings for the automobile industry: door handles and...

See similar textbooks

Similar questions

Polaris Inc. manufactures two types of metal stampings for the automobile industry: door handles and trim kits. Fixed cost equals 146,000. Each door handle sells for 12 and has variable cost of 9; each trim kit sells for 8 and has variable cost of 5. Required: 1. What are the contribution margin per unit and the contribution margin ratio for door handles and for trim kits? 2. If Polaris sells 20,000 door handles and 40,000 trim kits, what is the operating income? 3. How many door handles and how many trim kits must be sold for Polaris to break even? 4. CONCEPTUAL CONNECTION Assume that Polaris has the opportunity to rearrange its plant to produce only trim kits. If this is done, fixed costs will decrease by 35,000, and 70,000 trim kits can be produced and sold. Is this a good idea? Explain.
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.19 Labor Cost per Unit = $0.14 MY NOTES ASK YOUR TEACHI Revenue per Unit = $0.69 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 produce profit is calculated by subtracting the fixed cost and total variable cost from total revenue. If Cox Electric makes 43,100 units of the new product, what is the resulting profit (In whole dollars)? $
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 = $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 = $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 = $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 = $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.80 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 $ 141,450 $ 188,325 Variable cost per switch 0.57 0.25 Required: For each machine, what is the minimum number of switches that Vista must make annually for total costs to equal outside purchase cost? What volume level would produce the same total costs regardless of the machine purchased? What is the most profitable alternative for producing 155,000 switches per year and what is the total cost of that alternative
Alba Company is considering the introduction of a new product. To determine the selling price of this product, you have gathered the following information: • Direct material cost per unit Direct labor cost per unit • Variable manufacturing cost per unit Total fixed manufacturing costs.. • Variable selling and administration cost per unit Total fixed selling and administration costs.. .$3,000 .$2,250 ..S1,000 .S1,750,000 ..$1,250 .$550,000 If the company requires a rate of return 18% on its investments and $6,000,000 investments are needed. The total direct materials to be used in the production is $3,000,000. Required: 1. If the company uses absorption costing approach to cost-plus pricing, compute: a. The unit product cost. b. The markup percentage. c. The selling price per unit. 2. Assume that the company is considering the introduction of other new product. If the target-selling price per unit is $5,500 and the company investing $5,000,000 to purchase equipment needed produce 500…
An industrial firm uses economic analysis to determine which of two different machines to purchase. Each machine is capable. Each machine is capable of performing the same task in a given amount of time. Assume the MARR=8%. Use the following data for analysis:What is the approximate equivalent uniform annual cost of Machine X?