Problem $14-12($Static$)$

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

$\backslash$table$[[$Part Name: Bicycle frame$],[$Lead time $=2$ weeks$],[$On$-$hand $=0$

Problem $14-12($Static$)$

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

$\backslash$table$[[$Part Name: Bicycle frame$],[$Lead time $=2$ weeks$],[$On$-$hand $=0$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.$)$

RoictureClick here for the Excel Data File

$\backslash$table$[[$Part Name: Bicycle frame$],[$MRP Record,,,,,,,,$],[$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,$70,50,80,80,70,60,80,80],[$Scheduled receipts,$70,50,0,0,0,0,0,0],[$Available inventory,,

$,,,,,,],[$Net requirements,,,,,,,,$],[$Planned order receipts,,,,,,,,$],[$Planned order releases,,,,,,,,$]]$