Tuesday, April 5, 2011

INITIATING COMMUNICATIONS COST MANAGEMENT

Communications cost management (CCM) should be initiated or approved by a senior executive or officer equivalent responsible for ensuring organizational expenditures and accounting are in compliance with accounting and financial rules applicable to the organization. This individual should request or be provided with a briefing on known and suspected level of expenditures directly attributable to telephone service (i.e., data communications, website development, deployment, web publishing, content distribution, delivery, e-commerce, two-way radio, satellite, cable television, and any other service that could be deemed to be or directly support the organization’s internal and outside communications).


Communications Cost Management Executive Briefing Content Preparation

An executive briefing should be prepared for by researching basic facts and parameters of the organization’s communications cost accounting and operating practices. The following list of high level actions, analysis, and summary outlines what and how to prepare and present the information:
  • Gather all known contracts and billing agreements for voice, data, video, and Internet equipment, facilities, and services. If there are bills being paid according to tariffs on file with the FCC or PUC, obtain a copy of all the tariffs referenced in each billing. If it’s convenient and easy to get, include postage meter usage and overnight shipping, especially departments whose work output is not something physical other than paper documents. Every paper document is a candidate for electronic transmission at a fraction of the cost. And don’t forget that compact discs and other magnetic or optical media contain files that go quicker through the network at a similar fraction of the cost of paper.

  • Gather up at least 3, preferably 6 months worth of paid bills. Each bill should show circuit identification or other deliverable being billed. If the individual items on the invoices are not clear, get an explanation of the item, function, or purpose from the service provider. This should be a written service description that provides greater detail than what is included on the invoice. Usually the invoice references some kind of service description. If the unit price of the deliverable is not included on the invoice or in the service description, request this information from the service provider specific to each invoice.

  • Make a list of all billed deliverables paid for and include department, location, and name of the employee using the item. If it is a common item, such as a data line, list all the computer applications using the facility. Accounting might be able to provide a file or printout with this level of detail.

  • Find out how the organization acquires or otherwise commits to pay for communications services. The two best places to start are purchasing and accounts payable. Is there a central source for coordinating and consolidating service ordering and terminations? Does each department just order a telephone line or other service or facility when they need it and then pay the bill when it comes in?

  • Make a list of all equipment owned or leased and include year acquired, current book value, or unpaid lease obligation, monthly depreciation or lease payment, monthly maintenance cost, and planned replacement date if any. Some or all of this information may be available from accounting asset records or inventory files.

  • Summarize all known vendors by service, equipment, and estimated annual unit and dollar volume.

  • If cost management is an internal function, summarize headcount, professional specialty, and job responsibility of each individual directly attributable to CCM.

  • If a significant level of expenditure is attributable to outsourced or vendor-provided CCM exists, summarize the specific vendors, term of contract, monthly or annual cost, list of work activities and deliverables, and names of key individual contributors responsible for the deliverable, their professional specialty and job title, pay grade, and responsibilities.
The briefing should provide a complete picture of how much money is at stake, what it’s being spent for, and the value of the assets attributable to communications functions by department and organizational function. For example, if a set of server hardware and software exists that is used by a single department in engineering, marketing, sales or other area, make sure that department and the function for which it is used is very succinct and clear.

In addition to being clear and succinct about the cost and use of communications assets and expenditures, it is critical that the process and practices being followed be equally clear. This knowledge and information can be used to rationalize next steps and characterize current status. The outcome should be a realistic assessment of the process and practices with respect to compliance with applicable accounting and reporting rules under which the organization operates. Recognition of potential savings is important because real money is at stake. If changes need to be made in operating practices or procedures to improve the competitive or strategic position of the organization, this is the time to get that on the table for consideration as well.

Next Steps

By the time the work in the executive briefing is completed, it is highly likely that additional steps will have been taken, but not included in the briefing. What needs to be done is to take the high level work items, and expand the details of each to gain deeper insight and understanding of how much money is at stake, potential savings, improvement in service levels, better use of human resources and assets, and the limits of flexibility as represented by spare or unused capacity for growth.

