Restaurant Prime Cost Excel Spreadsheet Template
Set up how you want to compare yourself against the market benchmark. You will set an interval of efficiency that will generate a comparative dashboard automatically.
For each product state its monthly revenue, this is the first step to calculate your prime cost formula correctly.
Monthly Cost of Goods
This next tab will list the different types of costs of goods that you have and their related value monthly. Typically you can add ingredients, purchase utensils, fees, etc.
Monthly Labor Cost
Next, you should list the different types of labor costs of your restaurant. Here you can add expenses with cooks, cupbearers, cleaners, waiters, etc.
Prime Cost Analysis
Tab to analyze your prime cost monthly automatically. You can also view a chart comparing with the maximum and minimum standards set in the worksheet.
Analysis of Revenues and Annual Costs
Comparative tables showing total revenues, Costs of Goods and Labor Costs, as well as their percentages for the year.
Prime Cost Dashboard
A beautiful, automated, and dynamic dashboard that will showcase your main data about your prime costs.