HAL-PC Treasurer's Report -- May 1997 (unaudited)


TREASURER'S REPORT
PERIOD: May 31, 1997	PREPARED: June 24, 1997 
PREPARED BY: Lou Ann Coy	REVIEWED/APPROVED BY Mike Novominsky, Treasurer

This TREASURER'S REPORT with the Balance Sheet & Statement of Revenues and Expenses 
is posted monthly on the BBS in the HAL Politics Section in a message from the
treasurer attached in uncompressed format at the time that it's submitted for
inclusion in the monthly Board of Directors (BOD) meeting packet.  The entire report
with all attachments is posted on the BBS in the HAL BOD Section in text format.
The report is included in the Agenda sent to the BOD and the full report with all
statements is included in the Minutes of the Meetings of the Board of Directors
maintained in the HAL-PC Offices.
====================================================================================
== OVERVIEW == I DO NOT REVIEW ALL CKS, INVOICES, ETC., IMPERATIVE WE ALL REVIEW ===
   1.  Revenue deferrals to be calculated monthly, now affecting (ouch!) both annual dues 
       and Internet monthly fees.
   2.  In spite of revenue deferrals, YTD revenues top the one million mark!!
   3.  Internet monthly/setup fees constitute 52.7% of total YTD revenues.
   4.  Cash increasing, T-Bills purchases halted to build up cash reserve.
       MUST INCREASE MEMBERSHIP IMMEDIATELY. 
   5.  Dues $89,400 behind budget, Internet setup fees $23,000 behind budget.
   6.  Accounts Receivable for Caere 4/95 $1500 real old. Should we write off?
   7.  Should revise By-Laws to have Treasurer's Report at General Meeting in August.
=====================================================================================
BUDGET-------------------------------------------------------------------------------
     All references to budget are to final budget. THE BUDGET: $1,076,773 Revenues, 
       $715,271 Expenses, $2,000 Scholarship, $322,702 Cap. Addns.
       Non-Internet Loss $-20,000, Internet Profit $56,800, Total Profit $36,800
BALANCE SHEET (Comparative, Year to Year) -------------------------------------------
   1.  Cash - Up $77,687 from a year ago & up $33,843 from last month.
   2.  Fund Balance - Down $8,670 from a year ago & up $27,412 from last month.
   3.  Fixed Assets - Budgeted equipment purchases of $10,608 were made this month 
       to bring total purchases YTD to $458,933.
STATEMENT OF REVENUES AND EXPENSES (YTD vs. Annual Budget) --------------------------
   1.  Gain this month: $27,412 ($6,505 GAIN non internet, $20,907 GAIN internet)
       YTD: $8,670 LOSS ($43,892 LOSS non internet, $35,221 GAIN internet)
   2.  Presentation Fees, Gen. Mtg. - Annual budget $48,000, vs. $70,865 YTD.
   3.  Annual Dues - ($33,288) this month vs. annual Budget of $469,567 vs. $380,167 YTD.
       This year dues:  $30,416-Jun 96, $32,976-Jul 96, $35,103-Aug 96, $39,493-Sep 96,
       $37,095-Oct 96,  $31,506-Nov 96 [-$6,155]-Nov Def Adj., $28,715-Dec 96.
       $54,342-Jan 97,  $43,301-Feb 97, $41,793-Mar 97, $34,776-Apr 97, [-$57,243]-Def.
       Adj., $33,288-May 97
       YE 5-31-96 dues: $22,460-Jun 95, $21,687-Jul 95, $28,583-Aug 95, $41,326-Sep 95,
       $27,111-Oct 95,  $32,719-Nov 95 [-$6,471]-Nov Def Adj, $27,665-Dec 95,
       $36,587-Jan 96,  $40,133-Feb 96, $28,390-March 96,
       $26,765-Apr 96,  $27,780-May 96, [-$32,445]-May 96 Def. Adj.
