[Solved] Due 10/17

Assignment Prompt & Instructions

see attached

**files (6)**

– ## AbbreviatedBudgetMaumelle20252.docx

– ## ResearchPaperAppropriationsandExpensesTrendAnalysisAssignmentInstructions1.docx

– ## AMayorsPersonnelBudgetWorksheet1.xlsx

– ## AGeneralRevenueWorksheet1.xlsx

– ## ResearchPaperAppropriationsandExpensesTrendAnalysisGuide.docx

– ResearchPaperAppropriationsandExpensesTrendAnalysisTemplate1.docx

**## AbbreviatedBudgetMaumelle20252.docx**

PADM 702



Page 2 of 2

## image1.emf

## image2.emf

**## ResearchPaperAppropriationsandExpensesTrendAnalysisAssignmentInstructions1.docx**

PADM 702

**Research Paper: Appropriations and Expenses Trend Analysis Assignment Instructions**

Overview

Agency budgets consist of appropriations spent and expenditures for services delivered. The approved budget becomes an important device to monitor and evaluate spending and service delivery. Budget and finance officers must constantly monitor the relationship between appropriations and expenses. Evaluating agencies assist in understanding budgetary impact and internal infrastructure of efficiency and/or waste.

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.

**You must use the Trend Analysis Template**. You must include citations to a sufficient number of appropriate professional, scholarly, or other appropriate sources to fully support your assertions and conclusions (which will likely require more than the minimum number of citations); each paper must include a minimum of 3 sources per heading, not including the course textbooks, and the Bible.

To successfully complete this assignment, please refer to
**Research Paper: Appropriations and Expenses Trend Analysis Assignment Guide.**

_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.

**## AMayorsPersonnelBudgetWorksheet1.xlsx**

## TSA Budget

| | | | | | | | |
| — | — | — | — | — | — | — | — |
| | Mayor's Personnel Budget (Expenses) | % of Total Expenses | | | Total Expenses in 2025 dollars |
| | | 2023 | 2024 | 2025 | 2023 | 2024 | 2025 |
| | Salaries | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | Health Insurance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | Retirement Expenses | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | Social Security Taxes | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| | Total of Four Major Personnel Expenses | | | | $ – 0 | $ – 0 | $ – 0 |

Comparison of the Four Largest Expense Items in the Mayor's Personnel Budget, 2023

Salaries Health Insurance Retirement Expenses Social Security Taxes 0 0 0 0

Comparison of the Four Largest Expense Items in the Mayor's Personnel Budget, 2024

Salaries Health Insurance Retirement Expenses Social Security Taxes 0 0 0 0

Comparison of the Four Largest Expense Items in the Mayor's Personnel Budget, 2025

Salaries Health Insurance Retirement Expenses Social Security Taxes 0 0 0 0

**## AGeneralRevenueWorksheet1.xlsx**

## Worksheet

| | | | | | | | | | | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| | Maumelle |
| | General Revenues Budget | Line Item | 2023 | 2024 | 2025 | | | Chart 1 |
| | | | Constant Dollars (2025) | Constant Dollars (2025) | Constant Dollars (2025) |
| | | | Total | Total | Total | | | | Chart 1 | | | | | | | | Chart 2 |
| Appropriation Category |
| 1 | Public Safety | Public Safety |
| | | Total Revenues |

| | Percentage | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Appropriation Category |
| 2 | Parks and Recreation | Parks and Recreation |
| | | Total Revenues |

| | Percentage | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Appropriation Category |
| 3 | Senior Services | Senior Services |
| | | Total Revenues |

| | Percentage | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Appropriation Category |
| 4 | Planning and Permits | Planning and Pemits |
| | | Total Revenues |

| | Percentage | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | | | | Chart 3 | | | | | | | | | | Chart 4 |

Percent of Revenues Allocated to Public Safety

2023 2024 2025 0 0 0

Years

Percent of Revenues allocated to Public Safety

Percent of Revenues Allocated to Parks and Recreation

2023 2024 2025 0 0 0

Years

Percent of Revenues allocated to Parks and Recreation

