for #1- I need the linear program written out, preferably on excel with explanation of how to get there

for #2- i need the linear program solved using "Solver" add in on excel, and a written strategy. then i need a sensitivity analysis and the binding constraints identified.

As well as "problem C" listed

1) A company produces drinks in liters ( 33.8oz.) and single serving ( 16.9oz.) containers that utilize three resources of soda, plastic for the containers, and manufacturing time. The liter requires 3 ounces of plastic and the single-serving container requires 1.5 ounces of plastic, while the liter requires a total of 2 minutes of manufacturing time and a single serving requires 90 seconds of manufacturing time. Each week, the company has 55,000 ounces of soda available, 6,000 ounces of plastic, and 40 hours of manufacturing time. Each liter has a profit of $0.70 and each single serving has a profit of $0.50. a. Write the Linear Program. (15 pts) 2) A farmer is planning the crops that will be planted in the upcoming season. The farmer can get $353.08 per metric ton of soybean, $119.42 per metric ton of barley, $163.80 per metric ton of corn, and \$212.64 per metric ton of wheat. The total capacity of the farm is 400 metric tons of product. Based on rising tariffs, at most, the soybeans should constitute 20% of the total crop. Prices for barley and wheat have been declining, so corn should at least be 175 metric tons. a. Solve the linear program using Solver and write the strategy. ( 15pts) b. Run a sensitivity analysis and identify the constraints that are binding. (10 pts) c. What is the change in the objective function value if the minimum for corn was 100 metric tons and the farmer acquired land that could produce 75 more metric tons of crop? (10 pts)