need help with C

A winery makes three varieties of contemporary wines: a ne red, a table white, and a hearty pink. The raw materials, labor, and contribution per case of each of these wines is summarized in the table below: Grapes Grapes Variety A Variety B Sugar Contrib. bushels bushels - ounds Labor ours - er case ___-_ _-__\" The winery has 2800 bushels of Variety A grapes, 2040 bushels of Variety B grapes, 800 pounds of sugar, and 1060 hours of labor available during the next week. The rm operates to achieve maximum contribution. a) (30 p.) Formulate a linear programming (LP) model for this problem. b) (10 p.) Solve the problem with Excel's Solver in order to maximize the total contribution (prot) of this operation. How many cases of each wine should be produced? Attach all Excel printouts (e. g., screenshots) as Exhibits. 0) (10 p.) How much should the winery be willing to pay for an additional hour of labor? Fully explain your