s.p.o.t. saving pets on time

S.P.O.T.Saving Pets On Time

A standardized communication network for a quick and comprehensive recovery in placement of pets

CS410 Red TeamProfessor Janet BrunelleMilestone1 Presentation April 15, 2010

May 6, 2010

SPCA

SPCA

SPCA Humane Society

Animal Control

Neighbors

Animal Control

Animal Control

Neighbors

Neighbors

Family/Friends

Family/Friends

Family/Friends

Shelters

Shelters

Humane Society

Pet Classifieds

Pet Classifieds

Pet Classifieds

Pet Classifieds

May 6, 2010

Agencies that support lost or unwanted animals lack a sufficient communication network.

May 6, 2010

Problem Statement

Number of Pets Entering Animal Shelters Per Year

May 6, 2010

58.3%41.7%

Source: ASPCA

Overcrowding Effects on Animals• Animal begin fighting.• Animals become overstressed.• Animals become more prone to diseases.

ex: Kennel Cough• Innocent animals are euthanized.

May 6, 2010

Source: ASPCA

Lost Pet Recovery Fees

May 6, 2010

Dol

lars

Source: Anne Wheeler

Average Shelter Costs • 15,000 lbs of food consumed each year• 14,000 lbs of cat litter • $25.00 daily cost to feed and house a dog• $18.00 daily cost to feed and house a cat 1

• Over $2 billion is spent annually by local governments to shelter and ultimately destroy 8-10 million adoptable dogs and cats due to shortage of homes 2

May 6, 2010

Resources:Animal Shelter of the Wood River Valley1

Pawprints and Purrs, Inc 2

S.P.O.T. Provides a standardized communication

network for a quick and comprehensive recovery in placement of pets while reducing costs, suffering, and the number of deaths.

May 6, 2010

May 6, 2010

SPCA)))Shelters)))

Family/Friends)))

Animal Control)))

Neighbors)))

S.P.O.T.

May 6, 2010

Major Functional Components

May 6, 2010

May 6, 2010

Major Prototype Components

May 6, 2010

What hardware and software will be required to build it?

Hardware-High speed Internet connection to physically access data

could be provided by an ISP-Storage device that can serve simultaneous requests for access

could be provided by a server with hard drive Software

-Database software that can store and retrieve information on storage device

could be provided by Oracle or MySQL-Web interface to information stored on database

could be provided by HTML, Javascript and PHPMay 6, 2010

May 6, 2010Please See Appendix

May 6, 2010Please See Appendix

May 6, 2010Please See Appendix

May 6, 2010Please See Appendix

Database Overview• Owner database contains owner profiles with associated metadata.• Shelter database contains shelter profiles with associated

metadata. Also contains personnel listings with authentication data.

• Animal database contains animal profiles with associated metadata. Also contains lists of valid species, breeds by species, colors and dispositions.

• Datamining registry contains statistical figures that are called by reporting functions and knowledge-based decisions. Statistical figures are stored by shelter, type of metadata and type of disposition.

Please See Appendix May 6, 2010

Database Schema

May 6, 2010

Reporting Comes In Three Varieties• Trending gives statistical analyses over a given

timeframe for any number of data factors (IE How many black cats adopted on October 31st, 2009?).

• Occupancy returns lists of animals, limited via the various parameters, similar to performing a search using the website.

• At-risk evaluations allow polling of owners that have exceeded a limit on an “at-risk” activity and may be investigated.

May 6, 2010

Innovation Using Data Mining

May 6, 2010

Knowledge-Based Decisions

May 6, 2010

Pre Registration

May 6, 2010

COMPETITION MATRIX

Customers

• Pet Owners • SPCA• Independent Shelters• Rescue Groups• Animal Control

May 6, 2010

Market Size• There are about 5,000 independent community animal

shelters nationwide 1

• About 63 percent of all households in the United States have a pet.

• About 75 million dogs and about 85 million cats are owned in the United States. – In 2006, nearly half of pet owners, or 49.7%, considered

their pets to be family members. 2

May 6, 2010

Source:1 ASPCA.org2U.S. Pet Ownership & Demographics Sourcebook

What will the customer need in order to use this product?

Hardware-needs a device with an Internet connection

could be a phone, computer, or other device Software

-needs a web browser with support components used in the website

could be Mozilla, Internet Explorer, or other browsers

May 6, 2010

Phase 1 WBS

May 6, 2010Please See Appendix

Phase 1: Staffing RequirementsTitle Quantity Salary Hours Hourly Rate Total

Database Administrator 1 $23,000(12-15?)

160 $11.00 $1,760

Computer Programmer 3 $23,000 2040 $11.00 $22,440

Web Developer 1 $23,000 320 $11.00 $3,520

Project Manager 1 $23,000 760 $11.00 $8,360

Software Engineer 1 $23,000 510 $11.00 $5,610

Network Engineer 1 $23,000 315 $11.00 $3,465

Total $45,15540% Overhead $18,062Overall Total $63,217

Phase 1 staff represented by student internsMay 6, 2010

Phase 1: Hardware RequirementsDescription Quantity Cost Per Unit Total Cost

Laptop 7 $850 $5,950

Desktop 1 $750 $750

Network Switch and Firewall 1 $140 $140

Network Cable (500 ft) 1 $50 $50

PHP/MySQL 1 Free -

Total $6,890

May 6, 2010

Phase 1: Projected Costs

May 6, 2010

Phrase 2 WBS

May 6, 2010Please See Appendix

Phrase 2 WBS

May 6, 2010

Phrase 2 WBS

May 6, 2010

Title Quantity Salary Hours Hourly Rate Total

Database Administrator 1 $82,000 300 $39.42 $11,826

