Please use Excel to solvethank you.

A B 3 2 4 3 4 4 PLM Inc. manufactures 3 versions of a product by requiring them to have work done in each of 3 departments, and, by requiring them to use 3 of the same types of material. The following table includes information that is necessary to determine the optimal amounts of each product to produce to maximize PLM's total profit subject to satisfying all necessary constraints. Product available production time reg'g/ unit in dept. X 5 6 8 9,000+ production time reg's/ unit in dept. Y 5,500 production time reg'd/ unit in dept. Z 6,000 material] (grams) regg/unit 75 100 94 27,000+ material K (grams) reg'd/unit 31 14,000+ material b (grams) reg'g/unit 12 11,000 profit per unit $48 $59 Using A, B and C as your decision variables, formulate the following portions of the linear programming model that will allow PLM to maximize its total profit subject to satisfying all necessary constraints. When formulating the constraints, make sure you use the traditional form. For example, 3A + 2B - 30 s 50, not 3A + 2B s 50 + 3C. YOU DO NOT NEED TO FORMULATE THE ENTIRE MODEL. Only complete what is asked below! a) The complete objective function 25 14 41 20 $53 b) The constraint for dept. X t c) The constraint for material Lt t t d) The constraint that the amount of product A produced must be at least 40% of the overall total of all amounts produced e) The constraint that the profit from manufacturing product B must be at least 20% of PLM's total profit t Excel Assignment 1 Name Student No. X