2 3 Category 1 Library Budget Account 2022 2023 4 Revenue 5 Federal Funding $156,728.0 6 Real Estate Tax $123,500.0 7 Local Fundraising $36,140.0 8 Fees $4,793.1 9 Total: $321,161 10 Personnel 11 Librarian $58,500.0 12 Other Professionals $32,500.0 13 Clerical Staff $19,500.0 14 Custodians $13,650.0 15 Benefits $16,042.0 16 Total: $140,192 17 Expenses 18 Books $65,650.0 19 Periodicals $49,146.5 20 Audio/Video $38,555.4 21 Insurance $4,582.5 Library Loop Practice Problem You are participating in a service learning program where you are using your IE knowledge to help the community. You are volunteering to help your local library create a budget worksheet. Using the previous year's budget, supplied to you by the library, you decide to create a procedure that will ask for a percent increase (or decrease) from the previous year, and then create the next fiscal year's budget amounts. 1. Use the LibraryBudget.xlsm file that you can find on Canvas. 2. Write a CopyNext Years Budget procedure that asks users if they want to create a new budget. The message box should have yes and no buttons. If the user presses yes, the program should continue. If the user presses no, the program should stop. 3. Ask the user (if they pressed yes) what percentage increase they want to use for the next budget year. Store this amount in a variable with a data type of single. 22 Utilities $7,784.4 4. Make the Federal Funding amount for 2022 the active cell. 23 Maintenance $9,750.0 24 Supplies $3,854.5 25 Total: $179,323 26 27 Net Budget: $1,646 28 5. In a loop: a. Copy the budget from the previous year and increase it by the percentage entered by the user in step 3. b. Move down to the next line. C. number of items in the budget may change, but Net Budget will always be the final line. Continue this loop until the last line in the budget, "Net Budget:" is reached. The 29 30 31 Sheet1