Categories:

December 3, 2015

Food Product Cost & Pricing Spreadsheet – US">Food Product Cost & Pricing Spreadsheet – US

Knowing how much your products cost you to make and how to price them in a way that will make you money is as important to a successful food business as having good recipes. This custom-designed Excel spreadsheet will enable you to input your recipes and help you calculate your specific product costs and provide pricing guidance. This can be used for all of your recipes and you keep them safe and sound on your computer where you can always access them. Written instructions and an example are included with the spreadsheet too.

Product Features:

  • Calculates your per unit cost for each of your ingredients and packaging for up to 20 recipes.
  • Tells you how much of each ingredient and packaging you need based on how much quantity you want to make
  • Incorporates your cost of labor into the product cost
  • Calculates product pricing for multiple channels based on your preferred margin percentages
    Want to know how to get your product to a certain price and still make money? This tool lets you work backwards from a final retail price and tells you how much you need to get your product cost down to in order to make the product and still make money
  • The spreadsheet includes directions but this 20 minute step-by-step video illustrates how to input a recipe in order to determine accurate product costs and pricing.

 

This spreadsheet is in US dollars and utilizes excel. This program has also been tested to work on Numbers for Mac.To enable spreadsheet to be utilized in Google Docs follow these two quick steps (1) n Google Drive, click the Settings icon in the top-right corner of the page and select Settings > Convert uploads. (2)Click the New button on the left of the page and select File upload, then navigate to your Excel file.

Please note that certain cells are password protected to ensure that the spreadsheet accuracy is maintained. The step-by-step video explains how you access the cells necessary to complete the spreadsheet.