Home / Free tools / Finance & Accounting
Excel · 5 KB
Weekly Prime Cost Tracker
A five-week Excel tracker for prime cost. Enter food sales, beverage sales, cost of goods sold and labor for each week; it totals sales, adds COGS and labor into prime cost, and shows prime cost as a percentage of sales week by week.
- Format
- Excel workbook
- Size
- 5 KB
- Price
- Free, no sign-up
- Section
- Finance & Accounting
What's in it
- Five week rows, so a trend is visible rather than one snapshot
- Food and beverage sales entered separately and totalled for you
- Prime cost calculated as cost of goods sold plus total labor
- Prime cost percentage per week, with a 60%-of-sales reference target
How to use it
- Fill it in weekly - prime cost read monthly arrives too late to act on
- Close the week on the same day each time so the periods are comparable
- Enter COGS for the week, not invoices paid that week
- Watch the direction across the five rows more than any single week's number
The guide that explains it
Understanding Prime Cost and Why It Matters — Prime cost = cost of goods sold + total labor. Here's how to calculate it, what a good prime cost is, why it beats food cost alone, and how to control it weekly.