DATE:	July 6, 2006
TO:	Director, Division of the Commission Clerk & Administrative Services (Bayó)
FROM:	Office of the General Counsel (Scott) Division of Competitive Markets & Enforcement (Simmons, Dowds, Higgins)
RE:	Docket No. 050194-TL – Complaint by Florida BellSouth customers who paid fees to BellSouth Telecommunications, Inc. related to Miami-Dade County Ordinance Section 21-44 ("Manhole Ordinance") and request that Florida Public Service Commission order BellSouth to comply with Section A.2.4.6 of General Subscriber Service Tariff and refund all fees collected in violation thereof.
AGENDA:	07/18/06 – Regular Agenda – Proposed Agency Action – Interested Persons May Participate
COMMISSIONERS ASSIGNED:		All Commissioners
PREHEARING OFFICER:		Carter
CRITICAL DATES:		None
SPECIAL INSTRUCTIONS:		None
FILE NAME AND LOCATION:		S:\PSC\CMP\WP\050194R.RCM.DOC

 

Case Background

            On March 23, 2005, a Complaint of Florida BellSouth Customers Against BellSouth Telecommunications, Inc. and Request for Relief (“Complaint”) was filed by Karla Hightshoe, Timothy McCall, and Manuel Garcia, individually, and Best Investment Realty, Inc., a Florida Corporation, as well as on behalf of all other BellSouth customers who have paid the Miami-Dade County Ordinance #83-3 (“Manhole Ordinance”) fee, (collectively as the “Petitioners”).[1]

The Complaint alleges that BellSouth has violated the terms of Section A.2.4.6 of its General Subscriber Service Tariff (“Tariff”) since 1983, when a fee was first established to recoup BellSouth’s costs associated with complying with the Manhole Ordinance.  Pursuant to the Manhole Ordinance, while anyone is working below ground level, at or near a manhole, another person must provide above-ground surveillance.  The Complaint requests that this Commission enforce the Tariff, and order BellSouth to comply with its Tariff and to refund all fees collected in violation of the terms of the Tariff.[2]

On April 18, 2005, BellSouth filed its Motion to Dismiss (“Motion”) the Complaint on the following four bases:  (1) the individual customers lack standing to initiate a proceeding, (2) there is no statutory authority for this Commission to hear a class action suit, (3) this Commission has no authority to grant injunctive relief, and (4) this Commission has no authority to award attorney’s fees.  On April 28, 2005, the Petitioners filed their Response to BellSouth’s Motion to Dismiss (“Response”) in which they requested that the Motion be denied.  Alternatively, the Petitioners suggested that this Commission enter an order acknowledging that the matters in the Complaint are and were properly before the Circuit Court.

By Order No. PSC-05-0762-PCO-TL, issued July 25, 2005, the Commission granted in part and denied in part BellSouth’s Motion to Dismiss the Petitioners’ Complaint.  The Commission found that the Petitioners have standing to bring the subject matter of the Complaint before this body and to seek a refund of any charges collected in violation of the Tariff.  However, the claim for attorney’s fees was stricken since the Commission lacks the subject matter jurisdiction to grant such a claim.  In addition, the request for injunctive relief was not addressed at that time, as additional information was necessary in order to proceed in an appropriate and efficient manner.  Staff was directed to investigate this matter, provide the  results of its investigation, and advise the Commission.[3]  This recommendation provides staff’s assessment based on three sets of discovery responses from BellSouth.  Staff notes that this recommendation was deferred from the May 2 and May 16, 2006 Agenda Conferences in order to provide additional fee and financial data.

Discussion of Issues

Issue 1: 

 Has BellSouth violated the terms of Section A.2.4.6 of its General Subscriber Service Tariff, with respect to the Manhole Ordinance Fee, for all or part of the period 1983 through 2005?  If so, what action should the Commission take?

Recommendation: 

 Staff recommends the Commission find that BellSouth violated the terms of Section A.2.4.6 of its General Subscriber Service Tariff, during all or part of the period 1998 through 2005.  Given that the per line credit or refund would be less than $.50, and since a significant number of affected customers may no longer be receiving service from BellSouth, staff recommends that no customer credit or refund be required.

Instead, staff recommends that the Commission set the cumulative overage in collections, with interest, as of year-end 2005 at $469,176 and require that BellSouth consider this overage and any overage/underage for January 2006 through June 2006, in setting the Manhole Ordinance Fee to be assessed for the period July 2006 through December 2006.  In addition, staff recommends the Commission find that, pursuant to existing Section A.2.4.6 of its General Subscriber Service Tariff, BellSouth is required to perform reconciliations for each future six-month period and to apply the overage/underage in collections as an accounting adjustment, to determine the appropriate fee.  Finally, staff recommends that in the future, overhead loadings be computed using the same method in general use by BellSouth (i.e., the “original” method).  (Simmons, Dowds, Higgins)

