Account Quarterly & Monthly Revenue and Units Sold

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