$1)$ Excel Exercise: Attached is three years of data downloaded from the City$$s annual comprehensive financial report $($ACFR$),$ using the City$$s financial management system. Using a pivot table, summarize expenses by year for the Department of Social Services and the Department of Homeless Services. Using this summary:

a$.$ Calculate the annual average growth rate for each agency.

b$.$ Calculate the percent of personal services $($PS$)$ expenses for each agency by year.

c$.$ Document findings:

i$.$ Which expenses have changed the most? What are some possible reasons for the changes in spending?

ii$.$ What additional information would you ask for to help evaluate spending changes?

Fiscal year As of Actg Period Dept Department Name Object Object Code Description Resp Center Control Category Adopted Budget Total Expense

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $020290001,063,212\mathrm{.}00634,312\mathrm{.}92$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $020390001,912,203\mathrm{.}002,879,125\mathrm{.}00$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $031290000\mathrm{.}00270,635\mathrm{.}70$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $017090004,863,932\mathrm{.}004,746,679\mathrm{.}42$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $0312900014,723,321\mathrm{.}0017,563,802\mathrm{.}31$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $031273001,895\mathrm{.}00281,022\mathrm{.}63$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $03139000291,562\mathrm{.}001,142,371\mathrm{.}96$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $16509000423,774\mathrm{.}000\mathrm{.}00$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $021890006,614,009\mathrm{.}004,747,407\mathrm{.}71$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $11249000982,636\mathrm{.}00691,825\mathrm{.}89$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $010190003,140,912\mathrm{.}004,759,048\mathrm{.}68$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $165173000\mathrm{.}00315,424\mathrm{.}77$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $2263900051,826,676\mathrm{.}0029,979,196\mathrm{.}03$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $130690004,616,683\mathrm{.}004,483,057\mathrm{.}85$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $13699000713,399\mathrm{.}001,182,137\mathrm{.}32$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $1661900012,561,329\mathrm{.}0011,961,594\mathrm{.}40$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $02169000186,313\mathrm{.}00333,450\mathrm{.}48$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $1182900013,054,964\mathrm{.}0011,244,258\mathrm{.}55$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $14199000314,046\mathrm{.}00281,393\mathrm{.}69$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $02189000133,814\mathrm{.}000\mathrm{.}00$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $180490004,110,208\mathrm{.}005,175,427\mathrm{.}59$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $14199000377,081\mathrm{.}00227,472\mathrm{.}16$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $180490002,497,088\mathrm{.}00181,876\mathrm{.}08$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $11829000888,156\mathrm{.}00813,058\mathrm{.}90$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $141990005,102,511\mathrm{.}00616,258\mathrm{.}16$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $1419900053,266,418\mathrm{.}0053,305,275\mathrm{.}59$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $0420900020,823,130\mathrm{.}0019,256,037\mathrm{.}26$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions $0423900016,818\mathrm{.}00826,477\mathrm{.}49$

$202113069$ Department of Social Services $001001$ Full$-$Year Positions