3.3.4 Activity:Shipping Time (Weeks) Convert yearly shipping times value to weekly value
What am I doing wrong?
Check Your Work: In the INV01 Inventory Ordering module, what is the Shipping Time Weeks for Cookie Crumbs_EN in Week 1 FY20?
The correct answer is 4 but I am getting 2.
The Data Hub DAT02 Shipping Metrics has the following values: Air =1, Rail = 4, Road = 2, and Ship = 8
I have run the import process again but it doesn’t change the values.
The Supply Chain Module, TRA01 Shipping Metrics by Week has the following values: Air = 1,Rail = 2, Road = 2, Ship = 7
Road and Ship are INCORRECT for some reason.
Why don’t Rail and Ship match what’s in the DAT02 Shipping Metrics?
I would also assume that the COST per 1000 Units is incorrect as well but have no idea why?
The SYS08 SKU Details shows that Cookie Crumbs_EN are supplied by Toronto
The SY07 Distribution Center Details shows that Toronto’s Default Shipping Method is by RAIL
Answers
-
@JMarshall All your modules looks fine except DAT02 Shipping Metrics .There is some data mismatch in that module.
Shipping Time
Cost
Air
1
100
Rail
4
30
Road
2
65
Ship
8
10
I think this will solve your issue.
1 -
My DAT 02 matches your screenshot, so I don't think that is the issue:
0 -
Only the Rail and Ship are wrong. It's the same formula for Shipping Time:
YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)')
and Cost:
YEARVALUE('DAT02 Shipping Metrics'.'Cost per 1000 Units')
COST is correct and matches the Dat02 Data Metrics.
0 -
Found my error.
0
