1

KoKo’s Canine Pet Club

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 KoKo’s daily exercise usually took the form of a walk around the

neighborhood, Ms. Magana, as a busy executive, had trouble scheduling KoKo’s daily walks. Ms. Magana’s

friend Ian, would walk KoKo on the days when Ms. Magana was extremely busy. Ms Magana’s 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 pet’s 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..

2

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

Benefits

Benefit Approximate Dollar Value

Insurance Savings $200

Storage savings $8,000

Staff Reduction (1 less person) $1,000

Increased Business $2,000

Faster Processing $1100

Total Costs

Development Costs

One Time Cost Approximate Dollar Value

1 Server $3,000

2 New Workstation @ 1,250 $2,500

1 Printer / Fax / Copier Machine $1,200

1 Server Software $300

2 Workstation Software @ 250 $500

Development Labor $9,000

Total Costs

Operational Costs

Cost Approximate Dollar Value

Hardware $950

Software $450

Operational Labor (maintenance) $1,500

Total Costs

3

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

DELIVERABLES INSTRUCTIONS

• Turn in a neatly stapled assignment

• Use the cover page at the end of this assignment as the first page in your binder turn in the assignment in the specified order.

• Title each page accordingly.

4

Course: CIS 3150 -Introduction to Systems Analysis and

Assignment: Design Project 2

Student Name:

Instructor Comments:

Project Grade: