The Health and Wellness Company blends two organic ingredients (Ingredient 1 and Ingredient 2) to produce two
Question:
The Health and Wellness Company blends two organic ingredients (Ingredient 1 and Ingredient 2) to produce two health supplements (not steroids) to sell. Supplement 1 must be at least 70% Ingredient 1, and Supplement 2 must be at least 60% Ingredient 2. Up to 4,000 ounces of Supplement 1 can be sold at $6 per ounce, and up to 3,000 ounces of Supplement 2 can be sold at $5 per ounce. Up to 4,500 ounces of Ingredient 1 can be purchased at $5 per ounce, and up to 4,000 ounces of Ingredient 2 can be purchased at $4 per ounce. Set up and solve the problem to maximize the total profit for the company. The maximum total profit for the correct solution should be $8,000.
Set up and complete a one-way SolverTable. Change the available supply of ingredient 2, varying it from 2,000 to 5,000 in increments of 250 to see the impact on the amount of the two supplements produced and the total profit. Explain the results of the SolverTable in terms of the impact on the three outputs.