Once you have an overall picture of how much money is at stake, and what it’s being spent for, you can consider and decide the level and timing of effort appropriate for further work because you are now ready to take constructive, proactive ownership and management of communications cost in the enterprise you’re part of. Here’s a high-level list of topics and an explanation of what needs to be done, how to go about it, and a view of value or impact on the organization’s ability to accomplish its mission.

Friday, April 1, 2011

Automated Invoice Validation System

Automated invoice validation requires a file from the telephone company. Most, if not all, telephone company–provided billing information is assembled in standard formats and made available on various transport media or transported across a network connection. If no validation system exists, or for whatever reason it’s desirable to design and build a new one, the process involves getting a file and proceeding to extract the required information from it. The key fields used to match to department allocation are the location and telephone numbers. Information in these fields must be unique. It is highly likely your organization already has unique location names or numbers. In and of itself, the unique name is not sufficient for full allocation. The telephone number making and receiving calls is unique to the telephone company, and they have their own counterpart to the location name, which is a physical port on a switch or access facility into the nearest wire center.


In addition to the key field data, detailed unit count and pricing for all fixed monthly charges and all variable or usage based charges should be extracted and carried over into a file in the organizational accounting system. In addition to the charges for service, taxes and other fees such as access charges and universal service fees should be extracted and maintained in the file. Essentially what has to be done is to take this file with the current charges and perform all the calculations done by the telephone company and re-create the same information, but instead of using the reference pricing they used, use a separate reference database.

Figure 1 is a conceptual diagram of the invoice validation system.

 
Figure 1: Telephone Billing File Interface to Enterprise Accounting System

It must be implemented in the organization’s information technology (IT) infrastructure or built separately and integrated with the other systems.

Note the dotted line from vendor pricing. It will become solid after completion of the standard cost development in steps 4 through 8. Resist temptation to jump too far too fast until you’re confident the following functions are being performed:
  • Import the billing file
  • Extract the desired data
  • Compare the data from the reference file with the billing file and highlights exceptions
  • Output a list of invoices with amounts due by department, location, and user name satisfactory for feeding the cost allocation process
  • Output a file with taxes and desired details required for allocation and further possible tax treatment
  • Output a file with any or all fees in a format acceptable for use by the accounting and reporting systems
This will provide a preliminary look at the difference between manual invoice validation and automated validation. So far the only expenditure is the billing tape (should be under $50 for each telephone company, $100 for one local and one long distance) and the value of the time of the programmer(s). When the bill data of the first service provider(s) is successfully imported into the accounting system, incremental service providers, locations, and service should require less time and occur smoothly. If there are issues with the second, be sure to go back and resolve any common issues with the first one. Over time and with additional service providers, adding more billing into the system will become routine.

Saturday, March 26, 2011

CHALLENGES AND POTENTIAL REWARDS OF COMMUNICATIONS COST MANAGEMENT

The accounting question in lay terms: Are the charges valid, can they be verified, and are they treated in a manner consistent with accounting practices across communications expenses and assets?

Beyond basic compliance issues, there are immediate potential hard-dollar savings. There are also other benefits that come from good management practices. Potential savings vary depending on the size of the organization and the effectiveness of current practice. Realizing the savings requires headcount and computer resources appropriate to the size of the organization. To get a feel for potential impact you can compare your organization to large and mid-size business.

Fortune 500 companies average $10 to $12 billion in annual revenue and typically spend $100 to $120 million on communications. Mid-size companies average $18 to $20 million in revenue and spend $20 to $30 million on communications. It takes between one and seven heads to pay the (monthly) telephone bill, which typically ranges between a few hundred and several thousand invoices, where each invoice may contain several hundred or several thousand pages (or pounds). The monthly delivery of the telephone bill becomes a point where the physical work involved in breaking the bill down and entering the actual charges into an accounting system is a daunting effort. Validating the charges is almost never done, and that’s one of the areas where cost management can realize significant hard-dollar savings. How much is the issue. General industry consensus based on experience is a range of 10% to 12% of total spending during the first year, tapering to half that level over the next 4 or 5 years. If one took the numbers literally, that would indicate a positive impact on earnings for the Fortune 500 on the order of $10 to $12 million or 10% of earnings, and $2 to $3 million for mid-size companies. How to realize that kind of impact on net income is attention-getting for any sane chief financial officer or chief executive officer.

