L2 Sprint 3 3.3.6 Activity: Test the Shipping Cost Formulas

stephaniejlw

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

3_152130.png

AdamCookson

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