4.5. Given the following product tree, explode, offset, and determine the gross and net requirements. All lead times are 1 week, and the quantities required are shown in parentheses. The master production schedule calls for 100 As to be available in week 5. There are 20 Bs available. All other on-hand balances =0. Excel File Edit View Insert Format Tools Data Window Help Problem Set 03 Home Insert Draw Page Layout Formulas Data Review View @ Tell me 4.6. Complete the following table. Lead time for the part is 2 weeks. The lot size is 100 . What is the projected available at the 41 end of week 3 ? When is it planned to release an order? \begin{tabular}{|l|} \hline 42 \\ \hline 43 \\ \hline 44 \\ \hline 45 \\ \hline 46 \\ \hline 47 \\ \hline 48 \\ \hline 49 \\ \hline 50 \\ \hline 51 \\ \hline \end{tabular} 4.8. Given the following partial product tree, explode, offset, and determine the gross and net requirements for components H,I,J, and K. There are other components, but they are not connected to this problem. The quantities required are shown in parentheses. The master production schedule calls for the completion of 60Hs in week 3 and 80 in week 5 . There is a scheduled receipt of 120 Is in week 2. There are 400Js and 400Ks available. All lot sizes are lot-for lot. 52 53 54 55 56 57 58 Ready Accessibility: Investigate 4.5. Given the following product tree, explode, offset, and determine the gross and net requirements. All lead times are 1 week, and the quantities required are shown in parentheses. The master production schedule calls for 100 As to be available in week 5. There are 20 Bs available. All other on-hand balances =0. Excel File Edit View Insert Format Tools Data Window Help Problem Set 03 Home Insert Draw Page Layout Formulas Data Review View @ Tell me 4.6. Complete the following table. Lead time for the part is 2 weeks. The lot size is 100 . What is the projected available at the 41 end of week 3 ? When is it planned to release an order? \begin{tabular}{|l|} \hline 42 \\ \hline 43 \\ \hline 44 \\ \hline 45 \\ \hline 46 \\ \hline 47 \\ \hline 48 \\ \hline 49 \\ \hline 50 \\ \hline 51 \\ \hline \end{tabular} 4.8. Given the following partial product tree, explode, offset, and determine the gross and net requirements for components H,I,J, and K. There are other components, but they are not connected to this problem. The quantities required are shown in parentheses. The master production schedule calls for the completion of 60Hs in week 3 and 80 in week 5 . There is a scheduled receipt of 120 Is in week 2. There are 400Js and 400Ks available. All lot sizes are lot-for lot. 52 53 54 55 56 57 58 Ready Accessibility: Investigate