Staff Analysis: 

 The Petitioners maintain that semi-annual audits are required under the Tariff, and BellSouth must “compare the costs required to comply with the Manhole Ordinance with the amounts collected and return any excess amounts collected back to its customers.” (Complaint, ¶¶ 21, 24)  Further, according to the Petitioners, this “return” is to be in the form of a refund of  all fees collected by BellSouth in violation of the Tariff, plus interest. (Complaint, ¶ 28)  In its Motion to Dismiss, BellSouth stated that the use of the word “reconcile” in the Tariff does not imply that a refund or audit is required.  (Motion, p. 5)  The tariff language in question appears in Section A2.4.6 of BellSouth’s General Subscriber Service Tariff and provides:

An estimated monthly amount of such costs shall be billed to the affected subscribers each month and an adjustment to reconcile  these estimates to the actual costs incurred for the six month periods ending June 30 and December 31 of each year shall be applied (emphasis added).

 

From staff’s perspective, the term “reconcile” does indicate that the costs required to comply with the Manhole Ordinance are to be compared with the amounts collected, at the end of each six-month period.  Once the comparison is made, however, staff believes that the language indicates that the overage/underage in amounts collected is to be considered in establishing the appropriate fee for the next six months.  Staff’s conclusion stems from the words “adjustment,” “reconcile,” and “applied,” which suggest that the process is accounting in nature.  Whether BellSouth actually considered the overage/underage in establishing the fee for each subsequent six-month period is very much in doubt, and staff believes that the Commission should determine if there is a cumulative over-collection at this current point in time.  Due to the passage of time and the unavailability of data for earlier periods, staff does not believe that an

analysis can be performed for each six-month period since the inception of the fee.  Moreover, as will be discussed below, there is a plausible basis for using 1998 as a starting point, to determine whether there is a cumulative overage or underage in collections as of the end of 2005.

 

            During the period 1983-1997, BellSouth operated under rate-of-return regulation.  In addition, from 1988 to 1997, BellSouth was operating under a sharing plan whereby earnings above certain rate-of-return levels were refunded, all or in part, to customers.  In response to Staff’s First Set of Interrogatories, No. 1, BellSouth stated in part:

 

. . . “Refunds and Sharing Amounts” for the years 1993 through 1997 arising from the Commission’s Order No. PSC-94-0172-FOF-TL also included the [Ordinance-related] revenues and expenses as booked.  Therefore, they were included in calculation of achieved Rates of Return (on Equity) that resulted in sharing refunds to BellSouth customers during three of those five years.  In 1997, BellSouth earned the maximum allowed by the PSC order and refunded all earnings above that level.  Due to reaching this earnings cap on 1997 earnings, BellSouth reset the cumulative under/over balance to zero at the beginning of 1998, thereby forgoing recovery of past un-recovered costs incurred in complying with the Ordinance. (July 15, 2005, Item No. 1, Page 4 of 7)

 

Staff notes that while BellSouth’s calculations show there was a cumulative under-recovery at the end of 1997, the supporting data necessary to confirm this result is not available, and there is a question as to the appropriate method for calculating overhead expenses, which will be discussed later.  Nonetheless, based on how BellSouth was regulated over the 1983-1997 period, any over-recovery of company expenses was addressed, in theory, at the aggregate level.  Consequently, staff believes that there is no necessity to evaluate whether there was over-recovery specific to the Manhole Ordinance fee.  In fact, to do so might be construed as double counting for certain years.  Staff acknowledges that this treatment may not be ideal for all years in the period, since BellSouth may have over-recovered with respect to the Manhole Ordinance fee, but not on an overall basis in certain years.  However, the reverse situation is also possible – BellSouth may have under-recovered with respect to the Manhole Ordinance fee, but not on an overall basis in certain years.  On balance, and in consideration of data limitations, staff believes that BellSouth’s approach of setting the cumulative under/over balance to zero at the beginning of 1998 is reasonable.

 

History of Fee Changes          

 

            Staff observes that BellSouth often adjusted the fee during the period 1987 through 1993, with the highest fee charged being $.17 and the lowest fee charged being $.01.  Before and after this period, however, BellSouth rarely changed the fee.  In response to a staff discovery request to provide the fee for each six-month period, BellSouth provided the following fee history:

 

                                               

 

 

 

1983                                        $.15

                                                June 1987                                $.08

                                                January 1988                           $.12

                                                February 1988                         $.13

                                                August 1988                            $.14

                                                February 1989                         $.17

                                                February 1990                         $.09

                                                August 1990                            $.01

                                                February 1991                         $.08

                                                August 1991                            $.12

                                                January 1992                           $.12

                                                August 1992                            $.09

                                                February 1993                         $.06

                                                August 1993                            $.11

                                                1998 – December 2003           $.11

                                                January 2004 to present           $.08

 

(July 15, 2005, Item No. 1, Page 7 of 7)

 

