DOWNLOAD: Ideal Cost Worksheet
The Ideal Cost Worksheet is a tool that helps to find the variance between "Ideal" cost and "Actual" cost. Ideal cost is calculated by multiplying the cost of each menu item by the number of items sold for a given period. Add the total menu cost for each item to arrive at the Ideal cost for the period.
This worksheet, in conjunction with the Cost of Sales worksheet, can be used to calculate the variance between "Ideal Cost" and "Actual Cost".
Steps to Create an Ideal Cost Worksheet:
1. Properly cost out each menu item.
2. Make sure that each menu item has its own POS key.
3. List each menu item and its cost in the worksheet.
This template comes in a Microsoft Excel (.xls) file format.