HAL-PC Revenues & Expenses (Budget) -- February 1998 (unaudited)

Apr 1, 1998                          HAL-PC                           Page 1    
 4:22 am               STATEMENT OF REVENUES AND EXPENSES                       
                                                                                
                                                                                
                                 9 Months       Annual                          
                               Ended Feb/98     Budget        Unused     % Used 
                               ============  ============  ============  ====== 
REVENUES                                                                        
    Interest income                 $10,581       $18,000        $7,419   58.8% 
    Presentation fees                62,629       100,000        37,371   62.6% 
    Vendor fees                      15,241        15,000          -241  101.6% 
    Shortage                             -0             0            -0         
    External Internet feeds           4,850             0        -4,850         
    Revenue - Other                     779           500          -279  155.7% 
    Donations to HAL-PC                 690             0          -690         
    Donations to HAL-PC                   0       150,000       150,000    0.0% 
    Rental income - Headquarters        400             0          -400         
    Rental income - Special events      795             0          -795         
    Advertising - Magazine           88,215       206,775       118,560   42.7% 
    Annual dues                     327,466       395,772        68,306   82.7% 
    BBS class fees                      411             0          -411         
    Internet setup fees - Exempt        225             0          -225         
    Internet monthly fees - Exempt   12,820             0       -12,820         
    Web Site Workshop                 1,050             0        -1,050         
    Donations to HAL-PC Clear Lake     -402             0          -402         
    Daytime Workshop class fees      16,765        24,000         7,235   69.9% 
    HAL-PC Clear Lake class fees      6,070             0        -6,070         
    Exempt pipeline sales             2,097             0        -2,097         
                                                                                
    Taxable revenues                                                            
      CD-ROM sales                    6,012             0        -6,012         
      Electronic parts sales         26,591             0       -26,591         
      Digital camera sales            9,075             0        -9,075         
      Internet setup fees            93,819       135,000        41,181   69.5% 
      Internet setup fees-Clear Lake  1,140             0        -1,140         
      Internet monthly fees         489,553       855,000       365,447   57.3% 
      Internet monthly fees - CL        940             0          -940         
      Pipeline sales                  3,109             0        -3,109         
      Monitor sales                   1,160             0        -1,160         
      Phone line sales                  640             0          -640         
      Refreshment sales                 346             0          -346         
      Shirt sales                       174             0          -174         
      Study guide sales                 947             0          -947         
      Videotape sales                    49             0           -49         
                               ------------  ------------  ------------         
    TOTAL Sales Taxable For Sales Tax                                           
                                    633,556       990,000       356,444   64.0% 
                               ------------  ------------  ------------         
TOTAL REVENUES                    1,184,237     1,900,047       715,810   62.3% 
                               ------------  ------------  ------------         
****** NET REVENUES               1,184,237     1,900,047       715,810   62.3% 
                               ------------  ------------  ------------         
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                          FOR DISCUSSION PURPOSES ONLY                          
                                                                                
Apr 1, 1998                          HAL-PC                           Page 2    
 4:22 am               STATEMENT OF REVENUES AND EXPENSES                       
                                                                                
                                                                                
                                 9 Months       Annual                          
                               Ended Feb/98     Budget        Unused     % Used 
                               ============  ============  ============  ====== 
                                                                                
Cost of Goods Sold                                                              
    Digital camera sales cost        10,540             0       -10,540         
    CD-ROM sales cost                 6,389             0        -6,389         
    Daytime Workshop manuals cost         0         9,600         9,600    0.0% 
    Monitor sales cost                1,888             0        -1,888         
    Electronic parts sales cost      27,889             0       -27,889         
    Study guide sales cost            2,448             0        -2,448         
    Refreshment sales cost              734             0          -734         
    Shirt sales cost                    192             0          -192         
                               ------------  ------------  ------------         
TOTAL Cost of Goods Sold             50,079         9,600       -40,479  521.7% 
                               ------------  ------------  ------------         
****** ADJUSTED NET REVENUES      1,134,158     1,890,447       756,289   60.0% 
                               ------------  ------------  ------------         
                                                                                
