About Jemsheed

@Misbah  1. Shipping Costs = Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] Is there any problem with this formula?   2. Safety stock Target = WEEKVALUE('DAT04 Distribution Center Parameters'.Weekly Safety Stock) Safety Stock Exception Count = IF Ending Inventory < Safety Stock Target THEN 1 ELSE 0 I am getting '0' as values for safety stock target. Anything I have got to correct here? ... View more

@Misbah  Shipping Costs = 'INV01 Inventory Ordering'.Final Shipping Costs[SUM: 'SYS08 SKU Details'.Distribution Center] This formula for the shipping costs line item is giving me '0' as values. Is it because the formulae I have entered is wrong? ... View more

@Misbah  Could you tell me what I am doing wrong in this formula. Demand = 'DEM03 Demand Forecast'.Final Forecast[LOOKUP: 'SYS08 SKU Details'.Product] ... View more

Could someone please tell me what I am doing wrong with these formulas. @Misbah  1. Beginning Inventory =  IF 'SYS01 Time Settings By Week'.'1st Week of Timescale?' THEN 'DAT01 Beginning Inventory'.Beginning Inventory ELSE PREVIOUS(Ending Inventory) 2. Submit Purchase Order Request= OFFSET(PO Submitted, Shipping Time Weeks, 1) = 1 3. PO Submitted = IF Submit Purchase Order Request THEN 1 ELSE 0 4. Confirmed PO Delivery= IF PO Submitted > 0 THEN OFFSET(PO Submitted, Final Shipping Time Weeks, -1) ELSE 0 5. Confirmed Purchase Order Receipt= IF Confirmed PO Delivery > 0 THEN OFFSET(Final Shipment Amount, -Final Shipping Time Weeks, 0) ELSE 0 6.Shipping Time Weeks= 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product] ... View more

Could someone help me with the formulas for these line items. 1.Distribution Center Capacity 2. Percentage full ... View more