# Excel - Party for 5 Food Budget

## Students Create a Budget Showing Allowance, Costs and Money Left Over

Students have a budget of \$25.00 to feed a total of 5 people (including themselves) for a party.

Each of the people want to eat and drink different things.

In order to make sure everyone has something they like to eat and drink, Students must choose at least 2 items from each of the 6 food categories on the Party Food Menu.

To make sure there is enough food, students must try to buy as much as they can with the \$25.00 budget, without going over the budget.

## The Assignment:

Students create a budget using a spreadsheet to show how much they have to spend (allowance) , and how much each item costs (expenses).

Students use autosum to calculate the total costs.

Students create a simple formula to subract total food expenses from the \$25.00 allowance to show how much money is left over (money left over).

### Requirements:

1) Students must choose at least 2 items from each food category to satisfy their finicky party friends. For example students will choose 2 items from "Hot Foods," 2 items from "Salads," and so on.

2) Students must also choose any 5 drinks from the drink menu.

3) Students should spend more than \$24.00, but less than \$25.00.

## Excel - Party for 5 Food Budget Finished Example:

Students enter their food choices and their prices in the spreadsheet. Students format the prices with dollar signs and use formulas to calculate the total costs and money left over. Students create a chart illustrating the food costs.

Students should use print preview to ensure that everything will fit on a single page before printing.

## Party for 5 Food Budget - Starter Template

Students can use this excel template to guide their budgeting. Students will need to apply necessary formatting, enter all the food choice data, food prices, and formulas.

## Party for 5 Food Budget Instructions

### More IdeasFor PC's and Microsoft Office

• Excel
Bar Chart
• Thanksgiving
Copy and Paste
• Green Screen
Photo Editing
• Computer Lab
Rules
• California Regions
Brochure
• Amazing Animals
PowerPoint
• I Am
Poem Generator
• "Floater"
Animation
• Learn PowerPoint
in One Minute
• Copy and Paste
Practice
• M & M
Excel Chart
• Newspaper
Template