BuiltByEstradaBook a call

Weekly Labor and Prime Cost Tracker

Restaurants and Bars line

Daily sales, supplier invoices, hours by role and a weekly inventory count become cost of goods, labor and prime cost %, with a warning above your limit and the guests per day you need to break even. One file covers 13 weeks.

Excel and Google Sheets workbook, English and Spanish files

Fare

$19

founding price until January 31, 2027 · then $31

Secure checkout by Stripe, which adds sales tax where it applies. You download the file as soon as you pay.

Not what you needed? Write to us within 30 days of purchase and we refund you in full.

Labor-and-Prime-Cost-Tracker.zipSCREENSHOTS · full version
Weekly Labor and Prime Cost Tracker: the Daily sales tab, with EXAMPLE data
Daily sales: tab with EXAMPLE data See the whole tab
Weekly Labor and Prime Cost Tracker: the Purchases tab, with EXAMPLE data
Purchases: tab with EXAMPLE data See the whole tab
Weekly Labor and Prime Cost Tracker: the This week tab, with EXAMPLE data
This week: tab with EXAMPLE data See the whole tab

Screenshots of the full version, taken from the real file. Every number in them is an EXAMPLE.

What you do, what the sheet does

YOUTHE SHEET
You type daily sales and guestsIt gives the average check and the week's sales
You type invoices and the inventory countIt works out cost of goods
You type hours by roleIt adds pay, payroll taxes and salaried pay
The week closesIt shows prime cost % in red above your limit and the guests per day to break even

What the full version has

  • Setup: roles and pay, payroll taxes, fixed costs and your prime cost limit
  • Daily sales and guests for 91 days
  • Hours by role for 13 weeks
  • Purchases log for 400 invoices and weekly inventory counts
  • Weekly summary: prime cost % with a warning above 65%, labor %, cost of goods %, break even guests per day
  • One page This week report to print

Who it is for

Owners who want to see food, drink and labor costs every week and catch a bad week while they can still fix it.

Every dish, price, name and number already in the files says EXAMPLE. They are fictional and only show how each file works.

Made by BuiltByEstrada in McAllen, Texas. In English and Spanish.