Hello, good morning! Thank you for your comment. To calculate the price of biscuits (cookies) by weight, simply use the spreadsheet as shown in the video-calculating based on the unknown cost. However, when entering the quantity the batch produces, you’ll indicate how many kg/lb the recipe yields. For example, if your recipe yields 1.8 kg of the finished product, just enter 1.8 in the 'This batch yields...' field. This will calculate the price per kg of the biscuits in the 'Individual' column.
@@ExcelPracticalSolutions Hello, hello! Thank you for taking some of your time to answer my question, I will try this method and let you know, thank you
Hello, please how to calculate the price of biscuits (cookies) by weight (kg/lb) in Excel, thank you
Hello, good morning! Thank you for your comment. To calculate the price of biscuits (cookies) by weight, simply use the spreadsheet as shown in the video-calculating based on the unknown cost. However, when entering the quantity the batch produces, you’ll indicate how many kg/lb the recipe yields. For example, if your recipe yields 1.8 kg of the finished product, just enter 1.8 in the 'This batch yields...' field. This will calculate the price per kg of the biscuits in the 'Individual' column.
@@ExcelPracticalSolutions Hello, hello! Thank you for taking some of your time to answer my question, I will try this method and let you know, thank you