Complete the MRP record for a bicycle frame using a L4L lot-sizing strategy. Repeat using a fixed order quantity of 100 frames. Compare and contrast the results. What are the benefits and drawbacks to each approach? Note that scheduled receipts exist in Week 1 and Week 2 as shown in the answer table below. (Leave no cells blank - be certain to enter "0" wherever required.) pictureClick here for the Excel Data File \begin{tabular}{|l|r|r|r|r|r|r|r|r|} \hline Order quantity: L4L & Week 1 & Week 2 & Week 3 & Week 4 & Week 5 & Week 6 & Week 7 & Week 8 \\ \hline Gross requirements & 70 & 50 & 80 & 80 & 70 & 60 & 80 & 80 \\ \hline Scheduled receipts & 70 & 50 & 0 & 0 & 0 & 0 & 0 & 0 \\ \hline Available inventory & & & & & & & & \\ \hline Net requirements & & & & & & & \\ \hline Planned order receipts & & & & & & & \\ \hline Planned order releases & & & & & & & \\ \hline \end{tabular} Complete the MRP record for a bicycle frame using a L4L lot-sizing strategy. Repeat using a fixed order quantity of 100 frames. Compare and contrast the results. What are the benefits and drawbacks to each approach? Note that scheduled receipts exist in Week 1 and Week 2 as shown in the answer table below. (Leave no cells blank - be certain to enter "0" wherever required.) pictureClick here for the Excel Data File \begin{tabular}{|l|r|r|r|r|r|r|r|r|} \hline Order quantity: L4L & Week 1 & Week 2 & Week 3 & Week 4 & Week 5 & Week 6 & Week 7 & Week 8 \\ \hline Gross requirements & 70 & 50 & 80 & 80 & 70 & 60 & 80 & 80 \\ \hline Scheduled receipts & 70 & 50 & 0 & 0 & 0 & 0 & 0 & 0 \\ \hline Available inventory & & & & & & & & \\ \hline Net requirements & & & & & & & \\ \hline Planned order receipts & & & & & & & \\ \hline Planned order releases & & & & & & & \\ \hline \end{tabular}