Very few, if any, large companies receive and pay paper phone bills today. Even with the demise of paper invoices, the number of transactions and invoices cries for some form of automated invoice validation. Pricing complexity for basic services, plus the burdens of taxes, access charges, universal service fees, and other add-on charges imposed by federal, state, and municipal tax authorities all add up to a significant challenge. Adding normal business expansion, contraction, churn, and change doesn’t make it easier. Automated invoice verification requires the bill in machine-readable form and an accurate, well maintained reference database containing standard cost and inventory of circuits, equipment, facilities, and services.

Defining the Problem

Recall the earlier description of what is included in telephone service bills—they are highly summarized and comparing each charge in each invoice is very labor intensive. To put the problem and a potential approach to solving it in perspective, it is helpful to diagram it out as shown in Figure 1.


Figure 1: End-to-End Billing and Cost Allocation Process

On the service provider side, it is easy to see that the billing submitted is made up of many components. The basic service charges include a fixed monthly charge for local service and variable charges for long distance service. In addition to basic service charges, there are a myriad of federal, state, and municipal taxes, FCC access charges, universal service fee, and others. 

FCC access charge funds do not get remitted to the FCC. They go into the RBOC Treasury. This has implications for the future as far as eliminating variable long distance charges.

On the organizational side of the problem, we have two basic needs: keep track of taxes that may have an impact on corporate income or other taxes and fees that may be useful when dealing with community relations or investor information, and allocate total expenditures to all the departments in the accounting system.

Tuesday, March 22, 2011

ANATOMY AND PATHOLOGY OF COMMUNICATIONS BILLING AND PAYMENT

Billing for communications equipment, facilities, and services has its roots in telephone service billing. For many years before 1984, AT&T’s local operating companies generated the vast majority of telephone bills. Pricing was based on tariffs accepted and filed with the Federal Communications Commission (FCC) and each state Public Utilities Commission (PUC). Basically there were two rate structures, one for business or other organizational entities and another for residential service. Pricing was a combination of a fixed monthly charge to subscribe to local service, plus an incremental charge for calls outside the local exchange area, also called a long distance call. Charges for long distance calls were made each time long distance service was used and calculated on the basis of a minimum charge for the first 3 minutes, plus a per-minute rate for each additional minute the call continued beyond the first 3 minutes. The basic minimum and additional minutes rates were also distance sensitive. The longer the physical distance between the end-points of the connection, the higher the rate. Go back and read this paragraph again.


So far, we have a basis and method for calculating charges for service. Nothing has been mentioned about extra charges for other fees and taxes. We can get by this point fairly quickly by using the simple technique our elected governing brethren use when exercising their awesome responsibility to levy taxes—simply tell the merchant to charge and immediately remit a flat percentage against an item or on the total amount. Maybe we should add on one other little detail. How many taxing entities are there? Hard to say, but we can estimate starting with one federal, 50 state, and thousands of local municipal and county entities who want to charge some small amount for the privilege of paying a telephone bill within the boundaries of the governmental jurisdictions where one lives and works.

Now we are at a point in our anatomy and pathology where we have written a high-level description of the method for arriving at the charges for one or a primary telephone line for 1 month of service. With the magic of simple addition and multiplication on an already complex process, we can contemplate printing and presenting a bill for payment. What does the bill look like? First there’s a summary of fixed monthly charges for subscribing to the service, complete with taxes. Then there’s the long distance calling summary, complete with details about the time the call started, duration, and charges for each call. For one call, or none, add one more page for long distance service. For the 21st call, add one more page. From the service provider perspective, we now have a streamlined process where we can bill for the majority of our customer base as long as they are single line customers. Oh, and by the way, because we are considering this from the telephone company’s perspective, we also have a streamlined provisioning process whereby every single order for changes or new service drives the single line billing process. What happens when someone wants a second telephone line? Simple answer: Install one and send a second bill each month.

