To address this, I engineered a custom Excel VBA multi-entity consolidation system featuring automated Overhead Allocation Logic for IT, HR, and Accounting. By applying Q1-Q2 Variance Analysis, the model simulated a path to recovery through admin payroll optimizations, restructured sales commission logic, and cost stabilization via WACC modeling.