# 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.

### Step 2 – Calculating the Food Cost

• To calculate the price of the total plates of meatballs, enter the following formula in E6.
`=C6*D6`

• Press Enter to see the expense.

• To calculate the expense for the potato skins, enter the following formula in E7.
`=C7*D7`

• Press Enter to see the expense.

• Enter the formula in E8.
`=C8*D8`

• Press Enter to see the expense.

• To calculate the expense for the last food items use the following formula in E9.
`=C9*D9`

• Press Enter to see the result.

• To calculate the total food price, use the following formula with the SUM function.
`=SUM(E6:E9)`

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

### Step 3 – Determining the Beverage Cost

• To determine the expense of cold coffee, use the following formula in E14.
`=C14*D14`

• Press Enter to see the expense.

• To determine the expense for the second beverage, use the following formula in E15.
`=C15*D15`

• Press Enter to see the expense.

• To determine the total beverage price, in E6, enter the following formula.
`=SUM(E14:E15)`

• Press Enter to see the expense.

• To determine the total cost of food and beverage, enter the following formula in E17.
`=E10+E16`

• 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.
`=E17*.1`

• 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.
`=E20+E21`

• Press Enter.

### 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.
`=E17+E22`

• Press Enter to see the result.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Md. Araf Bin Jayed

I am Araf. I have completed my B.Sc in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Currently I am working as an Excel & VBA Content Developer in Softeko. With proper guideline and aid of Softeko I want to be a flexible data analyst. With my acquired knowledge and hard work, I want to contribute to the overall growth of this organization.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF