need help on homework assignment

For this assignment, you need to work on the Funville Recreation Budget. You have the budget for FY22 and you need o create the budget for FY23. In order to correctly do this, you will need to work in Excel (or similar) and use formulas o make your calculations. If you just type the numbers into each cell for the FY23 numbers, if will not be correct. The number has to be correct and the formula also has to be correct. This is basic Excel that you need to know, so if you do not, then just watch some YouTube videos and figure it out, or I have included a videe 3 explaining how I use calculations in Excel in the Learning This Week pages. It is not hard and it is good to have a basic understanding of Excel functions. Some of the figures are provided for you but the empty blanks, you will need to figure out. The information you need to build this budget is below. - All membership fees are going up 5% - We are expanding the hours the sports team field rentals for external organizations, so we expect a 10% increase - Fitness Boot Camp is adding a 7am session so we plan to have a 20% increase - The Sports Team fees are being reduced by 5% - Sports Tournament Fees are expected to increase about $10,000 because we are adding 2 tournaments - Concession sales are expected to stay the same - Summer Program fees are expected to stay the same - All employees will receive a 4% cost of living raise - You need to have a total of your revenues and expenses in each section, so at the bottom of the Income section, have a total, and at the bottom of the Expenses group, have a total that is calculated with a formula. You also need to add a balance at the very bottom to show if we make money, break even, or lose money. So, have a cell that uses a formula to copy the Income total, use another cell to copy the expenses total, then have a balance calculation that figures out what the income minus expenses are for the balance. You need to state next to the total which one we are making money, losing money, or breaking even. - The holiday children's program should stay the same - The benefits are expected to all raise by 2% except the gym membership will increase by $150 - Office Supplies are expected to increase by $500, the rest of the supplies are expected to stay the same - All maintenance is expected to go up 10% - Professional Services are expected to go up 2%, except Janitorial will go up 50% since we are adding some additional shifts - Postage is expected to increase to $450 - Training-Outside will increase by $1000 - Replacement-Fleet will purchase 2 new vehicles so it will increase by $120,000 - Copiers will increase to $1000 - The rest of the categories are expected to stay the same AutoSsve OOf B Budgeting Assignment Spread Sheet TO POST-2 V Psearch(At+Q) fx Summary \begin{tabular}{|l|r|r|} \hline Income & $631,550 & \\ \hline Expenses & $547,657 & \\ \hline Balance & $83,893 & \\ \hline \end{tabular} For this assignment, you need to work on the Funville Recreation Budget. You have the budget for FY22 and you need o create the budget for FY23. In order to correctly do this, you will need to work in Excel (or similar) and use formulas o make your calculations. If you just type the numbers into each cell for the FY23 numbers, if will not be correct. The number has to be correct and the formula also has to be correct. This is basic Excel that you need to know, so if you do not, then just watch some YouTube videos and figure it out, or I have included a videe 3 explaining how I use calculations in Excel in the Learning This Week pages. It is not hard and it is good to have a basic understanding of Excel functions. Some of the figures are provided for you but the empty blanks, you will need to figure out. The information you need to build this budget is below. - All membership fees are going up 5% - We are expanding the hours the sports team field rentals for external organizations, so we expect a 10% increase - Fitness Boot Camp is adding a 7am session so we plan to have a 20% increase - The Sports Team fees are being reduced by 5% - Sports Tournament Fees are expected to increase about $10,000 because we are adding 2 tournaments - Concession sales are expected to stay the same - Summer Program fees are expected to stay the same - All employees will receive a 4% cost of living raise - You need to have a total of your revenues and expenses in each section, so at the bottom of the Income section, have a total, and at the bottom of the Expenses group, have a total that is calculated with a formula. You also need to add a balance at the very bottom to show if we make money, break even, or lose money. So, have a cell that uses a formula to copy the Income total, use another cell to copy the expenses total, then have a balance calculation that figures out what the income minus expenses are for the balance. You need to state next to the total which one we are making money, losing money, or breaking even. - The holiday children's program should stay the same - The benefits are expected to all raise by 2% except the gym membership will increase by $150 - Office Supplies are expected to increase by $500, the rest of the supplies are expected to stay the same - All maintenance is expected to go up 10% - Professional Services are expected to go up 2%, except Janitorial will go up 50% since we are adding some additional shifts - Postage is expected to increase to $450 - Training-Outside will increase by $1000 - Replacement-Fleet will purchase 2 new vehicles so it will increase by $120,000 - Copiers will increase to $1000 - The rest of the categories are expected to stay the same AutoSsve OOf B Budgeting Assignment Spread Sheet TO POST-2 V Psearch(At+Q) fx Summary \begin{tabular}{|l|r|r|} \hline Income & $631,550 & \\ \hline Expenses & $547,657 & \\ \hline Balance & $83,893 & \\ \hline \end{tabular}