By now your hair is hurting, or if it isn’t, then get ready, it may begin to hurt shortly. Sure it’s painful, but you must understand this picture, else communications cost management will remain elusive and without value. Remember, we are trapped in telephone service billing and payment before 1984, which means one bill for each telephone line, one payment for each bill. Not bad for residential and small business, school, church, library, or other organizational entity to deal with. Telephone service for the masses. What about the larger organization with a corporate headquarters and tens, hundreds, or maybe thousands of field offices? Or a state, county, or large city government with hundreds or thousands of employees in many locations, each with at least one telephone line. You guessed it; phone bills in boxes, not envelopes, measured in pounds, not pages.

The telephone company rose to the challenge, installing service, which works well, and delivering a bill for which payment is expected in due course. Now it’s someone’s job to validate the bill and pay. And with that, we have arrived at the point where it starts to make sense to consider communications cost management process and practice in large and mid-size organizations—business, non-profit, government secular, or whatever—the consideration is how many telephone lines are required and being paid for. And remember, this is before 1984, and only applies to telephone service, single line access to shared switching facility based services called plain old telephone service (POTS). What’s happened since 1984, you might ask. The simple answer is that beginning with the divestiture of AT&T and deregulation of the long distance communications industry, businesses and residential subscribers had to replace single line, single-service billing with triple billing and in many cases initially with triple payment, one for equipment, one for local service, and a third for long distance service. Stop and think about it—the number of billable items tripled. The amount of envelopes and postage tripled or maybe quadrupled.

Fast forward to 2003 and consider again that communications cost management is not just paying the telephone bill any more. What was a single bill changed into multiple bills because of deregulation and divestiture in 1984. Since then, technological advances and availability of commercial products and services from hundreds or thousands of potential suppliers morphed into hundreds or thousands of bills representing millions of transactions for data traffic, mobile telephones, pagers, two-way radios, remote site security and surveillance services, Internet web access supporting internal and external supplier, and customer transactions, as well as plain old telephone service. Now instead of one trusted supplier whose bill was (appropriately or inappropriately) trusted for so many years, we now have many suppliers requiring some level of validation and due diligence to comply with basic accounting rules, tax statutes, and fiduciary responsibility. Read this paragraph again. Not only are there common sense reasons to manage and pay communications costs wisely, there may be legal implications as well. Check out the Sarbanes-Oxley Bill of 2002 and talk to your attorney and an outside auditor.

Friday, March 18, 2011

ACCEPTANCE OF EQUIPMENT

Digital equipment and systems always include some form of software. After all, digital hardware wouldn’t be of much value without the software. Software sometimes goes by other names or euphemisms such as firmware or micro code. Less often, other software such as interpreters and compilers and utilities may be included or supplied with equipment or part of systems. Application or configuration software may be required for the equipment or system to function properly or meet requirements. Applications software might be the product of a third party developer. The possibilities are many, but what is important is what the requirements are or what was included in the order or supply agreement that caused the equipment to be delivered.


The digital television transmitter contains detailed specifications and a general approach to test and acceptance. This gives the potential supplier an idea of expected performance and an outline of proving the equipment meets or exceeds the specifications. What is not included is a detailed test plan. A test plan can be written from scratch by the buyer or alternatively provided by the supplier as part of the deliverables, subject to approval by the buyer. Both require significant effort to prepare and validate. Chances are the supplier or the manufacturer already has a detailed test plan for each component or subsystem used in the manufacturing process as well as a system test plan for a complete unit.

Making a manufacturer’s system test plan valid for use in accepting the equipment is dependent on emulating the intended use and environment. Essentially, this involves assembling the system as close as possible to the final operational configuration. In most cases this is not a big issue. However if the equipment or system will carry significant volumes of traffic, this may not be possible, except through the use of traffic generators. Again, the main concern is to carry out any and all steps included in the supply agreement. Simply making measurements and validating functions and features outlined in the supplier’s published specifications is prudent and helps to uncover and resolve any issues or concerns.

