Sushmitha Kokkalgave
revenue-forecasting-variance
● LIVE
Python · XGBoost · Scikit-learn
Snowflake · Tableau
Revenue Intelligence Platform
Forecasting &
Variance
Analysis
Linear Regression · XGBoost · 12-month horizon · 5 departments · 5 regions
All Departments
Inpatient
Outpatient
Pharmacy
Diagnostics
Behavioral Health
All Regions
Northeast
Southeast
Midwest
Southwest
West
Linear Regression
XGBoost
Total Actual Revenue
—
All periods · filtered
Budget Attainment
—
—
YoY Growth
—
—
Avg Gross Margin
—
Revenue minus cost
Forecast Accuracy
—
—
Anomalies Detected
—
Z-score > 2.5
Revenue actuals vs forecast
Historical actuals · 12-month forecast with confidence band
LR
Monthly variance vs budget
Over budget (green) · Under budget (red)
Revenue by department
Total actual · all periods
YoY growth by department
% change vs prior year
Gross margin % by dept
Revenue minus cost
12-month rolling revenue trend
3-month vs 12-month rolling average
Model performance — LR vs XGBoost
R² score per department
Department variance summary
Actual vs budget vs prior year · budget status · margin
Department
Total Actual
Budget
Variance $
Variance %
YoY Growth
Avg Margin %
Status
Revenue anomalies detected
Periods with Z-score > 2.5 — statistically unusual revenue