BellSouth also provided the following explanation of the company’s decision making process used to determine if the fee should be changed.

 

The cumulative balance, along with the six-month trend in recovery, would be the primary information utilized in a decision to change the pass-on charge on customer bills.  BellSouth would also take into account the Information Technology (“IT”) costs and the increased cost associated with customer inquiries that accompany an increase if the company was in an under-recovered position.  If the trends indicated that a cumulative under-recovery was being steadily and materially reduced, the pass-on charge would not be increased.  (July 15, 2005, Item No. 1, Page 5 of 7)

 

            After reviewing the history of fee changes and BellSouth’s explanation of its decision making process, staff believes the two pieces of information are difficult to reconcile.  The history suggests that BellSouth was reviewing financial data at six-month intervals and adjusting the fee, as indicated by the data, during 1987 – 1993.  Thereafter, the fee was not changed for ten years, which seems puzzling except possibly for BellSouth’s explanation that its decision making process relied on data trending.  Even accepting BellSouth’s explanation, the decision making process does not seem consistent over time.

 

            Regardless of how the overhead loadings are computed and the resulting cumulative overage or underage in collections as of the end of 2005, staff believes that the history of fee changes indicates that, at a minimum, the Tariff was not administered in a consistent manner.  By not administering the Tariff in a consistent manner, staff believes this raises the issue of Tariff compliance.  Even if the semi-annual reconciliations and adjustments required by the Tariff are subject to interpretation, staff believes that BellSouth’s interpretation should not change over time.

Overhead Loadings

 

            Overhead calculations inherently generate questions due to the aggregate nature of the loading factors used.  In this case, a loading factor is multiplied by the amount of vouchered security guard expense to determine overhead expense.  BellSouth has presented two different methods for developing loading factors.  A loading factor is essentially a ratio; the two methods use the same numerator, but a different denominator.  Under BellSouth’s “original” method, the loading factor was developed by dividing total corporate operations expense by total operations expense (less depreciation and amortization).  Under BellSouth’s “revised” method, the loading factor was developed by dividing total corporate operations expense by BellSouth salaries and wages.  Due to the smaller denominator used in the “revised” method, the resulting loading factor is higher.  In discovery, BellSouth reported that the “revised” method of developing loading factors is consistent with the method used from 1983-1996.

 

            Staff understands from discovery responses that the “original” method is in general use company-wide today.  For purposes of the Manhole Ordinance fee, BellSouth apparently used the “original” method from 1998 through 2003, before concluding that this method was incorrect for this application and adopting the “revised” method.  BellSouth contends that the “original” method understated the overhead costs as compared to historical calculations made from 1983 through 1996.  On this basis, BellSouth believes that any refund or adjustment should be based on the “revised” method, for the entire period in question.  According to BellSouth, use of the “revised” method and all known revisions to correctly identify revenues and expenses (BellSouth’s Revised Exhibit B) provides the company’s “best determination of the expenses associated with the Dade County Manhole ordinance and their recovery through billing to Dade County customers.” (September 13, 2005, Item No. 9, Page 3 of 7)  As will be discussed below, staff disagrees and believes that this unique handling of overhead loadings is inappropriate.

 

            In theory, how the loading factor is applied should be consistent with how the loading factor is developed, i.e., the loading factor should be applied only to those items included in the denominator of the factor.  Accordingly, staff believes that the “original” method is conceptually sound since the loading factor is applied to vouchered security guard expense, which staff believes is clearly included within the total operations expense base.

 

            Under the “revised” method, however, there arguably is an inconsistency between how the loading factor is developed and how the factor is applied.  Vouchered expense is not included in the BellSouth salaries and wages base, yet the resulting loading factor is applied to vouchered expense.  By its very definition, the loading factor should only be applied to BellSouth salaries and wages.  BellSouth alleges that voucher expense for security guards is “equivalent” to BellSouth salaries and wages.  While the security guards substitute for BellSouth employees, staff does not believe the two are equivalent in this context.  In order to be equivalent for this purpose, the denominator of the loading factor would need to be defined as salaries and wages for BellSouth employees and vouchered expense for contract labor.  On the positive side, the “revised” method is consistent with the method used during 1983-1996, and there is merit to having a uniform approach over time.

 

            Determining the amount of a cumulative overage or underage in collections as of the end of 2005 turns on how the overhead loadings are computed.  Staff notes that the fee remained unchanged at $.11 throughout the 1998-2003 period and was reduced to $.08 in January 2004.  In staff’s opinion, this rate reduction suggests that BellSouth believed there was a cumulative over-recovery at the end of 2003.

 

