Complete the MRP record for a bicycle frame using a L4L lot-sizing strategy. Repeat using a fixed order quantity of 102 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 fx70 Problem 14.12 \begin{tabular}{|l|c|c|c|c|c|c|c|c|} \hline MRP Record & \multicolumn{5}{|c|}{ Part Name: Bicycle Frame } \\ \hline Leadtime=2weeksOn-handinventory=Safetystock=0Orderquantity:L4L & & & & & & & & \\ \hline Wross requirements & 70 & 52 & 82 & 82 & 72 & 62 & 82 & 82 \\ \hline Scheduled receipts & & & & & & & & \\ \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 102 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 fx70 Problem 14.12 \begin{tabular}{|l|c|c|c|c|c|c|c|c|} \hline MRP Record & \multicolumn{5}{|c|}{ Part Name: Bicycle Frame } \\ \hline Leadtime=2weeksOn-handinventory=Safetystock=0Orderquantity:L4L & & & & & & & & \\ \hline Wross requirements & 70 & 52 & 82 & 82 & 72 & 62 & 82 & 82 \\ \hline Scheduled receipts & & & & & & & & \\ \hline Available inventory & & & & & & & & \\ \hline Net requirements & & & & & & & & \\ \hline Planned order receipts & & & & & & & & \\ \hline Planned order releases & & & & & & & & \\ \hline \end{tabular}