Develop a MRP table to identify the planned order release using lot$-$for$-$lot replenishment.

b$.$ Revise the MRP table using a fixed order quantity of $80$ units.

c$.$ Due to unreliable supply, we now want to maintain a one$-$week safety lead time in addition to the $2$ weeks

of supplier$$s lead time. If we use lot$-$for$-$lot replenishment policy, would there be a problem? As a

production planner, how would you report a change notice or exception notice?

$($a$)$ Rules: Lot$-$for$-$Lot; Lead Time $=2$ weeks

Week $12345678910$

Demand $41648442848627184930$

Scheduled Receipt $2020$

On$-$hand: $120$

Net Demand

Planned Order Receipts

Planned Order Release

Report:

$($b$)$ Rules: Fixed Order Quantity $=80$ or Multiples of $80$; Lead Time $=2$ weeks

Week $12345678910$

Demand $41648442848627184930$

Scheduled Receipt $2020$

On$-$hand: $120$

Net Demand

Planned Order Receipts

Planned Order Release

Report:

$($c$)$ Rules: Lot$-$for$-$Lot; Lead Time $=2$ weeks; Safety Lead Time $=1$ week

Week $12345678910$

Demand $41648442848627184930$

Scheduled Receipt $2020$

On$-$hand: $120$

Net Demand

Planned Order Receipts

Planned Order Release

Report: