Hi guys
I am to set up a business which provides birthday planning services for parents of small children.
The task is to develop a Microsoft Excel based flexible financial/costing model to provide parents a quick and easy way to manage invitations and attendees and hence cost the party based on relevant criteria required for each party, such as:
* The number of attendees
* The food provided
* Optional extras
I can use complete flexibility to make it as creative or as complex as I want. But it should use at least one formula in excel
I also need to consider all aspects of costs and financial considerations, using a formula based spreadsheet.
I’m thinking the spreadsheet should allow parents to input number of attendees and automatically calculate the food, optional extras depending on what the parents put in, what do you think? So at this point number of attendees will be blank until a parent opens the spreadsheets puts it in, at which point the calculations will automatically take place
I have the following details at the moment:
Optional Extras:
Decorations
Cake
Tables/Chairs
Candles
Bouncy Castle
Cups
Plates
Drinks
Orange Juice
Apple Juice
Water
Foods
Pizza Slices
French Fries
Veggie Sandwich
Chicken Sandwich
Nachos
Is someone able to help in what sort of layout I could put this in Excel, and how best it would be to input formulas-or your way of doing this?
Thanks
I am to set up a business which provides birthday planning services for parents of small children.
The task is to develop a Microsoft Excel based flexible financial/costing model to provide parents a quick and easy way to manage invitations and attendees and hence cost the party based on relevant criteria required for each party, such as:
* The number of attendees
* The food provided
* Optional extras
I can use complete flexibility to make it as creative or as complex as I want. But it should use at least one formula in excel
I also need to consider all aspects of costs and financial considerations, using a formula based spreadsheet.
I’m thinking the spreadsheet should allow parents to input number of attendees and automatically calculate the food, optional extras depending on what the parents put in, what do you think? So at this point number of attendees will be blank until a parent opens the spreadsheets puts it in, at which point the calculations will automatically take place
I have the following details at the moment:
Optional Extras:
Decorations
Cake
Tables/Chairs
Candles
Bouncy Castle
Cups
Plates
Drinks
Orange Juice
Apple Juice
Water
Foods
Pizza Slices
French Fries
Veggie Sandwich
Chicken Sandwich
Nachos
Is someone able to help in what sort of layout I could put this in Excel, and how best it would be to input formulas-or your way of doing this?
Thanks