Retail operations pack
Consolidates point-of-sale exports from every location and reports gross margin and productivity by store
How it works
-
Upload a completed operations pack
The consolidated sales table and the store scorecard distributed to regional managers
-
Add all source files
All regional POS exports, labor hours, returns and waste, and the store and product masters
-
Skipper learns the consolidation rules
How regional exports map to the standard layout, how SKUs match cost and price data, how returns reduce gross profit, and how waste affects operating contribution
-
Upload the new POS exports each month
Skipper consolidates the standard files, incorporates exports from newly opened stores, and updates the scorecard
Input files
- pos_export_austin_boston_202X-07.xlsx POS transactions for one group of stores
- pos_export_denver_chicago_202X-07.xlsx The equivalent export for the remaining stores, one file per region
- labor_hours_202X-07.xlsx Regular and overtime hours and labor costs by store and department
- returns_and_waste_202X-07.xlsx Refunds, damages, and waste by store and SKU
- store_master.xlsx Store name, region, format, and manager
- product_master.xlsx Category, unit cost, and standard price by SKU
Output workbook
retail_operations_pack_202X-07.xlsx
- Summary Chain-level net sales, gross margin, labor, and shrink
- Normalized Sales All point-of-sale exports consolidated into one table with store and product attributes
- Store Scorecard Net sales, gross profit, gross margin, sales per labor hour, waste cost, and operating contribution
- Checks Reconciliation of store totals to each point-of-sale export