Cox Electric makes electronic components and has estimated the following for a new design of one of its products: Fixed Cost = $13,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: equal to the location of profit, To value: = 0, and By changing cell: equal to the location of the production volume in your model.

Cox Electric makes electronic components and has estimated the following for a new design of one of its products: Fixed Cost = $13,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: equal to the location of profit, To value: = 0, and By changing cell: equal to the location of the production volume in your model.

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)

14th Edition

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Chapter8: Cost Analysis

Section: Chapter Questions

Problem 5E

See similar textbooks

Similar questions

The publishing company is publishing a book for business economics for which it has estimated the following total fixed and average variable cost: Total fixed cost $ 100,000 Average Variable Cost $ 20 Selling Price $ 30 Determine the breakeven output and total sales revenues. Determine the output that would generate a total profit of $ 60000 and total sales revenue at that output level. If total fixed cost reduced to $ 40,000 then what is the breakeven point. How much units they have to sale if they require to have a profit of $ 60,000. Find out the publisher breakeven point if fixed cost remain same at $ 100,000 but the variable cost reduced to $10. Also find out the breakeven point if profit of $60,000 has to be earned. Find out the breakeven and sales at required profit of $60,000 if all cost remain same but the price per unit increased to $40.
The economic order quantity of Inc. is 1,000 unit. They sold their sole product for a selling price of P5. It takes P20,000 a year for Inc. in ordering 1,000 units per transaction. Carrying cost is P4 per unit per year. The lead time for this product is one week. How much sales revenue should Inc. have for this economic order quantity to be plausible? (Use 360 days a year)
The publishing company is publishing a book for business economics for which it has estimated the following total fixed and average variable cost: Total fixed cost $100,000 Average Variable Cost $ 20 Selling Price $ 30 a) Determine the breakeven output and total sales revenues. b) Determine the output that would generate a total profit of $ 60000 and total sales revenue at that output level. c) If total fixed cost reduced to $ 40,000 then what is the breakeven point. How much units they have to sale if they require to have a profit of $ 60,000. d) Find out the publisher breakeven point if fixed cost remain same at $ 100,000 but the variable cost reduced to $10. Also find out the breakeven point if profit of $60,000 has to be earned. e) Find out the breakeven and sales at required profit of $60,000 if all cost remain same but the price per unit increased to $40.
Data for a new product that is very labor intensive introduced by Hicks Brothers in the operation in Hendersonville, TN, is given below. The average labor cost including overhead expenses is about $20 per hour. If production time required for the first unit is 10 hours, and the operation has a 95% learning curve, what is the cumulative (i.e. total) time for 10 units to be made? Group of answer choices 103.43 hrs 30.69 hrs 89.56 hrs 501.40 hrs
Sales of bottled water in the United States totaled 34.0 gallons per person in 2014. Evian, a high-quality natural spring water, costs about 60¢ per bottle, while a local brand of purified municipal water may cost only 25¢ per bottle. On average, a local municipal water utility may provide drinkable tap water for $2.90 per 1000 gallons. If the average person drinks two bottles of water per day or uses 5 gallons per day to obtain the same amount of water from the tap, what are the present worth values per person for 1 year of drinking tap water versus bottled water using (a) Evian, and (b) local-brand bottled water? Use an interest rate of 6% per year, compounded monthly, and 30 days per month.
Economic cost is equal to the sum of exiplicit and implicit costs. True/ False
A cell phone company has a fixed cost of $1,000,000 per month and a variable cost of $22 per month per subscriber. The company charges $33 per month to its cell phone customers. a.What is the annual breakeven point for this company? b. The company currently has 95,000 subscribers and proposes to raise its monthly fees to $39.95, what is the new annual break-even point if the variable cost increases to $25 per customer per month? c.lf 20,000 subscribers will drop their services because of mönthly increase in part (b), will the company still be profitable?
Henleigh Hill, CFO of HH Corp., uses a decentralized company processing center for check collection. She estimates that the total annual cost of collections is currently $300,000. Henleigh is considering switching to a centralized company processing center, but she is worried about the required increase in fixed costs. Use the following assumptions to determine the maximum fixed cost of the centralized company processing center that would make Henleigh indifferent between a decentralized or centralized company processing center. Number of checks processed per year = 450,000 Average face value of checks = $1,000 Collection float for centralized processing = five days Variable processing cost per check for centralized processing = $0.25 Opportunity cost rate = 5 percent
Determine the breakeven point in terms of number of units produced per month and draw its corresponding break-even chart using the following data:➢ Selling price/unit 600 PhP➢ Total monthly overhead expenses 428,000 PhP➢ Labor cost 115 PhP➢ Cost of Materials 76 PhP➢ Other variable 2.32 Php
Need as soon as possible. Will upvote as long as correct and complete solution. Thank you! Correct Answers: DBM- 881,696.22 SFM- 3,896,123 SYD- 1,091,800 SLM- ?
Tom borrowed Php500,000 from her parents to open a spa. He pays her parents a 5% yearly return on the money they lent her. Her other yearly fixed costs equal Php150,000 and his variable costs equal Php200,000. In her first year, Tom had a total of 2,000 customers at a price of Php300/customer. Tom's total fixed cost is
Sally Statistics is implementing a system of statistical process control (SPC) charts in her factory in an effort to reduce the overall cost of scrapped product. The current cost of scrap is $X per month. If a 75% learning curve is expected in the use of the SPC charts to reduce the cost of scrap, what would the percentage reduction in monthly scrap cost be after the charts have been used for 6 months? (Hint: Model each month as a unit of production.)