Complete the MRP record for a blcycle frame using a L$4$L lot$-$sizing strategy. Repeat using a fixed order quantity of $104$ frames. Compare and contrast the results. What are the benefits and drawbacks to each approach? Note that scheduled recelpts exist In Week $1$ and Week $2$ as shown in the answer table below.

Note: Leave no cells blank $-$ be certaln to enter $"0"$ wherever required.

Click here for the Excel Data File

MRP Record Part Name: Bicycle frame

Lead time $=2$ weeks On$-$hand $=0$ Safety stock $=0$ Order quantity: L$4$L

Week $1$ Week $2$ Week $3$ Week $4$ Week $5$ Week $6$ Week $7$ Week $8$ Gross requirements $7054848474648484$ Scheduled receipts $7054000000$ Available inventory Net requirements Planned order receipts Planned order releases

MRP Record Part Name: Bicycle frame

Lead time $=2$ weeks On$-$hand $=0$ Safety stock $=0$ Order quantity: FOQ $=104$

Week $1$ Week $2$ Week $3$ Week $4$ Week $5$ Week $6$ Week $7$ Week $8$ Gross requirements $7054848474648484$ Scheduled receipts $104104000000$ Available inventory Net requirements Planned order receipts Planned order releases