r00190019
Badges: 0
Rep:
?
#1
Report Thread starter 4 years ago
#1
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
0
reply
Kevin De Bruyne
Badges: 21
Rep:
?
#2
Report 4 years ago
#2
(Original post by r00190019)
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
One thing you could do is have all the optional things in one area and split up the cost into fixed and addition price per unit.

So for example, a bouncy castle would have a large fixed cost to set up, transport etc then it doesn't matter if only one person goes on it or 100 people do, the additional cost would be 0.

Alternatively for pizza the delivery costs might be £5 then £10 for each pizza required.
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

How do you prefer to get careers advice?

I like to speak to my friends and family (15)
12.82%
I like to do my own research online using careers specific websites (73)
62.39%
I like speaking to the careers advisors at school, college or uni (14)
11.97%
I prefer to listen watch videos or listen to podcasts of people in my chosen career (12)
10.26%
Something else (let us know in the thread) (3)
2.56%

Watched Threads

View All