What constitutes the various forms of plagiarism and to avoid all forms of plagiarism.

OVERVIEW
Agency budgets consists 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 assists in understanding budgetary impact and internal infrastructure of efficiency and/or waste.
INSTRUCTIONS
For this assignment you will write a 7-pages (not including title page, reference page, charts/ graphs/ pictures and any appendices). More specifically, you will need to:
1) Compute and create tables and charts to analyze a three-year trend (2015, 2016, 2017) of selected appropriations and expenses for agencies within the Department of Homeland Security
2) Using the tables and charts, write a 7 paged, double-spaced, research paper that discusses and analyzes the relationship between appropriations and expenses.
The paper must be in current APA format with 1-inch margins and 12-pt Times New Roman font. You must also include a title page and reference page. 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 contain citations to the course texts book, assigned readings, and a minimum of 5 additional sources not including the course textbooks, assigned readings, and the Bible.
To successfully complete this assignment, please refer to Assignment Resource: Appropriations and Expenses Trend Analysis Assignment Guide.

Note: Your assignment will be checked for originality via the SafeAssign plagiarism tool.
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.

ASSIGNMENT RESOURCE: APPROPRIATIONS AND EXPENSES TREND ANALYSIS ASSIGNMENT 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, your will only have to focus creating charts and doing the analysis.
The spreadsheets sometimes contain budgetary figures for illustrative purposes. You must enter the appropriate budget figures in constant dollars (2020) in each of the cells.
1) Open and save the Assignment Resource: Appropriations Trend Analysis Worksheet.
2) Prepare the Appropriations Data for U.S. Department of Homeland Security
You will open and save the Assignment Resource: Abbreviated Budget Department of Homeland Security
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.
ii. The easiest way to do that is to use an inflation calculator, such as the Assignment Resource: U.S. Inflation Calculator.
iii. Open the calculator and enter the year of the data (e.g., 2015, 2016, 2017), enter the year, the dollar amount, and the current year (e.g., 2020). That will convert all dollar amounts to 2020 dollars, controlling for the impact of inflation. Enter the 2020 dollars (constant dollars) into the excel spreadsheets.
Look at the Total Budget Authority and enter the Total Budget (in 2020 dollars) into the excel spreadsheet for each of the three years.*
Look at the U.S. Immigration and Customs Enforcement (CAS-ICE) and enter the Total Appropriations (in 2020 dollars) into the excel spreadsheet for each of the three years. *
Look at the Transportation Security Administration (CAS-TSA) and enter the Total Appropriations (in 2020 dollars) into the excel spreadsheet for each of the three years.*
Look at the U.S. Coast Guard and enter the Total Appropriations (in 2020 dollars) into the excel spreadsheet for each of the three years.*

3) Analyze the Appropriations Data for Department of Homeland Security
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, title, and legend.
Be sure to view the Assignment Resource: Video: How to Make a Bar Chart in Excel.

4) Prepare the Expense Data for The U.S. Department of Homeland Security
Utilizing the Assignment Resource: Expenses Trend Analysis Worksheet enter data for the five (5) line-item expenses in the example below for Transportation Security Administration (CAS-TSA) for 2015, 2016, and 2017.*
5) Analyze the Expense Data
Analyze, the expenses distribution for the Transportation Security Administration (CAS-TSA). for 2015, 2016, and 2017 utilizing Excel Tool Pie Chart in the research paper. The Pie Chart should be labeled appropriately with a title and legend.*
Example: for the U.S. Department of Homeland Security, analyze the three-year budgetary allocations for the Transportation Security Administration (CAS-TSA). So, look at the line-item allocations within that agencys line item and select four-line items allocation as follows:

Be sure to view the Assignment Resource: Video: How to Make a Pie Chart in Excel.

6) Use the Assignment Resource: Trend Analysis Report found in the assignment as a template for your report.

*Note- Remember to use the inflation calculator and convert the 2015, 2016, and 2017 budgetary figures into 2020 figures and enter the calculated figures into the spreadsheet.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]