Calculations for Rebalancing Item Quantity Allocated to Production and WIP

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.