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.


0 likes · 0 views · Oct 3, 2026
TITLE: Back-to-School Shopping - Price Comparison & Budget Analysis PROJECT TYPE: Personal/Practice project DESCRIPTION: I analyzed a back-to-school shoppi...