1. Expenditure Analysis in Current Dollars a. You are a fiscal analyst in the ci
ID: 2372482 • Letter: 1
Question
1. Expenditure Analysis in Current Dollars
a. You are a fiscal analyst in the city’s budget office. Complete the currentdollar
portion of Table 4.4 analyzing the Health Department’s expenditures;
use the available data in Table 4.1.
b. Write a memo from you (as a fiscal analyst) to the budget director explaining
the trends.
2. Expenditure Analysis in Constant Dollars
a. In this exercise, you will complete the rest of the spreadsheet in Table
4.4, conducting the same analysis you did above, only you will convert
all the dollars to constant dollars. This exercise allows you to adjust a
Uncorrected page proof. Copyright © 2009 by CQ Press, a division of Congressional Quarterly Inc. No
part of these pages may be quoted, reproduced, or transmitted in any form or by any means, electronic
or mechanical, without permission in writing from the publisher.
TABLE 4.4
Trend Analysis: New York City’s Investment in Health Expenditures, FY 1996 to FY 2007
(in $ thousands)
Current dollars
Actual Percent Actual Percent Percent Actual Percent Percent
Departments FY 1996 of total FY 1997 of total change FY 1998 of total change
Health $419,308 22.9 $420,275 29.0 0.2 $472,030
Mental Health 319,275 17.5 345,284 23.8 8.1 396,095
Hospitals (HHC) 1,090,173 59.6 682,924 47.1 –37.4 684,601
Total health $1,828,756 100.0 $1,448,483 100.0 –20.8 $1,552,726
Total health
as percentage of
New York City’s
expenditures 5.7 4.3
Reference group
New York City’s expenditures $32,066,586 $33,736,152 5.2 $34,923,250
Constant or real dollars (controlling for inflation)
Dept. of Health $576,580 22.9 $564,714 29.0 –2.1
Dept. of Mental Health 439,027 17.5 463,950 23.8 5.7
Hospitals (HHC) 1,499,070 59.6 917,629 47.1 –38.8
Total health $2,514,676 100.0 $1,946,293 100.0 –22.6
Total health
as percentage of
New York City’s
expenditures 5.7 4.3
Reference group
New York City’s expenditures $44,093,957 $45,330,485 2.8
Consumer Price Index 166.9 170.8
Note: HHC = Health and Hospitals Corporation.
Explanation / Answer
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.