L2 Sprint 3 3.3.6 Activity: Test the Shipping Cost Formulas

stephaniejlw
Contributor

L2 Sprint 3 3.3.6 Activity: Test the Shipping Cost Formulas

Hi,

I have been trying to test the shipping cost formulas and cannot seem to figure this out, and I've identified that other formulas are incorrect, too.  Could someone please review and help point me in the right direction?  I am attaching a screenshot of my BP view as well as data to show where my figures are not aligned with the example.  Any help is greatly appreciated.

 

Formulas I have used where there is variance:

Confirmed purchase order receipt: IF NOT Override Shipping Method? THEN 0 ELSE Shipping Costs - Final Shipment Amount

 

Shipping costs: Final Shipment Amount * 1000 / 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

 

Final shipping costs: Final Shipment Amount * 1000 / 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]

 

Shipping cost variance: IF NOT Override Shipping Method? THEN 0 ELSE Shipping Costs - Final Shipment Amount

1 ACCEPTED SOLUTION

Accepted Solutions
AdamCookson
Certified Master Anaplanner

Hi,

 

Unfortunately, I can't access the screenshots right now, but in regard to your formulas I believe they should look like this:

 

Confirmed Purchase Order Receipt: IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks) ELSE 0

 

Shipping costs: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping time (week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

 

Final Shipping costs: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping time (week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]

 

Shipping cost variance: IF NOT Override Shipping Method? THEN 0 ELSE Shipping Costs - Final Shipping Costs

 

I see we've a difference on the PO receipt, if you alter this are you able to reconcile the numbers?

 

Adam

View solution in original post

3 REPLIES 3
AdamCookson
Certified Master Anaplanner

Hi,

 

Unfortunately, I can't access the screenshots right now, but in regard to your formulas I believe they should look like this:

 

Confirmed Purchase Order Receipt: IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks) ELSE 0

 

Shipping costs: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping time (week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

 

Final Shipping costs: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping time (week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]

 

Shipping cost variance: IF NOT Override Shipping Method? THEN 0 ELSE Shipping Costs - Final Shipping Costs

 

I see we've a difference on the PO receipt, if you alter this are you able to reconcile the numbers?

 

Adam

stephaniejlw
Contributor

Thank you so much!  The formula update for the PO fixed it, along with removing my overrides from a previous lesson.  Thanks again!

AdamCookson
Certified Master Anaplanner

No worries, glad it helped