Planning excel
Budget: $30 – $250 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
- 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
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
Each load out area (like building 44, would also have a max number). We could also set a different trigger for weekends. Would be ideal if you could double click the number to get a break out of what orders make up that day.
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
- 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
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
Each load out area (like building 44, would also have a max number). We could also set a different trigger for weekends. Would be ideal if you could double click the number to get a break out of what orders make up that day.
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.