I will create a restaurant inventory and food cost tracking spreadsheet
About this Gig
Get a practical inventory spreadsheet built around your restaurants ingredients and counting process.
With hands-on restaurant general management experience, I understand the importance of accurate counts, consistent units, and clear cost reporting.
I will customize one Excel workbook for one restaurant location and up to 25 ingredients.
Your workbook includes:
Beginning inventory, purchases, and ending counts
Actual usage calculations
Variance calculations using your supplied theoretical usage
Unit costs and dollar variance reporting
A weekly summary
Clearly marked input cells and brief instructions
You provide your ingredient list, counting units, unit costs, and any available sample data. Theoretical usage should come from your POS sales and recipe standards.
Delivery: 3 days. Includes one revision to the agreed setup.
This package covers spreadsheet setup. Recipe costing, POS integration, ongoing data entry, and additional locations are separate services. Message me before ordering if you need a larger or more complex workbook.

