Question
Please show in excel with equations! 1) A Chemical company manufactures three chemicals: A, B, and C. These chemicals are produced via two production processes:
Please show in excel with equations! 1) 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 unit of B, and 100 unit of C. Running process 2 for an hour costs $100 and yields 100 unit of A and 100 unit 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. [Chapter 3]
a. Write the algebraic formulation for the problem.
b. Use Solver to determine a daily production plan that minimizes the cost of meeting companys daily demands.
c. Confirm graphically that the daily production plan from part a minimizes the cost of meeting companys daily demands.
d. What happens to the decision variables and the total cost when the hourly processing cost for process 2 increases by 50$. How large must this cost increase be before the decision variables change? What happens when it continues to increase beyond this point? [hint: use sensitivity report]
e. What are the values of slack and surplus for constraints? [hint: use solver report] f. Which constraints have non-zero shadow prices? Explain.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started