Database Developer 1 $55,000 240 $26.44 $6,346

Computer Programmer 2 $45,000 1744 $21.63 $37,723

Web Developer 1 $50,000 288 $24.04 $6,924

Project Manager 1 $84,000 1152 $40.38 $46,518

Software Engineer 1 $68,000 346 $32.69 $11,311

Hardware Engineer 1 $72,000 173 $34.62 $5,990

Network Engineer 1 $62,000 267 $29.81 $7,960

Total $134,59840% Overhead $53,840Overall Total $188,438

Phase 2: Staffing Requirements

Description Quantity Cost Per Unit Total Cost

Workstation 6 $750 $4,500

Server 1 $5,150 $5,150

Server Rack 1 $2,000 $2,000

Server Power Supply 1 $1,000 $1,000

Power Cable 1 $240 $240

Cable Modem 1 $80 $80

PHP/MySQL 1 Free -

Total $12,970

Phase 2: Hardware Requirements

May 6, 2010

Phase 2: Projected Costs

May 6, 2010

Phase 3 WBS

May 6, 2010Please See Appendix

Phase 3: Staffing RequirementsTitle Quantity Salary Hours Hourly Rate Total

Database Administrator 1 $82,000 500 $39.42 $19,710

Computer Programmer 1 $45,000 120 $21.63 $2,596

Project Manager 1 $84,000 2,016 $40.38 $84,000

Technical Support Technicians

2 $41,000 4,032 $19.71 $82,000

Hardware Engineer 1 $72,000 80 $34.62 $2,770

Software Engineer 1 $68,000 100 $32.69 $3,269

Network Engineer 1 $62,000 240 $29.81 $7,155

Web Developer 1 $50,000 50 $24.04 $1,202

Marketing Specialist 1 $67,500 1,048 $32.45 $34,008Total $236,710

40% Overhead $94,684

Overall Total $331,394May 6, 2010

Phase 3: Hardware RequirementsDescription Quantity Cost Per Unit Total Cost

Backup Server 1 $5,150 $5,150

Power Supply 1 $1,000 $1,000

Power Cable 1 $240 $240

Cable Modem 1 $80 $80

Network Switch and Firewall 1 $140 $140

Total $6,610

May 6, 2010

Phase 3: Projected Costs

May 6, 2010

Combined Phases: Cost

Phase Total Cost

1 $70,107

2 $201,408

3 $338,004

Combined Total $609,519

May 6, 2010

Yearly Costs and Projections

• $475/month charge for each shelter• 23 shelters in Hampton Roads, 174 in Virginia,

870 in surrounding states• 60 shelters a year required remain afloat• Break even just after the second year, in the

25th month

May 6, 2010

Break Even Analysis

May 6, 2010

Return on Investment• SPCA

– More animals adopted– Less costs for feeding/euthanizing/body disposals of animals– More freed space – More donations from happy patrons– Profits from data mining

• Discover animal abuse – Animal factories– Negligent pet owners

• Statistical Data– Adoptions statistics (breed, shelter, location, etc)

• End-User (Pet Owner)– Increased chance of being reunited with lost pets– Find lost pets faster– Search available pets for adoption

May 6, 2010

Benefits• More pets in homes (less strays)

• “It is impossible to determine how many stray dogs and cats live in the United States; estimates for cats alone range up to 70 million. – that is almost as many as the number of cats that are in homes (80 million)”1

• Less pets are euthanized, lives are saved.• Lost pets are reunited with owners.• Promotes the SPCA

- Donations-Save money

Source: 1ASPCA

May 6, 2010

What Are The Risks?

May 6, 2010

Save the Animals

May 6, 2010

References• Adopt-a-pet.com. (2004). Adopt A Pet. Retrieved March 30, 2010 from

http://www.adoptapet.com/ • Animal Shelter of the Wood Valley. Shelter Facts and Figures. Retrieved April 12, 2010, from

http://www.animalshelterwrv.org/faqs.php.• ASPCA | Pet Statistics. (n.d.). ASPCA: The American Society for the Prevention of Cruelty to Animals.

Retrieved March 31, 2010, from http://www.aspca.org/about-us/faq/pet-statistics.html• Bureau of Labor Statistics. Occupation o f Labor Statistics. Retrieved on April 12, 2010, from

http://www.bls.gov/oes/2008/may/oes_va.htm#b15-0000• Industry Statistics & Trends. (n.d.). Welcome to the American Pet Products Association (APPA).

Retrieved March 31, 2010, from http://www.americanpetproducts.org/press_industrytrends.asp• Horn, Ralph. Personal Interview. Mathews County Animal Control, Mathews, VA, March 15, 2010.• Market research statistics - U.S. Pet Ownership & Demographics Sourcebook. (n.d.). American

Veterinary Medical Association. Retrieved March 31, 2010, from http://www.avma.org/reference/marketstats/sourcebook.asp

• NCPPSP - Featured Research. (n.d.). National Council on Pet Population Study and Policy. Retrieved March 31, 2010, from http://www.petpopulation.org/research.html

• Pawprint and Purrs, Inc. Education the key to awareness. Retrieved April 14, 2010 from Pawprints and Purrs, Inc

• Wheeler, Anne. Portsmouth Humane Society, Portsmouth, VA. March 16,2010.

May 6, 2010

Appendixes

May 6, 2010

New User Registration

May 6, 2010

Pet Addition

May 6, 2010

Pet Removal

May 6, 2010

Searching

May 6, 2010

Alerts

May 6, 2010

May 6, 2010

Website Layout for Superuser

May 6, 2010

Website Layout for Administrative User

May 6, 2010

Website Layout for Registered User

May 6, 2010

Please See Appendix

Website Layout

May 6, 2010

Data Flow

May 6, 2010