Percent of Revenues Allocated to Planning and Pemits

2023 2024 2025 0 0 0

Years

Percent of Revenues allocated to Planning and Pemits

Percent of Revenues Allocated to Senior Services

2023 2024 2025 0 0 0

Years

Percent of Revenues Allocated to Senior Services

**## ResearchPaperAppropriationsandExpensesTrendAnalysisGuide.docx**

PADM 702

**Research Paper: Appropriations and Expenses Trend Analysis Guide**

_Note- All spreadsheets in this assignment are interactive. That is, after you enter the appropriate figures, the percentages and tables and charts will be computed for you. You will not have to do that. Thus, you will only have to focus on copying and numbering charts and doing the analysis. You must enter the appropriate budget figures in constant dollars (2025) in each of the cells._

Use the
**Research Paper: Appropriations and Expenses Trend Analysis Report Template** found on the assignment page as a template for your report.
**NOTE**: The
_Trend Analysis Report Template_ will serve as the template for your report.
You must use it as is. You are not writing the
_Trend Analysis Report_. It is already written for you. You just need to compute the data, present the charts in a professionally looking format, and analyze the data in the Concluding Analysis section.

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.

·
**When dealing with dollars over time:**

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.

iii.
Open the calculator and enter the year of the data (e.g., 2023, 2024 and 2025), enter the year, the dollar amount, and the current year (e.g., 2025). That will convert all dollar amounts to 2025 dollars, controlling for the impact of inflation. Enter the 2025 dollars (constant dollars) into the excel spreadsheets.

· 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

**ResearchPaperAppropriationsandExpensesTrendAnalysisTemplate1.docx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/researchpaperappropriationsandexpensestrendanalysistemplate1-docx)

**ResearchPaperAppropriationsandExpensesTrendAnalysisTemplate1.docx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/researchpaperappropriationsandexpensestrendanalysistemplate1-docx)

**## AbbreviatedBudgetMaumelle20252.docx**

PADM 702



Page 2 of 2

## image1.emf

## image2.emf

**## ResearchPaperAppropriationsandExpensesTrendAnalysisAssignmentInstructions1.docx**

PADM 702

**Research Paper: Appropriations and Expenses Trend Analysis Assignment Instructions**

Overview

Agency budgets consist of appropriations spent and expenditures for services delivered. The approved budget becomes an important device to monitor and evaluate spending and service delivery. Budget and finance officers must constantly monitor the relationship between appropriations and expenses. Evaluating agencies assist in understanding budgetary impact and internal infrastructure of efficiency and/or waste.

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.

**You must use the Trend Analysis Template**. You must include citations to a sufficient number of appropriate professional, scholarly, or other appropriate sources to fully support your assertions and conclusions (which will likely require more than the minimum number of citations); each paper must include a minimum of 3 sources per heading, not including the course textbooks, and the Bible.

To successfully complete this assignment, please refer to
**Research Paper: Appropriations and Expenses Trend Analysis Assignment Guide.**

_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.

**## AMayorsPersonnelBudgetWorksheet1.xlsx**

## TSA Budget

| | | | | | | | |
| — | — | — | — | — | — | — | — |
| | Mayor's Personnel Budget (Expenses) | % of Total Expenses | | | Total Expenses in 2025 dollars |
| | | 2023 | 2024 | 2025 | 2023 | 2024 | 2025 |
| | Salaries | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | Health Insurance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | Retirement Expenses | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | Social Security Taxes | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| | Total of Four Major Personnel Expenses | | | | $ – 0 | $ – 0 | $ – 0 |

Comparison of the Four Largest Expense Items in the Mayor's Personnel Budget, 2023

Salaries Health Insurance Retirement Expenses Social Security Taxes 0 0 0 0

Comparison of the Four Largest Expense Items in the Mayor's Personnel Budget, 2024

Salaries Health Insurance Retirement Expenses Social Security Taxes 0 0 0 0

Comparison of the Four Largest Expense Items in the Mayor's Personnel Budget, 2025

Salaries Health Insurance Retirement Expenses Social Security Taxes 0 0 0 0

