The first workbook contained Altria’s annual enterprise transportation spend and logistics spend from manufacturing sites to public warehouses.
Five different dashboards allowed for segmentation by date, carriers, OpCo, cost center general ledger and category.
Other dashboards displayed the STO data to identify the spend, volume and average shipment for each carrier and lane with adjustable time range for transportation from manufacturing plants to public warehouses.
The second workbook included Altria’s spending on deliveries from public warehouses to customers, and incorporates KPI’s such as total shipment count, cost/mile, cost/ton-mile, number of cases, cost/lb, shipment cost, total weight, on-time delivery percentage, and delivery frequency.
Within this workbook, the dashboards grouped customers, carriers and public warehouses by geographic region and lane with adjustable time range, carrier type, carrier name, customer type and customer ID.