Budget vs. Actual Analysis

This project analyzes a small retail brand's Q1 2026 performance by comparing budgeted figures against actual revenue and expenses. I built a fully formula-driven Excel model — no hardcoded numbers — that automatically calculates dollar and percentage variance for each category, flags results as "Favorable" or "Unfavorable" with color-coded formatting, and rolls everything up into Total Revenue, Total Operating Expenses, and Net Operating Income. A clustered bar chart visualizes budget vs. actual side-by-side for quick executive review. The goal was to show how a business owner could spot exactly where they overspent or outperformed expectations at a glance, without digging through raw numbers.