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.
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).
Excel Party Food Menu
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.
Make this menu available for students to view.
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
Excel Spreadsheet Rubric for Grading Assignments:
For PC's and Microsoft Office