How to Create a Food and Beverage Budget in Excel – 5 Steps

This is the sample dataset.

Step 1- Preparing the Dataset

• Enter data in an Excel sheet, as shown below.

Read More: How to Prepare a Vacation Budget in Excel

Step 2 – Calculating the Food Cost

• To calculate the price of the total plates of meatballs, enter the following formula in E6.

• Press Enter to see the expense.

• To calculate the expense for the potato skins, enter the following formula in E7.

• Press Enter to see the expense.

• Enter the formula in E8.

• Press Enter to see the expense.

• To calculate the expense for the last food items use the following formula in E9.

• Press Enter to see the result.

• To calculate the total food price, use the following formula with the SUM function.

• Press Enter to see the value: $15,843.00.

Read More: How to Create Budget and Expense Tracker in Excel

Step 3 – Determining the Beverage Cost

• To determine the expense of cold coffee, use the following formula in E14.

• Press Enter to see the expense.

• To determine the expense for the second beverage, use the following formula in E15.

• Press Enter to see the expense.

• To determine the total beverage price, in E6, enter the following formula.

• Press Enter to see the expense.

• To determine the total cost of food and beverage, enter the following formula in E17.

• Press Enter. The formula will return $19943.00.

Read More: How to Create Renovation Budget in Excel

Step 4 – Finding Additional Costs

• Use the following formula in E20 to find the service charge.

• Press Enter.

• The cost is $650.

• To get the value of the total additional cost, add E20 and E21 in E22. Use the following formula.

• Press Enter.

Read More: How to Create Actual Vs Budget Variance Reports in Excel

Step 5 – Showing the Final Result

• Add the total cost of food and beverage and the total additional cost in E24 with the following formula.

• Press Enter to see the result.

Download the Practice Workbook

Related Articles

• How to Create Bi Weekly Budget in Excel
• How to Create Uncertainty Budget in Excel
• Create Retirement Budget Worksheet in Excel
• How to Create a Budget with Irregular Income in Excel
• How to Create a 50-30-20 Budget Spreadsheet in Excel
• How to Prepare a Sales Budget with Example in Excel

<< Go Back to Budget Template | Finance Template | Excel Templates