Work Center Model A Model B 10 2.4 3.5 The master production schedule for the next 5 weeks is Week 1 2 3 4 5 Model A 70 50 50 60 48 Model B 20 40 55 30 45 a. Using the resource bill and the master production schedule, calculate the number of hours required in work center 10 for each of the 5 weeks. Use the following table to record the required capacity on the work center. a. Using the resource bill and the master production schedule, calculate the number of hours required in work center 10 for each of the 5 weeks. Use the following table to record the required capacity on the work center. Week 1 2 3 4 3 Model A Model B Total Hours Answer. The total hours required are as follows: week 1, 238; week 2, 260; week 3, 313; week 4, 249; and week 5, 273. b. If the available capacity at work station 10 is 260 hours per week, suggest possible ways of meeting the demand in week 3. 3.10. Using the scheduled receipts, calculate the ATP. There are 45 units on hand. Week 1 2 3 4 5 6 7 8 Customer Orders 45 50 35 40 30 40 20 18 MPS 100 100 100 100 ATP 3.14. Given the following data, calculate the projected available balance and the planned MPS receipts. The lot size is 200. The demand time fence is 2 weeks. Week 1 2 3 4 Forecast 80 80 80 70 100 Customer Orders 90 50 40 Projected Available Balance 140 MPS Answer. There is a planned MPS receipt in week 2. 5.1. A work center consists of 4 machines each working a 16-hour day for 5 days a week. What is the weekly available time? Answer. 320 hours per week 5.2. The work center in problem 5.1 is utilized 75% of the time. What are the hours per week actually worked? 5.3. If the efficiency of the work center in problem 5.1 is 120%, what is the rated capacity of the work center? Answer. 288 standard hours per week 5.6. Over a period of 4 weeks, a work center produced 50, 45, 40, and 55 standard hours of work. What is the demonstrated capacity of the work center? Answer. 47.5 standard hours of work per week