13. Materials Management Controls and Procedures

· The Department of Public Works has recently remodeled and expanded the materials storeroom at the 2323 Cesar Chavez Street maintenance yard. The operating bureaus have increased the inventory that they maintain in the storeroom. Storeroom issuances from the storeroom to the Bureau of Building Repair in fiscal years 2004-2005 and 2005-2006 were only $11,266 and $11,586, respectively, although the Bureau of Building Repair expends in excess of $3 million annually on materials and supplies. The Bureau receives all other materials to be used for projects directly at the requesting Bureau trade shop. However, the Bureau maintains materials left over from or not used for projects within the confines of the trade shops. The Bureau has no formal inventory of these materials, creating the risk of theft, loss or misuse of the materials.

· In general, City departments lack adequate inventory and material storeroom internal controls. Since 2003 the Budget Analyst has audited the storerooms of the Port, the Public Utilities Commission, the Recreation and Park Department, and the Department of Public Works, and found that many of the departments lacked standard storeroom practices and in some instances had significant control deficiencies. Inadequate storeroom internal controls has been a long-standing Citywide problem, previously identified by the Budget Analyst in a 1991 report. The Department of Public Works should work with the City Services Auditor to establish a system of controls that can be extended to other City departments.

· The Department of Public Works should also develop formal materials policies and procedures to ensure standardized and efficient materials management.

· The Department of Public Works does not ensure that only authorized staff approve department purchases. The City's Office of Contract Administration has procedures to ensure that only authorized staff approve purchases. However, three Department of Public Works' staff regularly approve purchase orders without formal authorization. Thus, a set of controls developed by the Office of Contract Administration to provide reasonable assurance that procedures developed to implement the sensitive authority of procuring commodities and services of up to $10,000 on each such procurement were not being adhered to by the Department of Public Works.

Inadequate Control of Storeroom Operations Citywide

Since August of 2003, the Budget Analyst has audited the storerooms of the following City Departments:

The Port of San Francisco

The Public Utilities Commission storerooms

o Water Pollution Control Division

o Hetch Hetchy Water and Power Division

o City Distribution Division

o Water Supply and Treatment Division

Recreation and Park

Department of Public Works

The audits of the seven storerooms have revealed a lack of standardization in storeroom practices and in some instances significant control deficiencies. Whereas the Public Utilities Commission's Water Pollution Control Division's storeroom operates with effective controls, the following statements from the Port of San Francisco and Recreation and Park Department storeroom audits highlight significantly deficient conditions:

The Port of San Francisco

The storeroom is unkempt, with a crust of dirt on most of the items stored. At the outset of this management audit, the storeroom was in essence a highly disorganized warehouse, with items of inventory commingled with all manner of non-inventoried items, such as relics taken from the Ferry Building. Lately, there have been improvements made to the organization of the storeroom

Many of the shelves in the storeroom do not have bin locations. Thus, as is the procedure in auditing storerooms for the accuracy of inventory, one cannot obtain an inventory bin location, proceed to that location, and determine whether the actual number of inventoried items matches what is recorded in the inventory records& .

The Recreation and Park Department

The Structural Maintenance Division does not maintain an inventory of the many thousands of dollars in material and supplies stored in the trade shops, in shed bays, or in the open, central yard& .

With the exception of work orders for reimbursable work and capital projects, the Structural Maintenance Division does not record material usage on its work orders& .

As previously stated, the Recreation and Park Department operates a storeroom that is located in the Structural Maintenance Division's yard. According to the Classification 1936 Senior Storekeeper who has operated the storeroom for the last 19 years, the Recreation and Park Department has not conducted an annual physical inventory in at least the last five years. According to the Senior Storekeeper, management eliminated the physical inventory in order to avoid the cost of performing the inventory.

The Budget Analyst released a management audit report on the Purchasing and Storekeeping Functions as Administered by the Purchasing Department in March of 1991. At the time of the audit, the Purchasing Department's Stores and Equipment Division operated 20 storerooms for ten departments, including nine storerooms of the Municipal Railway, which was then a part of the Public Utilities Commission. The Port of San Francisco storeroom was under the Port of San Francisco. Subsequent to the audit, control of the all departmental storerooms under the Purchasing Department was transferred to the respective departments.

The general finding statement and recommendations of Section 2.1, Administrative Control, which pertain to the administrative control of the departmental storerooms and the need for guidelines and procedures, are as follows:

Section 2.1: Administrative Control

The Purchasing Department manages the various decentralized departmental storerooms as if these storerooms are central and Charter mandated. However, administrative control of the various departmental storerooms is divided between the Purchasing Department and the operating departments, which has resulted in poor management of the storerooms. The storerooms are departmental in nature, and would be managed better if full administrative control were given to the operating departments, and if the Internal Audits Division of the Controller's Office made periodic reviews of the efficiency and effectiveness of operating departments' administration of the storerooms.

