Excel for Retail Store Managers: Daily Sales, Staffing, Stock & Shrink
20 hands-on labs for store managers and assistant managers of one gift and homeware store: sales vs last year, sales per labour hour, rota vs budget, conversion and basket, UPT, markdowns, stock counts and shrink, sell-through, weeks of cover, top sellers, cash-up and a weekly dashboard, then staffing by the hour, next week's forecast, returns, ordering in case packs, four-wall profit, tills at the peak, click & collect and a monthly store review.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course follows the manager of one fictional gift and homeware store through 20 hands-on spreadsheet labs. You compare daily sales with the same day last year, calculate sales per labour hour, check the rota against the hours budget, turn footfall into conversion and average basket, read units per transaction, price markdowns, value stock-count variances and shrink, measure sell-through and weeks of cover, rank top sellers, reconcile the cash drawer and build a weekly dashboard. Part two adds staffing by the hour, a day-by-day sales forecast with the hours it earns, return rates and write-offs, orders rounded to whole case packs, four-wall profit and break-even sales, till capacity at the December peak, click & collect promises and uncollected orders, and a monthly store review with a status per week. Every cell is checked instantly.
Lessons
- Daily Sales Report: Today vs Same Day Last YearFree
- Sales per Labour Hour: Is the Rota Right? Locked
- Staff Schedule: Hours and Wage Cost vs Budget Locked
- Footfall, Conversion Rate and Average Basket Locked
- Items per Transaction: UPT by Team Member Locked
- Markdowns: Sale Price, Margin and the Cost of a Discount Locked
- Stock Count: Variances and Shrinkage % Locked
- Sell-Through Rate: Which Seasonal Lines to Mark Down Locked
- Weeks of Cover: Reorder or Overstocked? Locked
- Top and Bottom Sellers: Rank, Share and a Bar Chart Locked
- Cash Drawer Reconciliation: Count, Over/Short and Banking Locked
- Weekly Store Dashboard: Trend Chart and Highlights Locked
- Staffing by the Hour: Footfall per Hour, Staff Needed and Gaps in the Rota Locked
- Forecasting Next Week: Last Year × Trend and the Hours the Forecast Earns Locked
- Returns: Return Rate by Department, Write-Off Cost and the Reasons Behind Them Locked
- Ordering to Cover: Units Needed, Whole Case Packs and the Order Value Locked
- Four-Wall Profit: Store Contribution, Break-Even Sales and the Occupancy Ratio Locked
- Tills at the Peak: Service Time, Till Capacity per Hour and Hours with Queue Risk Locked
- Click & Collect: Minutes to Ready, the On-Time Promise and Uncollected Orders Locked
- Final Project: The Monthly Store Review – Plan, Conversion, SPLH, Wage % and a Status per Week Locked
Learner reviews
Be the first to review this course.