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

TREASURER'S REPORT

PERIOD: May 31, 1998 PREPARED: July 2, 1998

PREPARED BY: Lou Ann Coy REVIEWED/APPROVED BY Ray Shasteen, Treasurer

 

This TREASURER'S REPORT 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.

==========

OVERVIEW

==========

  1. Annual audit underway.
  2. IRS has abated $6,500 penalty by $3,331. D. Zimmerer is trying to have penalty eliminated entirely.
  3. End of year profit (pending audit results) at $338,094.
  4. Cash decreased from last month by $30,000, largely due to expansion expenses.
  5. Recommend charging .75% monthly finance charge on accounts receivable with a grace period of 30 days.
  6. New employee Durhmon Jennings.
  7. Accounts receivable: 50.60% past due as of 6/30/98.

BUDGET

All references to budget are to final budget. THE BUDGET: $1,890,447 Revenues, $1,373,580 Expenses, $2,000 Scholarship, and $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 $421,537 from a year ago & down $30,368 from last month.
  2. Fund Balance - Up $338,094 (this year’s profit) from a year ago & down $3,547 (this month’s loss) from last month.
  3. Fixed Assets - The Budgeted equipment purchases accounts were increased this month by $15,999 to bring total purchases YTD to $238,483.

STATEMENT OF REVENUES AND EXPENSES (YTD vs. Annual Budget)

  1. 1. Loss this month: $3,547 ($32,629 LOSS non internet, $29,082 GAIN internet) YTD: $338,094 GAIN ($34,878 LOSS non internet, $372,972 GAIN internet)
  2. Presentation Fees, Gen. Mtg. - Annual budget $100,000, vs. $8773 YTD ($12,227 behind budget).
  3. Annual Dues (before deferral adjustments) - $30,440 this month (DOWN $3,340 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, $56,234-Feb 98, $55,248-Mar 98, $33,780-Apr 98, $30,440-May 98. YTD Total: $467,681

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. YTD Total: $437,236

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. YTD Total: $360,326

DEPOSIT ACCTS. Nations oper - $103,704; Pru MM $16,298; T-bills $739,511

A/R STATUS 5-31-98 Balance $36,662 with past due invoices shown in bold.

01 11/97 $35, 3COM/USR 9/97 $3,493, Ask Me 4/97 $1,500, Caere 4/95 $1,500, Commvault 5/98 $2,500, Current 12/97 $225, Exabyte 9/97 $2,916, 11/97 $2,917, Houston Cell 7/98, $135, 10/98 $195, Instant 2/98 $225, 4/98 $100, Kiss 1/98 $2, Microsoft Ho 5/98 $4,167, One 4/98 $$150, PowerQuest 10/97 $2,500, Quarterdeck 6/98 $5,000, Resumail 4/98 $225, TI 3/97 $992, TRI 3/97 $3,333, U of H 5/97 $340 & 12/97 $120, 4/98 $1,480, Visioneer<

REFERENCE

Contacts: HAL-PC office (713) 993-3300, fax (713) 993-3333.

Lou Ann Coy HAL-PC (713) 993-3300x103, pgr (281) 262-9173, cell (281) 467-9339 (no title) louann@hal-pc.org

Ray Shasteen (H/W)(713) 465-7084 (Treasurer) shasteen@hal-pc.org

Ray Morris (281) 447-1616 (President) ray@hal-pc.org

Gus Hrncir (281) 498-3137 (Membership Secretary) hrncir@hal-pc.org

Mel Babb (H)(713) 952-3374 (Recording Secretary) melbab@hal-pc.org

Mike Novominsky (713) 772-2772 (Director) mikejn@hal-pc.org

Joe Whinery (281) 232-8798 (Director) jwhinery@hal-pc.org

Nick Streater (281) 491-5027 (Director) nicks@hal-pc.org

Milt Eberhardt (281) 376-3975 (Director) milte@hal-pc.org

Ralph Roddy (281) 493-6444 (Finance Committee) ralphr@hal-pc.org

Larry Dillard pgr (800) 285-5460 (MIS Coordinator) spirit@hal-pc.org

George Roy (281) 316-0768 (Clear Lake Coordinator) roygt@hal-pc.org

Phil Salchli (281) 496-3020 (CPA)

John F. Hinman (713) 650-4702 (Prudential Securities – VP-Investments) JOHN_HINMAN@prusec.com

Cheryl Fuller (713) 756-2950 (NationsBank – Account Officer)

Kennard Wilder (214) 508-7262 (NationsBank – Lockbox Acct Rep)

Deborah Foster (713) 984-1988, fax (713) 984-2295 (Insurance Agent)

Kim Bridges (713) 868-9112 (State Comptroller’s Office – Sales Tax)

 

The purpose of the following schedule is to compare BUDGETED EQUIPMENT PURCHASES to actual expenditures. Note that the Total For Internet and Grand Total, both Actual and Budgeted amounts agree to the amount shown on the Statement of Revenues and Expenses under Other Income & Expenses for Budgeted equipment purchases.

BUDGETED EQUIPMENT PURCHASES

 

 

 

 

 

 

 

Ck

Invoice Date

Payee

For

Actual

Budgeted

Area

Comments

 

 

 

 

 

 

 

 

INTERNET

 

 

 

 

 

 

 

 

1997-1998 Budget

 

 

 

$300,000.00

 

 

1139

10-Jun

OMNI-TEQ

10 32 meg ram 60NS

$ 1,750.00

 

 

 

1190

30-Jun

OMNI-TEQ

3 64 bit Adaptec

1,401.00

 

 

 

102

30-Jun

ASCEND

Max TNT Base

48,596.95

 

 

 

1204

8-Jul

OMNI-TEQ

2 Pentium 200s

7,000.00

 

 

 

1207

15-Jul

ASCEND

Pipeline 75 BRI

6,031.68

 

 

 

 

 

 

Modem sales

(9,162.64)

 

 

 

1227

15-Jul

OMNI-TEQ

Pentium 200 Intel

3,500.00

 

 

 

1235

28-Jul

OMNI-TEQ

3 2.0 HD et al

4,483.00

 

 

 

6995

22-Jul

CARRUTH

Desk

280.00

 

 

 

 

 

 

Modem sales

(5,560.00)

 

 

 

1304

12-Aug

CARRUTH

Plantronics

134.98

 

 

 

 

13-Aug

Lanier

Upgrade

350.00

 

 

 

1311

15-Aug

PC

Baystack 350T 16

2,803.24

 

 

 

1385

8/27/30

OMNI-TEQ

3COM Combo/PCMCIA

585.00

 

 

 

 

31-Aug

Prior TXN

Coding correction

1,220.00

 

 

 

 

 

 

Modem Sales

(1,200.00)

 

 

 

1383

13-Sep

MCATEE

Ethernet Cards

45.00

 

 

 

1393

15-Sep

OMNI-TEQ

2 computers

2,594.00

 

 

 

 

 

 

Modem Sales

(2,800.00)

 

 

 

1473

20-Oct

LEGGETT

Part of Router

149.87

 

 

 

1487

25-Oct

OMNI-TEQ

Si-Jet External

390.00

 

 

 

7020

24-Oct

MM

Cisco Router

30,303.75

 

 

 

 

 

 

Modem Sales

(800.00)

 

 

 

1608

27-Nov

OMNI-TEQ

Slim SCSI-2 PCMCIA

145.00

 

 

 

1609

7-Nov

SOLUNET

Cisco 1-Port HSSI

4,260.00

 

 

 

1660

14-Nov

INSYNC

Larscom Mega-T

17,936.60

 

 

 

1686

21-Nov

OMNI-TEQ

AMD K6-200

165.00

 

 

 

 

12-Nov

PC

Refund of sales tax

(212.77)

 

 

 

1668

12-Dec

NEXTEL

5 Phones

1,414.70

 

 

 

1669

4-Dec

OFFICEMAX

6 Mid-BCK MGR CHR

899.94

 

 

 

1690

15-Dec

DILLARD

4 Cel Phones

120.00

 

 

 

1750

23-Dec

LEGGETT

Bay Baystack 350T

2,497.20

 

 

 

1764

19-Dec

BASS

6 Iomega Zipp 100MB

594.00

 

 

 

1799

10-Dec

DASKO

Sharing Device

285.00

 

 

 

 

 

 

Modem Sales

(9,081.41)

 

 

 

1830

16-Jan

OMNI-TEQ

Notebook 12.1 active (512k)

2,902.00

 

 

 

 

31-Jan

BASS

Coding correction

792.00

 

 

 

 

 

 

Modem Sales

(300.00)

 

 

 

1830

5-Feb

OMNI-TEQ

NT 4.0 Workstation

189.00

 

 

 

 

 

 

Modem sale

(100.00)

 

 

 

1928

4-Mar

DASKO

7 Drive SCSI 3 Cable

112.50

 

 

 

1964

20-Mar

OMNI-TEQ

Dual Pentium II

3,709.00

 

 

 

1998

30-Mar

ENIX

Refund – Modem

100.00

 

 

 

2001

30-Mar

OMNI-TEQ

3 17"Monitor 1280

1,140.00

 

 

 

2093

27-Apr

SOLUNET

Cisco AS5300, 96 Modems, Quad T1/PRI

31,921.60

 

 

 

2162

29-Apr

OMNI-TEQ

Tektronic

8,400.00

 

 

 

2238

28-May

OMNI-TEQ

2 Asus/1 Dual Pen

15,550.00

 

 

 

 

 

 

 

 

 

 

 

 

TOTAL FOR INTERNET

 

 

$175,535.19

$300,000.00

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

NON-INTERNET

 

 

 

 

 

 

 

 

1997-1998 Budget

 

 

 

$109,290.00

 

 

1140

3-Jun

OMNI-TEQ

Pentium Board

$ 353.00

 

60

Daytime Classes

1141

4-Jun

PC MAX

AMD K5-133 CPU

969.00

 

70

Clear Lake

6983

30-Jun

MICRO CE

DVD Drive

499.00

 

30

General Meeting

 

30-Jun

Prior TXN

Coding correction

(149.95)

 

70

Clear Lake

 

30-Jun

Prior TXN

Coding correction

(2,147.36)

 

70

Clear Lake

1204

8-Jul

OMNI-TEQ

Pentium II 266

5,649.00

 

40

Magazine

1263

20-Jul

ADVANCED

K% 133 System

655.00

 

70

Clear Lake

1225

26-Jul

MICROMA

Scanimage QS Wand

878.99

 

50

Membership

1239

29-Jul

DATA

2 Projectors

9,398.00

 

22

SIGs

1249

29-Jul

LEGGETT

Plantronics headset

216.00

 

10

G & A

1252

29-Jul

OFFICEMAX

Fire-Safe Safe

139.99

 

10

G & A

1264

30-Jul

LEGGETT

Plantronics headset

234.00

 

10

G & A

1267

31-Jul

LANIER

Digital copier

8,856.00

 

10

G & A

1279

31-Jul

BASS

Ivision Camera

360.00

 

30

General Meeting

1278

2-Aug

ADVANCED

K5 133 System

655.00

 

70

Clear Lake

1297

12-Aug

MOORE

Toshiba 4X CDROM

49.00

 

20

BB

1364

29-Aug

ADVANCED

K 5 133 System

655.00

 

70

Clear Lake

1390

13-Sep

LEGGETT

Messaging System

2,200.00

 

10

G & A

1394

16-Sep

THOMPSON

Fire extinguishers

968.00

 

10

G & A

1436

30-Sep

BASS

WD 1.6 IDE 11MS

330.00

 

60

Daytime Classes

1443

30-Sep

PAUSKY

Projector tables

155.60

 

22

SIGs

1461

14-Oct

BASS

Gigabyte/Intel

1,215.50

 

30

General Meeting

1473

20-Oct

LEGGETT

Voicemail System

163.88

 

10

G & A

1459

12-Oct

OMNI-TEQ

2 Viewsonic G771

1,120.00

 

22

SIGs

1473

20-Oct

LEGGETT

PA System Expenses

1,577.53

 

22

SIGs

1459

12-Oct

OMNI-TEQ

Window 95 Rel 2

100.00

 

30

General Meeting

1481

22-Oct

BASS

Altec Lansing ACS

130.00

 

30

General Meeting

1486

25-Oct

BASS

AMD K6-200 MMX CPU

189.50

 

30

General Meeting

1486

25-Oct

BASS

Iomega Zipp 100MB

99.00

 

30

General Meeting

1486

25-Oct

BASS

Maxtor 7.0 Gig Ide

329.00

 

30

General Meeting

1491

25-Oct

OMNI-TEQ

24XCDROM/SB Sound

185.00

 

30

General Meeting

1466

17-Oct

EGGHEAD

Encore DVD

350.00

 

30

General Meeting

1459

12-Oct

OMNI-TEQ

Diamond Stealth

132.00

 

60

Daytime Classes

1525

30-Oct

OMNI-TEQ

Diamond Stealth PCI

66.00

 

60

Daytime Classes

 

24-Oct

OMNI-TEQ

Uncashed Ck #6435

(730.00)

 

60

Daytime Classes

1480

22-Oct

ADVANCED

2 Pentium MB K 5

1,310.00

 

70

Clear Lake

1551

6-Nov

PAUSKY

Speaker mount stuff

4.56

 

22

SIGs

1564

6-Nov

NEXTEL

PowerFones iP370

1,374.00

 

30

General Meeting

1579

21-Nov

ADVANCED

Mid Case, K5 166

655.00

 

70

Clear Lake

1586

24-Nov

ADVANCED

2 ACS K5-166

1,310.00

 

70

Clear Lake

1670

12-Dec

OMNI-TEQ

5 2.1 GIG Western

1,025.00

 

60

Daytime Classes

1752

27-Dec

OMNI-TEQ

ASU Pentium

1,375.00

 

10

G & A

1764

19-Dec

BASS

2 Iomega Zip

198.00

 

30

General Meeting

1793

22-Dec

PI

Cabling in SIGA&B

648.98

 

22

SIGs

 

14-Jan

Pausky

Cabling in SIGA&B

71.80

 

22

SIGs

 

22-Jan

PI

Cabling in SIGA&B

230.00

 

22

SIGs

 

31-Jan

BASS

Coding correction

(792.00)

 

30

General Meeting

1808

2-Feb

ADVANCED

five Pentium 133

1,298.00

 

70

Clear Lake

1838

7-Feb

PAUSKY

Speaker mount stuff

52.70

 

22

SIGs

1849

16-Feb

LEGGETT

Telephone sys upgr

3,885.69

 

10

G & A

1880

10-Feb

LEONBERG

Polaview 211LCD

3,600.00

 

60

Daytime Classes

1902

9-Feb

OMNI-TEQ

ATX Gigabytte Board

185.00

 

30

General Meeting

1930

10-Feb

LEONBERG

Polaview 211LCD

3,700.00

 

22

SIGs

1947

13-Mar

ADVANCED

ACS Pentium 166

1,800.00

 

70

Clear Lake

1950

13-Mar

BASS

Matrox Millenium II

169.00

 

30

General Meeting

1988

26-Mar

BASS

Maxtor 2.1 IDE/IBM

179.50

 

30

General Meeting

2001

30-Mar

OMNI-TEQ

3 17"Monitor 1280

1,140.00

 

22

SIGs

2047

17-Apr

OMNI-TEQ

15" monitor 1280

194.00

 

22

SIGs

2048

17-Apr

PAUSKY

Sony VCR for SIG A

209.97

 

22

SIGs

2147

31-Mar

OMNI-TEQ

Pentium 233 MMX

1,690.00

 

22

SIGs

2157

7-May

NEXTEL

Cell for D Jennings

129.00

 

40

Magazine

2159

7-May

ADVANCED

Pentium 166 MMX

1,134.15

 

70

Clear Lake

2186

15-May

OMNI-TEQ N

Adi Model E40

200.00

 

30

General Meeting

2193

18-May

MORGAN

QVS VGA Monitor

119.95

 

70

Clear Lake

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

TOTAL NON-INTERNET

 

 

$ 62,947.98

$109,290.00

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

GRAND TOTAL

 

 

 

$238,483.17

$409,290.00

 

 

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