Recommendations

We recommend that the Purchasing Department, in conjunction with the operating departments:

Classify all storerooms not under the direct supervisor of the Director of Purchasing and Services as operating departmental storerooms as opposed to central storerooms.

Continue to develop a City-wide set of guidelines and procedures and a training program, as outlined in their operational plan, on storeroom operation and management as recommended in Section 2.2 of this report.

We recommend that the Internal Audit Division of the Controller's Office:

Develop a City-wide set of guidelines and procedures for City storeroom internal control.

Develop an audit program for periodic reviews of the performance of the department storerooms.

Request three new Financial Auditor positions to implement and maintain the audit program.

According of the Office of Contract Administration, the current management has no knowledge of the Citywide set of guidelines and procedures on storeroom operation and management ever being developed. The City Administrator, who oversees the General Service Agency, including the Office of Contract Administration and the Department of Public Works, should direct the Office of Contract Administration to develop Citywide guidelines and procedures on storeroom operation and management.

According to the Manager, Internal Audits Division of the Controller's Office, the recommendations have not been implemented. The Department of Public Works should work with the Controller's Office to develop materials management internal control guidelines and audit schedule, as part of the Department's work order for City Services Auditor services.

Storage of Materials and Supplies and Tools at the Operations Division

The Department of Public Works maintains a storeroom/toolroom in the Cesar Chavez Street Maintenance Yard of the Operations Division for the purpose of servicing the four Bureaus of the Operations Division. During the entire period of this management audit, the storeroom operation has been undergoing significant physical remodeling and expansion of storeroom responsibilities.

As a percentage of total material usage within the Department of Public Works, the operations of the storeroom expanded from issuances of $288,943 in fiscal year 2004-2005 to issuances of $697,453 in fiscal year 2005-2006, an increase of 141.4 percent. Further, the storeroom inventory reports show a significant increase in the number of line items stocked and total inventory value between fiscal year 2004-2005 and fiscal year 2005-2006: 490 inventoried items with a total value of $250,252 in fiscal year 2004-2005 to 819 items with a total value of $668,890 in fiscal year 2005-2006. The storeroom has assumed storage responsibilities for many of the items used by the Bureaus of Street and Sewer Repair, Street Environmental Services, and Urban Forestry. However, the storeroom responsibility for items used by the Bureau of Building Repair is still small compared to the potential efficient storage by the storeroom.

The Bureau of Building Repair expended approximately $3 million on work order material during fiscal year 2005-2006. However, material ordered for use by the Bureau of Building Repair is not processed through the storeroom. Storeroom issuances from the storeroom to the Bureau of Building Repair in fiscal years 2004-2005 and 2005-2006 were only $11,266 and $11,586, respectively. Following approval of Bureau of Building Repair purchase requests by the Department of Public Works Accounting Office that is located on-site at the Maintenance Yard, material ordered by Bureau of Building Repair personnel is either delivered to the requesting shop or picked up from the vendor by the user. In general, the Bureau of Building Repair trade shops do not order material for inventory; each material order is in support of an approved work order.

The trade shops of the Bureau of Building Repair do, however, maintain material within the confines of the shop or a shop annex. These inventories consist of material left over from completed jobs, from material ordered but not used because of cancellation of the work order, or from material cannibalized from equipment and fixtures no longer in service. There is no formal inventory of these stores of material.

According to the Deputy Director for Operations, the ultimate objective of Operations Division storeroom operation is to store all common items used by the Bureaus and all Bureau-specific items for which there is a recurring demand and which can be economically and efficiently stored by the storeroom. The Budget Analyst agrees that there is much room for efficient and effective expansion of storeroom inventory and control of material. The objective should be adequate control of material without adversely affecting the effectiveness of the Bureau of Building Repair trade shops and other bureaus of the Operations Division.

Lack of a Materials Management Policies and Procedures Manual

The Operations Division of the Department of Public Works does not have a Materials Management Policies and Procedures Manual to standardize its processes for obtaining goods and services. Good practice requires that the Operations Division develop a Materials Management Policies and Procedures Manual to simplify and supplement the various Administrative Code and Office of Contract Compliance provisions that regulate the procurement of goods and services in City government. As an administrative control, a Materials Management Policies and Procedures Manual provides standardization and accountability. The absence of a Materials Management Policies and Procedures Manual, which in addition to this current audit report, the Budget Analyst has reported on in recent audits of the Port of San Francisco, three divisions of the Public Utilities Commission, and the Recreation and Park Department stems from a lack of appreciation by management of the power of policies and procedures as administrative controls. The Budget Analyst strongly recommends that the Deputy Director of Operations develop a Materials Management Policies and Procedures Manual.

