Operations Planning and Control 1- Read the material on d21: Master Scheduling & Capacity Management. Answer the following questions using excel spreadsheet. 2- Post your answers as Excel spreadsheet to Assignment 1 Dropbox. Write your name on the answer sheet. Production Plan Quarter 2 3 Total Forecast Sales 220 300 200 200 Projected Available Balance 270 Production Plan Answer. Quarterly production = 200 units The forecast sales for each of the mailboxes in the family also follow. Develop an MPS for each item, bearing in mind that production is to be leveled as in the produc- tion plan. For each mailbox, the lot size is 200. Mailbox A. Lot size: 200 Quarter 1 2 3 4 Total Forecast Sales 120 180 100 120 Projected Available Balance 120 MPS Answer. Scheduled receipts in quarters 2 and 3 Mailbox B. Lot size: 200 Quarter 1 2 3 4 Total Forecast Sales 100 120 100 80 Projected Available Balance 150 MPS Answer. Scheduled receipts in quarters 1 and 4