Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  1. Daily Sales Report: Today vs Same Day Last YearLabFree
  2. Sales per Labour Hour: Is the Rota Right?Lab Locked
  3. Staff Schedule: Hours and Wage Cost vs BudgetLab Locked
  4. Footfall, Conversion Rate and Average BasketLab Locked
  5. Items per Transaction: UPT by Team MemberLab Locked
  6. Markdowns: Sale Price, Margin and the Cost of a DiscountLab Locked
  7. Stock Count: Variances and Shrinkage %Lab Locked
  8. Sell-Through Rate: Which Seasonal Lines to Mark DownLab Locked
  9. Weeks of Cover: Reorder or Overstocked?Lab Locked
  10. Top and Bottom Sellers: Rank, Share and a Bar ChartLab Locked
  11. Cash Drawer Reconciliation: Count, Over/Short and BankingLab Locked
  12. Weekly Store Dashboard: Trend Chart and HighlightsLab Locked
  13. Staffing by the Hour: Footfall per Hour, Staff Needed and Gaps in the RotaLab Locked
  14. Forecasting Next Week: Last Year × Trend and the Hours the Forecast EarnsLab Locked
  15. Returns: Return Rate by Department, Write-Off Cost and the Reasons Behind ThemLab Locked
  16. Ordering to Cover: Units Needed, Whole Case Packs and the Order ValueLab Locked
  17. Four-Wall Profit: Store Contribution, Break-Even Sales and the Occupancy RatioLab Locked
  18. Tills at the Peak: Service Time, Till Capacity per Hour and Hours with Queue RiskLab Locked
  19. Click & Collect: Minutes to Ready, the On-Time Promise and Uncollected OrdersLab Locked
  20. Final Project: The Monthly Store Review – Plan, Conversion, SPLH, Wage % and a Status per WeekLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy