TITLE: Pet Ownership Cost Analysis - Dog vs. Cat Comparison

PROJECT TYPE: Personal/Practice Project

DESCRIPTION: I analyzed a pet ownership scenario in which a couple was comparing the estimated one-year costs of owning a dog versus a cat. The analysis compared initial setup expenses and recurring monthly costs to provide a clear view of the total annual cost of each option.

WHAT I DID:

• Organized initial and recurring pet ownership cost: Purchase, Collar, Tag, Bowl and Leash.

• Calculated monthly expenses using Excel formulas.

• Calculated estimated one-year ownership costs.

• Created a dashboard showing monthly expenses by category.

• Created a second dashboard comparing one-year total costs.

• Used charts to visualize the difference between the two options.

KEY INSIGHT DELIVERED:

Based on the assumption in the dataset, the estimated annual cost was $559.50 for the cat and $644 for the dog, a difference of $84.50.

RESULT:

The completed Excel model provided a clear breakdown of initial, monthly and annual costs, making it easier to compare the two pet ownership scenarios.

TOOLS USED: Microsoft Excel, SUM, Cost Modeling, Bar Charts and Comparative Analysis