TITLE: Pet Ownership Cost Analysis by Marvellous OlaonipekunTITLE: Pet Ownership Cost Analysis by Marvellous Olaonipekun

TITLE: Pet Ownership Cost Analysis

Portfolio project
Marvellous Olaonipekun
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

0 likes · 0 views · Oct 2, 2026

TITLE: Pet Ownership Cost Analysis - Dog vs. Cat Comparison PROJECT TYPE: Personal/Practice Project DESCRIPTION: I analyzed a pet ownership scenario in whi...

Tags