Week Demand Inventory Level Planned Order Receipt Planned Order Release Holding Cost Ordering Cost Total Cost

$110050100100250200450$

$21002001002005000500$

$3250150250250375200575$

$4250-250-0200200$

Table B: Fixed Order Quantity $($FOQ$)$ of $200$

Orders are placed for a fixed quantity of $200$ items every other week $($lead time is $2$ weeks$).$

Week Demand Inventory Level Planned Order Receipt Planned Order Release Holding Cost Ordering Cost Total Cost

$110050220-2500250$

$2150100-1005000500$

$325060250-3000300$

$45070-701750175$

$5250250250-125001250$

Table C: Fixed Order Period $($FOP$)$ of $3$ weeks

Orders are placed every $3$ weeks, regardless of demand, for enough quantity to cover the demand for the next $3$ weeks.

Week Demand Inventory Level Planned Order Receipt Planned Order Release Holding Cost Ordering Cost Total Cost

$1100-100-0200200$

$250120-503000300$

$370120-703500350$

$41201501501207500750$

$5300-300-0200200$

Export to Sheets

Table D: Lot Size of $50$ items

Orders are placed for a fixed quantity of $50$ items, with a lead time of $2$ weeks.

Week Demand Inventory Level Planned Order Receipt Planned Order Release Holding Cost Ordering Cost Total Cost

$1180100100100500200700$

$217070120703500350$

$31201001201005000500$

$4100250-250125001250$

$5400-400-0200200$