What agencies are involved in higher education sub-function

Assignment Help Financial Management

Reference no: EM133780497

Homework: Analysis of a Raw Budgetary Database (Excel, Pivot Table, CPI, Outlay & Real XChange)

This part of the homework focuses on the analysis of a raw budgetary database. Please answer the following questions based on the FY24 OMB Table of Outlays sheet

Hints: You should be able to get the required information using Pivot Tables. To calculate all real changes, use the Historical CPI information in the second tab. Please list the data as calculated but be careful when listing your units. NOTE: FY24 OMB Table of Outlays are in thousands of dollars

Present your answer in a succinct and organized way.

A. What is the total outlay for mandatory spending, discretionary spending, and net interest for 2020? What is the real change in 2020 dollars for mandatory spending, discretionary spending, and net interest since 2019? Since 2010?

B. What is the total outlay for the departments (only) of the U.S. Federal Government for 2010.2018, 2019, and 2020? Which department has the largest/smallest outlay (0 or higher) for 2020? For the department with the largest smallest outlays in 2020, what was the real change in 2020 dollars of these outlays since 2019? Since 2010? Qualitatively discuss funding trends (if any) for the departments with the largest and smallest outlays.

C. What was the total outlay for the Legislative Branch for 2020? What is the real change in 2020 dollars for the Legislative Branch since 2019? Since 2010

D. The Director of the OMB has prioritized three government functions for 2020: Health, Higher Education (sub-function) and Defense. In this sense, he has asked you the following questions.

E. What sub-functions does the Department of Health perform and what are the outlays to these for 2020? Which sub-function has the largest/smallest outlay (0 or higher) for 2020? For the sub-function with the largest/smallest outlays in 2020, what was the real change in 2020 dollars of these outlays since 2019? Since 2010?

F. What agencies are involved in the "Higher Education" sub-function? Which agency has the largest/smallest outlay (0 or higher) for 2020? For the agency with the largest/smallest outlays in 2020, what was the real change in 2020 dollars of these outlays since 2019? Since 2010?

G. What agencies are involved in the "Defense" function? Which agency has the largest/smallest outlay (0 or higher) for 2020? For the agency with the largest/smallest outlays in 2020, what was the real change in 2020 dollars of these outlays since 2019? Since 2010?

Reference no: EM133780497

Questions Cloud

Transformational leadership style in your service : How will you employ a transformational leadership style in your service?

Reflect upon your current clinical rotation : Reflect upon your current clinical rotation. If you do not have a current clinical rotation, reflect upon your current or previous clinical experience

History of being late for work : One of your better employees has a history of being late for work. You meet with the employee to discuss the situation and try to correct the problem.

Explain the medical social workers role in healthcare : Explain the medical social workers role in healthcare, as relates to assisting patients and their families. Support your answers with sufficient evidence

What agencies are involved in higher education sub-function : What agencies are involved in the Higher Education sub-function? Which agency has the largest/smallest outlay (0 or higher) for 2020?

Business analyst is performing cost benefit analysis : A business analyst is performing a cost benefit analysis as part of a requirements evaluation task.

Would bob be considered a person with a disability : mitigate the effects of his hearing loss so that his hearing loss is mild. Under the pre-ADAAA interpretation of disability, would Bob be considered a person

Define and apply the terms : Define and apply the terms: List of terms: human subjects research, IRB, Nuremburg code, Declaration of Helsinki

How do physical resources influence the development : How do physical resources influence the development of nursing curriculum.

User Account

All Pages