1. Worldwide Can- openers Inc makes a family of two hand operated can openers. The production plan is based on months. There are 4 weeks in this month. The opening inventory is 2000 dozens and it is planned to increase that to 4000 dozen by the end of the month. The MPS is made using weekly periods. The forecast and projected available balance for the two models follows. The batch size for both Models is 1000 dozen. Calculate the production plan and the MPS for each Item. 4 Total Week Sales Forecast PAB (2000) Production Plan 1 3000 2 3500 3 3500 2 Marks (Show all calculations or use the excel sheet provided with formulae) The Sales forecast for the individual Models is provided given the lot size is 1000 units. Model A: Lot Size: 1000 Week Sales Forecast PAB (1500) MPS 4000 1 2 3 4 Total 2000 2000 2500 2000 (4 marks)(Show all calculations or use the excel sheet provided with formulae) del B: Lot Size:1000