please do all parts. This is one question. Use provided excel format.

complete question. no other values.

Destination D E Capacity 4 Cost/Destination 5 To Distributor 6 A 7 B 8 Demand 9 10 $0.00 11 Model 12 13 Total Cost 14 15 16 Cost/Destination 17 To Distributor 18 A 19 B 20 Total E Destination D 0 0 0 0 0 0 0 0 0 Total 0 0 DECISION VARIABLES X1 X2 X3 Where, Product Mix X1 = X2 X3 = OBJECTIVE FUNCTION Max Profit Total 0 CONSTRAINTS LHS RHS OOO OO BINDING BINDING BINDING BINDING BINDING BINDING 04: C5: 0 The management of Hartman Company is trying to determine the amount of each of two products to produce over the coming planning period. The following information concerns labor availability, labor utilization, and product profitability: Labor-Hours Required (hours/unit) Department Product 1 Product 2 Hours Available 1.00 0.35 100 B 0.30 0.20 36 0.20 0.50 Profit contribution/unit $30.00 $15.00 a. Develop a linear programming model of the Hartman Company problem. Solve the model to determine the optimal production quantities of products 1 and 2. Using the appropiate Excel format, estimate the optimal solution of this problem and report the value for product 1. 2. Based on question 1, use Excel Solver to find the optimal solution and report the value of product 2. 3. Based on question 1, use Excel Solver to find the optimal profit amount. 4. Attach the Excel file with your work