Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

formula for excel cell g2 H Year 3 Co 1 Patrons-Year 1 Information Technology-Year 1-Year 3 Projected Budget - County Libraries 2. Smith Law Library

formula for excel cell g2 image text in transcribed
H Year 3 Co 1 Patrons-Year 1 Information Technology-Year 1-Year 3 Projected Budget - County Libraries 2. Smith Law Library 300000 Number Library Patrons for Smith, Valey & King 735000 3 Valey Center Library 250000 Year 1 (This Year) Year 2 4 King Library 125000 County Budget $ 214,000,000 5 Total patrons for Year 1 This Year) 735000 IT Revenue from Student Fees $ 1653 750 6 County Budget for Last Year 5208,650,000 IT Revenue From County Budget $ 5.350,000 7 T Revenue of County Budget 0025 Total Anticipated IT Revenue S 7003750 & Salaries of Total Revenue) 027 IT Salaries 5 1,891,013 9 Student Fees Per Persen 2.25 Training and Maintenance Contracts $575,500 10 County Budget Growth Rate (Last Yr This Y 2:56 Software Licenses and Hardware $587,500 11 Expenses growth rate 0.04 Miscellaneous IT Anticipated Expenses $3.548,600 12 Patrons growth rate -001 TotalAnticipated IT Expenditures s 6.802,613 13 Total Net Income 5 401,138 14

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental accounting principle

Authors: John J. Wild, Ken W. Shaw, Barbara Chiappetta

21st edition

1259119831, 9781259311703, 978-1259119835, 1259311708, 978-0078025587

Students also viewed these Accounting questions