Cumulative Overage/Underage in Collections

 

            Staff believes that some level of overhead loadings should apply, since BellSouth clearly incurs administrative costs in order to comply with the Manhole Ordinance.  From a practical standpoint, staff believes that the Commission has three options available approaches for overhead loadings:  the “original” method, the “revised” method, or a combination based on which method was actually used for which years.  As will be described below, staff has developed results under each option approach, to assist the Commissioners in considering this matter.

 

            Staff has used BellSouth data through the end of 2005, to produce three four sets of results: one under the “original” method of developing loading factors; a second under the “revised” method; and a third and fourth using the “original” method for 1998-2003 and the “revised” method for 2004-2005.  In the first three each scenarios, the cumulative under/over balance was set to zero at the beginning of 1998, as both BellSouth and staff believe is appropriate.  The fourth scenario employs the same overhead loading methods used in the third scenario, but the cumulative under/over balance was not set to zero at the beginning of 1998, and the cumulative balance was reset at the beginning of 2004.  As a result the cumulative overage/underage amounts under the third and fourth scenarios are quite different.  In addition, the revenue and expense data used in the fourth scenario is, according to BellSouth, the data actually used for purposes of conducting six-month reviews.  In contrast, the revenue and expense data used in the first three scenarios incorporate various corrections made by BellSouth.  Staff emphasizes, however, that the exhibits relied upon by staff to produce all four scenarios were created by BellSouth in response to our discovery, and could not be independently verified.

 

            One approach the Commission could entertain is to treat any cumulative overage as an accounting adjustment flowing from the reconciliation process.  While accounting adjustments are usually made at book value, staff believes there is merit, in this instance, to calculate the cumulative overage/underage with interest.  This approach would help ensure that the benefit to BellSouth from any over collection and use of these funds flows back to Dade County ratepayers in the form of a lower future Manhole Ordinance fee, than would otherwise apply.  If the Commission requires that any cumulative overage be returned to rate payers through bill credits and refunds, different calculations would be required to develop customer-specific amounts.  Nonetheless, staff believes that the cumulative overage/underage is a useful composite figure.

 

            For the period 1998-2005, interest was computed monthly and applied to the monthly overage/underage in amounts collected to determine the cumulative overage/underage with interest through the end of 2005.  In making interest calculations, staff used the thirty (30) day commercial paper rate for high grade, unsecured notes, regularly published in the Wall Street Journal.  This is the same interest rate used for refunds ordered by this Commission (see Rule 25-4.114(4)(a), Florida Administrative Code), and staff believes the same rate would be appropriate in the current context.  As a further point of clarification, staff believes that interest only should be considered in the context of calculating the cumulative overage/underage amount; accruing interest would not be appropriate in the context of future six-month reconciliations.  This approach of applying interest on a one-time basis would help redress the concern that the Tariff may not have been administered as intended for a lengthy period of time.

 

            The cumulative overage/underage amounts developed using each of these three four scenarios options are shown below as Options 1, 2, 3, and 4.  A summary of financial data for all options is provided on Attachment A.  Staff has provided cumulative figures with and without interest where possible, but recommends that interest be included for the reasons described above.

 

                                                                                    Cumulative      Cumulative with Interest

 

            Option 1                                                          $   320,408                  $   469,176

            (“Original” Method)

 

            Option 2                                                          $ (660,207)                 $ (613,966)

            (“Revised” Method)

 

            Option 3                                                          $    81,528                   $  223,129

            (“Original” Method 1998-2003/

            “Revised” Method 2004-2005;

           

            Option 4                                                          $ (660,207)                 Not available

            (Option 3, excluding corrections with

            1998 beginning balance not set to zero,

and 2004 beginning balance reset)

 

From a conceptual standpoint, staff recommends the first option on the basis that (1) the loading factor is developed and applied in a consistent manner, and (2) BellSouth appears to have used this method for all other purposes since 1998.  A uniform method of handling overhead loadings helps to ensure that the various corporate overhead allocations sum to the whole.  Attachment AB to this recommendation provides supporting financial data for the first option.  In particular, the attachment shows how the cumulative overage amount of $320,408 (excluding interest) through 2005, was derived.  Also, Attachment A provides an alternative calculation of the cumulative amount through 2005, based on BellSouth’s reported underage in collections at the beginning of 1998, ($1,170,369). 

 

While the second option presumably is consistent with the method used during 1983-1996, staff believes that this approach has conceptual shortcomings, as discussed previously.  Finally, the third and fourth options reflects how BellSouth actually apparently computed overhead loadings during the periods in question, but is are not consistent over time.  Supporting financial data for Options 2, 3, and 4 is provided on Attachments C, D, and E, respectively.

 

As mentioned earlier, the data employed in Option 4 is based on data that BellSouth states was actually used for purposes of conducting the semi-annual reviews and is known to contain errors.  In addition, staff believes that the methods reportedly used for computing overhead expense during 1983-1996 had conceptual weaknesses.  Accordingly, staff questions the reasonableness of the reported 1998 beginning balance.

 

A review of the summary results shown on Attachment A reveals that Option 4 is the only scenario showing an initial under-recovery being reduced over time and then being followed by an over-recovery, which would have justified reducing the fee in January 2004.  Options 1, 2, and 3 show long periods of over-recovery where the overage is not trending down, yet the fee remained the same.  Staff believes that Option 4, which is based on data apparently used for six-month reviews, has two unique deficiencies:  there are known data errors, and BellSouth has provided no means of verifying the reported 1997 ending balance.

 

            Based on the cumulative overage developed using the first option (i.e., “original” method), which staff believes is the conceptually preferred method among the options discussed, and the long periods of over-recovery under the first, second, and third options, BellSouth did not perform the required semi-annual reconciliations and adjustments during all or part of the period 1998 through 2005.  In staff’s opinion, this conclusion also is supported by the earlier discussion on the history of fee changes.  As a result, staff believes that BellSouth’s failure to do so violated the terms of Section A.2.4.6 of its General Subscriber Service Tariff.

 

            Staff notes that the Commission’s finding on the issue of whether BellSouth violated its Tariff will be based on inferences drawn from various data and analyses, which may support different conclusions.  In this situation, the Commission has wide discretion as to the type of finding rendered.  For example, the Commission could find that BellSouth did violate its Tariff; find probable cause that BellSouth violated its Tariff; determine the evidence is inconclusive; or find that BellSouth did not violate its Tariff.  Regardless of the Commission’s finding, staff believes that the Commission still can set the cumulative overage/underage in collections as of year-end 2005 and specify how overhead loadings, reconciliations and adjustments are to be performed in the future, under the Tariff.  Staff recommends that the Commission take this opportunity to establish clarity going forward, to avoid future disputes of this type.

 

Disposition of Cumulative Overage in Collections

 

            The Petitioners are seeking a refund of all fees collected by BellSouth in violation of the Tariff, plus interest.  While staff does not believe the Tariff, when administered as intended, contemplates refunds, the cumulative overage in collections developed under Option 1 ($469,176 with interest) indicates a long-standing issue.  Consequently, staff believes that refunds could be considered, if such an approach were practical.  Rule 25-4.114, Florida Administrative Code, addresses procedures for Commission-ordered refunds, yet still provides latitude for unique situations.  Staff has looked to this rule for guidance in helping to determine the appropriate resolution in this instance.

 

            In particular, staff has focused on Rule 25-4.114(5), Florida Administrative Code, which addresses the method of refund distribution.  This portion of the rule provides that for customers

still on the system, the refund is to be handled as a bill credit.  For those customers no longer on the system, the company is to mail a refund check to the last known address, except that no refund of less than one dollar need be made.  In this case, with the cumulative overage being calculated over an eight-year period, there are likely to be many affected customers who are no longer on the system.  As a result, refunds that are not claimed or not required could be a significant issue, and one the Commission would need to address.  Providing proportionately higher bill credits only to existing customers who received service during the period at issue would ensure all monies are returned, but would ignore a portion of the affected customers.  Relying on prospective rate relief and not providing refunds has the drawback that the customer base going forward will differ from the customer base over the period during which there was an overage in collections.

 

            Staff recognizes the practical difficulty in targeting compensation to the affected customers.  In this instance, staff believes the more prudent course of action is to treat the cumulative overage as an accounting adjustment flowing from the reconciliation process required by the Tariff.  Although both over inclusive and under inclusive vis-à-vis the set of affected customers, this approach is workable and reasonable given the small per line amounts at issue.  While the number of BellSouth access lines in the Miami exchange varied over the 1998-2005 period, 1.0 – 1.1 million lines is a rough average.  Based on staff’s recommended cumulative overage with interest of $469,176, the average per line amount would be less than $.50.  Finally, as noted previously, the Tariff does not require refunds, in staff’s opinion.  Nonetheless, staff considered refunds since the cumulative overage in collections indicated that the Tariff had not been administered as intended.

 

Conclusion

 

Staff recommends the Commission find that BellSouth violated the terms of Section A.2.4.6 of its General Subscriber Service Tariff, during all or part of the period 1998 through 2005.  Given that the average per line amount would be less than $.50, and since a significant number of affected customers may no longer be receiving service from BellSouth, staff recommends that no customer credit or refund be required.  Instead, staff recommends that the Commission set the cumulative overage in collections, with interest, as of year-end 2005 at $469,176 and require that BellSouth consider this overage and any overage/underage for January 2006 through June 2006, in setting the Manhole Ordinance Fee to be assessed for the period July 2006 through December 2006.  In addition, staff recommends the Commission find that, pursuant to existing Section A.2.4.6 of its General Subscriber Service Tariff, BellSouth is required to perform reconciliations for each future six-month period and to apply the overage/underage in collections as an accounting adjustment, to determine the appropriate fee. Finally, staff recommends that in the future, overhead loadings be computed using the same method in general use by BellSouth (i.e., the “original” method).

Issue 2: 

 Should this docket be closed?

Recommendation: 

 The Order issued from this recommendation will be a Proposed Agency Action.  Thus, the Order will become final and effective upon issuance of a Consummating Order if no person whose substantial interests are affected timely files a protest within 21 days of issuance of the Order.  With issuance of a Consummating Order, this docket should be closed. (Scott)

Staff Analysis: 

 Staff recommends that the Order issued from this recommendation will become final and effective upon issuance of a Consummating Order, unless a person whose substantial interests are affected by the Commission’s decision files a protest that identifies with specificity the issues in dispute, in the form provided by Rule 28-106.201, Florida Administrative Code, within 21 days of the issuance of the Proposed Agency Action Order.  As provided by Section 120.80(13)(b), Florida Statutes, any issues not in dispute should be deemed stipulated.

Dade County Manhole Data

Revenue less Expense, 1998 – 2005

Per Six Months¹

	Option 1	Option 2	Option 3	Option 4
1/98 – 6/98	($40,141)	($87,433)	($40,141)	$178,260
7/98 – 12/98	$51,942	$20,562	$51,942	$239,290
1/99 – 6/99	$302,763	$263,433	$302,763	$308,574
7/99 – 12/99	$91,805	$21,985	$91,805	$84,187
1/00 – 6/00	$169,128	$127,499	$169,128	$161,434
7/00 – 12/00	$246,741	$206,326	$246,741	$246,843
1/01 – 6/01	($95,093)	($180,791)	($95,093)	($125,195)
7/01 – 12/01	$190,650	$124,650	$190,650	$191,297
1/02 – 6/02	($61,928)	($171,152)	($61,928)	($62,091)
7/02 – 12/02	($70,974)	($138,679)	($70,974)	($78,149)
1/03 – 6/03	$49,319	($30,112)	$49,319	$56,245
7/03 – 12/03	$153,152	$89,343	$153,152	$38,132
1/04 – 6/04	($87,093)	($145,266)	($145,266)	($145,266)
7/04 – 12/04	($235,910)	($298,728)	($298,728)	($298,728)
1/05 – 6/05	$84,448	$45,701	$45,701	$45,701
7/05 – 12/05	($428,401)	($507,544)	($507,544)	($507,544)

 

Option 1 = “Original” Method

 

Option 2 = “Revised” Method

 

Option 3 = “Original” Method 1998 – 2003 / “Revised” Method 2004 –               2005

 

Option 4 = Option 3, excluding corrections with 1998 beginning balance not set to zero, and 2004 beginning balance reset

           

 

 ¹ Excludes Interest.

Dade County Manhole Data

Revenue less Expense, 1998 – 2005

Cumulative¹

	Option 1	Option 2	Option 3	Option 4
01/01/1998  Balance	Ø	Ø	Ø	($1,170,369)
1/98 – 6/98	($40,141)	($87,433)	($40,141)	($992,109)
7/98 – 12/98	$11,801	($66,872)	$11,801	($752,818)
1/99 – 6/99	$314,565	$196,562	$314,565	($444,245)
7/99 – 12/99	$406,370	$218,547	$406,370	($360,058)
1/00 – 6/00	$575,498	$346,046	$575,498	($198,623)
7/00 – 12/00	$822,239	$552,371	$822,239	$48,219
1/01 – 6/01	$727,146	$371,580	$727,146	($76,976)
7/01 – 12/01	$917,796	$496,230	$917,796	$114,321
1/02 – 6/02	$855,868	$325,078	$855,868	$52,230
7/02 – 12/02	$784,894	$186,399	$784,894	($25,919)
1/03 – 6/03	$834,213	$156,287	$834,213	$30,325
7/03 – 12/03	$987,364	$245,629	$987,364	$68,458
1/04 – 6/04	$900,272	$100,364	$842,098	$100,364
7/04 – 12/04	$664,362	($198,364)	$543,370	($198,364)
1/05 – 6/05	$748,809	($152,663)	$589,071	($152,663)
7/05 – 12/05	$320,408	($660,207)	$81,527	($660,207)

 

Option 1 = “Original” Method

 

Option 2 = “Revised” Method

 

Option 3 = “Original” Method 1998 – 2003 / “Revised” Method 2004 – 2005

 

Option 4 = Option 3, excluding corrections with 1998 beginning balance not set to zero, and 2004 beginning balance reset

           

 ¹ Excludes Interest.

Option 1 – Financial Data for the Period 1998-2005

 

		1998		1999		2000		2001
		JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.
MANHOLE FEE:		$0.11	$0.11	$0.11	$0.11	$0.11	$0.11	$0.11	$0.11
REVENUE:		$948,621.89	$977,794.07	$1,000,241.21	$1,015,769.92	$1,025,765.57	$1,042,684.34	$1,055,789.68	$1,023,321.24
VOUCHERED EXPENSE:		$699,928.32	$640,598.34	$480,665.90	$674,849.82	$623,318.29	$574,652.51	$877,780.18	$622,633.75
TOTAL EXPENSE:		$988,762.45	$925,852.19	$697,477.81	$923,964.77	$856,637.86	$795,942.93	$1,150,882.80	$832,671.27
REVENUE LESS EXPENSE
CURRENT PERIOD:		($40,140.56)	$51,941.88	$302,763.40	$91,805.15	$169,127.71	$246,741.41	($95,093.12)	$190,649.97
CUMULATIVE:
12/97 SET TO ZERO:		($40,140.56)	$11,801.32	$314,564.72	$406,369.87	$575,497.58	$822,238.99	$727,145.87	$917,795.84
		2002		2003		2004		2005
		JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.
MANHOLE FEE:		$0.11	$0.11	$0.11	$0.11	$0.08	$0.08	$0.08	$0.08
REVENUE:		$975,046.49	$775,343.38	$849,751.54	$902,131.33	$641,892.13	$604,969.10	$634,538.50	$599,540.97
VOUCHERED EXPENSE:		$796,181.65	$621,998.59	$577,404.83	$528,554.56	$510,193.49	$595,009.06	$365,705.03	$742,749.44
TOTAL EXPENSE:		$1,036,974.55	$846,317.50	$800,432.56	$748,979.49	$728,984.81	$840,879.40	$550,090.81	$1,027,941.93
REVENUE LESS EXPENSE
CURRENT PERIOD:		($61,928.06)	($70,974.12)	$49,318.98	$153,151.84	($87,092.68)	($235,910.30)	$84,447.69	($428,400.96)
CUMULATIVE:
12/97 SET TO ZERO:		$855,867.78	$784,893.66	$834,212.64	$987,364.48	$900,271.80	$664,361.50	$748,809.19	$320,408.23

 

Note:       Data shown in these tables has been extracted from BellSouth Exhibit C, which the company prepared in response to staff discovery. In discovery responses, BellSouth has provided supporting detail for "Vouchered Expense." The figures shown under "Revenue Less Expense" do not include interest.

Option 2 – Financial Data for the Period 1998-2005

 

		1998		1999		2000		2001
		JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.
MANHOLE FEE:		$0.11	$0.11	$0.11	$0.11	$0.11	$0.11	$0.11	$0.11
REVENUE:		$948,621.89	$977,794.07	$1,000,241.21	$1,015,769.92	$1,025,765.57	$1,042,684.34	$1,055,789.68	$1,023,321.24
VOUCHERED EXPENSE:		$699,928.32	$640,598.34	$480,665.90	$674,849.82	$623,318.29	$574,652.51	$877,780.18	$622,633.75
TOTAL EXPENSE:		$1,036,054.93	$957,232.54	$736,807.87	$993,784.72	$898,266.81	$836,358.83	$1,236,580.74	$898,671.22
REVENUE LESS EXPENSE
CURRENT PERIOD:		($87,433.04)	$20,561.53	$263,433.34	$21,985.20	$127,498.76	$206,325.51	($180,791.06)	$124,650.02
CUMULATIVE:
12/97 SET TO ZERO:		($87,433.04)	($66,871.51)	$196,561.83	$218,547.03	$346,045.79	$552,371.30	$371,580.24	$496,230.26
		2002		2003		2004		2005
		JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.
MANHOLE FEE:		$0.11	$0.11	$0.11	$0.11	$0.08	$0.08	$0.08	$0.08
REVENUE:		$975,046.49	$775,343.38	$849,751.54	$902,131.33	$641,892.13	$604,969.10	$634,538.50	$599,540.97
VOUCHERED EXPENSE:		$796,181.65	$621,998.59	$577,404.83	$528,554.56	$510,193.49	$595,009.06	$365,705.03	$742,749.44
TOTAL EXPENSE:		$1,146,198.69	$914,022.46	$879,863.81	$812,788.70	$787,157.67	$903,696.89	$588,837.93	$1,107,084.84
REVENUE LESS EXPENSE
CURRENT PERIOD:		($171,152.20)	($138,679.08)	($30,112.27)	$89,342.63	($145,265.54)	($298,727.79)	$45,700.57	($507,543.87)
CUMULATIVE:
12/97 SET TO ZERO:		$325,078.06	$186,398.98	$156,286.71	$245,629.34	$100,363.80	($198,363.99)	($152,663.42)	($660,207.29)

 

Note:       Data shown in these tables has been extracted from BellSouth exhibits (Revised Exhibit B and Updated Revised Exhibit B), which the company prepared in response to staff discovery. In discovery responses, BellSouth has provided supporting detail for "Vouchered Expense." The figures shown under "Revenue Less Expense" do not include interest.

Option 3 – Financial Data for the Period 1998-2005

 

		1998		1999		2000		2001
		JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.
MANHOLE FEE:		$0.11	$0.11	$0.11	$0.11	$0.11	$0.11	$0.11	$0.11
REVENUE:		$948,621.89	$977,794.07	$1,000,241.21	$1,015,769.92	$1,025,765.57	$1,042,684.34	$1,055,789.68	$1,023,321.24
VOUCHERED EXPENSE:		$699,928.32	$640,598.34	$480,665.90	$674,849.82	$623,318.29	$574,652.51	$877,780.18	$622,633.75
TOTAL EXPENSE:		$988,762.45	$925,852.19	$697,477.81	$923,964.77	$856,637.86	$795,942.93	$1,150,882.80	$832,671.27
REVENUE LESS EXPENSE
CURRENT PERIOD:		($40,140.56)	$51,941.88	$302,763.40	$91,805.15	$169,127.71	$246,741.41	($95,093.12)	$190,649.97
CUMULATIVE:
12/97 SET TO ZERO:		($40,140.56)	$11,801.32	$314,564.72	$406,369.87	$575,497.58	$822,238.99	$727,145.87	$917,795.84
		2002		2003		2004		2005
		JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.
MANHOLE FEE:		$0.11	$0.11	$0.11	$0.11	$0.08	$0.08	$0.08	$0.08
REVENUE:		$975,046.49	$775,343.38	$849,751.54	$902,131.33	$641,892.13	$604,969.10	$634,538.50	$599,540.97
VOUCHERED EXPENSE:		$796,181.65	$621,998.59	$577,404.83	$528,554.56	$510,193.49	$595,009.06	$365,705.03	$742,749.44
TOTAL EXPENSE:		$1,036,974.55	$846,317.50	$800,432.56	$748,979.49	$787,157.67	$903,696.89	$588,837.93	$1,107,084.84
REVENUE LESS EXPENSE
CURRENT PERIOD:		($61,928.06)	($70,974.12)	$49,318.98	$153,151.84	($145,265.54)	($298,727.79)	$45,700.57	($507,543.87)
CUMULATIVE:
12/97 SET TO ZERO:		$855,867.78	$784,893.66	$834,212.64	$987,364.48	$842,098.94	$543,371.15	$589,071.72	$81,527.85

 

Note:       Original" Method 1998 - 2003 (Option 1) / "Revised" Method 2004 - 2005 (Option 2).  The figures shown under "Revenue Less Expense" do not include interest.

 

Option 4 – Financial Data for the Period 1998-2005

 

		1998		1999		2000		2001
		JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.
MANHOLE FEE:		$0.11	$0.11	$0.11	$0.11	$0.11	$0.11	$0.11	$0.11
REVENUE:		$948,621.89	$977,794.07	$1,000,241.21	$1,015,769.92	$1,025,765.57	$1,050,800.36	$1,047,673.66	$1,030,669.02
VOUCHERED EXPENSE:		$520,504.62	$489,409.04	$469,741.73	$674,849.82	$623,318.29	$574,652.51	$889,596.73	$624,885.10
TOTAL EXPENSE:		$770,361.52	$738,503.92	$691,667.54	$931,583.06	$864,331.09	$803,957.85	$1,172,868.55	$839,372.43
REVENUE LESS EXPENSE
CURRENT PERIOD:		$178,260.37	$239,290.15	$308,573.67	$84,186.86	$161,434.48	$246,842.51	($125,194.89)	$191,296.59
CUMULATIVE:
12/97 = ($1,170,368.90):		($992,108.53)	($752,818.38)	($444,244.71)	($360,057.85)	($198,623.37)	$48,219.14	($76,975.75)	$114,320.84
		2002		2003		2004		2005
		JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.	JAN. - JUN.	JUL. - DEC.
MANHOLE FEE:		$0.11	$0.11	$0.11	$0.11	$0.08	$0.08	$0.08	$0.08
REVENUE:		$974,883.36	$768,157.43	$856,687.70	$895,195.17	$641,892.13	$604,969.10	$634,538.50	$599,540.97
VOUCHERED EXPENSE:		$796,181.65	$621,998.59	$577,404.83	$614,756.55	$510,193.49	$595,009.06	$365,705.03	$742,749.44
TOTAL EXPENSE:		$1,036,974.30	$846,306.71	$800,442.96	$857,062.91	$787,157.67	$903,696.89	$588,837.93	$1,107,084.84
REVENUE LESS EXPENSE
CURRENT PERIOD:		($62,090.94)	($78,149.28)	$56,244.74	$38,132.26	($145,265.54)	($298,727.79)	$45,700.57	($507,543.87)
CUMULATIVE:
12/97 = ($1,170,368.90):		$52,229.90	($25,919.38)	$30,325.36	$68,457.62	$100,363.80	($198,363.99)	($152,663.42)	($660,207.29)
1/04 = 245,629.34:

 

Note:       Data shown in these tables has been extracted from BellSouth exhibits (Exhibit A for 1998 - 2003, Option 2 for 2004 - 2005), which the company prepared in response to staff discovery. In discovery responses, BellSouth has provided supporting detail for "Vouchered Expense." The figures shown under "Revenue Less Expense" do not include interest.