MAC-PAC Homecontact ussupport login 
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).

 



Balance Type




Code


On-
Hand Flag



Plan Flag



Dist Flag

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

 

Available Quantity

Manufacturing

Distribution

 

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

 

 

Sales Order


Planned?


Relief Cde


Warehouse


Order Qty

Reserv
Qty

Backord Qty


Alloc Qty

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