ATTENTION!!! Following problem NEEDS to be solved using EXCEL, and the solver function, and the one way table (solvertable). HANDWRITTEN RESPONSES ARE NOT AVAILABLE. PLEASE provide screenshots of how you set the problem up, of ALL formulas, what you put into the solver function, the one way table, and the results. Thanks

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.