TITLE: Back-to-School Shopping - Price Comparison & Budget Analysis

PROJECT TYPE: Personal/Practice project

DESCRIPTION: I analyzed a back-to-school shopping scenario for Tim and Susan by comparing the prices of school supplies across three stores. The analysis calculated item-level and total shopping costs to identify cost differences and potential savings.

WHAT I DID:

• Created separate shopping lists based on each shopper's requirements.

• Organized prices for 15 school-supply items across three stores.

• Calculated item costs using Unit Price × Quantity.

• Used SUM to calculate total shopping costs.

• Compared individual item prices across stores.

• Created charts for unit-price and total-cost comparisons.

KEY FINDINGS:

Based on the prices and quantities in the dataset, WaltMart had the lowest total shopping cost for both shoppers. Susan's estimated total was $82.79, while Tim's was $185.71. The analysis showed potential savings of $20.50 for Susan and $45.15 for Tim compared with the highest-cost store.

RESULT:

The completed Excel model provided a clear comparison of school-supply prices and total shopping costs, helping identify lower-cost purchasing options and potential saving.

TOOLS USED: Microsoft Excel, SUM, Price Comparison, Cost Calculation, Bar Charts, Budget Analysis and Data Comparison.