Systems Analysis and Design Term Project

Max Tennyson is a small busin" rel="nofollow">iness owner, specializin" rel="nofollow">ing in" rel="nofollow">in rentin" rel="nofollow">ing vacation cottages in" rel="nofollow">in Europe and Africa. Up to now, his busin" rel="nofollow">iness, Tennyson’s Travel, has been manageable with spreadsheets and manual records. All busin" rel="nofollow">iness has been conducted in" rel="nofollow">in the travel office or on the phone. TT has been experiencin" rel="nofollow">ing phenomenal growth, at a rate of 25% a year. Max has only 3 employees currently but is now lookin" rel="nofollow">ing to expand the operations, up to 10 employees. He knows that he needs to automate the records and is unsure where to start. He also believes that he needs to create a website. Keep in" rel="nofollow">in min" rel="nofollow">ind that both the travel agents and customers would like to search the in" rel="nofollow">inventory usin" rel="nofollow">ing criteria, such as price, location, property type, number of bedrooms and how many people total can sleep in" rel="nofollow">in property. Max hires you to analyze his busin" rel="nofollow">iness/in" rel="nofollow">industry and come up with a plan to automate his small busin" rel="nofollow">iness. Where to start: Second work  Work up a spreadsheet how much it would cost to create the new system from scratch and compare your numbers again" rel="nofollow">inst the purchase price for a pre-programmed software package. Assume that the company currently only owns Office 2010 (Word, Excel, PowerPoin" rel="nofollow">int, Access, Project – COST ESTIMATE).  Create a task list and schedule for your project. The travel company needs this implemented no later than September 30, 2017, in" rel="nofollow">in order to be fully operational for the busy win" rel="nofollow">inter break vacation season. Use either Excel or Project. Show durations of each task, task dependency and total project length. Use an expected task estimate formula. This can be done by hand. Prin" rel="nofollow">int out your task list with 3 columns next to it (best-case, worst-case, and probable-case time estimates then you can show your formula by hand (or in" rel="nofollow">in an Excel spreadsheet.) (TIME ESTIMATES)  From your task list, either prin" rel="nofollow">intout a network diagram from Project or create in" rel="nofollow">in Word/Visio a PERT/CPM diagram similar to the ones shown in" rel="nofollow">in your textbook. It does NOT have to look exactly like these. (NETWORK DIAGRAM)  Make or buy decision – justify your decision in" rel="nofollow">in a PowerPoin" rel="nofollow">int presentation to Max (your customer.) Make it a convin" rel="nofollow">incin" rel="nofollow">ing decision. Make sure that your decision has met all the feasibility requirements (operational, technical, economic, and schedule.) Also, take in" rel="nofollow">into account the total cost of ownership (both the tangible and in" rel="nofollow">intangible costs.) (MAKE VS BUY)  Create a screen mockup of the fin" rel="nofollow">inal system. Either create the mockup in" rel="nofollow">in Word, Visio, Access (forms), HTML, or use Visual Basic. Show at least one of the data entry and one of the output screens. Explain" rel="nofollow">in what can’t be seen, such as data validation and other data entry controls. (MOCKUP)  Detail your plan for software testin" rel="nofollow">ing and rollout in" rel="nofollow">in Word memo. (ROLLOUT PLAN) 1. Cost Estimate 2. Time Estimate 3. Network Diagram (name can be hand-written in" rel="nofollow">in footer) 4. Rollout Plan