Create Your First Project
Start adding your projects to your portfolio. Click on "Manage Projects" to get started
Account Quarterly & Monthly Revenue and Units Sold
Project Type
Revenue & Volume Trend Analysis
This report provides a detailed breakdown of quarterly revenue and units sold for two key medical products - Product 1 and Product 2 - at River Hospital during the 2023 fiscal year.
Using Excel, I created a structured reporting table to visualize both financial and operational performance by product line. Revenue data was aligned with corresponding units sold to highlight sales trends, seasonal demand, and product adoption.
🔍 Key Actions:
Cleaned and organized raw sales data into two clear summary tables: Revenue and Units Sold
Segmented results by quarter and product to enable comparative analysis
Included calculated totals for both revenue and units to support executive-level visibility
📈 Business Impact:
Enabled Sales and Finance teams to quickly assess product performance over time
Supported inventory planning and forecasting discussions by aligning sales dollars with unit movement
Identified Q4 as a peak performance period, driving further investigation into sales strategies used during that timeframe
