The Sheet would has 1- Data base for Customer name, address 2- Data base for fix knew cost to pay tour guide, Hotel tax, so it can use dropdown menu to avoid mistakes 3- Input for variable costs Hotels costs, Airfare cost, Meals costs etc.
Two parts clearly Buy ( actual buy the service ) while Sale ( actual quote the service ), the difference is profit projection. The sheet as capacity for me to adjust the cost markup so that I can come up with a competitive quote while maximize profit if possible.
Finally the actual quote would print out the final Sale portion of the calculation. The sheet need to use all available functions in Excel to avoid miscalculations, wrong dates, wrong markup with build in error checking and format. Simple sheet but need someone paid attention into visual design as well as maximize use of database functions, menus, tables, which will minimize input while use all drop down for input.
Sheet should be clearly simple presentation in sheet 1 for input data ( variable & fix cost ), Sheet 2 ( all database for input modify ), sheet 3 Report of actual cost and Quote sent out to customer.