L2 Sprint 3 3.3.6 Activity: Test the Shipping Cost Formulas

stephaniejlw
stephaniejlw
edited November 2022 in

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

Best Answer

  • AdamCookson
    AdamCookson
    edited November 2022 Answer ✓

    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

Answers

  • stephaniejlw
    stephaniejlw
    edited November 2022

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

  • AdamCookson
    AdamCookson
    edited November 2022

    No worries, glad it helped

Categories