Acceptance of Circuits, Facilities, and Services

On the service provider side, similar concerns and processes exist. The governing approach is either in a tariff or some form of supply agreement. If not explicitly mentioned or called out, then the alternate approach is to use applicable ANSI, IEEE, IETF, ITU, or other applicable recommendations. The process and focus of the effort should be structured around the end-to-end service model block diagram. Initial concern is to make sure connectivity exists by examining and testing the underlying circuit or facility. Validating or accepting a new circuit on an existing facility is less complicated but riskier than accepting a new facility. Regardless, the process is fairly simple and very similar.

If the circuit or facility is intra–LATA (local), only one provider is involved. If it is inter-LATA (long-distance), three service providers are involved: two local exchange carriers and one inter-exchange carrier. If the service is international, the international portion will involve two more physical pieces and a local exchange carrier at the far end.

Circuit acceptance in any case involves a fairly simple process and requires relatively simple test equipment. When the service provider informs you that it is ready for acceptance, simply connect the equipment, loop back the circuit at the far end, and initiate a bit error rate performance test for at least 48 hours—preferably 72 hours. The circuit should perform error free. If there are errors, turn it back over to the provider and ask them to fix it.
Once the circuit or facility is accepted, then remove the bit error rate test equipment and replace it with the operational equipment (multiplexer, server, or whatever) and begin operational tests with the complete system.

Monday, March 14, 2011

DOCUMENTATION DEVELOPMENT PROCESS

Documentation typically starts when a bright idea appears on the scene. The bright idea may fix a problem, expand production capacity, save operating expense, or change the way a company does business. For content transport networks, the project will likely be structured around a combination of equipment, facilities, and services. Carrying the project through to completion will hopefully have a favorable impact on revenue and operating expenses, be profitable when completed, and require significant capital investment.


Starting documentation should be done at the earliest possible time and continue throughout the project with a final release upon completion and commencement of operations. Documentation should reflect reality as closely as possible during the construction and test phases, and especially upon completion. Sloppy or incomplete and uncoordinated documentation leads to mistakes and mismatches, any or all of which can cause re-work, which can be expensive.

Missing details in the final release can impede quick and efficient repair or service restoration.
Documentation should mature as the project matures. Small projects where the project manager functions as the design authority and holds overall responsibility for the project should follow the same process as large projects with dedicated full-time design, scheduling, and financial staff. Components in the documentation include an initial sketch, first draft, preliminary release, one or more revisions, and a final release.

The initial sketch is simply a combination of a brief description of the idea in written form and one or more drawings. It may also include a high-level table or spreadsheet containing preliminary budget estimates of cost, revenue, and profit impact.

A designated project manager should prepare a first draft document as soon as the bright idea gains traction and sufficient interest. This individual should be knowledgeable about the technology and basic business financial aspects of the project. The first draft should be as complete as possible in technical and financial terms. At a minimum, it should contain a technical description, list of equipment, facilities, and services required, a statement of the impact on operational functions, an estimate of the cost, revenue, and profit impact in as much detail as possible, and a schedule or estimated time frames associated with major phases or activities making up the project.

Design review is a critical step in any project. Design reviews are nothing more than a small group of experts from accounting, purchasing, operations, and engineering considering the details of a proposed or in-progress project and making an assessment of the potential risks and unknowns associated with various aspects of the project. A design review can be conducted at any time during the life of the project after the first draft documentation is complete. Depending on the scope and size of the project, it may be valuable to stage multiple reviews as a project progresses. Design reviews may morph into project status reviews over time.

Some practitioners find it valuable to conduct the first design review before release of an RFP, and a follow-on review after responses are received, evaluated, and preliminary vendor selection is completed. Vendor presentations can be made part of a design review where all functional organizations representatives have an opportunity to gain exposure to potential suppliers and assess their ability to perform.

