Excel Planning Project
Budget: $15 – $25 USD
Provide a 14 day rolling calendar outlook, realizing that the best view will always be the next 7 days but trying to identify ‘problem children’ as early as possible
- Highlight volume constraints at both a load out point and overall location – in this case, Decatur
- Provide a view into where overages are coming from against contracted norms
- Highlight non-optimized freight and impacts
- Highlight shortfalls in station replenishment driven by over pulling truck customers
I’m picturing 3 parts to the dashboard at this point.
14 day rolling outlook, with weekends highlighted in a different color. Cells conditionally formatted to trigger at the Plant Total for anything above a certain number Would be ideal if you could double click the number to get a break out of what orders make up that day. Second part of the dashboard would be the Customer volume vs Contracted Rates. Weekly buckets of orders vs contracted volumes, highlights anything over contracted volumes as RED (could set this with a tolerance factor, say 10%). Highlight any customer volume Yellow if there location is not normally contracted for truck volume – highlight any volume.
- Highlight volume constraints at both a load out point and overall location – in this case, Decatur
- Provide a view into where overages are coming from against contracted norms
- Highlight non-optimized freight and impacts
- Highlight shortfalls in station replenishment driven by over pulling truck customers
I’m picturing 3 parts to the dashboard at this point.
14 day rolling outlook, with weekends highlighted in a different color. Cells conditionally formatted to trigger at the Plant Total for anything above a certain number Would be ideal if you could double click the number to get a break out of what orders make up that day. Second part of the dashboard would be the Customer volume vs Contracted Rates. Weekly buckets of orders vs contracted volumes, highlights anything over contracted volumes as RED (could set this with a tolerance factor, say 10%). Highlight any customer volume Yellow if there location is not normally contracted for truck volume – highlight any volume.