Reference no: EM132255913

Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and C. The labor-hour requirements, by department, are as follows:

Department                Product   1    Product 2 Product 3

A                               1.50                              3.0                              2.0

B                               2.0                                1.0                             2.50

C                               0.25                               0.25                          0.25

During the next production period, the labor-hours available are 450 in department A, 350 in department B, and 50 in department C. The profit contributions per unit are $25 for product 1, $28 for product 2, and $30 for product 3. The setup costs are $400 for product 1, $550 for product 2, and $600 for product 3. At most, 175 units of product 1, 150 units of product 2, and 140 units of product 3 can be produced.

Part a. Formulate a mixed-integer linear programming model (identify and define decision variables, objective function and constraints) that can be used for maximizing total profit contribution. For “Part a” you do NOT need to solve this problem using Excel, you just need to do the formulation in the standard mathematical format.

Part b. Use Solver in Microsoft Excel to solve the model that you developed in “Part a”. Give the values of each decision variable and the objective function.