Assistant Store Manager Schedule Template: Opens, Mids and Closes
Most retail stores run their leadership team on three shift types: an open, a mid and a close. Each ASM or department manager works five days, one of those shifts per day, and the store needs at least one key carrier on every open and every close. That is the whole structure. The hard part is filling it in for a month without anyone getting a raw deal. Here is the template, and more importantly, the rules that make it work.
The basic layout
A manager schedule is a grid: managers down the left, days of the month across the top, one shift code per cell. Keep the codes short so the month fits on one page.
- O for open (typically an hour before doors until mid-afternoon)
- M for mid (late morning until early evening, covers the lunch and after-school rush)
- C for close (afternoon until after the registers are counted)
- X for a scheduled day off
- PTO for approved time off, so it is not confused with a regular day off
Below the grid, add two summary rows per manager: total closes this month and total weekend closes this month. Those two numbers are what your team will actually look at.
Constraints the template needs to enforce
A blank grid is only useful if you know the rules for filling it in. These are the ones most stores land on.
- Every manager works exactly five days a week. No six-day weeks to cover a gap unless the manager volunteers.
- No more than five consecutive working days, even across a week boundary.
- At least one key carrier on every open and every close, every day the store is open.
- No close followed by an open the next morning.
- A ceiling on mids plus closes per person per week, usually three.
- Weekend closes rotate so that over a quarter, every manager has roughly the same count.
- Truck days, inventory and other fixed events get a specific manager locked in before anything else is assigned.
Key takeaway
The template is the easy part. The rules are what make it fair, and a month is too many cells to apply the rules by hand without missing one.
How to fill it in by hand
Start with what is fixed. Lock PTO, locked-in requests and any events that need a specific manager. Then assign weekend closes from the bottom of last quarter's weekend-close count up, so the person with the fewest gets the first Saturday. Assign weekday closes the same way from the overall close count. Then fill opens, making sure each open has a key carrier. Mids go last; they are the flexible shift and they absorb whatever is left. Finally, walk each manager's row and check for six-day stretches, clopens and weeks over the mid-plus-close cap.
Plan on an hour and a half for a team of five. Longer for six or more, because every constraint you fix tends to break another one two weeks later.
The alternative
Schedule Maker is the template with the rules built in. Add your managers, mark PTO, lock anything that is already decided, and generate the month. It enforces the five-day week, the consecutive-day limit, the key-carrier coverage and the no-clopen rule, balances weekend closes against three months of history, and grades the result for fairness. If you want to override something, click the cell and change it; the grade updates so you can see what the change cost. Then print the month on one page or send each manager their shifts to their calendar.
Download or generate
If you want the manual version, the layout above is all you need; draw it in Excel or Google Sheets in ten minutes. If you would rather not spend Sunday night on it, generate the month for free and only pay if you want to save it, sync it, or export it.