Examples of topics covered in materials management policies and procedures manuals that apply to storerooms are shown below in Table 13.1.

Table 13.1

· Policy and Functions of Materials Management

· Authorization to Withdraw Materials from the Storeroom

· New Stock Requests

· Receiving Material

· Storeroom Issues and Credits

· Bin Locations

· Storeroom Scheduled Deliveries

· Low Value Items (Free Stock)

· Back Orders

· Non-Discrimination in Contracts

· Departmental Blanket Purchase Order Procedures

· Cost of Ordering and Cost of Carrying

· Departmental Purchase Requisitions

· Inactive Inventory

· Purchase Requisitions

· Physical Inventory

· Active Inventory

· Management Reporting

Materials Management Policies and Procedures Policies and Procedures Manual Example Contents

The "Lower Yard"

The "Lower Yard" area of the Operations Division Maintenance Yard is used as a vehicle park; as a store of plant material, soils, and equipment of the Bureau of Forestry; as a store of homeless belongings, and as a store various materials, primarily those of the Bureau of Street and Sewer Repair. At the initiation of this audit, the Lower was unsightly and disorganized. At the time of the April 6 2006, inspection the appearance of the Lower Yard had improved somewhat. However, the Health and Safety Inspector recommended that the Department "Improve housekeeping and store supplies, equipment, and abandoned items in an orderly manner. Discard items that are unusable."

At the time of a final walkthrough of the Lower Yard on October 10, 2006, most if not all of the deficiencies cited in the Health, Safety, and Environmental inspection of April 6, 2006, had been corrected and the orderliness and general appearance was excellent.

The Budget Analyst recommends that the Deputy Director of Operations and the Manager Environmental Health and Safety continue to emphasize the importance of orderliness and good housekeeping to successful operations and a healthy and safe environment.

Procuring Goods and Services

Chapter 21 of the San Francisco Administrative Code governs the acquisition of commodities and services. Section 21.03(a) of the Administrative Code provides approval authority for the acquisition of commodities and services, as follows:

(a) Approval of Purchases. The Purchaser shall purchase all Commodities or Services required by City departments and offices of the City, except as otherwise provided in the Charter and Municipal Code of San Francisco. The Purchaser shall, by regulation, designate and authorize appropriate department personnel to exercise the Purchaser's approval authority for contracts approved as provided in this section.

Accordingly, the Purchaser has the authority to delegate signature authority to departments up to the specified dollar amount, currently $10,000, stated in regulation 21.5(a) of the Rules and Regulations Pertaining to the San Francisco Administrative Code, Chapter 21, promulgated by the Purchaser.

In addition to the foregoing "Delegated Departmental Purchasing" authority under which departments are able to procure individual goods and services through Departmental Purchase Orders, the Purchaser may also delegate Departmental Blanket Purchase Order authority. Unlike a City Blanket Purchase Order (also known as a "Term Contract") under which all City agencies may procure commodities and services at a price negotiated by the Purchaser, Departmental Blanket Purchase Orders are established individually between a department and a vendor. Currently, Departmental Blanket Purchase Orders for open market purchases in excess of $50,000 require the approval of the Office of Contract Administration. Individual orders against the Departmental Blanket Purchase Orders, called "releases," are currently limited to $1,000 per vendor, per day.

A third method of departmental procurement, the Direct Voucher method, is used for small purchases, normally $200 or less.

Departmental Purchase Orders

The Purchaser has promulgated specific rules for departments to follow in order to continue to use Delegated Departmental Purchasing authority, as follows:

Departments must submit a roster of employees in the department who are authorized to purchase goods and services using delegated purchasing authority.

The roster must list employee name, Civil Service classification, address and telephone number. The Office of Contract Administration may restrict the delegated authority to certain Civil Service classifications as appropriate, upon a review of the information submitted.

All designated employees are required to attend a Purchasing training class. The roster must indicate the date training was completed.

All employees who exercise delegated Purchasing signature authority must adhere to the Principles and Standards of Ethical Purchasing Conduct promulgated by the Office of Contract Administration and must sign a statement attesting thereto.

All designated employees shall file Form 700, Statement of Economic Interests annually as required by the Article III, Chapter 1, of the San Francisco Campaign and Governmental Conduct Code.

The Office of Contract Administration provided the Budget Analyst with its list of Department of Public Works staff persons authorized to engage in departmental purchasing. The list contained five names, including one of a recently retired employee. However, our review of delegated departmental purchasing documents showed three Department of Public Works staffmembers who regularly approve delegated departmental procurements were not named on the authorized listing obtained from the Office of Contract Administration. Thus, a set of controls developed by the Office of Contract Administration to provide reasonable assurance that procedures developed to implement the sensitive authority of procuring commodities and services of up to $10,000 on each such procurement, were not being adhered to by the Department of Public Works. The Budget Analyst immediately informed the Department of Public Works management of the deficient condition.

