For the data in the table attached, please evaluate the cost of the plan given in the table if an in-house regular hour is 10$, overtime hour is 15$, and a contract man-hour costs 25. In addition, every backlog man-hour delayed from period t to t + 1 costs 5. Develop an alternative competitive plan in which you can have instead of 5 skilled employees have a mixture of skill and unskilled. The hour of unskilled worker is 8$.

7 8 9 12 11 , 29 Deterministic Approaches for Capacity Planning RM) OM CM, OM, 40 RM 10 10 10 150 40 20 Table 29 Sample data for heuristic tableau capacity planning Col. # 2 3 4 5 6 Period: FM B-1 TM TM TM, 1 150 100 250 150 100 2 200 50 250 150 100 3 250 50 300 150 4 180 100 280 180 100 5 200 80 280 200 80 6 150 80 230 120 110 7 200 30 230 150 80 8 250 30 280 150 130 9 200 80 280 150 130 10 300 80 380 200 180 11 250 70 320 210 110 12 200 260 200 60 - 20 40 150 150 150 160 100 120 150 150 150 160 160 160 $$$$$$$$ 40 40 40 10 10 10 110 40 40 40 10 10 7 8 9 12 11 , 29 Deterministic Approaches for Capacity Planning RM) OM CM, OM, 40 RM 10 10 10 150 40 20 Table 29 Sample data for heuristic tableau capacity planning Col. # 2 3 4 5 6 Period: FM B-1 TM TM TM, 1 150 100 250 150 100 2 200 50 250 150 100 3 250 50 300 150 4 180 100 280 180 100 5 200 80 280 200 80 6 150 80 230 120 110 7 200 30 230 150 80 8 250 30 280 150 130 9 200 80 280 150 130 10 300 80 380 200 180 11 250 70 320 210 110 12 200 260 200 60 - 20 40 150 150 150 160 100 120 150 150 150 160 160 160 $$$$$$$$ 40 40 40 10 10 10 110 40 40 40 10 10