A preliminary release, sometimes called version 1.0, is considered the first example of final documentation. It should include all the documents deemed to be appropriate and necessary for accounting, purchasing, installation, test and acceptance, operations, administration, maintenance, and change procedures. Each document created specifically for the project should contain a reference section where specific third party documents, standards, construction codes, regulatory, and other references are noted. The preliminary release should include updated and extended versions of all documents included in the first draft. Equipment, facilities, and services should be as detailed as possible, and at a minimum include quantity, part number, or other reference identification to be used by accounting when auditing and paying one-time or recurring charges.
One important document in the preliminary release is a formal test plan and acceptance form. This document should be in a state of completion so it can be used to verify physical, functional, and performance characteristics of equipment, software, facilities, and services provided by third parties in fulfillment of purchase orders and accepted proposals. The test plan acceptance form should have matured through the RFP and contract process with each third party. Exceptions or conditions related to acceptance should be documented and any agreement to waive or delay performance as agreed in any contract should be within the context of the test plan.

The documentation should be carefully managed during the construction, test, and acceptance phase. This involves attention to physical details such as cable, patch panel, and rack label details as well as configuration parameters. For example, IP address and phone number details should be checked and double-checked from the time they are planned until final check-off on the completed documentation. Class and type of service designators must be validated.

As the documentation and construction come closer and closer to reality, it may be necessary or appropriate to make additional releases. These should be clearly labeled with a new version number, such as version 1.1, similar designator, dated, and maybe even timed, depending on circumstances and potential requirement to maintain coordinated work to continue. It is also advisable to maintain a change record summarizing the changes included in each release, why changes were necessary, and the specific section and page where the changes were made.

Thursday, March 10, 2011

EVALUATING SOURCES OF SUPPLY

Evaluating sources of supply may be more critical than evaluating what’s being supplied. After all, the best equipment or service on the planet is greatly diminished in value if it can’t be depended on. Repair, replacement parts, and upgrades are important life cycle extenders. The latest gadget has diminished value if your organization gets sued for patent infringement by the supplier’s competitor and the entity the gadget was purchased from isn’t around, or doesn’t have the resources to defend itself and its customers in such an action. No matter who is right, the outcome is less than satisfactory.

If your organization uses a purchase order process (i.e., limits the power to commit funds to be paid in exchange for goods and services using a purchase order form) then it’s likely the individuals authorized to issue POs can conduct supplier due diligence. Initial or preliminary due diligence is general in nature and does not require any technical subject matter expertise beyond a qualified purchasing representative’s knowledge of buying what the acquiring organization needs for its business. As project planning proceeds and technical concerns arise, subject matter expertise will be needed to complete the due diligence process.

Evaluating sources of supply is a process whereby accounting, contractual, legal, and technical subject matter expertise investigate and quantify potential risks of doing business with an unknown third party. It involves an examination of the entity’s financial health, ability to produce deliverables in the level and amounts required, and its ability and reputation for post-deliverable support of whatever type is required by the acquiring organization.
Evaluating the financial health and stability of a potential supplier can be accomplished by examining a set of audited financial statements covering a period of time in the past. Publicly traded entities that are potential suppliers are required by law to file quarterly and annual financial statements. If the potential supplier is not a publicly traded company, then there may be other sources of financial information such as Dunn & Bradstreet. D&B is a credit rating organization, providing credit history and assessment. As such they have access to information on most any entity that wishes to do business on credit. They also collect information about how the subject pays their bills. 

For example, do they pay on time, or according to agreed on terms, or are they occasionally or perpetually behind? These same agencies also monitor and report on lawsuits and extraordinary events that may have an impact on the company. Considerations or concerns about the potential suppliers intellectual property rights may be found in simple searches that can turn up patent or copyrights granted.

The overall concern amounts to the ability of the supplier to produce and support the required quantity of equipment, software, or facilities and services for the time required, typically ranging from 2 or 3 years to longer than 10 years. The ability to conduct due diligence isn’t rocket science; it’s mostly a matter of common business knowledge. You and your peers in accounting that deal with purchasing, contracting, and paying bills can undertake and complete it with a reasonable amount of time and effort.