Hello, can you please provide a step-by-step detail and solution in Excel for the question below:

2. 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 protability: Product (hours/unit) Labor-Hours Department 1 2 Available A 1.00 0.35 100 B 0.30 0.20 36 C 0.20 0.50 50 Prot contribution/unit $30.00 $15 .00 a. Develop a linear programming model of the Hartman Company problem. Solve the Problems model to determine the optimal production quantities of products 1 and 2. 395 In computing the prot contribution per unit, management doesn't deduct labor costs because they are considered xed for the upcoming planning period. However, sup- pose that overtime can be scheduled in some of the departments. Which departments would you recommend scheduling for overtime? How much would you be willing to pay per hour of overtime in each department? Suppose that 10, 6, and 8 hours of overtime may be scheduled in departments A, B, and C, respectively. The cost per hour of overtime is $18 in department A, $22.50 in department B, and $12 in department C. Formulate a linear programming model that can be used to determine the optimal production quantities if overtime is made avail- able. What are the optimal production quantities, and what is the revised total contri- bution to profit? How much overtime do you reconunend using in each department? What is the increase in the total contribution to prot if overtime is used