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

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

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter19: Pricing Concepts

Section: Chapter Questions

Problem 6DRQ

See similar textbooks

Similar questions

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)
Please do not give solution in image format thanku Bob's candle factory is considering three different manufacturing options. Option A uses hand labor with fixed costs of $10,000 and variable costs of $2.75/candle. Option B uses a combination of hand and automation with fixed costs of $15,000 and variable costs of $1.10/candle. Option C is highly automated with fixed costs of $20,000 and variable costs of $0.75/candle. a. If demand for Bob's candles is 2500, which option should he pick, and what is the cost? b. If demand for Bob's candles is 4500 which option should he pick, and what is the cost?
An airline company LTd limited planning to launch a holiday’s business and was seeking a system that would enable them to: Dynamically package hotels and other ground products with their flights to offer quality, value-for-money packages. Easily and quickly launch new international and domestic destinations. Create and sell special offers. Provide easy and reliable online booking. Name architectural style that you will use and why? State the three most important advantages of using this architecture
a. distinguish between systems design and systems quality. what challenges are there? b. describe the relationship between design capacity, system capacity, and actual output. how can you ensure a projected output is within the boundaries of the design capacity and system capacity?
Prepare an REA diagram for a Fitness Center using the following assumptions. We only offer individual memberships. Each membership costs a client $50 per month. On the first of each month, our Accounts Payable clerk sends to each client a monthly bill for $50. The client is expected to pay the bill within 10 days or the membership will be cancelled. When the check comes in, our Cash Receipts clerk deposits it into our sole bank account. (Hint: Do we need a Resource connected to the Sale event? Do we need a Resource connected to the Cash Receipt event?)
You are the operations manager for Louisiana Oysters, Inc. The company has designed new "Oyster shucking" knife that is expected to reduce risk of injury to the user. Your firm plans to begin production of these knives soon. Either of two machines, A or B could be used for in-house production. Machine A would have a fixed cost of $6000 and a variable cost of $5 per knife produced, and machine B would have a fixed cost of $9600 but a variable cost of $3 per knife. Each knife is expected to sell for $15. Determine the Range of annual “Volume of Business“[Q], for which each of the two alternative machines would be optimal i.e. best. Hint: Compute various break-even points for your evaluation
What is service Blueprinting? Outline it's components?
Finding the Break-Even QuantityA hospital is considering a new procedure to be offered at $200 per patient. The fixed cost per year would be $100,000, with total variable costs of $100 per patient. What is the break-even quantity for this service? Use both algebraic and graphic approaches to get the answer.
Describe service blueprinting? Give some examples of when it should be used?
1) Create a business scenario/description. 2) Based on the business description created, construct an Order Processing flow chart that is appropriate for the business.
Theories and concepts: Cause of the difficulties In this section, I will explain the causes of the difficulties which I have explained above. The reason for the missing cages uses to be that the cage is still being picked or not and if the picker is still using the cage to pick the items then request the picker to drop the cage off to the packing department so that the items can be packed and sent out the shipping department for the delivery. Also, if the cage is not in the picking department buffer or pack buffer and is not being picked then as a process guide it was my duty to search for the cage at the packing stations first, and if not found then to escalate to the management so that relevant department can be contacted for the action. During the critical pool time, there were a few shipments IDs use to get sent down from the picking department which they couldn’t send into the picker’s scanners as either the batch assigned for the item by the stowing department would be wrong or…
Because of the coronavirus, Cafes and restaurants are going to be open between 8 a.m. and 20 p.m. , and with 50% capacity. Imagine that the Ministry of Health thinks Coronavirus can last for years and wants to develop a system that can be used to fulfill the above rule. Write a report about that... 1- Write a “problem definition”, “objectives” and “issues to be solved” for this rule, as a system analyst you are. 2- What system development methodology do you use and why?