AutoSave OH PL Session 5 Class Problem (2) - Protected View File Home Search Insert Page Layout Formulas Data Review View O PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Help Enable Editing S8 1 x D G H I J K M N A B F 1 Session 5 2 Chapter 4 Class Problem 3 Problem 4.4 Given the following product tree, explode, offset, and calculate the gross and net requirements. All lead times are one week, and the quantities required are shown in parentheses. The MPS calls for completion of 50 Js in week 5. There is a scheduled receipt of 50 Ks in week 2. There are 100 Ls and 200 Ns on hand 5 6 ] 4 7 8 K (2) L (1) 9 10 M (2) N (3) 11 12 13 Week 3 1 2 14 4 5 15 16 17 18 Item Number Gross requirements Scheduled receipts J Projected available Net requirements Planned order receipt Planned order release Gross requirements Scheduled receipts K Projected available Innt raruticomonte Sheet1 Sheet2 Sheet3 19 20 21 22 Ready Type here to search O PROTECTED VIEW Be carefulfiles from the Internet can contain vineses. Unless you need to edit, it's safer to stay in Protected View Enable Editing S8 B G H 18 19 20 21 22 K 23 24 25 26 27 28 L 29 30 31 Planned order receipt Planned order release Gross requirements Scheduled receipts Projected available Net requirements Planned order receipt Planned order release Gross requirements Scheduled receipts Projected available Net requirements Planned order receipt Planned order release Gross requirements Scheduled receipts Projected available Net requirements Planned order receipt Planned order release Gross requirements Scheduled receipts Projected available Net requirements Planned order receipt Planned order release 2 3 1 M 5 N Sheet1 Sheet2 Sheet3