County Library IT Budget Instructions: Formatting and Formulas In cell B5, use a sum formula to calculate the total patrons in year 1 (this year) 2 In cell B10, calculate the growth rate for the county budget from last year to year 1 (this year) Format cell B10 as a percent with 2 decimal places In cell F5, calculate the amount of student fees to be used for IT revenue using the total patrons for year 1 (this year) calculation and the dollar amount that IT receives per person. Example: If IT receives $2 per person and there are 200 people, then IT receives $400.00 In cell F6, calculate the revenue that IT receives from the large county budget. IT receives a certain percent of the county budget. Example: if IT receives 5% of the county budget and the county budget is $2000, then IT receives $100 6 In cell F7, write a sum formula to calcualte the total anticipated IT Revenue In cell F8, calculate the IT salary expense. IT Salaries are a percent of the total anticipated IT revenuethat comes from the county budget In cell F12, calculate the total of the IT expenses 9 In cell F13, calculate the net income for the IT department County Library IT Budget Instructions: Formatting and Formulas In cell B5, use a sum formula to calculate the total patrons in year 1 (this year) 2 In cell B10, calculate the growth rate for the county budget from last year to year 1 (this year) Format cell B10 as a percent with 2 decimal places In cell F5, calculate the amount of student fees to be used for IT revenue using the total patrons for year 1 (this year) calculation and the dollar amount that IT receives per person. Example: If IT receives $2 per person and there are 200 people, then IT receives $400.00 In cell F6, calculate the revenue that IT receives from the large county budget. IT receives a certain percent of the county budget. Example: if IT receives 5% of the county budget and the county budget is $2000, then IT receives $100 6 In cell F7, write a sum formula to calcualte the total anticipated IT Revenue In cell F8, calculate the IT salary expense. IT Salaries are a percent of the total anticipated IT revenuethat comes from the county budget In cell F12, calculate the total of the IT expenses 9 In cell F13, calculate the net income for the IT department