#1
|
|||
|
|||
Excel Spreadsheet
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 Also posted on: http://www.excelguru.ca/forums/showt...1360#post31360 https://www.excelforum.com/excel-cha...ml#post4623749 Last edited by r00190019; 04-06-2017 at 09:52 AM. |
#2
|
||||
|
||||
Hi and welcome
Please,do not crosspost your question on multiple forums without including links here to the other threads on other forums. Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
HI
I've just edited it to include the links is that ok now?
Thanks |
#4
|
|||
|
|||
.
. A few resources to study. Each one has at least one aspect that might be included in your project: https://www.tidyform.com/catering-invoice-template.html http://www.chefs-resources.com/kitch...vent-planning/ http://www.bucknell.edu/x4795.xml https://templates.office.com/en-us/S...query=catering https://templates.office.com/en-us/Menus https://www.spreadsheet123.com/calcu...alculator.html https://www.restaurantowner.com/publ...t-Template.cfm http://www.smokymtbarbecue.com/bbq-t...p#.WOaE1IjythE |
#5
|
||||
|
||||
Yes, thank you. Adding links prevents members from losing time
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Spreadsheet shows as 'Read Only' | Bec | Excel | 5 | 07-23-2015 04:54 AM |
Can't Open Excel Spreadsheet | Lucky Luke | Excel | 0 | 03-12-2015 12:47 PM |
Labels from excel spreadsheet | Shepherdra | Mail Merge | 5 | 12-11-2014 11:26 PM |
How do I export my contacts to an Excel spreadsheet? | Shawn76 | Outlook | 2 | 05-22-2010 07:54 AM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |