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.

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Similar questions

Smith Manufacturing is a major player in the lawn sprinkler business. Their high-end sprinkler is used commercially and is quite popular with golf course greens keepers. In producing these sprinklers Smith’s fixed cost (CF) is $50,000 per month with a variable cost (cv) of $10 per unit. The selling price for these high-end sprinklers is described by the equation p=$90 – 0.2(D). a) What is the optimal volume of sprinklers? b) Does Smith make a profit at that volume? Thank you.
The cumulative average labor hours to assemble the first five units of product A was 15.554 hours. If the learning curve, based on the previous experience with similar products, is 85%, what is the estimated time (labor hours) that will be required to assemble the 19th unit? The number of labor hours required to assemble the 19th unit is hours. (Round to one decimal place.)
Owen conner works part time packaging software for a local distribution company in indiana. The annual fixed cost is $15,000 for this process, direct labor is $4.00 per package, and material is $5.00 per package. The selling price will be $15.00 per package. How much revenue do we need to take in before breaking even? What is the break even point in units?
Last year, a company introduced a new version of its main product. The product costs $24002400 to develop (i.e. the start up costs) and $3535 to manufacture each product. Do all the following problems on your page: i) Give a linear equation in the form C(n)=mn+bC(n)=mn+b that gives the total cost to produce nn of these products. Give your answer in function notation. No steps or work are required, just give the function. ii) Find the total cost to produce n=3500n=3500 of these products. Show what numbers you used in your arithmetic calculations. Use function notation in your work. Answer in a complete sentence form with units and context. iii) If the company has $5315053150, how many of these items can be produced? Use function notation in your work. Answer in a complete sentence form with units and context.
The total cost a power plant ($/megawatts) to produce electricity is Y=12+1.3X+0.24 X2 , where X is in megawatts. The estimated selling price of electricity is (16-0.23X) per megawatts. Find the value of X that maximizes profit. Group of answer choices Less than 10 megawatts Between 10-12 megawatts Between 12-14 megawatts More than 14 megawatts Dont
Assume a pool of 115 people in an insurance pool (a group of people insured through community rating). It is estimated that a small number in the pool will have significant pre- existing conditions as indicated in the table. Based on the age of these 115 people, the insurance company estimates the following distribution of health care claims (which includes necessary profit and administrative costs of the insurance company). Number of Insured Antidipated Heath Costs/Year/Person $1,400 $1,500 $1,600 $1,700 $1,800 $1,900 $2,000 $2,100 $2,200 $2.300 $2,400 $2,500 $2,700 $2,000 $2,900 $3,000 $3,100 $3.200 $3.300 $4,000 57,00 $10,000 Everyone joins the poal ad pays the necessary premum in the first year. The clams experience of the customers is faund to be generaly consstent with expeclations of the insurance company. A) What would be the premium In the third year if there is no inflation, based on the company's oxperience from the past year? B) If those customers who have anticipated…
Mirtha owns an online jewelry store that specializes in earrings. In March, she sells 50 pairs of earrings priced at $15. The cost of materials to create the 50 pairs of earrings was $100. The website she uses to sell her wares costs her $10 a month, and she is also charged 4% on each sale by the company that processes debit/credit card purchases. Which of the following best represents Mirth’s total cost? Group of answer choices A)The $750 Mirtha earned from earring sales minus the materials ($100), online website charge ($10), and payment processing charge (4%) B)The sum of the materials ($100), website charge ($10), and 4% payment processing charge (4%) C)The cost of all the materials used to create the earrings, $100 D)The costs of materials minus the costs it takes to run her business through the online store, in this case the $10 website charges and the 4% payment processing charge
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.)
An architect-engineering firm is planning a parking lot to accomodate 400 vehicles. Each parking space will be 8.5 feet x 15 feet. It has been estimated that the space required for aisles will be 70 percentage of the space required for parking. A local paving company charges 8$ per square foot for paving and a flat fee of $10,600 for marking and painting the individual parking spaces. Based on this information, what is the estimated cost of paving and marking this parking lot? The estimated cost of paving and marking the parking lot is: $ ?
Alfarah Company estimates that variable costs will be 50% of selling price per unit, and fixed costs will total 500,000 The selling price of the product is $5. Instructions 1. Compute the break-even point in (a) units and (b) dollars. 2. Prepare a CVP graph, assuming maximum sales of $3,200,000, (Note: Use$400,000 increments for sales and costs and 100,000 increments for units.) 3. Assuming actual sales are $2million, compute the margin of safety in (a) dollars and (b)as ratio. Note, Variable costs: 50% of the selling price per Fixed costs: $500,000 Selling price per unit: $5 Maximum sales: $3,200,000 Actual sales: $2,000,000 unit
A large company in the communication and publishing industry has quantified the relationship between the price of one of its products and the demand for this product as Price=160−0.02×Demand for an annual printing of this particular product. The fixed costs per year (i.e., per printing)=$47,000 and the variable cost per unit=$40. What is the maximum profit that can be achieved? What is the unit price at this point of optimal demand? Demand is not expected to be more than 4,000 units per year. The maximum profit that can be achieved is $? (Round to the nearest dollar.) The unit price at the point of optimal demand is $? per unit.
A manufacturer of dishwashers is preparing to set the price on a new design. Demand is thought to depend on the price and is represented by D = 2100 – 4.3P The accounting department estimates that the total costs can be represented by C = 4840 + 6.2D (a) Develop a model for the total profit in terms of the price, P. (b) What will be the total profit if the price is $380.