. Sheet 1
Create a party budget for an upcoming graduation party. List 12 items to purchase. Plan for 50 people to attend.
Set up a worksheet to add up the expenses, using formulas. DO NOT SUBMIT NUMERIC answers that you computed on a calculator. You must use formulas and functions. Add a column for tax at a rate of 4.5%. Compute the pretax purchase amount and then compute tax, adding it to the item total cost.
Finally, total the cost per item, including tax, then compute the total cost of the party.
If five people are splitting the cost of the party, how much will each contribute? Note this on the spreadsheet.
Name Sheet 1 Party. Format the sheet so it is professional looking and easy to read.
- Sheet 2
Create a grade book using the following information.
Sample Solution