Question: PRACTICE ASSIGNMENT- I'm needing help setting up the problem in excel. Could you do it in excel and send the picture to me? It costs
PRACTICE ASSIGNMENT- I'm needing help setting up the problem in excel. Could you do it in excel and send the picture to me?
- It costs a company 50 cents to product a gallon of regular gasoline and 70 cents to produce a gallon of premium gasoline. The company's minimum weekly production capacity is 3000 gallons. There are three ingredients that go into production. For ingredient P, there are 2200 gallons available. Each regular gallon requires 0.6 gallons of ingredient P and each premium gallon requires 0.8 gallons of ingredient P. There are 1100 gallons available of ingredient E. For each gallon of regular, 0.3 gallon of ingredient E are used and for each gallon of premium, 0.1 gallon of ingredient E are used. For ingredient S, there are 250 gallons available. A gallon of regular and a gallon of premium require 0.1 and 0.05 gallon of ingredient S in production, respectively.
- Write the Linear Program.
Here's an example of what the excel sheet is supposed to look like.... (just an example, not for this problem)
| Stocks | Mutual Funds | Gold | Bond | Crypto | ||||
| Invest in | ||||||||
| Return | 0.15 | 0.12 | 0.1 | 0.07 | 0.18 | 0 | ||
| s.t. | ||||||||
| Total fund | 1 | 1 | 1 | 1 | 1 | 0 | <= | 10 |
| Max. Crypto | 1 | 0 | <= | 2 | ||||
| Min. Mutal Fund | 1 | 0 | >= | 1 | ||||
| Min. gold + bond | -0.3 | -0.3 | 0.7 | 0.7 | -0.3 | 0 | >= | 0.3 |
| Min. stock | 0.75 | -0.25 | -0.25 | -0.25 | -0.25 | 0 | >= | 0.25 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