**## AGeneralRevenueWorksheet1.xlsx**

## Worksheet

| | | | | | | | | | | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| | Maumelle |
| | General Revenues Budget | Line Item | 2023 | 2024 | 2025 | | | Chart 1 |
| | | | Constant Dollars (2025) | Constant Dollars (2025) | Constant Dollars (2025) |
| | | | Total | Total | Total | | | | Chart 1 | | | | | | | | Chart 2 |
| Appropriation Category |
| 1 | Public Safety | Public Safety |
| | | Total Revenues |

| | Percentage | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Appropriation Category |
| 2 | Parks and Recreation | Parks and Recreation |
| | | Total Revenues |

| | Percentage | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Appropriation Category |
| 3 | Senior Services | Senior Services |
| | | Total Revenues |

| | Percentage | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Appropriation Category |
| 4 | Planning and Permits | Planning and Pemits |
| | | Total Revenues |

| | Percentage | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | | | | Chart 3 | | | | | | | | | | Chart 4 |

Percent of Revenues Allocated to Public Safety

2023 2024 2025 0 0 0

Years

Percent of Revenues allocated to Public Safety

Percent of Revenues Allocated to Parks and Recreation

2023 2024 2025 0 0 0

Years

Percent of Revenues allocated to Parks and Recreation

Percent of Revenues Allocated to Planning and Pemits

2023 2024 2025 0 0 0

Years

Percent of Revenues allocated to Planning and Pemits

Percent of Revenues Allocated to Senior Services

2023 2024 2025 0 0 0

Years

Percent of Revenues Allocated to Senior Services

**## ResearchPaperAppropriationsandExpensesTrendAnalysisGuide.docx**

PADM 702

**Research Paper: Appropriations and Expenses Trend Analysis Guide**

_Note- All spreadsheets in this assignment are interactive. That is, after you enter the appropriate figures, the percentages and tables and charts will be computed for you. You will not have to do that. Thus, you will only have to focus on copying and numbering charts and doing the analysis. You must enter the appropriate budget figures in constant dollars (2025) in each of the cells._

Use the
**Research Paper: Appropriations and Expenses Trend Analysis Report Template** found on the assignment page as a template for your report.
**NOTE**: The
_Trend Analysis Report Template_ will serve as the template for your report.
You must use it as is. You are not writing the
_Trend Analysis Report_. It is already written for you. You just need to compute the data, present the charts in a professionally looking format, and analyze the data in the Concluding Analysis section.

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.

·
**When dealing with dollars over time:**

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.

iii.
Open the calculator and enter the year of the data (e.g., 2023, 2024 and 2025), enter the year, the dollar amount, and the current year (e.g., 2025). That will convert all dollar amounts to 2025 dollars, controlling for the impact of inflation. Enter the 2025 dollars (constant dollars) into the excel spreadsheets.

· 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

**ResearchPaperAppropriationsandExpensesTrendAnalysisTemplate1.docx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/researchpaperappropriationsandexpensestrendanalysistemplate1-docx)

**## AbbreviatedBudgetMaumelle20252.docx**

PADM 702



Page 2 of 2

## image1.emf

## image2.emf

**## ResearchPaperAppropriationsandExpensesTrendAnalysisAssignmentInstructions1.docx**

PADM 702

**Research Paper: Appropriations and Expenses Trend Analysis Assignment Instructions**

Overview

Agency budgets consist of appropriations spent and expenditures for services delivered. The approved budget becomes an important device to monitor and evaluate spending and service delivery. Budget and finance officers must constantly monitor the relationship between appropriations and expenses. Evaluating agencies assist in understanding budgetary impact and internal infrastructure of efficiency and/or waste.

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.

**You must use the Trend Analysis Template**. You must include citations to a sufficient number of appropriate professional, scholarly, or other appropriate sources to fully support your assertions and conclusions (which will likely require more than the minimum number of citations); each paper must include a minimum of 3 sources per heading, not including the course textbooks, and the Bible.

To successfully complete this assignment, please refer to
**Research Paper: Appropriations and Expenses Trend Analysis Assignment Guide.**

_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.

