You are a Senior Financial Analyst serving the ABCD division, and you have been assigned to prepare the FY24 budget allocation for the ABCD division, accounting for the changes that have taken place. The budget comprises two main categories: "Salaries" and "Operations." Below is the table containing the ending budget for FY23:

ABCD FY23 Ending BudgetBranch ABranch BBranch CBranch DFY23 Division TotalSalaries $ 4,703,100 $ 4,316,700 $ 3,191,500 $ 2,297,500 $ 14,508,800 Operations $ 29,419,500 $ 3,007,100 $ 282,100 $ 559,300 $ 33,268,000 FY23 Ending Budget $ 34,122,600 $ 7,323,800 $ 3,473,600 $ 2,856,800 $ 47,776,800

Objective: Your objective is to prepare the FY24 budget allocation and compose a brief email to the Assistant Deputy Minister (ADM) of the division. The email should explain how you arrived at the FY24 amounts and summarize the year-over-year (YoY) changes that occurred.

Instructions:

Please complete the following tasks:

1. Prepare a table of the final FY24 budget allocation for each branch, including the adjusted salary uplift and operational budget amounts.
2. Write a concise email (500-word max, excluding tables) summarizing to the Assistant Deputy Minister (ADM) the year-over-year adjustments that have taken place and what the FY24 branch and divisional budget allocations would be given those changes. Your email should include a table similar to the above.

Please note the following adjustments must be accounted for in the ABCD Divisional budget for FY24, with all else remaining the same as FY23:

1. The Branch B FY23 salary budget included $315,000 of temporary project funding that did not carry through into FY24 since it is not base funding. Any uplifts should not consider this amount.
2. The division has received a Base Salary Uplift of $2,000,000. This uplift is to be applied proportionally to the branches, based on their portion of the division's total FY23 base salaries.
3. The Assistant Deputy Minister (ADM) of ABCD division has noted consistently higher attrition rates recently and wants to withhold 3% of the salary uplift, so that it is not surplus at year-end. This amount will be applied to Branch C's operational budget in FY24, as they have a priority project that is currently unfunded.

Important Note: Please focus on clearly presenting your calculations and analysis in a professional and concise manner. The email to the ADM should be included in the "ADM Email tab" of the Excel file. The 500-word limit for the email does not include the table you provide.