Documentation >
MAC-PAC Reference Library >
Distribution >
Order Processing >
Key Concepts and Procedures >
Relief Codes and Balance Types >
Example 3: Manufacturing & Planning Inventory Separate
Example 3: Manufacturing & Planning Inventory Separate
This scenario assumes that the value of the Sales Order Planning flag = N (no).
|
|
|
|
|
|
Qty at Mfg Warehouse
(Sales Order Planning flag = N)
|
Qty at Dist Warehouse #1 (Available for Planning = Y)
|
Qty at Dist Warehouse # 2 (Available for Planning = N)
|
|
On-Hand
|
H
|
Y
|
Y
|
N
|
20
|
60
|
50
|
|
In Transit
|
T
|
N
|
N
|
N
|
0
|
0
|
0
|
|
Quarantine
|
Q
|
N
|
N
|
N
|
0
|
0
|
0
|
|
Distribution
|
D
|
N
|
N
|
Y
|
100
|
30
|
25
|
Forecast = 150
|
|
|
|
|
|
Manufacturing Warehouse
|
20
|
100
|
Totals in types avail for mfg and dist.
|
|
Distribution Warehouse #1
|
30
|
30
|
Although Planning flag is N, Avail for Planning = Y, so distribution inventory is counted
|
|
Distribution Warehouse #2
|
NA
|
25
|
Avail for Planning flag = N
|
|
|
|
|
|
|
|
|
|
|
001
|
Y
|
D
|
Mfg Whs
|
170
|
100
|
70
|
0
|
|
|
002
|
N
|
M
|
Mfg Whs
|
10
|
0
|
0
|
10
|
|
|
003
|
NA
|
D
|
Dist #2
|
20
|
20
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Master Scheduling:
Available for Planning = Avail at Mfg Warehouse + Avail at Distrib Warehouse #1 = 20 + 30 = 50
Net Forecast against planned order: 150 netted against 0 (Sales Order Planning flag = N): net demand = 150
Note: 001 not included, since Sales Order Planning flag = N.
002 not included because not a planned order.
003 not included because sourced from distribution warehouse.
Total requirements = Net demand + unplanned orders = 150+10 = 160
Scheduled for production = Total requirements - inventory available for planning = 160 - 50 = 110