A=312, B=162, C=102, D=28, E=30

Please Explain The Work

If You Cant Answer the question Please give it to someone who can Thank You!

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 day. 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 C 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 French Provincial models and Danish Modern models needed to be manufactured. (2 pt.) Values are in the next page