3. (15 points) A company that makes home standby generators wants to prepare a master production schedule for May, June, and July. Marketing has forecasted demand of 120 generators for May, 100 generators for June, and 160 generators for July. These have been evenly distributed over the four weeks in each month. There are customer orders that have been committed (booked) and must be filled as shown in the table below. 1 May 2 3 June July 4 1 2 3 4 1 2 3 4 Forecast Customer Orders 37 22 9 33 11 39 3 9 8 5 17 Projected on hand inventory MPS Available to promise There are currently 53 generators on hand. Use the MPS rule of scheduling production when the projected on-hand inventory would be negative without production and use a lot size of 80.