Question 1 (30 Points) a) The production manager of a manufacturing facility that produces semiconductor wafers is intended to perform the aggregate planning for the next four months. The table below includes the demanded quantities of the aggregate product (in units) in addition to the in-house regular capacity for the mentioned periods. Demand of Maintenance Regular time aggregate Planning period product capacity (units) (units) 350 Month 2 400 280 Month 3 340 360 Month 4 325 350 Month 1 650 An additional overtime capacity can be utilized such that it could contribute in work by 30% of the regular capacity in each month. Also, a third-party (subcontractor) can provide the product through a contract of purchasing 120 units-capacity in each of the four months. Regarding the resource cost, the costs are constant in each of the four months as follows: In-house regular unit cost is SR100 with a 50% increase for the overtime production. Subcontracting cost is 180 SR/unit. Inventory cost is 20 SR/unit/month, and the backordering is not permitted. 1) Set up the transportation table for the aggregate planning problem. (4 points) 2) Find the transportation solution for the problem. (8 points) 3) Calculate the total cost of the resultant plan in Part 2), (3 points)