Calculations for Rebalancing Item Quantity Allocated to Production and WIP
The utility uses these calculations:
Qty WIP Calculation
For each job that has a status of Released or Stopped, or production schedule with a status of Released, this utility increments the item's quantity WIP by the difference between the job/production schedule's quantity released and the quantity complete.
IQW = JQR - JQC
IQW = Item Qty WIP
JQR = Job/PS Qty Released
JQC = Job/PS Qty Complete
Allocated to Prod Calculations
For each corresponding job/production schedule material or project resource with a type that is not Other, this utility increments the appropriate item's Allocated to Prod field as shown below:
For Jobs:
- Job Material Per Lot/Per Unit field = Unit: Allocated
to Prod field is incremented by quantity released multiplied
by material quantity minus quantity issued.
IQAP = (JQR * JMMQ) - JMQI
IQAP = Item Qty Allocated to Prod
JQR = Job Qty Released
JMMQ= Job Material Matl Qty
JMQI = Job Material Qty Issued
- Job Material Per Lot/Per Unit field = Lot AND the Job's Qty Released
> 0: Allocated to Prod field is
incremented by the difference between the material quantity and quantity
issued.
IQAP = JMMQ - JMQI
IQAP = Item Qty Allocated to Prod
JMMQ= Job Material Matl Qty
JMQI = Job Material Qty Issued
For Production Schedules:
- Production Schedule Material Per Lot/Per Unit field = Unit: Allocated to Prod field is incremented by
the (quantity released) - (operation quantity complete * material
quantity).
IQAP = (PSQR - OQC) * PSMMQ
IQAP = Item Qty Allocated to Prod
PSQR = Production Schedule Quantity Released
PSMMQ = Production Schedule Material Matl Qty
OQC = Operation Quantity Complete
- Production Schedule Material Per Lot/Per Unit field = Lot, AND the Production Schedule's Qty Released > 0: Allocated to Prod field is incremented by the material quantity.