Please help me!

Data

A: 334

B:193

C:149

D:21

E: 22

Homework Assignment 9 (Linear Programming) You can submit your work either . as a Word file, or an Excel file, or solve it on paper, take a picture, and upload it to Canvas Don't forget to explain your work! Read the case given below carefully: Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table below contains all relevant information concerning production times per cabinet produced and production capacities for each operation per day, along with net revenue per unit produced. The firm has a contract with an Indiana distributor to produce a minimum of 30 of each cabinet per week. Owner Bob Winkler would like to determine a product mix to maximize his daily revenue. Cabinet Carpentry Painting Finishing Net Revenue Style (Hours/ (Hours/ (Hours/ Cabinet) Cabinet) Cabinet) French 3 1.5 0.75 D Provincial Danish 2 1 0.75 E Modern Department A B Capacity Assume that number of French Provincial cabinets and Danish Modern cabinets are integers. Based on this case a) What is the objective function? Express the objective function in mathematical terms (2 pt) b) What are the constraints given in the question? (i.e. ignore the constraints like all variables being positive, etc.) (6 constraints, 0.5 pt each, 3 pts total) c) Solve the problem using Excel's solver and determine the number of Alpha 4s and Beta 5s needed to be manufactured. (2 pt.)