{"product_id":"recipe-cost-calculator-spreadsheet","title":"Recipe Cost Calculator Spreadsheet","description":"\u003cp\u003eThis recipe cost calculator tells you what a meal actually costs before you cook it, per recipe and per serving. It is for home cooks, a home baker selling bakes, or anyone who wants food cost in numbers rather than guesses.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eNothing on the dashboard is typed. Choose all recipes or any one, and the cards, cost and batch follow it.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eFive live cards: recipe cost, cost a serving, selling price, margin and batch profit\u003c\/li\u003e\n\u003cli\u003eWhere the cost goes: each ingredient's share of a recipe's cost, dearest first\u003c\/li\u003e\n\u003cli\u003eBest margins, with every serving's price split into cost and profit\u003c\/li\u003e\n\u003cli\u003ePrices that moved since the last price, and the recipes hit hardest\u003c\/li\u003e\n\u003cli\u003eMargin against target, turning red when a recipe keeps less than you aim for\u003c\/li\u003e\n\u003cli\u003eA batch calculator: how many a batch makes, what it costs, sells for and leaves you\u003c\/li\u003e\n\u003cli\u003ePrice to hit your margin, for recipes under your target\u003c\/li\u003e\n\u003cli\u003eAverage cost against average price by kind of recipe: breakfasts, dinners, bakes and more\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eChange one price, everything follows\u003c\/h2\u003e\u003cp\u003ePrice an ingredient once and every recipe using it re-costs itself, per recipe and per serving, so a cheap-looking dish that serves two is never mistaken for one that serves four. Every figure on the dashboard is calculated from the tabs behind it. Nothing is typed into a summary, so the front page can never disagree with the rows it came from.\u003c\/p\u003e\u003ch2\u003eWhat is included\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eRecipes:\u003c\/strong\u003e eighty recipes with meal type, minutes, cost per recipe and cost per serving\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRecipe lines:\u003c\/strong\u003e four hundred lines of ingredient and quantity, with the unit pulled through and how many recipes use each ingredient\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMeal plan:\u003c\/strong\u003e put recipes on the week and see the cost of the week\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eShopping list:\u003c\/strong\u003e builds itself from the week, with the pantry subtracted, so it doubles as your grocery list\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e live\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eNine connected tabs in all, every one reading the same source list, so the meal planner and the costing never disagree.\u003c\/p\u003e\u003cp\u003eYou get real spreadsheet files, not a PDF with a link in it: Excel and Google Sheets, each filled in and each blank and ready for yours. The filled copy is the file in the photos, so you can see how it behaves before you type anything.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example, and the same workbook blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. The files are for personal use on your own devices; please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eCan I use it in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to the Google Sheets versions (filled and blank).\u003c\/p\u003e\u003ch3\u003eWhat happens when an ingredient price changes?\u003c\/h3\u003e\u003cp\u003eChange it once and every recipe that uses it re-costs itself. The dashboard also shows which prices moved and which recipes were hit hardest.\u003c\/p\u003e\u003ch3\u003eCan I work out a selling price for my bakes?\u003c\/h3\u003e\u003cp\u003eYes. Set a selling price and a target margin; recipes below target turn red, and the dashboard shows the price that would reach your margin.\u003c\/p\u003e\u003ch3\u003eHow many recipes does it hold?\u003c\/h3\u003e\u003cp\u003eEighty recipes and four hundred recipe lines.\u003c\/p\u003e\u003ch3\u003eDoes it make a shopping list?\u003c\/h3\u003e\u003cp\u003eYes. Put recipes on the week and the shopping list builds itself, with what you already have in the pantry subtracted.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597863583838,"sku":"OPX-057","price":22.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/recipe-cost-calculator-spreadsheet-01.jpg?v=1790832253","url":"https:\/\/opxviashop.com\/products\/recipe-cost-calculator-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}