The operations manager for an auto supply company is evaluating the potential purchase of a new machine for the production of a transmission component. Current manufacturing costs are fixed costs of $11,000 and a variable cost of $0.50 per unit. The new machine would have fixed cost of $4,000 and a variable cost of $0.75 per unit. Each component is sold for $1.50 per unit. Develop two separate models in your spreadsheet to calculate Total Profit for each option. The models must be flexible and able to calculate Total profit for any Quantity produced. ( use an excel sheet to show formulas) . Find the break-even quantity for each option

The operations manager for an auto supply company is evaluating the potential purchase of a new machine for the production of a transmission component. Current manufacturing costs are fixed costs of $11,000 and a variable cost of $0.50 per unit. The new machine would have fixed cost of $4,000 and a variable cost of $0.75 per unit. Each component is sold for $1.50 per unit. Develop two separate models in your spreadsheet to calculate Total Profit for each option. The models must be flexible and able to calculate Total profit for any Quantity produced. ( use an excel sheet to show formulas) . Find the break-even quantity for each option

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 46P

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
The operations manager for an auto supply company is evaluating the potential purchase of a new machine for the production of a transmission component. Current manufacturing costs are fixed costs of $11,000 and a variable cost of $0.50 per unit. The new machine would have fixed cost of $4,000 and a variable cost of $0.75 per unit. Each component is sold for $1.50 per unit. (use a excel file to show all calculations) 1.Develop two separate models in your spreadsheet to calculate Total Profit for each option.The models must be flexible and able to calculate Total profit for any Quantity produced. 2.Find the break-even quantity for each option 3. Graph the Total profit for each option vs Quantity (both lines on one graph) Show Quantity from 0 to 50,000 4.Write an interpretation of your graph
Techno Corporation is currently manufacturing an item at variable costs of $5 per unit. Annual fixed costs of manufacturing this item are $140,000. The current selling price of the item is $10 per unit, and the annual sales volume is 30,000 units. so Techno can substantially improve the item’s quality by installing new equipment at additional annual fixed costs of $60,000. Variable costs per unit would increase by $1, but, as more of the better-quality product could be sold, the annual volume would increase to 50,000 units. Should Techno buy the new equipment and maintain the current price of the item? Why or why not?
Palisades Eco-Park is a small ecological reserve that admits a relatively small number of visitors on any day, but provides both educational and entertaining lectures, exhibitions, and opportunities to observe nature. The company has collected the following data on labor costs and number of visitors to the park over the last 30 months. Month Labor Cost Visitors 1 $ 26,720 2,600 2 $ 37,555 3,964 3 $ 41,361 4,299 4 $ 32,751 3,398 5 $ 36,022 3,630 6 $ 33,811 3,336 7 $ 33,139 3,372 8 $ 39,671 4,093 9 $ 39,912 4,222 10 $ 48,568 5,463 11 $ 43,627 4,551 12 $ 40,390 4,289 13 $ 35,644 3,694 14 $ 34,330 3,573 15 $ 38,260 3,836 16 $ 27,424 3,210 17 $ 31,732 5,195 18 $ 31,005 4,260 19 $ 28,552 3,689 20 $ 31,049 4,546 21 $ 26,588 3,058 22 $ 25,515 2,744 23 $ 29,899 4,997 24 $ 31,204 5,838 25 $ 29,099 3,964 26 $ 32,795 5,007 27 $ 29,650 4,572 28 $ 30,970 4,665 29 $ 29,429 3,841 30 $ 28,846 3,174 Required: a. Estimate the labor…
Techno Corporation is currently manufacturing an item at variable costs of $5 per unit. Annual fixed costs of manufacturing this item are $140,000. The current selling price of the item is $10 per unit, and the annual sales volume is 30,000 units.a. Techno can substantially improve the item’s quality by installing new equipment at additional annual fixed costs of $60,000. Variable costs per unit would increase by $1, but, as more of the better-quality product could be sold, the annual volume would increase to 50,000 units. Should Techno buy the new equipment and maintain the current price of the item? Why or why not?b. Alternatively, Techno could increase the selling price to $11 per unit. However, the annual sales volume would be limited to 45,000 units. Should Techno buy the new equipment and raise the price of the item? Why or why not?
The following data for 2021 are available for Canlubang AutomotiveCompany which manufactures and sells a single automotive product line.Unit selling price = 4Unit variable cost = 20Total fixed cost = 200,000a.) What is the break-even point in units for the current year?b.) Prepare a break-even chart for the operation in 2021 intervals of 5,000 units from 5,000to 30,000 units (show complete solution)
LPM Corp. produces and sells two types of frozen burgers, Turkey Burgers and Veggie Burgers. In the most recent month, the firm sold 12,000 Turkey Burgers and 8,000 Veggie Burgers. Turkey Burgers sold for $14.00 per box and variable costs were $7.40 per box. The Veggie Burgers sold for $16.00 per box and variable costs were $8.25 per box. The fixed expenses of the entire company were $41,160. If the sales mix were to shift toward the Turkey Burgers product line with total sales volume remaining constant at 20,000, the overall break-even point for the entire company:
In normal circumstances the airline industry creates value, a portion of which the airlines capture for themselves. Explain what we mean by value capture and how increased competition in the industry might impact the ability of airlines to capture value.
What outcomes from latest research can be used during the design of the aircraft to emphasize sustainability and minimization of adverse impact on the environment?
HPU currently has a recycling program for paper waste. The fixed cost of running this program is $18,500 per year. The variable cost for picking up and disposing of each ton of recyclable paper is $30. If the work is outsourced to a recycling company, the cost would be $43 per ton. If the forecasted demand is 1,500 tons, what should the university do? Use the Break-Even Excel template to find your answer.
The Soma Inn is trying to determine its break-even point. The inn has 75 rooms that are rented at $60 a night. Operating costs are as follows. Salaries $10,600 per month Utilities 2,400 per month Depreciation 1,500 per month Maintenance 800 per month Maid service 8 per room Other costs 34 per room (a) Determine the inn’s break-even point in (1) number of rented rooms per month and (2) dollars. 1. Break-even point in rooms 2. Break-even point $ per month
Problem 4-07 Hudson Corporation is considering three options for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: Demand Staffing Options High Medium Low Own staff 650 650 600 Outside vendor 900 600 300 Combination 800 650 500 If the demand probabilities are 0.2, 0.5, and 0.3, which decision alternative will minimize the expected cost of the data processing operation? _______________ (own staff, outside vendor, or combination) What is the expected annual cost associated with that recommendation?Expected annual cost = $________ (fill in the blank) Construct a risk profile for the optimal decision in part (a).The input in the box below will not be graded, but may be…