What this restaurant schedule is for
A restaurant's labour cost is its second-largest expense after food, and the schedule is where that cost is decided. Too few servers at Saturday dinner and tables turn slowly; too many on a Tuesday lunch and you pay people to fold napkins. Most outlets in India still schedule on a whiteboard or a WhatsApp message on Sunday night, which makes it impossible to see hours or cost before the week starts.
This template is for restaurant owners, outlet managers and small-chain operations heads running one to ten outlets with 8 to 60 staff each. It schedules by meal period rather than by generic shift, so it matches how restaurants actually staff; it totals weekly hours per person; and it estimates the week's labour cost from an hourly rate you enter per role, so you can compare it with forecast sales before publishing.
It is a weekly schedule for a single outlet. Chains copy the sheet per outlet and consolidate. Actual attendance is recorded separately; the schedule is the plan, and the difference between plan and actual is where you find late openings and unapproved overtime.
What is inside: Weekly Schedule and Peak Coverage
The Weekly Schedule sheet has a header with Outlet and Week (start date). Each row is a staff member: Staff, Role (Server, Kitchen, Cashier or Manager; extend as needed), Hourly Rate, then Mon to Sun. Each day cell takes a shift label: Lunch for 11:00 to 16:00, Dinner for 17:00 to 23:00, Split for both blocks (11:00 to 15:00 and 18:00 to 23:00), and OFF for the weekly off. Labels are chosen from a list so counts work.
After Sunday comes Weekly Hours, which converts labels to hours (5 for Lunch, 6 for Dinner, 9 for Split) via a lookup and sums them, and a Cost column that multiplies Weekly Hours by Hourly Rate. At the bottom, a Labour Cost row totals the week's estimated cost and a cell beside it takes forecast sales so labour cost percentage is visible. Hours over 48 in the week are flagged.
The Peak Coverage sheet has one row per meal period per day (Mon Lunch, Mon Dinner, and so on) with Required Staff by role and Scheduled Staff by role, the latter counted from the schedule with COUNTIFS on the day column and the Role column, including Split as present in both periods. A Gap column shows the shortfall in red. Required numbers come from your covers forecast and the table-to-server ratio you set at the top of the sheet.
- Weekly Hours: =COUNTIF(D5:J5,"Lunch")×5 + COUNTIF(D5:J5,"Dinner")×6 + COUNTIF(D5:J5,"Split")×9.
- Cost: =Weekly Hours × Hourly Rate; Labour Cost %: =Total Cost ÷ Forecast Sales.
- Scheduled servers, Mon Dinner: =COUNTIFS($B$5:$B$40,"Server",D5:D40,"Dinner") + COUNTIFS($B$5:$B$40,"Server",D5:D40,"Split").
- Required servers per period: =ROUNDUP(Expected Covers ÷ Covers per Server, 0).
How to build the week's schedule
Start with last week's sales by day and meal period and any bookings, and set Required Staff on the Peak Coverage sheet. A casual-dining outlet might need one server per 4 to 5 tables at dinner and one per 6 to 7 at lunch, with kitchen staffed to menu complexity rather than covers. Then enter leave and weekly offs, rotating Friday to Sunday offs so the same servers are not always missing at peak.
Fill dinner shifts first because they are the busiest and hardest to cover, then lunch, then decide who works split. Split shifts suit staff who live close by; a nine-hour split with a three-hour gap is tiring, so limit them to two or three a week per person. Watch the Weekly Hours column: six Split days is 54 hours, over the 48-hour cap, and should be broken up or paid as overtime with consent.
Check Labour Cost % against your target, usually in the range operators set for their format, then publish by Friday for a Monday start. Share a PDF on the outlet group and pin a print in the back of house. When you swap people mid-week, change the label in the file so the plan stays truthful and you can compare it to attendance. The hourly employee scheduling guide covers demand-based scheduling in more depth.
- Enter Hourly Rate as monthly wage ÷ 26 ÷ 8 for salaried staff so the cost row is comparable across roles.
- Keep part-timers and weekend casuals on the same sheet with their actual hourly rate.
- Schedule the manager's OFF on the quietest day and never on the same day as the senior server's.
How to customise the labels and periods
Change the shift labels to match your service hours: a cafe might use Open (07:00 to 15:00) and Close (14:00 to 22:00); a bar might run Evening (16:00 to 01:00) with a late-night code. Update the hours lookup on the Peak Coverage sheet and the Weekly Hours formula picks up the new durations. Add a Break column if your split shifts have paid breaks.
Add roles as columns on the Peak Coverage sheet: Bartender, Runner, Host, Delivery Packer for outlets with high aggregator volume. For delivery-heavy outlets, add a third period, Late (22:00 to 01:00), where the coverage need is kitchen and packing rather than servers.
Chains can add an Outlet column and a consolidated tab that sums Labour Cost by outlet against each outlet's forecast sales, giving the operations head one view of labour percentage across the brand every Friday.
Working-hours rules for restaurant staff
Restaurants fall under the state Shops and Establishments Act, and the Labour Codes in force since 21 November 2025 fix the outer limits: 48 hours a week, overtime at not less than twice the ordinary wage rate, a weekly rest day and daily hours and spread-over as notified by the state. Most states cap daily work at 9 hours and spread-over at 10.5 to 12 hours; a Split label running 11:00 to 23:00 has a 12-hour spread, so confirm your state's limit before using it every day.
Overtime needs the employee's consent under the Codes, and it must be paid on wages as defined, which pulls allowances above 50% of pay back into the wage base. Because restaurants often pay a consolidated monthly amount plus tips or service charge, define the wage components in writing so the double-rate overtime figure is unambiguous. The split shift glossary entry explains how spread-over is measured across the gap.
Late-night closing brings women's night-work conditions into play in several states, including transport home; check your state rules, and roster the closing shift with that in mind.
When the spreadsheet stops working
The schedule in Excel fails on Saturday evening when two servers do not show, the manager fills in by calling around, and nobody records who actually worked which hours. It fails when the outlet manager's file and head office's copy diverge, when overtime is paid on memory, and when the same exercise repeats across eight outlets every Friday.
Shift software keeps the meal-period logic but publishes the schedule to each employee's phone, handles swap requests with approval, warns when someone on leave is scheduled, and records attendance with a selfie or GPS at the outlet so scheduled and actual hours can be compared for every shift. Attend Mitra's restaurant staff attendance software and shift management for restaurants cover shift templates including split shifts, a weekly roster builder with draft and publish, and kiosk mode on a shared tablet at the pass.