food cost formula excel free download

Standardized Culinary Inventory and Unit Cost Calculation Agreement

Instructions for Use

• Complete the "Parties & Definitions" section to establish the scope of your inventory management and pricing oversight.
• Utilize the "Operative Clauses" to standardize your internal accounting practices, ensuring every ingredient is tracked by its purchase unit and yield percentage.
• Review the final calculations against your target margin benchmarks before implementing price adjustments in your point-of-sale system.

Parties & Definitions

This document is entered into by [Company Name] (the "Establishment") and [Department Head Name] (the "Accountable Party").

• "Inventory Item": Any raw material, ingredient, or consumable purchased by the Establishment.
• "Purchase Unit": The standard container size or weight in which an item is acquired from a vendor.
• "Recipe Yield": The total quantity of finished product produced from a specific set of ingredients.
• "Cost of Goods Sold (COGS)": The total monetary value of ingredients consumed to produce a specific menu item.

Operative Clauses

1. Inventory Tracking: The Accountable Party shall maintain an accurate ledger of all Inventory Items, recording the Purchase Unit price and current stock levels on a [Weekly/Monthly] basis.
2. Standardized Yield Calculations: All recipes must be documented with precise measurements. The Accountable Party shall calculate the "Yield Percentage" by dividing the edible portion weight by the as-purchased weight.
3. Formula Application: The Establishment shall utilize the following formula for all menu item pricing: (Total Cost of Ingredients / Yield Percentage) / Desired Food Cost Percentage = Menu Price.
4. Waste Management: Any inventory loss due to spoilage, theft, or preparation error must be logged in the [Waste Log Document Name] to ensure accurate COGS reporting.
5. Periodic Review: The Accountable Party shall conduct a comprehensive audit of actual food costs versus theoretical food costs every [Number] days to identify variances exceeding [Percentage]%.
6. Vendor Price Adjustments: Upon receipt of updated pricing from vendors, the Accountable Party must update the master inventory spreadsheet within [Number] business days to prevent margin erosion.

Signature & Acknowledgment

By signing below, the parties agree to adhere to the standardized calculation methods and inventory management protocols outlined herein.

Signature: __________ Printed Name: [Full Legal Name] Title: [Job Title] Date: [Date]

Legal Disclaimer: This document serves as a general framework for culinary cost management and internal accounting processes. It does not constitute legal, tax, or financial advice. Consult with qualified counsel or a certified public accountant to ensure compliance with local regulations and specific business tax requirements.