The budget would be flexible with an upper limit but she

Assignment Help Computer Engineering

Reference no: EM13462119

Preparing a spreadsheet that helps one to plan custom vacation packages for families. The final outcome would be a nice vacation within a given budget and a given time span. While the scope of the work is pretty flexible, there are certain expectations that need to be met. You have the complete freedom to decide what the dimensions of "nice" are.

(a) There should be option of constructing a tour circuit by first selecting a state to visit, using a drop down list on the visual display. The list of tourist destinations should then appear automatically depending on the choice. The tour circuit will be constructed by choosing towns of tourist interest from this list, and deciding on the sequence in which the places will be visited. For example a client could choose Bihar as the state to visit and then construct the circuit with Patna, Nalanda, Rajgir and Gaya in that order.

(b) To increase flexibility in travel time, there could be a facility for selecting mode of transport.

(c) For the tour circuit your spreadsheet should allow for analysing two package options based on mode of transport (Air, Train, Car), and hotel quality (star rating, customer feedback etc.) for travelling from one place to other, activities, side tours and length of vacation. A tour starts from the first city and ends in the last one. Analysis of each package should result in a visual output of bar graphs comparing scores in budget, flexibility, and other metrics of your choice. Remember that outputs need to be scaled so that comparisons can be made on the same chart for the package options that can also be selected through radio buttons on Option 1 or Option 2 (radio buttons are simple extension of the check-boxes).

(d) Each bar graph should also have check box options to enable selection of various modes of transportation (Air and car; Air, Car and Train; Train only etc.).

(e) There should be a way of giving the clients some idea about how much it would be if bought now vs. two months later (this is in consideration of the significant savings that could accrue if the flight is booked much in advance).

The bottom line is that this would enable the client to get a clear feel of ‘What would constitute getting the most out of his/her trip'.

At the time of conceptualizing the model, you may keep the following guidelines in mind:

a) The users of the spreadsheet will be city persons and that feature in the decision making

b) The budget would be flexible with an upper limit. But (s)he would want value for money and would feel comfortable if it is kept within certain limit.

c) Tours and trips must be carefully considered

d) A bad hotel will quickly ruin the trip and also the user would have high expectation for the services that (s)he pay good money for.

You will have to download from web all necessary data like airfare, the distance, rates for the type of cars needed, temperature of the place, hotel charges, etc needed for creating the spreadsheet.

Reference no: EM13462119

Questions Cloud

Data mining is a powerful and tool but it poses challenges : data mining is a powerful and tool but it poses challenges to the protection of individual privacy. data mining can

A woman falls while skiing and accidentally is impaled by : a woman falls while skiing and accidentally is impaled by her ski pole. the pole passes through the abdominal body wall

Considerable success has been achieved by companies : considerable success has been achieved by companies practicing tqm. what are the major hurdles to continuing quality

Write a 700 to 1050 word paper on a specific web or mobile : write a 700 to 1050 word paper on a specific web or mobile application.describe a specific web or mobile applications

The budget would be flexible with an upper limit but she : preparing a spreadsheet that helps one to plan custom vacation packages for families. the final outcome would be a nice

For the management prepare a one page diversity policy for : a large chain of beauty salons hire you as a consultant. the organizations management team faces a unique problem.

Explain how you could find out the focus of a converging : describe how you could find the focus of a converging lens using a candle a sheet of white paper and a ruler be

Your organization is about to made a big change in merging : your organization is about to make a major change in merging with another health care system. management is planning on

Which of the following is not one of ways to evaluate hr : which of the following is not one of the ways to measure hr strategic effectiveness?return on investmentprice

User Account

All Pages