1 / 29

SCHH Computer Club

SCHH Computer Club. Treasurer’s Report February 8, 2007. Feb 1, 2007 Opening Balances. Liberty Bank Checking $10,150.76 Treasury Bills $80,000.00 Petty Cash $ 36.21 TOTAL FUNDS – 01/01/06 $90,186.97. January 2007 Income. Membership Dues $5,820.00

arsenio-marquez
Download Presentation

SCHH Computer Club

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SCHH Computer Club Treasurer’s Report February 8, 2007

  2. Feb 1, 2007 Opening Balances • Liberty Bank Checking $10,150.76 • Treasury Bills $80,000.00 • Petty Cash $ 36.21 TOTAL FUNDS – 01/01/06 $90,186.97

  3. January 2007 Income • Membership Dues $5,820.00 • Education Classes $1,260.00 • Printing Fees $ .00 • Interest Income • Treasury Bills $ 313.88 • Liberty Bank $ 6.16 TOTAL INCOME $7,400.04

  4. January 2007 Expenses • Administration $ 82.44 • Hardware $ 368.27 • Printer Supplies $ 51.34 • Software $ 194.10 • Subscriptions $ 48.00 TOTAL $ 744.15

  5. January 2007 Treasury Bill Activity • Opening Balance $ 80,000 • February2006 Additions $ 5,000 • End of February Balance $ 85,000

  6. January 31, 2007 Balances • Liberty Bank Checking $ 16,806.56 • Treasury Bills $ 80,000.00 • Petty Cash $ 36.21 TOTAL FUNDS – 1/31/07 $ 96,842.86

  7. SCHH Computer Club 2007 Budget

  8. 2007 Opening Balances • Liberty Bank Checking $10,150.76 • Treasury Bills $80,000.00 • Petty Cash $ 36.21 TOTAL FUNDS – 01/01/06 $90,186.97

  9. 2007 Planned Income • Membership Dues $22,000 • Education Classes $ 5,500 • Printing Fees $ 600 • Interest Income • Treasury Bills $ 3,800 • Liberty Bank Checking $ 50 TOTAL INCOME $31,950

  10. 2007 Planned Expenses [1 – 2] • Administration $ 445 • Education $ 1,350 • Hardware $ 9,580 • Membership $ 315 • Printing $ 1,025 • Printer Supplies $ 1,065 • Program $ 2,090

  11. 2007 Planned Expenses [2 - 2] • Software $ 5,091 • Computer Room Cleaning $ 1,550 • Special Events $ 4,950 • Subscriptions $ 760 TOTAL EXPENSES $28,221 TOTAL GAIN $ 3,729

  12. 2007 Year-End Balances • Liberty Bank Checking $ 9,890.36 • Treasury Bills $ 85,000.00 • Petty Cash $ .00 TOTAL FUNDS – 12/31/07 $ 94,890.36

  13. Key Issues for 2007 • Budget for New Computer Club Room [Est. Late 1st Quarter 2008 Install] • Develop Budget for Reserve Requirements • Review Annual Dues Rate Again

  14. SCHH Computer Club Proposed Budget New Computer Room

  15. Supplied By Del Webb/Pulte • A Large Room [46ft X 26ft] • Walls • Ceiling with Connections for Mounted Projector • Two Lockable Closets [6ft X 6ft] • Lighting w/Dimmers • Electrical Outlets • A Folding Partition to Allow Separate Classroom • A Raised Floor [Allows Wiring to be Hidden]

  16. Computer Club Requests • DSL & Cable TV outlets • Phone Outlet at Monitor Desk • Heavy Duty Air Conditioning – Power Usage • Dimmable Lighting • Opaque Back on Showcase [Limit Light] • Install Ceiling Mounted Projector & Projection Screen • Raised Flooring • Folding Wall to Establish Two Rooms, when Needed

  17. 3 ½” OD Cable Chase in wall (for future needs) PC, Mac, or Space for Laptop Laser Printer Scanner & Photo Printer 110 VAC 20 A (most under raised floor) 45’ 6” ID 16’ 8” ID 28’ 6” ID Folded Wall Monitor Storage Room Phone 5’ 6” 3’ 8” Clock outlet and hanger above door Folding Wall Printing Supplies Underneath 29’ 4” ID 5’ 30” 5’ 30” 5’ 30” 6’ Screen 5’ 4” In ceiling for projector 4’ 8” Showcase Clock outlet and hanger on wall Instructor 7’ Storage Cab (Desk Height) Storage Room

  18. What Do We Need to Buy? • New Workstation Furniture [Tables & Chairs] • New Cabinets for Printers/Scanners • New Computers [Est. 20 PCs and 3 MACs] • New & Upgraded Software • New Printers / Scanners • Cabling, Routers, UPS, and Surge Protectors • Mountable Projection Screen

  19. What Will Furniture Cost? • Workstations • Two Station Tables [18 @ $438] $ 7,884 • Work Station Chairs [32 @ $173] $ 5,536 • Storage Cabinets [3 @ $800] $ 2,400 FURNITURE TOTALS $15,820

  20. What Will Computers Cost? • Computers • PCs [Primarily Desktops] • 20 @ $2,000 $ 40,000 • MACs • 3 @ $2,500 $ 7,500 TOTAL COMPUTERS $ 47,500

  21. What Will Software Cost? • Software • Office Suite • 23 @ $147 $ 3,381 • Other Software • New & Upgrades $ 2,500 TOTAL SOFTWARE $ 5,881

  22. What Will Electric & Network Cost? • Electrical • Surge Protectors [16 @ $269] $ 4,304 • UPS [24 @ $98] $ 2,352 TOTAL ELECTRICAL $ 6,656 • Networking • Routers [2 @ $295] $ 590 • Cabling [ 36 @ $10] $ 360 TOTAL NETWORK $ 950

  23. What Will Miscellaneous Cost? • Miscellaneous • Projection Screen $ 1.239 TOTAL MISCELLANEOUS $ 1,239

  24. Cost Summary • Furniture $ 15,820 • Computers $ 47,500 • Software $ 5,881 • Electrical $ 6,656 • Networking $ 950 • Miscellaneous $ 1,239 • Tax & Shipping $ 2,500 GRAND TOTAL $ 80,546

  25. Annual Estimated Reservesfor Replacement and Upgrade

  26. Reserve Budget • Normal Replacement Cycle for Computers is 3 – 4 Years • CAM also notes that the Basic Insurance Policy for stolen or destroyed assets has a very high deductible. [ie Don’t Plan on It] • SCHHCC needs to plan for this contingency by Developing a Reserve Fund that will meet these replacement and upgrade needs.

  27. Reserve Budget [2 – 2] • Computers [Replace 6 per year] • Per Unit Cost $2000 $ 12,000.00 • Software Periodic Upgrades [O/S & Office] • Every 5 Years at $150 per $ 4,500.00 • Annual Reserve Requirement $ 8,000.00

  28. Reserve Budget [Time Phased] • 2007 $0,000 $00,000 $10,000 • 2008 $8,000 $00,000 $18,000 • 2009 $8,000 $00,000 $26,000 • 2010 $8,000 $12,000 $22,000 • 2011 $8,000 $16,500 $13,500 • 2012 $8,000 $12,000 $ 9,500 Start 2008 with an Estimated $10,000. Start Budgeting in 2008. Review Reserve Amount in 2011

  29. Any Questions or Comments?

More Related