STATEMENT OF SOURCE AND USE OF FUNDS (Month vs. Same Mo. Last Yr - NO COMMENTS THIS MONTH.
CHECK REGISTER (All May 1997 Checks, Sorted by Check Number,)---
   1.  Last check reported prior month:  6949
   2.  Checks reported this month, w/missing numbers 6953 and 6954:
	NationsBank - 1074 through 1127; 6950 through 6970
   3.  Checks Voided - 1074, 1090, 1092, 1097, 1106, 1120, 1123, 6955, 6961, 6963 and 6967
INVOICE DISTRIBUTION LIST (All Current Invoices, Showing Account & Department Charged. -
   Everything paid through A/P is included.  report doesn't generate a total, but when 
   added up, matches the total "Original Balance" of the accounts payable detail report.)
   NO COMMENTS THIS MONTH.
SPECIAL REPORT - STATEMENT OF REV. AND EXP. (YTD vs. Budget), DEPT 21, INTERNET------
       Gain this month: $20,907 vs YTD gain of $35,221 vs. annual budget of $56,800.
       Equipment purchases -month $6,217 -YTD $384,701 vs annual budget of $227,000.
       Monthly fee revenue of $401,796 YTD vs. annual budget of $330,000 
       Setup fees of $169,140 YTD vs. annual budget of $192,000.
BUDGETED EQUIPMENT PURCHASES - See next page-----------------------------------------
DEPARTMENT NUMBER LISTING - Included in this report for reference purposes - 
   Use in conjunction with reading the INVOICE DISTRIBUTION LIST.
   10  General & Adm. 20  Bulletin bd.  32  Member Services  40  User Journal
   11  Headquarters   21  InterNet      33  Scholarship      41  Software Lib. 
   12  Board of Dir.  22  Sig coord.    34  Special events   43  Press Relations
   13  Treasurer      30  General meet. 35  Texas Tech. Fair 50  Membership
   14  Recording Sec. 31  Exh. sales    52  Election         60  Daytime classes
DEPOSIT ACCTS.  Nations oper - $150,065; Pru MM $189,299, Pru T-Bills 2@ $50,000, 
     In Dec (12th) the first of the T-bills reached maturity, now monthly through July
   A/R STATUS 5-31 Balance $21,857 (Ask Me 4/97 $1,500, AskSam 10/97 $1,249, Caere 4/95
     $1,500, ComputerExpo 12/96 $25, Corel 4/97 $2,917, Diskettes 2/97 $780, Inter-Tel
     5/97 $2,917, Lee 6/97 $40, Microtek 6/97 $1,458, Telescan 5/97 $1,667, TI 3/97 $991,
     TRI 3/97 $3,333, U of H 5/97 $355, Wall 6/97 $1,667, Xerox 3/97 $1,458)
     In June, Corel and Xerox paid.
REFERENCE -------------------------------------------------------------------------
   Phones:  HAL-PC office (713)993-3300, fax (713)623-4251. 
      Lou Ann Coy (713)697-7241, pgr (281)262-9173, louann@hal-pc.org
      Mike Novominsky (H) (713)771-2772 (W) (713)621-3022, mikejn@halpc.org,
           fax (713)621-1099
      Ray Shasteen (H/W) (713)465-7084
      CPA-Phil Salchli, (281) 496-3020
      Mel Babb (H) (713)952-3374 (W) (713)785-6550
      Ray Morris (281)447-1616
      Milt Eberhardt (281)376-3975
      Larry Dillard pgr (713)909-6734
      Pru a/c 021-969508, John Hinman (713)650-4702 e-mail john541@aol.com
      Nations a/c 60782-4231-3, C Hunter (713)247-6547, Lockbox - K Wilder (214)508-7262
      Insurance - Deborah Foster (713)984-1988, fax (713)984-2295
      Jack Safley (713)666-2122
      State Tax Kim Bridges, (713)868-9112


TREASURER'S REPORT

The purpose of this schedule is to compare NEW BUDGETED EQUIPMENT PURCHASES 
to actual expenditures. Note that the Total Actual and Total Budget amounts 
for internet and total agree to the amount shown on the income statement for 
Budgeted equipment purchases under Other Income & Expense.

BUDGETED EQUIPMENT PURCHASES
Ck    Date  Payee       For                Actual      Budgeted  Area  Comments
----   -----  ---------- ----------------- ---------  ---------- -----  -------
INTERNET 
           Budget                                     227,000.00 
6242   06-04  NATIONSB   Tape Backup        1,338.00
6257   06-07  U.S.       Stolen Modem         262.50
6268   06-20  Joel Rubin Ethernet Cards       207.00
6288   06-25  U.S. Robo  30 Courier to 180  7,920.00
6276   06-30  OMNI-TEQ   486 cooling fan        5.00
6322   06-30  CAPELLA    Portmaster #7      2,951.00
6317   07-03  BASS       30 Courier to 210 12,700.00
6321   07-11  BOYD       swap to E.D.O. Ram    32.00
6329   07-16  CABLE &    Cables                95.00
6346   07-17  PC         Coax Hub +         1,844.00
6363   07-30  INFOMAX    Server cases         350.00
6384   07-31  CAPELLA    Portmaster #8      2,911.00
6389   08-08  HUPP       used ISDN B/U Box    700.00
6400   08-22  CAPELLA    30 Courier to 240 10,178.00
6401   08-22  DASKO      Cables               210.00
6405   08-22  OMNI-TEQ   2 Pent, Mon, Ram   8,449.00
6418   08-29  OMNI-TEQ   16 meg Ram           220.00
6440   08-31  OMNI-TEQ   SCSI 8x CD           320.00
6434   09-06  NATIONSB   Cabinet Rack       2,750.00
6457   09-13  TEXASNET   Transformers       1,023.60
6470   09-20  CAPELLA    Exp Server         2,904.00
6474   09-27  LEIMER     Network card         106.09
6480   09-30  CAPELLA    32 Couriers to 270 7,761.00
6490   09-30  OMNI-TEQ   Video Card           345.00
6494   09-30  TEXASNET   Modem Racks        8,506.40
6507   09-30  ELECTORT   BNC"T" 2 Fem          95.55
6515   09-30  OMNITEQ    Parts                308.00
6499   10-07  RESOURCE   Tape drive         1,626.00
6502   10-10  TEXASNET   2 Portmasters      4,300.00
6514   10-12  MOORE      2 SCSI Hard Drives 1,708.00
6535   10-25  MOORE      Hardware, Cables,    142.06
6536   10-31  PI         6 ft molded          232.22
6583   11-14  INSYNC     ADC Kentrox CSU    3,350.00
6622   12-04  CABLE      Cables/connectors  1,775.00
6636   12-31  STERLING                     13,525.00
6657   12-31  OMNI-TEQ   News Array/Server  5,885.00
6674   12-31  CAPELLA    30 Courier         7,273.00
6697   12-31  CAPELLA    2 Courier I-modem    645.00
6700   01-17  CURRENT    3" conduit         1,057.46
6708   01-17  MOORE      2 4-Gig            2,013.45
6714   01-21  STERLING   Start Up of EPE    8,876.00
101    02-06  ASCEND     Digital System   209,162.56
6780   02-14  DILLARD    UPS Switch         1,367.50
6786   02-14  CURRENT    " conduit           826.38
6816   02-28  STERLING   Grounding System   1,177.49
6874   03-17  LEGGETT    BayNetworks        2,599.00
6891   03-18  STERLING   Install Ground Bar 2,400.00
6892   03-19  DILLARD    Baystack 301 swtch 2,451.00
6904   03-24  MOORE      Dlink Combo Lan Crds 120.00
       03-24             Modem Sales         (496.29)
1008   03-31  CABLE &    Micro 10base Trnscvr 173.00
1020   03-31  ASCEND     P25-PX BRI (U) Systm 739.58
1053   04-28  OMNI-TEQ  Diamond Stealth 64/4M 195.00
6930   04-01  AMERICAN    Generator       12,175.00
1031   04-28  ASCEND     Pipeline 75 BRI    4,874.40
1053   04-28  OMNI-TEQ   4 SCSIs, Pentiums 12,342.00
1034   04-28  CAPELLA    Courier I-modem      335.00
1070   04-30  OMNI-TEQ   Dialup testing     4,434.00
1050   04-28  MOORE      Controller card      303.00
1060   04-30  CABLE &    8p mod plugs          84.80
                         Modem sales       (3,680.00)
1076   05-17  LEGGETT    Bay Networks       3,055.00
1082   05-19  ASCEND     Pipeline 75 BRI    1,223.70
1099   05-20  OMNI-TEQ   spares             2,894.00
6956   05-10  EMERGING   4 Port T1          2,163.00
6962   05-10  ONE 800    Controller         1,643.24
                         Modem sales       (5,719.54)
1139   06-10  OMNI-TEQ   Giga-Byte; Jaz       958.00
                                           ---------  ----------
     TOTAL FOR INTERNET                   384,701.15  227,000.00

NON INTERNET
Budget                                                 95,702.00 
6286   06-25  BASS       4 Pentium cmptrs   5,548.00              60 Daytime
6345   07-17  OMNI-TEQ   Pentium 586DX133   2,374.00              10 G&A
6319   07-05  BASS       4 USROBOTICS-28.8    580.00              22 SIGs
6315   07-03  OMNI-TEQ   MONITOR/850HD/486  1,324.00              22 SIGs
6435   08-31  OMNI-TEQ   2 Mon, 2 surges      730.00              60 Daytime
6460   09-14  BASS       Computer &         2,396.50              30 Gen. Mtg.
6495   10-03  MADEIRA    UPS Systems        1,028.19              10 G & A
6514   10-12  MOORE      Barracuda          2,820.00              20 BBS
6521   10-14  NATIONSB   BBS Software       2,181.00              20 BBS
6522   10-14  OMNI-TEQ   BBS Hardware       4,930.00              20 BBS
6587   11-14  MOORE      SIG Room "D"         835.00              22 SIGs
6632   12-08  MOORE      5 Seagate 4.3GB    6,502.07              20 BBS
6671   01-08  LEGGETT    Telephones         3,900.00              10 G&A
6702   01-17  FINGER     Chairs             1,950.00              22 SIGs
6703   01-17  SURPLUS    50% office furn    3,500.00              10 G&A
6813   01-31  OMNI-TEQ   Upgrade            1,545.00              60 Daytime
6749   02-01  SURPLUS    balance office fur 4,004.80              10 G&A
6776   02-10  BASS       ADI Monitors       1,200.00              22 SIGs
6814   02-27  MICRO CO   Monitor repairs      219.75              22 SIGs
6839   02-28  FINGER     Chairs             1,810.00              22 SIGs
6860   02-28  OMNI-TEQ   2 Pentiums         2,198.00              60 Daytime
6894   03-22  DMI        Flooring           9,850.00              10 G&A
6908   03-24  OMNI-TEQ   Parts for Inet mchns 860.00              22 SIGs
6916   03-27  OMNI-TEQ   Upgrades           3,864.00              60 Daytime
       03-31             Clear Lake assets  2,147.36              70 Clear Lake
1063   04-30  PC MAX     AMD K5-133 CPU Chip  969.00              70 Clear Lake
1103   05-24  BASS       AMD K5-166 CPU       124.50              30 GM
1104   05-24  BOYD       Matrox Mil. 4MB VGA  225.00              30 GM
       05-17  PETTY CASH Computer Network     149.95              70 Clear Lake
1094   05-19  OMNI-TEQ N 2 Pentium 133MHZ     850.00              60 Daytime
1105   05-24  OMNI-TEQ N Western Digital 1.6G 625.00              60 Daytime
1107   05-24  OMNI-TEQ N 2 Intel Pent         755.00              60 Daytime
1126   05-29  OMNI-TEQ N Pentium 133M         565.00              20 BBS
1103   05-24  BASS       Matrox Mil. 4MB VGA (225.00)             30 Gen Mtg.
1141   06-10  PC MAX     2 AMD K5-133       1,671.00              70 Clear Lake
                                           ----------  ----------
     TOTAL NON-INTERNET                    74,232.12   95,702.00

                                          ----------  ----------
GRAND TOTAL                               458,933.27  322,702.00

Return to Financial Reports index
Return to BOD Page
Return to HAL-PC Home Page