Business analysis assignment
The following time-phasing chart is available for a single item within a MRP system. Complete this chart by estimating inventory on hand and planned order release values. Lead time is 2 weeks and order policy is 100 units, which means this part can be ordered only in 100-unit batches. Inventory replenishment is JIT, lead times are negligible.
|
Week Number
|
1
|
2.
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
|
Gross Requirements
|
|
|
80
|
95
|
|
110
|
|
|
50
|
|
|
|
Scheduled Receipt
|
100
|
|
|
|
|
|
|
|
|
|
|
|
Inventory on Hand
|
|
|
|
|
|
|
|
|
|
|
|
|
Planned Order
Release
|
|
|
|
|
|
|
|
|
|
|
|