HAL-PC Treasurer's Report -- February 1998 (unaudited)
TREASURER'S REPORT
PERIOD: February 28, 1998 PREPARED: April 2, 1998
PREPARED BY: Lou Ann Coy REVIEWED/APPROVED BY Mike Novominsky, Treasurer
This TREASURER'S REPORT with the Balance Sheet, Statements of Revenues and Expenses and the Check Register
is posted monthly on the HAL-PC Home Page in uncompressed format at the time that it's submitted for
distribution at the monthly Board of Directors (BOD) meeting. 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
============================================================================================================
1. Internet monthly/setup fees constitute 51% of total YTD revenues.
2. Cash still increasing.
3. IRS has placed a 9-week hold on HAL-PC's account while they investigate the $6500
penalty assessed against HAL-PC for filing annual tax return late.
4. Internet monthly fees $138,000 behind budget.
5. Accounts receivable situation improving: 65.4% now are past due.
===========================================================================================================
BUDGET
------------------------------------------------------------------------------------------------------
All references to budget are to final budget. THE BUDGET: $1,730,047 Revenues,
$1,213,180 Expenses, $2,000 Scholarship, $409,290 Capital Addns.
Non-Internet Loss $-44,143, Internet Profit $149,720, Total Profit $105,577
BALANCE SHEET (Comparative, Year to Year) ------------------------------------------------------------------
1. Cash - Up $464,692 from a year ago & up $76,570 from last month.
2. Fund Balance - Up $244,042 from a year ago & up $47,684 from last month.
3. Fixed Assets - The Budgeted equipment purchases accounts were increased this month by $18,785 to bring
total purchases YTD to $176,560.
STATEMENT OF REVENUES AND EXPENSES (YTD vs. Annual Budget) -------------------------------------------------
1. Gain this month: $47,684 ($632 GAIN non internet, $47,052 GAIN internet)
YTD: $269,428 GAIN ($19,870 LOSS non internet, $289,298 GAIN internet)
2. Presentation Fees, Gen. Mtg. - Annual budget $100,000, vs. $62,629 YTD ($12,371 behind budget).
3. Annual Dues (before deferral adjustments) - $56,234 this month (UP $18,252 from last month).
YE 5-31-98 dues: $31,262-Jun 97, $29,453-Jul 97, $31,475-Aug 97, $33,980-Sep 97, 48,785-Oct 97,
$35,910-Nov 97, $43,131-Dec 97, $37,982-Jan 98.
YE 5-31-97 dues: $30,456-Jun 96, $32,936-Jul 96, $35,032-Aug 96, $39,563-Sep 96, $37,895-Oct 96,
$31,506-Nov 96, $28,715-Dec 96, $54,342-Jan 97, $43,301-Feb 97, $39,768-Mar 97, $34,181-Apr 97,
$29,541-May 97
YE 5-31-96 dues: $22,460-Jun 95, $21,687-Jul 95, $28,584-Aug 95, $41,366-Sep 95, $27,110-Oct 95,
$32,719-Nov 95, $27,705-Dec 95, $36,547-Jan 96, $39,248-Feb 96, $28,390-March 96, $26,765-Apr 96,
$27,745-May 96.
STATEMENT OF SOURCE AND USE OF FUNDS (Month vs. Same Mo. Last Yr - NO COMMENTS THIS MONTH.
CHECK REGISTER (All February 1998 Checks, Sorted by Check Number,)------------------------------------------
1. Last check reported prior month: 1806
2. Checks reported this month: NationsBank - 1807 through 1907.
3. Checks Voided - 1819-1821, 1903-1904.
INVOICE DISTRIBUTION LIST (All Current Invoices, Showing Account & Department Charged. -
Everything paid through A/P is included
SPECIAL REPORT - STATEMENT OF REV. AND EXP. (YTD vs. Budget), DEPT 21, INTERNET-----------------------------
Gain this month: $47,052 vs YTD gain of $289,298 vs. annual budget of $149,720.
Equipment purchases this month $6,064 -YTD $120,577 vs annual budget of $300,000.
Monthly fee revenue of $502,373 YTD vs. annual budget of $855,000
Setup fees of $94,044 YTD vs. annual budget of $135,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 - $276,601; Pru MM $593,809
A/R STATUS 2-28-98 Balance $43,034 with past due invoices shown in bold.
01 11/97 $35, American Power 3/98 $2,975, Ask Me 4/97 $1,500, AVRI 1/98 $2,917, Be, Inc. 3/98 $2,000,
Berger & Co. 3/98 $200, Caere 4/95 $1,500, Current 12/97 $225, Exabyte 9/97 $2,916, 11/97 $2,917,
Houston Cell 1/98 $195, 4/98 $195, 7/98, $195, 10/98 $195, Information 1/98 $250, 3/98 $350,
Instant 2/98 $225, Kiss 1/98 $2, McAfee 11/97 $68, Micrografx 3/98 $2,917, Microsoft 3/98 $3,193,
Polaroid 3/98 $2,083, PowerQuest 10/97 $2,500, , Symantec 3/98 $2,500, TI 3/97 $992, TRI 3/97 $3,333,
U of H 5/97 $340 & 12/97 $120, $11,375, USR 9/97 $3,493, Visioneer 9/97 $833, Western 1/98 $1,871.
In March, AVRI, Be, Micrografx, Microsoft, Polaroid paid;
Berger paid $100, Houston Cell paid $450, Western paid $71.
REFERENCE --------------------------------------------------------------------------------------------------
Phones: HAL-PC office (713)993-3300, fax (713)993-3333.
Lou Ann Coy (713)697-7241, pgr (281)262-9173, [email protected]
Ray Shasteen (H/W)(713)465-7084
Mike Novominsky (H)(713)771-2772, [email protected]
Mel Babb (H)(713)952-3374
Ray Morris (281)447-1616
Milt Eberhardt (281)376-3975
Larry Dillard pgr (713)909-6734
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 Invoice Date Payee For Actual Budgeted Area Comments
---- ----- ---------- ----------------- --------- ---------- ----- -------
INTERNET
1997-1998 Budget 300,000.00
1139 06-10 OMNI-TEQ 10 32 meg ram 60NS 1,750.00
1190 06-30 OMNI-TEQ 3 64 bit Adaptec 1,401.00
102 06-30 ASCEND Max TNT Base 48,596.95
1204 07-08 OMNI-TEQ 2 Pentium 200s 7,000.00
1207 07-15 ASCEND Pipeline 75 BRI 6,031.68
Modem sales (9,162.64)
1227 07-15 OMNI-TEQ Pentium 200 Intel 3,500.00
1235 07-28 OMNI-TEQ 3 2.0 HD et al 4,483.00
6995 07-22 CARRUTH Desk 280.00
Modem sales (5,560.00)
1304 08-12 CARRUTH Plantronics 134.98
08-13 Lanier Upgrade 350.00
1311 08-15 PC Baystack 350T 16 2,803.24
1385 08-27/30 OMNI-TEQ 3COM Combo/PCMCIA 585.00
08-31 Prior TXN Coding correction 1,220.00
Modem Sales (1,200.00)
1383 09-13 MCATEE Ethernet Cards 45.00
1393 09-15 OMNI-TEQ 2 computers 2,594.00
Modem Sales (2,800.00)
1473 10-20 LEGGETT Part of Router 149.87
1487 10-25 OMNI-TEQ Si-Jet External 390.00
7020 10-24 MM Cisco Router 30,303.75
Modem Sales (800.00)
1608 11-27 OMNI-TEQ Slim SCSI-2 PCMCIA 145.00
1609 11-07 SOLUNET Cisco 1-Port HSSI 4,260.00
1660 11-14 INSYNC Larscom Mega-T 17,936.60
1686 11-21 OMNI-TEQ AMD K6-200 165.00
11-12 PC Refund of sales tax (212.77)
1668 12-12 NEXTEL 5 Phones 1,414.70
1669 12-04 OFFICEMAX 6 Mid-BCK MGR CHR 899.94
1690 12-15 DILLARD 4 Cel Phones 120.00
1750 12-23 LEGGETT Bay Baystack 350T 2,497.20
1764 12-19 BASS 6 Iomega Zipp 100MB 594.00
1799 12-10 DASKO Sharing Device 285.00
Modem Sales (9,081.41)
1830 01-16 OMNI-TEQ Notebook 2,902.00
01-31 BASS Coding correction 792.00
Modem Sales (300.00)
1830 02-05 OMNI-TEQ NT 4.0 Workstation 189.00
Modem sale (100.00)
1935 02-19 SOLUNET Ascend Pipeline 75 5,975.00
--------- ----------
TOTAL FOR INTERNET 120,577.09 300,000.00
NON INTERNET
1997-1998 Budget 109,290.00
1140 06-03 OMNI-TEQ Pentium Board 353.00 60 Daytime
1141 06-04 PC MAX AMD K5-133 CPU 969.00 70 Clear Lake
6983 06-30 MICRO CE DVD Drive 499.00 30 Gen Mtg.
06-30 Prior TXN Coding correction (149.95) 70 Clear Lake
06-30 Prior TXN Coding correction (2,147.36) 70 Clear Lake
1204 07-08 OMNI-TEQ Pentium II 266 5,649.00 40 Magazine
1263 07-20 ADVANCED K% 133 System 655.00 70 Clear Lake
1225 07-26 MICROMA Scanimage QS Wand 878.99 50 Membership
1239 07-29 DATA 2 Projectors 9,398.00 22 SIGs
1249 07-29 LEGGETT Plantronics headset 216.00 10 G&A
1252 07-29 OFFICEMAX Fire-Safe Safe 139.99 10 G&A
1264 07-30 LEGGETT Plantronics headset 234.00 10 G&A
1267 07-31 LANIER Digital copier 8,856.00 10 G&A
1279 07-31 BASS Ivision Camera 360.00 30 Gen Mtg.
1278 08-02 ADVANCED K5 133 System 655.00 70 Clear Lake
1297 08-12 MOORE Toshiba 4X CDROM 49.00 20 BBS
1364 08-29 ADVANCED K 5 133 System 655.00 70 Clear Lake
1390 09-13 LEGGETT Messaging System 2,200.00 10 G&A
1394 09-16 THOMPSON Fire extinguishers 968.00 10 G&A
1436 09-30 BASS WD 1.6 IDE 11MS 330.00 60 Daytime
1443 09-30 PAUSKY Projector tables 155.60 22 SIGs
1461 10-14 BASS Gigabyte/Intel 1,215.50 30 Gen Mtg
1473 10-20 LEGGETT Voicemail System 163.88 10 G&A
1459 10-12 OMNI-TEQ 2 Viewsonic G771 1,120.00 22 SIGs
1473 10-20 LEGGETT PA System Expenses 1,577.53 22 SIGs
1459 10-12 OMNI-TEQ Window 95 Rel 2 100.00 30 Gen Mtg
1481 10-22 BASS Altec Lansing ACS 130.00 30 Gen Mtg
1486 10-25 BASS AMD K6-200 MMX CPU 189.50 30 Gen Mtg
1486 10-25 BASS Iomega Zipp 100MB 99.00 30 Gen Mtg
1486 10-25 BASS Maxtor 7.0 Gig Ide 329.00 30 Gen Mtg
1491 10-25 OMNI-TEQ 24XCDROM/SB Sound 185.00 30 Gen Mtg
1466 10-17 EGGHEAD Encore DVD 350.00 30 Gen Mtg
1459 10-12 OMNI-TEQ Diamond Stealth 132.00 60 Daytime
1525 10-30 OMNI-TEQ Diamond Stealth PCI 66.00 60 Daytime
10-24 OMNI-TEQ Uncashed ck #6435 (730.00) 60 Daytime
1480 10-22 ADVANCED 2 Pentium MB K 5 1,310.00) 70 Clear Lake
1551 11-06 PAUSKY Speaker mount stuff 4.56 22 SIGs
1564 11-06 NEXTEL PowerFones iP370 1,374.00 30 Gen Mtg
1579 11-21 ADVANCED Mid Case, K5 166 655.00 70 Clear Lake
1586 11-24 ADVANCED 2 ACS K5-166 1,310.00 70 Clear Lake
1670 12-12 OMNI-TEQ 5 2.1 GIG Western 1,025.00 60 Daytime
1752 12-27 OMNI-TEQ ASU Pentium 1,375.00 10 G&A
1764 12-19 BASS 2 Iomega Zip 198.00 30 Gen Mtg
1793 12-22 PI Cabling in SIGA&B 648.98 22 SIGs
01-14 Pausky Cabling in SIGA&B 71.80 22 SIGs
01-22 PI Cabling in SIGA&B 230.00 22 SIGs
01-31 BASS Coding correction (792.00) 30 Gen Mtg
1808 02-02 ADVANCED five Pentium 133 1,298.00 70 Clear Lake
1838 02-07 PAUSKY Speaker mount stuff 52.70 22 SIGs
1849 02-16 LEGGETT Telephone sys upgr 3,885.69 10 G&A
1880 02-10 LEONBERG Polaview 211LCD 3,600.00 60 Daytime
1902 02-09 OMNI-TEQ ATX Gigabytte Board 185.00 30 Gen Mtg
1930 02-10 LEONBERG Polaview 211LCD 3,700.00 22 SIGs
---------- ----------
TOTAL NON-INTERNET 55,985.41 109,290.00
---------- ----------
GRAND TOTAL 176,559.50 409,290.00
========== ==========
Return to Financial Reports index
Return to BOD Page
Return to HAL-PC Home Page