Due 10/17

Instructions

Using the Trend Analysis Template and Worksheets, you will write a report that:

1) Computes and create tables and charts to analyze a three-year trend (2023, 2024, and 2025) of selected appropriations and expenses for agencies within the General Revenues and Mayor's Personnel Budget for Maumelle, Arkansas.

2) Discusses and analyzes trends for appropriations and expenses.

Plagiarism in any form is strictly prohibited and may result in failure of the assignment, failure of the course, and/or removal from the program. It is your responsibility to ensure that you fully understand what constitutes the various forms of plagiarism and to avoid all forms of plagiarism.

Note: Your assignment will be checked for originality via the Turnitin plagiarism tool.

1) For all budget computations, use the line items under the following columns, 2023 Budget, 2024 Amended Budget, and 2025 Proposed Budget.

2) Open and save the A General Revenue Worksheet found on the assignment page.

3) Prepare the Appropriations Data for General Revenues

· You will open and save the Abbreviated Budget Maumelle 2025 assignment resource.

i. Before entering the budgeted amounts in the excel spreadsheets, you need to convert each dollar amount to constant dollars. Due to inflation, the purchasing power of the dollar changes over time, so to compare dollar values from one year to another, they need to be converted from nominal (current) dollar values to constant dollar values to adjust for inflation/deflation.

ii. The easiest way to do that is to use an inflation calculator, such as the U.S. Inflation Calculator found in the assignment resources.

· Look at the Total Revenues row and enter the revenues (in 2025 dollars) into the excel worksheet for each of the three years. (Remember to use the inflation calculator and convert the 2023, 2024 and 2025 budgetary figures into 2025 figures and enter the calculated figures into the spreadsheet.)

· Look at the Public Safety row and enter the revenues (in 2025 dollars) into the excel worksheet for each of the three years. (Remember to use the inflation calculator and convert the 2023, 2024 and 2025 budgetary figures into 2025 figures and enter the calculated figures into the spreadsheet.)

· Look at the Parks and Recreation row and enter the (in 2025 dollars) into the excel worksheet for each of the three years. (Remember to use the inflation calculator and convert the 2023, 2024 and 2025 budgetary figures into 2025 figures and enter the calculated figures into the spreadsheet.)

· Look at the Senior Services row and enter the revenues (in 2025 dollars) into the excel worksheet for each of the three years. (Remember to use the inflation calculator and convert the 2023, 2024 and 2025 budgetary figures into 2025 figures and enter the calculated figures into the spreadsheet.)

· Look at the Planning and Permits row and enter the (in 2025 dollars) into the excel worksheet for each of the three years. (Remember to use the inflation calculator and convert the 2023, 2024 and 2025 budgetary figures into 2025 figures and enter the calculated figures into the spreadsheet.)

4) Analyze the Appropriations Data

· Analyze and illustrate the appropriations for the three-year budget period utilizing Excel Tool Bar Graph in the research paper. Bar graph(s) should be labeled appropriately with a number, descriptive title, and vertical and horizontal labels.

· Be sure to view Watch: How to Make a Bar Graph in Excel – Tutorial in Module 4: Week 4.

5) Prepare the Mayor's Personnel Budget

· Utilizing the A Mayor's Personnel Budget Worksheet, enter figures for 2023, 2024 and 2025 in the appropriate cells. (Remember to use the inflation calculator and convert the 2023, 2024 and 2025 budgetary figures into 2025 figures and enter the calculated figures into the worksheet.)

For A Mayor's Personnel Budget Worksheet, enter the line-item allocations within that agency’s line item and select following item allocations:

· Salaries

· Health Insurance

· Retirement Expenses

· Social Security Taxes

The expense spreadsheet in this assignment is interactive. Thus, after you enter the appropriate figures in the appropriate cells, the percentages and pie charts will be computed for you with the correct format layout. Consequently, if completed properly, all you must do is to copy, number the chart, and paste the charts in the appropriate place in the Research Paper: Appropriations and Expenses Trend Analysis Template.

6) Analyze the Mayor's Personnel Budget

· Analyze the expenses distribution for A Mayor's Personnel Budget for 2023, 2024 and 2025 (in 2025 dollars) utilizing Excel Tool Pie Chart in the research paper. The pie chart should be labeled appropriately with a chart number, descriptive title, and legend, with each pie slice labeled.

Page 2 of 2