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

3 REPLIES 3
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?

Contributor

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

Certified Master Anaplanner