7d16172f-e8ef-462c-9e05-5960065bb6f7.xls
3.34 Autotestcon 2.60/(4.60) 3.70 (5.20) Travel IEEE HQ 2002 & Livewire Educ.Activ. Other 3.20 Rcpt from Region 2.70/(4.70) 2.90/(4.90) RadarCon 03 2.20/(4.20) Prof.Activ. 3.10 (5.52) Support Chairman's Publications IEEE Rebate to Regions Discretionary Grants (4.85) 50th Anniversity Project Revenue Line Number Ck. No. Ck. Cleared IEEE Code 2.10/(4.10) Meetings 2.50/(4.50) 2.40/(4.40) Conferences Advertising 2.80/(4.80) Stud.Activ. 3.40 Bank Int. (5.60) Other Expenses Line Number
Starting Balance -- 1 Jan 2005
Date
Balances
Explanation
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
1/1/05 1/5/05 1/5/05 2/7/2005 2/14/2005 2/14/2005 2/14/2005 2/16/2005 2/17/2005 2/19/2005 3/1/2005 3/10/2005 3/24/2005 2/8/2005 3/1/2005 4/6/2005 4/6/2005 4/9/2005 4/17/2005 4/19/205 4/19/2005 4/29/2005 4/29/2005 5/1/2005
6001 6002 6003 6004 6005 6006 6007 6008 6009
x x x x VOID x x x x
3.40 (4.10) (4.70) (5.20) (4.10) (5.60) (4.10) (5.20) (5.60) 3.40 3.40 (4.10) 3.20 3.40 (4.90) (4.90) (4.10) (4.80) (4.80) (4.10) (4.90) 3.40
$148.49 ($6.79) ($250.00) ($400.00)
($200.00) ($161.73) $157.13 $150.93 ($2,000.00) $90.00 $177.26 ($91.69) ($101.35) ($350.00) ($836.90) ($946.69) ($150.00) ($11.94) $164.49
6010
x
6011 6012 6013 6014 6015 6016 6017 6017
x x x x VOID x
$63,148.54 $63,297.03 $63,290.24 $63,040.24 ($45.00) $62,995.24 $62,595.24 $62,595.24 ($7.40) $62,587.84 $62,387.84 $62,226.11 ($6.24) $62,219.87 $62,377.00 $62,527.93 $60,527.93 $60,617.93 $60,795.19 $60,703.50 $60,602.15 $60,252.15 $59,415.25 $59,415.25 $58,468.56 $58,318.56 $58,306.62 $58,471.11 $58,471.11
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Interest Student Officer Lunches at Section Meeting -- Corey Johnson JECA Legislative Reception -- JECA JECA Travel Expenses for 27 Jan Legislative Meeting -- Ron Hackett E-Week Dinner hosted by ASME. 2 tables, 8 per table -- ASME VOID Written for $600 for 3 tables. Accidentally sent the wrong check; must send another. Postage: one book of stamps -- US Postmaster E-Week Dinner: correcting problem described in line 6 by sending an additional $200, from Chair's Discretionary Fund. -- ASME E-Week Plaques: to purchase five plaques thru Will Preussel -- Wholesale Trophies Mailing L50 Form in: signature on delivery -- Mail Pro Interest Interest Alabama Science & Engineering Fair (ASEF) one-time Category Level sponsorship IEEE Senior Member Program: $10 Rebate to the Section for each new Senior Member Interest Awards for Professional of the Year and Jim Anderson from Wholesale Trophies -- Keith Jadus Alabama Science & Engineering Fair (ASEF) Tent Cards & Supplies purchased at Staples -- Frank Parris Alabama Science & Engineering Fair (ASEF) Awards: 7 ea. $100 Savings Bonds reimbursement to Courtney Spivey, purchased at RFCU Travel Expenses for South East Conference 2005 -- reimbursed to Will Goins VOID: Made a mistake filling out the check. Travel Expenses for South East Conference 2005 -- reimbursed to Willie Fitzpatrick EMC April Meeting with door prizes -- Paul Stover EMC April Meeting with door prizes: cost of certificates, which exceeds current EMC budget. -- Paul Stover Interest Ending Balance -- 1 June 2005
Bank Reconciliation: Statement Date: May-05 $58,468.56 ($58,471.11) ($161.94) $164.49 $0.00
Closing Balance (Bank) (-) Treasury Balance (-) Checks Paid # 6017 (+) Revenue 5/1/05 Reconciled (if = $0.00)
Page 1
Budget Comparison
IEEE Huntsville Section 2005 Final Budget Line IEEE Number Code Budget Amount $ 63,148.54 Actual Starting Balance (As Of 1 Jan 2005)
Estimated Revenues
Explanation
1 2 3 4
2.40 3.10 3.40 3.20
$ Advertisement in the Huntsville Section LiveWire $ 7,400.00 IEEE Dues Rebate (Safe) $ 800.00 Bank Interest (Safe) $ 90.00 Region 3 New Senior Membership Rebate ($10/ea) $ 8,290.00 Estimated Revenue Sub-Total
Estimated Expenses
4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 28 29 30 36 31 32 33 34 35 36
(4.10) (4.10) (4.10) (4.10) (4.10) (4.10) (4.10) (4.10) (4.10) (4.10) (4.10) (4.10) (4.40) (4.60) (4.60) (4.60) (4.60) (4.70) (4.70) (4.70) (4.70) (4.70) (4.80) (4.80) (4.90) (5.20) (5.20) (5.52) (5.60) (5.60) (5.60) (5.60) (4.10)
$ (150.00) $ (150.00) $ (150.00) $ (150.00) $ (150.00) $ (150.00) $ (150.00) $ (150.00) $ (360.00) $ (800.00) $ (125.00) $ (200.00) $ (200.00) $ (800.00) $ (1,000.00) $ (400.00) $ (1,000.00) $ (50.00) $ (75.00) $ (250.00) $ (250.00) $ (600.00) $ (500.00) $ (6,000.00) $ (400.00) $ (200.00) $ (200.00) $ (500.00) $ (400.00) $ (100.00) $ (15.00) $ (200.00) $ (2,000.00) $ (17,825.00)
EMC Society Meetings Engineering Management Society Meetings Computer Society Meetings Control Society Meetings Aerospace & Electronics Society Meetings JCAM Society Meetings GOLD Committee Activities Section Meetings (1 Lecturer) UAH and Alabama A&M Student Officer Lunches (2 students from each university for 9 board meetings) Engineers Week Activities & Plaques Expenses Science Fair Judges Banquet Tickets HATS Professional of the Year Award Dinner and Plaque Expenses IEEE Huntsville Section Website Science Fair Awards (16 $100 Savings Bond) HATS-STEDTRAIN Seed Grant Money Future City Competition Awards K-12 Robotics Competition Educational Grant Money PACE Activities HATS Dues JECA Dues JECA Legislative Reception IEEE USA Leadership Workshop (Send 2 People) Alabama A&M Activities UAH IEEE Student Branch & UAH Senior Design Class -- SOUTHEASTCON '05 Robotics competition Chairman's Discretionary Fund Travel allowance for JECA Travel and Hotel allowance for JECA Legislative Reception IEEE Section Congress Travel LCD Presentation Projector Spare Bulb & Extension Cord Office Supplies Stamps for Paying Bills Guest Speaker Gift Alabama Science & Engineering Fair "Category Level" sponsorship Estimated Expense Sub-Total
$ (9,535.00) Estimated Increase or Decrease to Budget $ 53,613.54 Estimated Ending Projected Balance for Dec 2005
Page 2
Budget Comparison
Budget Changes Due to Approved Motions:
Feb 05 Mar 05 Mar 05 Mar 05 Mar 05 Line 36: Add Budget line for JECA Travel Allowance: $200.00 -- Action Item 149 Line 27: Increase E-Week Budget from $600 to $800 for additional plaques and attendees; ExCom 3/2/2005 Minutes item #3. Line 14: Increase budget to $125 for 5 total meals; ExCom 3/2/2005 Minutes item 16(c) Line 28: Increase budget by $4,000 to send four ExCom members to SECON '05: ExCom 3/2/2005 Minutes Item 16(d) Line 36: Add Budget line for one-time Category Level Sponsorship ($2,000.00) of Alabama Science & Engineering Fair (ASEF), approved by online vote.
Page 3
Budget Comparison
Line Number
Actual Revenue / (Expense)
Expense Delta (+) = Over Spent (-) = Budget Remaining
Revenue Delta (+) = Additional Revenue (-) = Less than Expected
1 2 3 4
$0.00 $0.00 $798.30 $90.00
$0.00 ($7,400.00) ($1.70)
4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 28 29 30 36 31 32 33 34 35 36
($150.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($6.79) ($761.73) $0.00 $0.00 $0.00 ($350.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($250.00) $0.00 $0.00 ($1,783.59) ($204.98) $0.00 ($45.00) $0.00 $0.00 $0.00 ($13.64) $0.00 ($2,000.00)
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
(150.00) (150.00) (150.00) (150.00) (150.00) (150.00) (150.00) (353.21) (38.27) (125.00) (200.00) (200.00) (450.00) (1,000.00) (400.00) (1,000.00) (50.00) (75.00) (250.00) (600.00) (500.00) (4,216.41) (195.02) (200.00) (155.00) (500.00) (400.00) (100.00) (1.36) (200.00) -
Page 4
Budget Comparison
Page 5
Budget Comparison
Budget Revenue / (Expense) By Month Line Number Jan-05 Feb-05 Mar-05 Apr-05 May-05 Jun-05
1 2 3 4
$148.49
$157.13
$150.93 $90.00
$177.26
$164.49
4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 28 29 30 36 31 32 33 34 35 36
($150.00)
($6.79) ($761.73)
($350.00)
($250.00)
$0.00 ($45.00)
($1,783.59) ($204.98)
($13.64) ($2,000.00)
Page 6
Budget Comparison
Page 7
Budget Comparison
Line Number
Jul-05
Aug-05
Sep-05
Oct-05
Nov-05
Dec-05
1 2 3 4
4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 28 29 30 36 31 32 33 34 35 36
Page 8