Comptroller Fiscal Year Memo Letter Head


M E M O R A N D U M

To:Chief Fiscal Officers and MMARS Liaisons
From:Martin J. Benison, Comptroller
Date:May 6 , 2010
Re:Prompt Payment Discount Statistics for FY2010 - Third Quarter

Comptroller Memo FY#2010-25

Executive Summary

The purpose of this memo is to update CFOs and MMARS Liaisons on the departments' utilization of the Commonwealth's Prompt Payment Discount program in FY10 and offer opportunities to expand use in FY10 and plan for FY

Discounts Taken* Discounts Not Taken*

FY07

FY08

FY09

FY10

FY07

FY08

FY09

FY10

1 st QTR

$546

$689

$1,025

$1,242

$462

$496

$449

$567

2 nd QTR

$482

$707

$835

$946

$371

$404

$340

$306

3 rd QTR

$557

$876

$821

$1,049

$326

$468

$328

$267

Total

$1,585

$2,272

$2,681

$3,237

$1,159

$1,368

$1,117

$1,140

* in Thousands

Over $14.3 million has been retained by departments for Prompt Payment Discounts realized since FY2006. As the success of this program grows so, too, could your department's line item spending power.

During the third quarter of FY2010, the Commonwealth continued to favorably increase its opportunities for discount savings . Vendors who have not offered discounts in the past should be approached again and asked to enroll in the PPD Program now. With a tight budget and tight credit market, PPD is a sensible way departments can use to save money and provide timely cash flow to their vendors.

Departments can save thousands of dollars by reviewing the Discounts Not Taken Report, and instructing Accounts Payable staff to process payments consistent with discount terms. Realizing the "Discounts Not Taken" would mean further savings to your appropriations. CTR continues to assist department CFOs by identifying additional contracts that could potentially offer prompt payment discounts. In addition to the listing of Active MAs that offer Prompt Payment Discounts that is available on the Contracts page of the CTR Web Portal, and in order to provide departments a quick and easy way to take advantage of more discounts, CTR posts a on department contracts on our Payments page. This list, refreshed daily, is derived from department encumbrances in final status which offer prompt payment discounts in FY2010.

Successful discount implementation needs the full support and participation of each department's payment, contracting, and vendor management staff. Departments should verify that the discount terms entered on encumbrances are accurate in both the vendor and commodity sections. Departments processing invoices in a timely manner should assure that the discounts offered are taken automatically.

To analyze and report FY10 activity the following attachments offer department specific and summary data.

Attachment A is a report (on selected object codes), sorted by department, for the third quarter of FY2010. This report shows discounts taken, partial discounts taken and discounts missed due to payments scheduled after the discount terms expired. Capturing future discounts is within each department's control.

Attachment B is the statewide summary discount report (on selected object codes) through the 3 rd Quarter of FY2010.

To assist departments now for FY10 business we have prepared the query of encumbrance activity to include all departments' FY10 encumbrances in those object codes where we expect discount savings.

Attachment C is a report that summarizes by department the FY10 encumbrances on MMARS on selected object codes. The charts below summarize all departments.



FY2010 Encumbrances With and Without Discount

Dept

Total Dollars Encumbered Eligible for Discount

Dollars Encumbered with Discount

Dollars Encumbered without Discount

% of total dollars with Discount

% of total dollars without Discount

All

$2,066,492,282.71

$355,197,137.28

$1,711,295,145.43

17.2%

82.8%

Dept

Count Total Encumbrances Eligible for Discount

Count Encumbered with Discount

Count Encumbered with no Discount

% of encumbrances with Discount

% of encumbrances without Discount

All

60,768

27,846

32,922

45.8%

54.2%

Attachment D lists encumbrance transactions with "with discount" offered on one tab and those encumbrances in selected object codes offering "no discount" on the second tab. It is sorted by department, transaction, and object code; it includes the discount percentage, commodity line number, accounting line number, and line amount for FY10. Records can be filtered by department. Those encumbrances in the tab "no discount" should be reviewed with the vendor for the addition of prompt payment discount terms. It is crucial that department CFO's and contract managers review these contracts and take the initiative to capture lost opportunities by encouraging the vendors to offer a mutually agreeable discount rate.

The Prompt Payment Discount Policy states that "Even if a Department has not included the Prompt Payment Discount Form as part of the RFR process, or for contracts when a procurement is not required, the Department is strongly encouraged to have a Contractor complete a Prompt Payment Discount Form during the contract execution, renewal or amendment process to ensure that Prompt Payment Discounts are available to departments to the maximum extent possible."

Through queries, CTR has identified eligible contracts with many vendors who offer discounts on other department contracts. This information is forwarded to department fiscal staff to assist them in requesting discounts directly from vendors. It is crucial that CFOs and Contract Managers review the discounts missed report and instruct relevant staff to ensure that payments are processed on a timely basis so that your department can receive the maximum discount offered under the contract.

To assist with department analysis, CTR has provided starter queries that departments can run in the Commonwealth Information Warehouse to identify payments made with discount terms offered. These Discount Starter Query instructions are available here doc format of dept_discount_starter_qry.doc
. In addition, report NAP630W, available in DocDirect, provides a month end listing of discounts missed.

Please review your discount statistics and, if you have any questions, please contact Michael Weld Eyob at (617) 973-2310.

Enc:
Attachment A - FY2010 3rd QTR Department Discount Summary - Taken, Partial Taken, No Discount Taken xls format of FY2010 3rd QTR Dept Discount SUmmary Attachment A.
Attachment B - FY2010 Commonwealth Discount Summary, 1st, 2nd and 3rd QTR, FY2010 xls format of FY2010 Commonwealth Discount Summary 3rd QTR Attac
Attachment C - FY2010 Encumbrance and Discount Opportunities Summary xls format of FY2010 Enc and Discount Opportunities Summary Atta
Attachment D - FY2010 Encumbrance Listing xls format of FY2010 Encumbrance Listing Attachment D.xls
file size 6MB














cc:General Counsels
Payroll Directors
Internal Distribution