MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Distribution > Order Processing > Key Concepts and Procedures > Relief Codes and Balance Types > Example 1: Inventory Available for Manufacturing and Distribution; Scenario A

Example 1: Inventory Available for Manufacturing and Distribution; Scenario A

 

This scenario assumes that the value of the Sales Order Planning flag = Y (yes).

 



Balance Type




Code


On-
Hand Flag



Plan Flag



Dist
Flag

Qty at Mfg Warehouse
(Sales Order Planning flag = Y)

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 = 120 +30 = 150
Net Forecast against planned order:  150 netted against 170:  net demand = 170

Note:    003 is not included, since it is sourced from the distribution warehouse.  Planned/unplanned
flag is irrelevant.

Total requirements = Net demand + unplanned orders = 170+10 = 180
Scheduled for production = Total requirements - inventory available for planning = 180 - 150 = 30