Chemical manufacturing
SuperClassA chemical company manufacturers 3 chemicals: A, B, and C. These chemicals are produced via 2 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 Solver to determine a daily production plan that minimizes the cost of meeting the company's daily demands.
Use SolverTable to see what happens to the decision variables and the total cost when the hourly processing cost for process 2 increases in increments of $0.50. How large must this cost increase be before the decision variables change?
| Chemical manufacturing | ||||||
| Process 1 | Process 2 | |||||
| Cost per hour | $400 | $100 | ||||
| Output production per hour | ||||||
| Process 1 | Process 2 | Chemical produced | Chemical required | |||
| Chemical A | 300 | 100 | Chemical A | 1000 | ||
| Chemical B | 100 | 100 | Chemical B | 500 | ||
| Chemical C | 100 | Chemical C | 300 | |||
| Process 1 | Process 2 | |||||
| Hours run | ||||||
| Total cost | ||||||
10 years ago
Purchase the answer to view it
chemical_manufacturing.xlsx
