Highlighted
New Contributor

Level 2 Sprint 3 INV01 Inventory Ordering

@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?

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Level 2 Sprint 3 INV01 Inventory Ordering

@Jemsheed 

 

Review Safety Stock Target Value. I don't think the requirement is to bring week values. Also it would be great if you don't copy your exact formula on the community. Just rephrase it appropriately we should be able to help you if there are any technical issues

 

 

Highlighted
New Contributor

Re: Level 2 Sprint 3 INV01 Inventory Ordering

As Safety Stock is maintained in DAT04 Distribution Center Parameters and it has HALFYEAR as time scale, use a function similar to YEARVALUE to populate the half-yearly number in weeks in INV01 module.