Departmental Blanket Purchase Orders

The Budget Analyst reviewed a sample of Departmental Blanket Purchase Order Releases and Direct Voucher payments processed by the Operations Division in order to determine whether the procurements under these methods were being processed in compliance with acquisition regulations. As previously stated, Departmental Blanket Purchase Orders are established between a department and a vendor. Currently, the maximum dollar amount authorized for Departmental Blanket Purchase Order releases is $1,000 per vendor, per day.

Our review of Departmental Blanket Purchase Orders and Direct Voucher payments disclosed no instances of improper use.

Non-Discrimination in Contracts

The Human Rights Commission, in its administration of Chapter 12B of the Administrative Code, Nondiscrimination in Contracts, requires that contractors entering into contracts with the City for accumulative sums in excess of $5,000 per fiscal year complete a Nondiscrimination in Contracts and Benefits form. The Chapter 12B compliance information on the vendor is entered into the City's Financial Accounting and Management Information System (FAMIS) where it is available to City departments.

The Budget Analyst selected a sample of contractors who had been awarded contracts with the Department of Public Works during fiscal year 2005-2006 for the purpose of determining whether the contractors were compliant with the provisions of Chapter 12B. With the exception of three who were exempt because of the $5,000 applicability provision, all of the contractors were on file as being compliant with the provisions of Chapter 12B.

Conclusion

The Department of Public Works lacks sufficient procedures and controls to ensure the security of its inventory, integrity of the purchasing process, and efficient operation of the storeroom. In a 1991 management audit, the Budget Analyst recommended implementation of Citywide guidelines and protocols to operate and maintain storerooms and to provide internal controls. Fifteen years later, these guidelines have not been developed Citywide. The Department of Public Works should develop internal control guidelines and procedures, including an audit schedule, through its work order with the City Services Auditor. The City Administrator, who oversees the Office of Contract Administration as well as the Department of Public Works, should develop Citywide guidelines and protocols to operate and maintain storerooms. The Department of Public Works could further strengthen its storeroom operations by writing formal policies and procedures to standardize the storeroom's procedures.

The Department of Public Works also lacks sufficient controls over the purchasing procedure, including allowing unauthorized employees to regularly approve departmental purchases and maintaining a retired employee on the list of employees authorized to approve departmental purchases.

Recommendations

The City Administrator should:

13.1 Direct the Office of Contract Administration to develop a City-wide set of guidelines and procedures and a training program on storeroom operation and management as recommended in Section 2.2 of the 1991 audit report of Purchasing and Storekeeping Functions as Administered by the Purchasing Department.

The City Services Auditor should:

13.2 As part of reviews or audits that it performs of City materials storerooms, recommend guidelines and procedures for City internal controls in this area. Guidelines and procedures recommended for the Department of Public Works may also be extended to other City agencies.

13.3 Develop an audit schedule for periodic reviews of City materials storeroom subject to the City Services Auditor's risk analysis and scheduling process.

The Director of Public Works should:

13.4 Work with the City Services Auditor to develop guidelines and procedures for City storeroom internal control, which may then be extended to other City agencies.

13.5 Work with the City Services Auditor to develop an audit schedule for periodic reviews of the Department of Public Works storerooms.

The Deputy Director, Operations, should:

13.6 Continue to expand the inventory of items under the storeroom's responsibility commensurate with economical and efficient operations.

13.7 Ensure that storeroom staff receives the training and understands the guidelines and procedures that we recommend that the Office of Contract Compliance develop.

The Deputy Director, Finance and Administration, should:

13.8 Comply with the requirements of Section 21.03(a) of the Rules and Regulations Pertaining to the San Francisco Administrative Code, Chapter 21, promulgated by the Purchaser, concerning delegated departmental procurements.

Costs and Benefits

Implementing the other recommendations, which would expand and improve the operations of the Operations Division storeroom, can be accomplished within the authorized resources of the Department of Public Works. The benefits of implementing the recommendations 15.1 through 15.3 would be to improve the economy, efficiency, and effectiveness of material management operations citywide, and could be significant. Implementation of recommendations 15.4 and 15.5 would improve the effectiveness of the Operations Division by improving storeroom operations, Implementation of recommendation 15.6 would bring the Department of Public Works into compliance with the requirements of Section 21.03(a) of the Rules and Regulations Pertaining to the San Francisco Administrative Code, Chapter 21, promulgated by the Purchaser, concerning delegated departmental procurements.