Documentation >
MAC-PAC Reference Library >
Distribution >
Order Processing >
Key Concepts and Procedures >
Relief Codes and Balance Types >
Example 2: Inventory Available for Manufacturing and Distribution; Scenario B
Example 2: Inventory Available for Manufacturing and Distribution; Scenario B
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
|
Y
|
Y
|
100
|
30
|
25
|
Forecast = 150
|
|
|
|
Manufacturing Warehouse
|
100 + 20 = 120
|
100
|
Totals in types avail for mfg and dist.
|
Distribution Warehouse #1
|
30
|
30
|
Mfg inventory at distribution warehouse is always "invisible" for planning
|
Distribution Warehouse #2
|
NA
|
25
|
Inventory cannot be used for mfg since 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 + Available for Distribution at Whs #1 - Reserved
= 120 + 30 - 100 = 50
Net Forecast against planned order: 150 netted against 0 (since Sales Order Planning flag = N): net = 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- 150 = 10