Using the spreadsheet provided, you need to plan a party for your class. You have 15 pounds per person to spend. From the long list of items on Tab 1, you must select one venue, one activity, two drinks, five food items, and up to five essentials and decorations. Now, let's work on the second tab, the Party Planner tab. So, you need to choose items from the long list and put them into your party planner. So, I'm gonna choose the school hall as my venue. I'm gonna highlight what I need. I'm gonna right-click and copy. And I'm gonna paste it into my second tab, which is the Party Planner tab. And you can see, my first item is the school hall. That's my venue, and the cost is nothing 'cause we are at school, and we don't have to pay for the school hall. Lucky us. Then, I'm gonna choose one activity. So, let's say we have a disco. I'm gonna right-click. I'm gonna copy. And I'm gonna paste into my party planner. And I'm gonna do that for drinks, food, and essentials, and decorations. Now, I'm gonna add in the quantity I need for each of the items. So, I need one school hall. I need one disco. The blackcurrant juice is per person, so I need 30 of those. 30 orange juice. I don't think everyone's gonna eat mozzarella bites, so I'm gonna go for 20. Same for pizza. Same for chips. I think 15 people might have vegetable sticks. 15 people might have sausage rolls. We need 30 paper plates, 30 cups, 30 napkins. Let's have 20 balloons, and let's have 30 party bags. So, I've got my cost and quantity of each item. Let's use a formula now to work out the subtotal of each item. So, in column E, I'm gonna type in =C2*D2. So, I'm multiplying the cost by the quantity. I'm gonna press Enter. And luckily, the school hall for me costs nothing. Now, instead of typing the formula in for each of these cells, remember I can hover over my small blue dot on the right hand side of a cell, and I can replicate my formula down. And you can see very quickly it's worked out the subtotals for each of my items. Now, I'm gonna add in the number of attendees. I've got 30 people in my class. My budget is 15 pounds per person. Now, I need to use a formula to work out my total budget. So, in cell I2, I'm gonna type in = and I'm gonna multiple cell G2*H2 'cause I'm doing 30 multiplied by 15 pounds. And that's worked out. I've got 450 pounds to spend. And here we've added in some formulas pre-made for you to work out the overall costs. So, here you can see the total venue cost is zero. The total activity cost is 150 pounds. The total drinks cost is 1 pounds 80. The total food cost is 150 pounds 65 pence. My essentials and decorations total 29 pounds. I've got 118 pounds left over. My party costs 331 pounds 45. And my party cost is 11. 05 pounds per person. Now, if I want to here, I can spend more of my money. I've got some budget left over. So, I'm gonna increase the total amount of balloons I've got. Let's say, go from 20, let's say, we have now, we want 40 balloons. You can see that's changed. It's taken some money away from my budget. It's increased my party cost and increased my cost per person. If you want to, you can save your budget.