**## AMayorsPersonnelBudgetWorksheet1.xlsx**

## TSA Budget

| | | | | | | | |
| — | — | — | — | — | — | — | — |
| | Mayor's Personnel Budget (Expenses) | % of Total Expenses | | | Total Expenses in 2025 dollars |
| | | 2023 | 2024 | 2025 | 2023 | 2024 | 2025 |
| | Salaries | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | Health Insurance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | Retirement Expenses | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | Social Security Taxes | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| | Total of Four Major Personnel Expenses | | | | $ – 0 | $ – 0 | $ – 0 |

Comparison of the Four Largest Expense Items in the Mayor's Personnel Budget, 2023

Salaries Health Insurance Retirement Expenses Social Security Taxes 0 0 0 0

Comparison of the Four Largest Expense Items in the Mayor's Personnel Budget, 2024

Salaries Health Insurance Retirement Expenses Social Security Taxes 0 0 0 0

Comparison of the Four Largest Expense Items in the Mayor's Personnel Budget, 2025

Salaries Health Insurance Retirement Expenses Social Security Taxes 0 0 0 0

**## AGeneralRevenueWorksheet1.xlsx**

## Worksheet

| | | | | | | | | | | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| | Maumelle |
| | General Revenues Budget | Line Item | 2023 | 2024 | 2025 | | | Chart 1 |
| | | | Constant Dollars (2025) | Constant Dollars (2025) | Constant Dollars (2025) |
| | | | Total | Total | Total | | | | Chart 1 | | | | | | | | Chart 2 |
| Appropriation Category |
| 1 | Public Safety | Public Safety |
| | | Total Revenues |

| | Percentage | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Appropriation Category |
| 2 | Parks and Recreation | Parks and Recreation |
| | | Total Revenues |

| | Percentage | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Appropriation Category |
| 3 | Senior Services | Senior Services |
| | | Total Revenues |

| | Percentage | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Appropriation Category |
| 4 | Planning and Permits | Planning and Pemits |
| | | Total Revenues |

| | Percentage | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | | | | Chart 3 | | | | | | | | | | Chart 4 |

Percent of Revenues Allocated to Public Safety

2023 2024 2025 0 0 0

Years

Percent of Revenues allocated to Public Safety

Percent of Revenues Allocated to Parks and Recreation

2023 2024 2025 0 0 0

Years

Percent of Revenues allocated to Parks and Recreation

Percent of Revenues Allocated to Planning and Pemits

2023 2024 2025 0 0 0

Years

Percent of Revenues allocated to Planning and Pemits

Percent of Revenues Allocated to Senior Services

2023 2024 2025 0 0 0

Years

Percent of Revenues Allocated to Senior Services

**## ResearchPaperAppropriationsandExpensesTrendAnalysisGuide.docx**

PADM 702

**Research Paper: Appropriations and Expenses Trend Analysis Guide**

_Note- All spreadsheets in this assignment are interactive. That is, after you enter the appropriate figures, the percentages and tables and charts will be computed for you. You will not have to do that. Thus, you will only have to focus on copying and numbering charts and doing the analysis. You must enter the appropriate budget figures in constant dollars (2025) in each of the cells._

Use the
**Research Paper: Appropriations and Expenses Trend Analysis Report Template** found on the assignment page as a template for your report.
**NOTE**: The
_Trend Analysis Report Template_ will serve as the template for your report.
You must use it as is. You are not writing the
_Trend Analysis Report_. It is already written for you. You just need to compute the data, present the charts in a professionally looking format, and analyze the data in the Concluding Analysis section.

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.

·
**When dealing with dollars over time:**

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.

iii.
Open the calculator and enter the year of the data (e.g., 2023, 2024 and 2025), enter the year, the dollar amount, and the current year (e.g., 2025). That will convert all dollar amounts to 2025 dollars, controlling for the impact of inflation. Enter the 2025 dollars (constant dollars) into the excel spreadsheets.

· 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

**ResearchPaperAppropriationsandExpensesTrendAnalysisTemplate1.docx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/researchpaperappropriationsandexpensestrendanalysistemplate1-docx)