What agencies are involved in the defense function

Assignment Help Other Subject

Reference no: EM133781041

Homework: Analysis of a Raw Budgetary Database

This part of the homework focuses on the analysis of a raw budgetary database. 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

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.

A. 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?

B. 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?

C. 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: EM133781041

Questions Cloud

In what ways has personality changed during intervening year : Consider your own personality from your childhood (e.g., ages 8-10). In what ways has your personality changed during the intervening years?

Discuss how you would prioritize efforts of your cds team : Describe the benefits of using CDS and how it supports decision making. Discuss how you would prioritize the efforts of your CDS team.

How much of this cost should be allocated to each department : How would you allocate the fringe benefits cost between the two divisions? How much of this cost should be allocated to each department?

Complete the design by specifying the values of the control : Complete the design by specifying the values of the control points using 0, 1 or X (don't care) in tables 1, 2, and 3 respectively. Make sure you identify

What agencies are involved in the defense function : What agencies are involved in the Defense function? Which agency has the largest/smallest outlay (0 or higher) for 2020?

Determine the reaction type : Predict the plat ducts in each of the following nuclear reactions and Determine the reaction type (natural transmutation, Artificial transmutation, fission, fus

Analyze the various martech data measurement solutions : Analyze the various MarTech data measurement solutions and select one or two strategies that could support the overall improvement efforts.

Prepare a chart comparing the two companies : Prepare a chart comparing the two companies based on the organizational demand characteristics discussed.

Determining the effect of a new drug to treat brain tumors : Determining the effect of a new drug to treat brain tumors. Determining the incidence of drug abuse in RNs in community hospitals.

User Account

All Pages