MistaMista
New Member
- Joined
- May 18, 2021
- Messages
- 14
- Office Version
- 2019
- Platform
- Windows
- MacOS
I have two different products, which both uses a mixture of two chemicals.
Suppose you have to prepare the mixture for Product A and Product B at the same time. How many liters of mixture for Product A and Product B can you prepare using the available inventory of the chemicals available?
Here's the amount in liters each product need.
INVENTORY AVAILABLE:
Acid Chemicals = 393 L
Stabilizer = 630 L
How many liters of Product A and B can I make?
So I have found correct answer using Wolfram, but on exam you're only allowed to use Excel, and I want to figure out how to do this easily with goalseek or solver?
WOLFRAM LINK TO ANSWER HERE!
Suppose you have to prepare the mixture for Product A and Product B at the same time. How many liters of mixture for Product A and Product B can you prepare using the available inventory of the chemicals available?
Here's the amount in liters each product need.
Product A | Product B | |
Acid Chemical (liters) | 0.178 | 0.546 |
Stabilizer (liters) | 0.638 | 0.199 |
INVENTORY AVAILABLE:
Acid Chemicals = 393 L
Stabilizer = 630 L
How many liters of Product A and B can I make?
So I have found correct answer using Wolfram, but on exam you're only allowed to use Excel, and I want to figure out how to do this easily with goalseek or solver?
WOLFRAM LINK TO ANSWER HERE!
Last edited: