Which products will be manufactured

Assignment Help Supply Chain Management

Reference no: EM133357047

A manufacturer sells two types of products. Product 1 is sold at a price of $50 per unit and product 2 at a price of $60 per unit. Three units of raw material and 1.5 labor hours are needed to manufacturer one unit of product 1. Six units of raw material and 2 labor hours are need to
manufacture one unit of product 2. The unit variable cost for product 1 is $30, and for product 2 is $20. A total of 15,000 units of raw material and 10,000 labor hours are available. If any product 1 is produced, a setup cost of $20,000 is incurred; if any product 2 is produced, a setup
cost of $35,000 is incurred. Use Excel to setup a model to maximize the manufacturer's profit. Please include both the model worksheet and the answer report in your excel file.

a) What is the effective capacity for product 1 and product 2, respectively?

b) In the optimal solution, which product(s) will be manufactured? What is the optimal production quantity? What is the optimal profit?

Reference no: EM133357047

Questions Cloud

Discuss the culture you have chosen and the viewpoint : You know as the nurse who will be caring for this patient you will need to understand this culture before beginning a conversation with the patient

Explain the dynamic effect that may result from : Explain the dynamic effect that may result from this order behavior. b) Elaborate two possible measures to avoid this effect.

How is walmart addressing this issue : poorly performing suppliers and higher inventories. How is Walmart addressing this issue?

What are some goals and expected outcomes you would like : What are some goals and expected outcomes you would like to have in place for this patient? What are some nursing interventions you would put into place

Which products will be manufactured : In the optimal solution, which product(s) will be manufactured? What is the optimal production quantity? What is the optimal profit

How would a summary of the patient be written : How would a summary of the patient be written with the following information Ms. Anderson is a 76-year-old Caucasian female resident at a long-term carefacility

What to do first - claim your topic : You can work by yourself or in groups of MAX 5 people. What to do First: Claim your topic on Discussion Boards

Calculate the performance score : Calculate the performance score for each of the three carriers. 2.Which carrier would you recommend that Bob consider for elimination? Why

Describe the seven levels of evidence : Describe the seven "levels of evidence" and provide an example of the type of practice change that could result from each. Provide reference from 2018 -2023

User Account

All Pages