CASE BACKGROUND About a year ago, Christina Magana found herself facing a dilemma. As a result of a chronic illness, KoKo, her beloved schnauzer, required medication, a special diet, and daily exercise. While the medication and special diet were easy to accommodate into a busy life style, ensuring that KoKo received daily exercise was another matter. Although KoKos daily exercise usually took the form of a walk around the neighborhood, Ms. Magana, as a busy executive, had trouble scheduling KoKos daily walks. Ms. Maganas friend Ian, would walk KoKo on the days when Ms. Magana was extremely busy. Ms Maganas friends and neighbors liked the pet walking idea so much that they approached Ms. Magana and Ian about walking their dogs as well. What began as a neighborhood walking service has now become a fledgling, yet growing, metropolitan area business. Ms. Magana has hired you to build a simple yet effective software program for her business. She needs the system to be able to track data about clients, pets, walkers, and schedules for when the walkers take out the pets. Although the service was only started six months ago, it currently provides pet walking services for 350 pets and is registering on average 5 pets per week. Paperwork is increasing and the owner needs a better record keeping system. During a meeting with the owner she explains to you that a new client must register with the service. During the registration process the new client provides basic information about his pet. Chooses a preferred walk time and specifies a walker preference. During this time a dog walking fee is determined and recorded on the pet registration form. The dog-walking fee varies by pet and is based on the pets size, temperament and the number of pets the owner has. The pet owner can request that his pet be walked in the early morning, late morning, early afternoon, late afternoon, or early evening hours. Available walk times are currently kept on a clipboard by the phone. However, Ms. Magana wants the available walk times, as well as walker, client, and pet information, kept in the system that you are building. Everything now is done on pre-printed paper forms. Because the business grew so fast Ms. Magana has contracted 20 walkers with alternating schedules. She has also hired three full-time college students to help with the record keeping and organization of the files. She is also renting a small storage unit when she keeps all the extra files that she is not able to keep at home. Below are the recurring costs that she is currently paying. As well as the benefits that she anticipates gaining by using the newly developed system. She would like to be able to see how the new system will operate as it is being built because she wants to be able to make some modifications to it at each stage..
Benefits Benefit Insurance Savings Storage savings Staff Reduction (1 less person) Increased Business Faster Processing Total Costs Approximate Dollar Value $200 $8,000 $1,000 $2,000 $1100 Development Costs One Time Cost 1 Server 2 New Workstation @ 1,250 1 Printer / Fax / Copier Machine 1 Server Software 2 Workstation Software @ 250 Development Labor Total Costs Approximate Dollar Value $3,000 $2.500 $1,200 $300 $500 $9.000 Operational Costs Cost Hardware Software Operational Labor (maintenance) | Total Costs Approximate Dollar Value $950 $450 $1,500 Assume that the interest rate used to calculate PV is 5% Assume that the increase in business will be 7% each year. Assume that the operational cost of the system will increase by 1.5% each year DELIVERABLES FOR PROJECT 2 1. Complete a feasibility analysis for 5 years. Determine the Break Even Point, and ROI. Write a small paragraph with your recommendation if Ms. Magana should go ahead with the system or not. 2. Create In a word document create a list of tasks needed for this project in table format 3. Create a work plan for the project (See example). Include duration, Start, Finish, Predecessors and fictitious resources. Include all phases of the SDLC in your list. a. Planning b. Analysis c. Design d. Implementation 4. Create a Gantt chart (See Example) for the WBS. Research and select a freeware tool online to create your Gantt chart. Specify which software you used for the Gantt chart Work Plan Example ID Task Name Duration Start Finish Predecessors Resource Names 10 days 1 Overall analysis Identify High-Level Requirements JAD session 6 days 4 days 2 days Jason, Carly. Ming Maria, Kenji Informal benchmarking Prioritize requirements Define Version 1 scope 2 days Jason 2 days Jason, Carly 61 days 17 days 5 days Ming Ming Fri 2/12/16 Mon 2/8/16 Thu 2/4/16 Mon 2/8/16 Wed 2/10/16 Fri 2/12/16 Mon 5/9/16 Tue 3/8/16 Fri 2/19/16 Tue 3/8/16 Wed 2/24/16 Tue 3/22/16 Fri 2/19/16 Thu 3/17/16 Wed 3/9/16 Tue 3/22/16 Mon 5/9/16 Fri 3/4/16 Version 1 Detailed Requirements Develop use cases Develop process models Develop data models Preliminary Design System architecture User interface 12 days 3 days Maria 27 days Mon 2/1/16 Mon 2/1/16 Mon 2/1/16 Fri 2/5/16 Tue 2/9/16 Thu 2/11/16 Mon 2/15/16 Mon 2/15/16 Mon 2/15/16 Mon 2/22/16 Mon 2/22/16 Mon 2/15/16 Mon 2/15/16 Wed 3/9/16 Thu 2/25/16 Wed 3/9/16 Mon 2/22/16 Mon 2/22/16 Thu 3/10/16 Mon 3/21/16 Wed 3/23/16 Wed 4/20/16 Wed 5/4/16 Tue 5/10/16 Fri 7/8/16 5 days Kenji 7 days 10 Ming Database 11 Maria Programs 10 days 10 days 56 days 13,10 Kenji Implementation Acquire HW & SW Construct database 10 days 13 Kenji Fri Maria 7 days 5 days Convert data Maria 15 19 19 16, 10 20, 21 Write programs Testing 20 days 10 days 4 days 3/18/16 Fri 3/25/16 Tue 4/19/16 Tue 5/3/16 Mon 5/9/16 Thu 7/7/16 Wed 8/17/16 22 Installation 24 Version 2 25 Version 3 Ming, Kenji Maria, Kenji, Ming Maria, Kenji, Ming Jason, Maria, Kenji, Ming Jason, Ming, Kenji, Maria 42 days 28 days Gantt Chart Example February March April May June July August September 211 218 2/152/22/2/29 317 311|321|323 41 111 a/18/a/2552 519 5/165/235/30 616 6/13/6/2016/27 714 71718725 811 818 8/15/8/22/8/29 915 9/12/9119 Jason, Carly, Ming Maria, Kenji Jason Jason, Carly Ming Wing bh Maria 15 Maria - Kerti Maria It-Maria- Ming, Keni Maria, Kenji, Ming Maria, Kenji, Ming Jason, Maria, Kenji, Ming Jason, Ming, Kenji, Maria Benefits Benefit Insurance Savings Storage savings Staff Reduction (1 less person) Increased Business Faster Processing Total Costs Approximate Dollar Value $200 $8,000 $1,000 $2,000 $1100 Development Costs One Time Cost 1 Server 2 New Workstation @ 1,250 1 Printer / Fax / Copier Machine 1 Server Software 2 Workstation Software @ 250 Development Labor Total Costs Approximate Dollar Value $3,000 $2.500 $1,200 $300 $500 $9.000 Operational Costs Cost Hardware Software Operational Labor (maintenance) | Total Costs Approximate Dollar Value $950 $450 $1,500 Assume that the interest rate used to calculate PV is 5% Assume that the increase in business will be 7% each year. Assume that the operational cost of the system will increase by 1.5% each year DELIVERABLES FOR PROJECT 2 1. Complete a feasibility analysis for 5 years. Determine the Break Even Point, and ROI. Write a small paragraph with your recommendation if Ms. Magana should go ahead with the system or not. 2. Create In a word document create a list of tasks needed for this project in table format 3. Create a work plan for the project (See example). Include duration, Start, Finish, Predecessors and fictitious resources. Include all phases of the SDLC in your list. a. Planning b. Analysis c. Design d. Implementation 4. Create a Gantt chart (See Example) for the WBS. Research and select a freeware tool online to create your Gantt chart. Specify which software you used for the Gantt chart Work Plan Example ID Task Name Duration Start Finish Predecessors Resource Names 10 days 1 Overall analysis Identify High-Level Requirements JAD session 6 days 4 days 2 days Jason, Carly. Ming Maria, Kenji Informal benchmarking Prioritize requirements Define Version 1 scope 2 days Jason 2 days Jason, Carly 61 days 17 days 5 days Ming Ming Fri 2/12/16 Mon 2/8/16 Thu 2/4/16 Mon 2/8/16 Wed 2/10/16 Fri 2/12/16 Mon 5/9/16 Tue 3/8/16 Fri 2/19/16 Tue 3/8/16 Wed 2/24/16 Tue 3/22/16 Fri 2/19/16 Thu 3/17/16 Wed 3/9/16 Tue 3/22/16 Mon 5/9/16 Fri 3/4/16 Version 1 Detailed Requirements Develop use cases Develop process models Develop data models Preliminary Design System architecture User interface 12 days 3 days Maria 27 days Mon 2/1/16 Mon 2/1/16 Mon 2/1/16 Fri 2/5/16 Tue 2/9/16 Thu 2/11/16 Mon 2/15/16 Mon 2/15/16 Mon 2/15/16 Mon 2/22/16 Mon 2/22/16 Mon 2/15/16 Mon 2/15/16 Wed 3/9/16 Thu 2/25/16 Wed 3/9/16 Mon 2/22/16 Mon 2/22/16 Thu 3/10/16 Mon 3/21/16 Wed 3/23/16 Wed 4/20/16 Wed 5/4/16 Tue 5/10/16 Fri 7/8/16 5 days Kenji 7 days 10 Ming Database 11 Maria Programs 10 days 10 days 56 days 13,10 Kenji Implementation Acquire HW & SW Construct database 10 days 13 Kenji Fri Maria 7 days 5 days Convert data Maria 15 19 19 16, 10 20, 21 Write programs Testing 20 days 10 days 4 days 3/18/16 Fri 3/25/16 Tue 4/19/16 Tue 5/3/16 Mon 5/9/16 Thu 7/7/16 Wed 8/17/16 22 Installation 24 Version 2 25 Version 3 Ming, Kenji Maria, Kenji, Ming Maria, Kenji, Ming Jason, Maria, Kenji, Ming Jason, Ming, Kenji, Maria 42 days 28 days Gantt Chart Example February March April May June July August September 211 218 2/152/22/2/29 317 311|321|323 41 111 a/18/a/2552 519 5/165/235/30 616 6/13/6/2016/27 714 71718725 811 818 8/15/8/22/8/29 915 9/12/9119 Jason, Carly, Ming Maria, Kenji Jason Jason, Carly Ming Wing bh Maria 15 Maria - Kerti Maria It-Maria- Ming, Keni Maria, Kenji, Ming Maria, Kenji, Ming Jason, Maria, Kenji, Ming Jason, Ming, Kenji, Maria
