Excel Spreadsheet for Fundraising Food Event
Budget: ₹1,500 – ₹12,500 INR
Assignment for Excel Project – English Translation (with additional requirements)
You are part of a local association organizing a food event to raise funds. Participants will register using a paper form handed out to friends, family, neighbors, and local politicians. On this form, they choose their meal and whether they want dessert. Multiple people can register on the same form. Payment can be done in advance or at the cash register.
You are asked to create a fully functional and user-friendly Excel spreadsheet that helps with the full organization of this event. Your spreadsheet should support the following tasks:
________________________________________
Main Goals
• Register and track orders, including the meals and desserts chosen.
• Track whether participants have already paid or still need to pay.
• Show how many meals/desserts are needed per time slot (lunch or dinner).
• Help with planning staff, tables, and ingredients.
• Provide a financial analysis: actual and forecasted profit/loss.
• Be flexible enough to reuse for future events.
• Bonus: Add useful automation features if possible.
________________________________________
Specific Instructions & Extra Requests
• Maximum 250 guests for lunch and 250 for dinner. Please make sure the spreadsheet includes a control to limit registrations per shift to 250 people.
• If possible: automatically assign a table number to each group upon registration (realistically assume ± 30 tables with 6–8 seats each). This allows guests to know where they’ll be seated when they arrive. If this feature is not possible, indicate that clearly. (if its to difficult, you can skip this)
• Automatic stock tracking is required: Set an initial stock per ingredient (e.g., 5 kg spaghetti). Based on orders, the spreadsheet must automatically update stock levels. If stock is low (e.g., <10 servings possible), a warning message should appear. If an ingredient is fully out of stock, the system should clearly show it and prevent further orders of that dish.
________________________________________
What Your Excel Must Include
1. Order overview
o Create your own registration form (based on what you’d distribute on paper).
o Input must match what's on the form.
o Populate your spreadsheet with data for at least a few dozen participants (you may generate fake data if needed).
2. Cash desk support
o Track who has paid (in advance or at the event).
o People may give donations (“keep the change”).
o Guests may pay in part beforehand and the rest at the event.
o People on the same form may pay separately.
o Desserts can still be bought on the day if available. Cashiers should be able to track remaining dessert stock live.
3. Meal planning
o Show number of meals per dish, split by shift (lunch/dinner).
o Show what ingredients to buy based on number of meals.
o Desserts are bought from a caterer (by unit). Always have a small buffer stock.
o Add realistic ingredient and dessert prices.
4. Logistics planning
o Estimate how many staff are needed per shift.
o Calculate how many seats and tables are required.
o Bonus points: If possible, make sure people registered on the same form are seated together.
5. Financial overview
o Predict how many participants are needed to break even (including hall rental).
o Track actual earnings and remaining expected income.
o Estimate profit or loss based on current orders.
________________________________________
What to Submit
• Your full Excel file with all sheets and working formulas. It must work without extra software on any standard computer with Excel.
• A digital version of your self-designed registration form (to check if your spreadsheet fits the setup).
________________________________________
Important Notes
• Work must be original and unique. Plagiarism or copying other groups is not allowed.
• Try to make the file as user-friendly and future-proof as possible.
• You may use digital tools to generate fake data or support your design.
• The quality of your work will also be tested during the final exam.
You are part of a local association organizing a food event to raise funds. Participants will register using a paper form handed out to friends, family, neighbors, and local politicians. On this form, they choose their meal and whether they want dessert. Multiple people can register on the same form. Payment can be done in advance or at the cash register.
You are asked to create a fully functional and user-friendly Excel spreadsheet that helps with the full organization of this event. Your spreadsheet should support the following tasks:
________________________________________
Main Goals
• Register and track orders, including the meals and desserts chosen.
• Track whether participants have already paid or still need to pay.
• Show how many meals/desserts are needed per time slot (lunch or dinner).
• Help with planning staff, tables, and ingredients.
• Provide a financial analysis: actual and forecasted profit/loss.
• Be flexible enough to reuse for future events.
• Bonus: Add useful automation features if possible.
________________________________________
Specific Instructions & Extra Requests
• Maximum 250 guests for lunch and 250 for dinner. Please make sure the spreadsheet includes a control to limit registrations per shift to 250 people.
• If possible: automatically assign a table number to each group upon registration (realistically assume ± 30 tables with 6–8 seats each). This allows guests to know where they’ll be seated when they arrive. If this feature is not possible, indicate that clearly. (if its to difficult, you can skip this)
• Automatic stock tracking is required: Set an initial stock per ingredient (e.g., 5 kg spaghetti). Based on orders, the spreadsheet must automatically update stock levels. If stock is low (e.g., <10 servings possible), a warning message should appear. If an ingredient is fully out of stock, the system should clearly show it and prevent further orders of that dish.
________________________________________
What Your Excel Must Include
1. Order overview
o Create your own registration form (based on what you’d distribute on paper).
o Input must match what's on the form.
o Populate your spreadsheet with data for at least a few dozen participants (you may generate fake data if needed).
2. Cash desk support
o Track who has paid (in advance or at the event).
o People may give donations (“keep the change”).
o Guests may pay in part beforehand and the rest at the event.
o People on the same form may pay separately.
o Desserts can still be bought on the day if available. Cashiers should be able to track remaining dessert stock live.
3. Meal planning
o Show number of meals per dish, split by shift (lunch/dinner).
o Show what ingredients to buy based on number of meals.
o Desserts are bought from a caterer (by unit). Always have a small buffer stock.
o Add realistic ingredient and dessert prices.
4. Logistics planning
o Estimate how many staff are needed per shift.
o Calculate how many seats and tables are required.
o Bonus points: If possible, make sure people registered on the same form are seated together.
5. Financial overview
o Predict how many participants are needed to break even (including hall rental).
o Track actual earnings and remaining expected income.
o Estimate profit or loss based on current orders.
________________________________________
What to Submit
• Your full Excel file with all sheets and working formulas. It must work without extra software on any standard computer with Excel.
• A digital version of your self-designed registration form (to check if your spreadsheet fits the setup).
________________________________________
Important Notes
• Work must be original and unique. Plagiarism or copying other groups is not allowed.
• Try to make the file as user-friendly and future-proof as possible.
• You may use digital tools to generate fake data or support your design.
• The quality of your work will also be tested during the final exam.