3. Consider a company having the following expected demand and the orders for its one of the end items. Assume that the beginning inventory of this end item is 110 units. Company is planning to have 200 units inventory at the end of week 8 and at least 30 units inventory at the end of each week. Assume that the end item is produced in lots of 300 (or multiples of 300) units, and each unit produced can be sold to the customers or used as a service part in the maintenance-repair. 1 2 3 Weeks 4 5 6 7 8 Customer forecast 150 100 120 100 150 80 70 60 Service forecast 80 110 90 60 80 140 240 100 International orders 30 90 40 80 70 120 60 40 Warehouse orders 180 180 180 180 (a) Develop an MPS, and calculate the projected-on-hand (POH) quantities. (b) Calculate the available-to-promise (ATP) using the discrete (period-by-period) method, the cumulative without look-ahead method, and the cumulative with look-ahead method. (c) Consider the following bill of labor at critical work centers of this company. Work Center End Item Bill of Labor (hours per unit) WC 1 5.5 WC 2 7.2 WC 3 WC 4 10.2 8.1 Using the bill of labor approach, determine the number of hours required in the work centers for each week. (d) Assume that for this end item the work at WC 1 must be done one week prior to the work at WC 2 and WC 4, the work at WC 2 must be done one week prior to the work at WC 3. Create the appropriate resource profile and the rough cut capacity plan that would result