EXPENSES                                                                        
    Accounting                       26,519        37,500        10,981   70.7% 
    Advertising                      47,576       160,000       112,424   29.7% 
    Audio visual                     57,474        54,000        -3,474  106.4% 
    Awards                               41             0           -41         
    Bad debts                             2             0            -2         
    Bank charges                         25           850           825    2.9% 
    Color proofs                        238             0          -238         
    Credit card expense              15,517        16,000           483   97.0% 
    Contract labor                   13,845        34,565        20,720   40.1% 
    Decorations, chairs & tables      9,350         6,900        -2,450  135.5% 
    Delivery service                  1,389         3,945         2,556   35.2% 
    Depreciation and amortization     5,940        14,600         8,660   40.7% 
    Amortization expense leasehold   12,593         7,000        -5,593  179.9% 
    Dues & subscriptions                 84         7,000         6,916    1.2% 
    Duplication services                773         3,300         2,527   23.4% 
    Electrical                       19,229        20,350         1,121   94.5% 
    Electronic parts                 15,157        73,600        58,443   20.6% 
    Employee payroll                 38,700        68,800        30,100   56.3% 
    Entertainment and meals           9,504        15,200         5,696   62.5% 
    Equipment rental                    846             0          -846         
    First aid services                  720         1,125           405   64.0% 
    Freight                           1,028         2,755         1,727   37.3% 
    Information services                145             0          -145         
    Insurance - Other                14,897        12,000        -2,897  124.1% 
    Interest expense                     30             0           -30         
    Licenses and fees                26,755        52,500        25,745   51.0% 
    Management fees                  24,500        35,000        10,500   70.0% 
    Manuals                           6,554           600        -5,954 1092.4% 
    Maintenance                       3,869         9,150         5,281   42.3% 
    Miscellaneous                       219         3,350         3,131    6.5% 
                                                                                
                                                                                
                                                                                
                          FOR DISCUSSION PURPOSES ONLY                          
                                                                                
Apr 1, 1998                          HAL-PC                           Page 3    
 4:22 am               STATEMENT OF REVENUES AND EXPENSES                       
                                                                                
                                                                                
                                 9 Months       Annual                          
                               Ended Feb/98     Budget        Unused     % Used 
                               ============  ============  ============  ====== 
    Moving expense                    9,304        30,000        20,696   31.0% 
    Office supplies and expense       6,944        26,540        19,596   26.2% 
    Parking                             200           685           485   29.1% 
    Payroll taxes                     2,984         7,000         4,016   42.6% 
    Penalties                            15             0           -15         
    Photography                         292           300             8   97.2% 
    Plaques, trophies & awards            8             0            -8         
    Postage                          25,741        28,125         2,384   91.5% 
    Printing                         87,391       119,875        32,484   72.9% 
    Promotions                          610             0          -610         
    Rent - Headquarters              16,560        50,200        33,640   33.0% 
    Rent - General meeting           27,500        30,000         2,500   91.7% 
    Rent - Vendor areas               6,100         6,000          -100  101.7% 
    Rent - Special events             1,500             0        -1,500         
    Rent                                  0            50            50    0.0% 
    Repairs                           1,081        40,260        39,179    2.7% 
    Security and patrol               2,081         4,700         2,619   44.3% 
    Small tools and equipment           863         5,350         4,487   16.1% 
    Software purchases                5,299        34,485        29,186   15.4% 
    Staff leasing                         0        72,900        72,900    0.0% 
    Spares                           10,620             0       -10,620         
    Supplies                          3,447         5,150         1,703   66.9% 
    Telecommunications Assessment         0         1,600         1,600    0.0% 
    Telephone                       115,427       221,770       106,343   52.0% 
    Travel                           10,747        23,500        12,753   45.7% 
    Video production                      0        25,000        25,000    0.0% 
                               ------------  ------------  ------------         
TOTAL EXPENSES                      688,232     1,373,580       685,348   50.1% 
                               ------------  ------------  ------------         
****** OPERATING REVENUES           445,927       516,867        70,940   86.3% 
                               ------------  ------------  ------------         
                                                                                
Other Income & Expenses                                                         
    Educational Program Support           0        -2,000        -2,000         
    A/P discounts                        61             0           -61         
    Budgeted equipment purchases   -176,560      -409,290       232,731   43.1% 
                               ------------  ------------  ------------         
TOTAL Other Income & Expenses      -176,498      -411,290       234,792   42.9% 
                               ------------  ------------  ------------         
****** REVENUES OVER (UNDER) EXPENSES                                           
                                    269,428       105,577      -163,851  255.2% 
                               ------------  ------------  ------------         
                                                                                
****** NET REVENUES OVER (UNDER) EXPENSES                                       
                                   $269,428      $105,577     -$163,851  255.2% 
                               ============  ============  ============         
                                                                                
                          FOR DISCUSSION PURPOSES ONLY                          

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