A chemical company manufactures three chemicals a b and c, Ask an Expert

Management Studies

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.

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M93101443

Have any Question?Write your Review or question?

Related Questions in Operation Management

Provide a specific situation professional life or personal

Provide a specific situation (professional life or personal situation) where you participated in a negotiation using a competitive or collaborative approach or used other modes of negotiation (accommodate, compromise, av ...

Image yourself as a cross-cultural manager of employees

Image yourself as a cross-cultural manager of employees from Ghana(West Africa). What are the motivation assumptions and techniques associated with that country? How would you motivate these employees to work hard and be ...

1 explain the difference between internal and external

1. Explain the difference between internal and external recruitment strategies. What are the benefits and potential challenges with each of these two types of recruiting efforts? 2. Describe each of the following trainin ...

We have had numerous disasters both natural and man made we

We have had numerous disasters both natural and man made. We have had Hurricanes Irma, Jose, and Maria as the largest hurricanes. We have had the mass shooting in Las Vegas, the shooting in Paris, the shooting in Manches ...

1 do a thorough swot analysis on the information technology

1. Do a thorough SWOT analysis on the information technology industry. 2. You are the hotel's liaison with the architects designing guest rooms for a new tower. Present them a list of the 10 most important items that mus ...

Resources ch 16 of management and appendix the project

Resources: Ch. 16 of Management and Appendix: The Project Planner's Toolkit of Management. Apply the concepts of the tools described in the Project Planner's Toolkit. After studying and evaluating the components included ...

A car manufacturer is considering one of two systems for

A car manufacturer is considering one of two systems for its windshield assembly line. The first is a robotic system that should save money due to a reduction in labor and materials costs. The robotic system will cost ...

1 identify and discuss some of the more significant

1. Identify and discuss some of the more significant trade-offs that a company faces with each of these various organization designs. Please be specific. and discuss in list form as follows: Simple Design Structure - Sig ...

Bruno fruscalzo decided to set up a small production

Bruno Fruscalzo decided to set up a small production facility in Sudney to sell at local restaurants that want gelato on their desser menu. To start simple, he would offer only three flavors of gelato: fragola( strawberr ...

1 what barriers exist that hamper the transfer of learning

1. What barriers exist that hamper the transfer of learning from the training classroom to back-on-the-job? 2. How is Micro Aggression Theory evident and displayed outside of the United States? 3. What are ways Micro Agg ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert