Frequently Asked Questions / Troubleshooting

Here you'll find answers to some commonly asked questions & troubleshooting information about the course and our templates...

QUESTION: How do I add a new row to the Recipe Costing Template if my recipe has more ingredients?

ANSWER: Right click anywhere in the table, and click Insert Row to add a new row. If the formula in row F (red row) doesn't automatically copy when adding a new row, copy and paste the formula from the row above into your new row.

The video below shows how to do this if you need a visual aid.

QUESTION: I added new rows to the Recipe Costing Template, but the formulas did not copy. How do I fix this?

ANSWER: If the formulas don't automatically copy when you add a new row, copy the formula from the row above and paste it into your new row. The formulas will update their pointers to the correct cells in the new row.

If you need a visual aid of how this works, please watch the video above.

QUESTION: The formulas aren't calculating in my spreadsheet - what do I do?

ANSWER: The most common reason the formulas aren't calculating, is because you have blank rows in the ingredient table. Delete any un-used / blank rows in the table that you didn't use to list your ingredients, and the formulas should calculate for you.

QUESTION: My recipes are not listed in grams. How do I convert them?

ANSWER: The most accurate way to convert your recipes is to use a food scale. These are fairly inexpensive and can be purchased through your restaurant supply store, at most big box stores, or through Amazon.

If you do not have access to a food scale or need to convert something in a pinch, I recommend looking it up on Aqua Calc >> https://www.aqua-calc.com/calculate/food-volume-to-weight

QUESTION: How do I factor in packaging costs in my costing spreadsheet?

ANSWER: Watch the video below to learn how I recommend you calculate your packaging costs for items in the RCE template.