2024: Week 17 - Budget vs Actuals Part 2
Challenge by: Michał Mioduchowski We're continuing with DS43's challenges so over to Michał to explain the her next challenge. _____________________________________ Superbytes has tasked us with examining their historical budgets once more, this time focusing on 2023, when the company began tracking actual spending on a monthly basis. The objective is to determine primary areas contributing to over-expenditure over the course of the year. CEO Phil suspects that the company may have invested too much into inventory without witnessing a corresponding uptick in sales performance last year. If suspicion turns out to be true, it will provide actionable insights for optimising resource allocation, and enhancing overall financial performance in line with Superbytes' strategic objectives. Inputs There are 13 inputs this week: Forecasted Spending Actual Monthly Spending (1 table per month) Requirements Input the Excel file : Combine the Monthly sheets into a single table Since w