West Morningside is halfway through it’s FY22 budget and has a large estimated gap to be closed. In addition, it has to create a reasonable and balanced budget for FY23. Using the following table and data, answer the following (note, xls table is uploaded)
For the answers, please upload a Word Doc and an Excel.
a. What is the size of and what are the main drivers of the estimated Deficit for FY22?
b. Calculate the Year-over-year changes in each line item (green) from FY21-FY22
c. Create a balanced FY23 budget by filling out Expenditures in the peach sells
d. Calculate the year-over-year change from FY22-FY23 for each line item.