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

This is the sample dataset.

5 Easy Steps to Make Food and Beverage Budget in Excel


Step 1- Preparing the Dataset

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

Preparing Data Set with Available Information as An Easy Step to Make Food and Beverage Budget in Excel

Read More: How to Prepare a Vacation Budget in Excel


Step 2 – Calculating the Food Cost

  • Enter the following formula in E6.
=C6*D6

Calculating Food Cost as An Easy Step to Make Food and Beverage Budget in Excel

  • 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:
=SUM(E6:E9)

Using SUM Function for Calculating Food Cost as An Easy Step to Make Food and Beverage Budget in Excel

  • 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.
=C14*D14

Determining Beverage Cost as An Easy Step to Make Food and Beverage Budget in Excel

  • 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)

Applying SUM Function for Calculating Beverage Cost as An Easy Step to Make Food and Beverage Budget in Excel

  • 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

Finding Out Additional Cost as An Easy Step to Make Food and Beverage Budget in Excel

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

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

Showing Final Result as An Easy Step to Make Food and Beverage Budget in Excel

  • Press Enter to see the result.


Download the Practice Workbook


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
Md. Araf Bin Jayed
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo