The Kartick Company is trying to determine how much of each of two products to produce over the coming planning period. There are three departments, A, B, and C, with limited labor hours available in each department. Each product must be processed by each department and the per unit requirements for each product, labor hours available, and per-unit profit are as shown below. Labor required in each department Product (hours/unit) Department Labor Hours Available Product 1 Product 2 A 1.00 0.30 100 B 0.30 0.12 36 C 0.15 0.56 50 Profit Contribution $33.00 $24.00 A linear program for this situation is as follows. Let x, = the amount of product 1 to produce. Let x, = the amount of product 2 to produce. Maximize 33 x1 + 24 X2 s.t. 1.0 x, + 0.30 X, $ 100 Department A 0.30 x, + 0.12 X2 5 36 Department B 0.15 x, + 0.56 X2 5 50 Department C X1/ X2 20Mr. Kartick (the owner) used trial and error with a spreadsheet model to arrive at a solution. His proposed solution is x, = 75 and x, = 60, as shown in the figure. He said he felt his proposed solution is optima Consider the following tables a representation of an Excel spreadsheet. Kartick Data Prod 1 Prod 2 Hours Department Available A 1.00 0.30 100 B 0.30 0.12 36 C 0.15 0.56 50 Per unit Contribution $33.00 $24.00 Decisions Prod 1 Prod 2 Quantity 75 60 Model Department Hours Unused Used Hours A 93 7 B 29.7 6.3 C 44.85 5.15 Contribution $3,915.00Is his solution optimal? Without solving the problem, explain why you believe this solution is optimal or not optimal. '5) His solution is optimal, it results in a maximum prot contribution. Cl His solution is optimal, it results in a minimum number of unused hours. 0 His solution is optimal, it results in a maximum number of hours used. (3' His solution is not optimal, it results in more hours used than what is available. 0 His solution is not opb'mal, it results in unused hours, thus more products can still be made. It