Create a spreadsheet of an annual report. This will show revenues and expenditures for two academic years.

Annual Report 2010-2011 2011-2012 Increase(Decrease) Amount % % % Revenues Federal State $ 1,953,326 $ 60,711,574 $ 51,351,571 $ 2,115,082 $ 52,536,753 $ 53,798,276 Local Total Revenues Expenditures Academic Salaries Classified Salaries Employee Benefits Books and Supplies Services Equipment Total Expenditures $ 49,616,383 $ 25,660,794 $ 21,603,406 $ 2,532,135 $ 9,014,479 $ 645,137 $ 47,241,955 $ 25,081,372 $ 20,820,582 $ 2,418,263 $ 9,142,759 $ 780 Excess revenue over(under) expenditures 2011 Expenses Services Equipment Books and Supplies 8% 1% 2% Academic Salaries 45% Employee Benefits 20% Classified Salaries 24%