Please fill in the rest of the blanks in part b to d. Please use excel solver and show the functions and answers.

(a) Formulate a linear programming model for maximizing total profit contribution. (Let Pi= units of product i produced, for i=1,2,3.) Max s.t. Department A Department B 2P1+P2+2.5P3350 Department C P1,P2,P30 (b) Solve the linear program formulated in part (a). How much of each product should be produced, and what is the projected total profit contribution (in dollars)? (P1,P2,P3)=()withprofit$ profit contribution (in dollars) after taking into account the setup costs? : x What is the objective function of the mixed-integer linear program? Max In addition to the constraints from part (a), what other constraints should be added to the mixed-integer linear program? units of Product 1 produced units of Product 2 produced units of Product 3 produced P1,P2,P30;y1,y2,y3=0,1 (P1,P2,P3,y1,y2,y3)=()withprofit$]