Determine daily production plan

Assignment Help Operation Management

Reference no: EM132113975

A chemical company manufactures three chemicals: A, B, and C. These chemicals are produced via two production processes: 1 and 2. Running process 1 for an hour costs $400 and yields 300 units of A, 100 units of B, and 100 units of C. Running process 2 for an hour costs $100 and yields 100 units of A and 100 units of B. To meet customer demands, at least 1000 units of A, 500 units of B, and 300 units of C must be produced daily.

Use Excel Solver to determine a daily production plan that minimizes the cost of meeting the company’s daily demand.

Define the decision variables necessary for the LP formulation as follows:

X = # hours of for process 1 to run Y =

# hours of for process 2 to run

1. Formulate appropriately as an LP to minimize the cost. Provide the algebraic formulation in your submission. Must be neatly presented. (Note: Integer constraints are NOT needed in this problem.)

2. Input and solve the formulation using Excel. After running Solver, generate both answer report and sensitivity report. Explain the production plan based on the solutions.

Reference no: EM132113975

Questions Cloud

Company receive from the optimal production strategy : A furniture company manufactures desks and chairs. How much profit will the company receive from the optimal production strategy?

Explain the social change model of leadership : Explain the Social Change Model of Leadership. What are its components? What does the model say is necessary for social change?

Some of control strategies associated with risk mitigation : List and explain some of the “Control Strategies” associated with risk mitigation and the control of hazards in aviation safety.

Manufacturer want to set up control chart for irregularities : A textile manufacturer wants to set up a control chart for irregularities?

Determine daily production plan : Determine a daily production plan that minimizes the cost of meeting the company’s daily demand.

What is the difference between mediator and arbitrator : What is the difference between a mediator and an arbitrator? Give a scenario where one or the other would be used.

What is the difference between leadership and coaching : What is the difference between leadership and coaching? List and describe the 4 basic steps involved in coaching

When exploring the marketing plans of various companies : When exploring the marketing plans of various companies, you will undoubtedly discover how some businesses have already experienced success,

Ethics plays central role in the leadership process : Do you agree or disagree with the following statement, "Ethics plays a central role in the leadership process." Support your answer.?

User Account

All Pages