Cost Estimator for Raising a Labrador Retriever

Comprehensive Project

AGME 2903

Carmen Albright

Description of Problem

• The spreadsheet allows a user to input selections of choices of housing, food, veterinary care, and miscellaneous items and uses these selections to calculate the costs of raising a Labrador retriever.

Inputs

• The user is asked for the following inputs:1. Price Paid for Lab2. Selection of Expected size of dog and dog food

brand, as well as a feeder and waterer for Food Costs3. Selection of Doghouse, Bedding, and Pen/Fence for

Housing Costs4. Selection of Veterinary Care options for Veterinary

Care Costs5. Selection of Miscellaneous options for Miscellaneous

Costs

Outputs

• From the inputs provided by the user, the spreadsheet calculates the following outputs:

1. Food Costs2. Housing Costs3. Veterinary Care Costs4. Miscellaneous Costs5. Total Estimated Cost

Formulas

• Food Costs-Amount of food needed for size of dog multiplied by price of brand of dog food added to the prices of the selected feeder and waterer

• Housing Costs-Addition of prices of selected doghouse, bedding, and pen/fence

• Veterinary Care Costs-Addition of prices of selected options

• Miscellaneous Costs-Addition of prices of selected options

• Total Cost-Sum of Price paid and Food, Housing, Veterinary Care, and Miscellaneous Costs

Layout

• The spreadsheet is organized with major and minor headings and group boxes for the option buttons and check boxes.

$0.00 0 0

1

1

Feeder: 4 $0.00

Waterer: 4 $0.00

$0.00$0.00

6

Price Paid for Lab:

Cost Estimator for Raising a Labrador Retriever

Expected Size:

Doghouse for Your Dog:

Food Costs:

Brand of Dog FoodYou Plan to Feed:

Housing Costs:

Igloo Tuff-N-Rugged Wooden Mansion

Dog Palace Do-It-Yourself Wooden House None

Large Bowl Petmate Feeder Raised Feeder None

Large Bowl Pet Fountain Self Waterer None

$0.00 4

$0.00 3 FALSE

$0.00 FALSE FALSE FALSE FALSE FALSE FALSEVeterinary Care:

Pen/Fence:

Bedding:

Inside/Outside Dog Bed Dog Lounger Canine Couch None

Inside Gates(3) Fence Kit

W/ Dog Door

None

Annual Exam Spay/Neuter Annual Rabies shot Interceptor (Worm Prevention)

Frontline Plus (Flea and Tick Control) K9 Advantix (Flea and Tick Control, Mosquito Repellent)

$350.00 FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE

Miscellaneous:

Check all the products you intend to purchase for your dog. (Note: Failing to select chew toys for your lab will result in $200 being added to your total because of the likelihood that your dog will cause damage to furniture and other things from a lack of something to chew on. Also, $150 will be added to your total if you fail to select some method of training because this can also result in damage to you or your home.)

Chew Toys:

Treats:

Training:

Other:

PRICELESS!

The total estimated cost for raising your labrador retriever is

$350.00

The value of your labrador retriever is

RopeNylabone Plush Bone Tennis Balls Wild Bird Toy

Beggin' Strips Milk-Bone Dog Biscuits Pet Life Crunchy Treats

Tips on Training Video "The Well Mannered Dog" PuppySmarts Lessons for a Lifetime CD-ROM Obedience Classes

Sweater Collar Leash Shampoo Brush Nail Clippers

Summary

• This spreadsheet allows for an easy, fairly accurate calculation of the costs of raising a Labrador retriever.

• To see the spreadsheet, click here.