Run · Digital owner toolkit
Weekly Shop Scorecard and Labor Planner
Review sales, employee wages, major food-cost drivers, cash availability, and daily flavor consumption, then build next week’s wage plan and assign three clear actions.
The numbers needed to run an ice cream shop often live in separate places. Sales are in the POS, employee wages are in timecards or payroll, purchasing information is on vendor invoices, cash is in the bank and payment processor, and inventory is tracked somewhere else entirely.
The Weekly Shop Scorecard and Labor Planner brings those operating reviews into one practical system. Only the highlighted amber cells require input; the remaining fields calculate automatically. The workbook compares the completed week with your plan and prior results, identifies exceptions, and helps you turn projected sales into a daily wage plan for the coming week.
The purpose is not to create more reporting. It is to help an owner understand what changed, decide what needs attention, and assign no more than three actions before the next review.
What is included
- Weekly Shop Scorecard and Labor Planner workbook for Microsoft Excel
- Weekly Shop Scorecard Procedure Guide in printable PDF and editable Word formats
- Manager Action Log in printable PDF and editable Word formats
What you can complete
- A weekly owner scorecard covering net sales, employee wages, periodic cost-driver changes, cash availability, and flavor replenishment
- A daily sales and wage review comparing the completed week with the sales plan
- An employee wage percentage calculated as employee wages divided by net sales
- A next-week labor plan using projected sales, a target wage percentage, minimum coverage hours, planned staff hours, and average hourly wage
- A periodic vendor price watch for the ingredients and supplies that have the greatest effect on product margin
- A cash availability check that considers expected deposits and obligations due before the next review
- A daily flavor inventory sheet using target inventory, start-of-day quantities, consumption, ending inventory, and the exact amount needed to replenish each flavor
- A four-week trend using comparable operating periods
- A three-action plan with an owner, due date, expected result, and next-review decision
Who it is for
This product is designed for independent ice cream shop owners and managers who can retrieve information from their POS, timecards or payroll, invoices, inventory records, payment processor, and bank but do not yet review those sources through one consistent operating routine.
Use one workbook copy per location and save a dated copy after each completed review. Established and multi-location operators who want automated data collection and a daily operating view can also learn about the Open Shop Morning Brief design-partner program.
Important limits
This product is a management tool, not accounting, payroll, tax, legal, food-safety, or employment-law advice. Labor plans must maintain safe coverage, required tasks, service standards, and accurate payment for every hour worked. The cash availability check is not a formal cash-flow statement.
This workbook does not calculate a complete weekly food-cost percentage or replace a physical annual inventory. It helps the owner monitor major vendor-price changes periodically and gives staff a daily process for reporting flavor consumption and replenishment needs.
This workbook does not calculate a complete weekly food-cost percentage or replace a physical annual inventory. It helps the owner monitor major vendor-price changes periodically and gives staff a daily process for reporting flavor consumption and replenishment needs.
- Weekly Shop Scorecard and Labor planner · 1
- Action Log · 1
- Procedure Guide · 1
- Procedure Guide Editable · 1
- Action Log Editable · 1
$25.00Secure checkout through Stripe
Digital product. Download access is delivered by email after confirmed payment.