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.:- M93101459

Have any Question?Write your Review or question?

Related Questions in Operation Management

What if any are the ethical reasons why rjr should change

What, if any, are the ethical reasons why RJR should change its promotions and what, if any, changes should it make? Are any of the arguments tobacco companies make in their defense legitimate? Explain. What would each o ...

1 read the article ldquomake-up shake-up the challenge of

1. Read the article “make-up shake-up: The challenge of multichannel marketing” and Explain the key problems, and describe a recommendation. 2. Nonresponse (to survey questionnaire) is a big problem for marketing resear ...

In some of the recent corporate scandals senior executives

In some of the recent corporate scandals, senior executives “doctored the books” and misrepresented the corporate financial status of the company. In others, transactions were created to and from inert or false companies ...

Purpose of assignment the purpose of this assignment is to

Purpose of Assignment The purpose of this assignment is to help students understand how manufacturing and service companies can maximize their competitive advantage. The Porter Model is discussed as a method to categoriz ...

In the last few chapters we have learned about various

In the last few chapters, we have learned about various selection techniques (e.g., applications, interviews, ability tests, performance tests, etc.). Think about these techniques, and address one or more of the followin ...

Use an organisation of your choice and discuss

Use an organisation of your choice and discuss, comprehensively and critically, workforce diversity and how it is affecting the productivity of the organisation. 1. Identify and discuss the similarities and differences a ...

1 when one party acquires a license to use another

1. When one party acquires a license to use another party’s business model and intellectual property in the distribution of goods and services, the arrangement is a __________. limited liability partnership kickback fran ...

Please read the following case of upd manufacturing and

Please read the following case of UPD Manufacturing and write the required report. UPD Manufacturing produces a range of healthcare appliance for hospital as well as for home use. The company has experienced a steady dem ...

Given that xerox developed the concept of competitive

Given that Xerox developed the concept of competitive benchmarking in the early 1980s and it is still around today, it appears that the concept is here to stay. It is especially useful to companies which are falling behi ...

You stated that change is inevitable and discussed the risk

You stated that change is inevitable and discussed the risk of poor quality. This is a threat because the customer does not have to accept the end product. This can result in rework without additional payment. Tollgate m ...

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