Data Formulas View Help Home Insert Review Page Layout File Tell me what you want to do Calibri A A ab Wrap Text General . Paste X Cut Copy Format Painter Clipboard BIU. A Merge & Center - $ . % ) 00 Font Alignment Number 08 f K A B D F G H 3.4. 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. Opening inventory is 2000 dozen, 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 follow. The lot size for both model is 1000 dozen. Calculate the production plan and the MPS for 1 each item. 2 Ending inventory 4000 3 Lot size 1000 4 Total production 5 Weekly production 6 Week 1 2 3 4 Total 7 Forecast 3000 3500 3500 4000 14000 Projected Available 8 Balance 2000 9 Production Plan 10 11 Model A 12 Week 1 2 3 4 Total 13 Forecast 2000 2000 2500 2000 8500 Projected Available 14 Balance 1500 15 Production Plan 16 17 Model B 18 Week 1 2 3 4 Total 19 Forecast 1000 1500 2000 5500 Projected Available 20 Balance 500 21 Production Plan Ca expressed in function 22 23 3.7. Calculate the available to bromise usine the followine data. There are 90 units on hand. Chapter 3 Chapter 4 1000 Type here to search Esc F2 F3 55