Download
Weekly Cost of Sales Worksheet
Included in the Weekly Cost of Sales Reporting file in the Cost of Sales Worksheet and the Invoice Log worksheet. Food, liquor, beer and wine purchases can be posted to the Invoice Log on a daily basis. Totals on the invoice log automatically update the weekly purchases on the Cost of Sales Worksheet.
Once sales and inventory information is entered, the Cost of Sales worksheet calculates the food, liquor, beer and wine cost for the week as well as the Number of Days of Inventory on hand and Inventory Turnover for each product category.
You can use the Cost of Sales Worksheet to get weekly feedback on your cost of sales and inventory levels. Many restaurants see immediate and significant improvement of their cost of sales by knowing these costs more frequently and being aware of how much inventory they are carrying, relative to how quickly the inventory is being used.
The mechanics and advantages of using this form have been described in detail in, "Food & Beverage Costs Deserve More Than Once a Month".
Summary of Features & Benefits:
- This file contains three worksheets, the Invoice Log, Cost of Sales Worksheet and a Weekly Trend Analysis.
- The worksheets are ready to use. Just enter your numbers and print.
- Each worksheet includes 1 formatted page and is set up to accommodate 4 cost of sales categories.
- The worksheet can be easily changed to fit your exact requirements.
Download the Weekly Cost of Sales Reporting (Blank)
Preview
This form is available in the following formats. You must have a compatible program installed on your computer to use them.
Click to Download Microsoft Excel format
Download the Weekly Cost of Sales Reporting (Sample)
Preview
This form is available in the following formats. You must have a compatible program installed on your computer to use them.
Click to Download Microsoft Excel format
