Last Updated: October 2017
MyFloridaMarketPlace (MFMP) Utilization Metrics Definitions
Seedescriptions of each utilization metric below and how MFMP calculates each for thequarterlyMFMP Utilization Report. Agenciescan access the supporting documentation/reports listed belowto obtain further insight into the MFMP Utilization Report results.
Metric 1: MFMP Purchase Order (PO) and Contract Utilization
Metric 1 measures the total value of orders in MFMP plus the total invoice spend against anMFMP contract divided by FLAIR payments against open MFMP orders (excluding payments with designated object codes and specific business designations).Calculation:
Supporting Documentation:
Total PO value in MFMP
/ Description: The total PO value in MFMP was obtained from orders that were issued (by ordered date) during the utilization report timeframe. Due to the nature of purchase orders, data may vary daily based on changed and cancelled orders.MFMP Analysis Report Name: “MFMP Purchase Order and Contract Utilization – 1A-1 – Total PO value in MFMP – Month YYYY.”
Total MFMP invoice value directly against an MFMP contract
/ Description: The total MFMP invoice value directly against an MFMP contract was obtained from invoices paid during the utilization report timeframe against an MFMP contract.MFMP Analysis Report Name: “MFMP Purchase Order and Contract Utilization – 1A-2 - Total MFMP invoice value directly against an MFMP contract.”
Expected MFMP value
/ Description: The expected MFMP Value was derived by excluding specific object codes, business designations, Pcard payments and certified forward payments from FLAIR payments issued during the utilization report timeframe (see the “Definitions” tab on the Utilization workbook).MFMP Secure Reports Report Name:There are individual reports for each month titled “Utilization Detailed -Expected MFMP value” with the month number included in the filename (for example: “Utilization Details - Expected MFMP value –10 FY117-18” is for October data during fiscal year 2017-18).
Metric 2: MFMP Invoice Utilization
Metric 2 measures the total spend of invoices processed directly in MFMP (excluding those marked ‘Paid in FLAIR’) divided by FLAIR payments against open MFMP orders (excluding payments with designated object codes and specific business designations).Calculation:
Supporting Documentation:
Total MFMP invoice value
/ Description: The total MFMP invoice value was obtained from invoices paid during the utilization report timeframe through MFMP.MFMP Analysis Report Name: “MFMP Invoice Utilization – 2A - Total MFMP invoice value minus Invoices Paid in FLAIR – Month YYYY.”
Expected MFMP value
/ Description: The expected MFMP Value was derived by excluding specific object codes, business designations, Pcard payments and certified forward payments from FLAIR payments issued during the utilization report timeframe (see the “Definitions” tab on the Utilization workbook).MFMP Secure Reports Report Name:There are individual reports for each month titled “Utilization Detailed -Expected MFMP value” with the month number included in the filename (for example: “Utilization Details - Expected MFMP value –10 FY17-18” is for October data during fiscal year 2017-18).
Metric 3: Catalog Utilization
Metric 3 measures the number of catalog line items created from an MFMP catalog divided by the number of line items created from a State Term Contract (STC), including Pride and Respect, where a catalog is available.Calculation:
Supporting Documentation:
Total number of MFMP STC PO catalog line items
/ Description: The total number of MFMP State Term Contract (STC) catalog line items was obtained from orders issued during the utilization report timeframe for catalog line items with a Method of Procurement (MOP) “A”, “B”, “M” or “N” and a line item or punchout catalog is available for the selected STC.Some contracts have been excluded from this metric due to the limited number of vendors with catalogs on the contract. As more vendors adopt catalog solutions from the excluded contracts, MFMP will evaluateadding these contracts to the metric. The MFMP team can provide the current list of excluded contracts upon request.”Due to the nature of purchase orders, data may vary daily based on change and cancelled orders.
MFMP Analysis Report Name: “MFMP Catalog Utilization - 3A - Total number of MFMP STC PO catalog line items.”
Number of All MFMP STC PO line items
/ Description: The number of all MFMP STC PO line items was obtained from orders issued during the utilization report timeframe with an MOP “A”, “B”, “M” or “N” and a line item or punchout catalog is available for the selected State Term Contract. Due to the nature of purchase orders, data may vary daily based on change and cancelled orders.MFMP Analysis Report Name: “MFMP Catalog Utilization - 3B - Number of All MFMP STC PO Line Items.”
Metric 4: Receiving Goods in MFMP Utilization
Metric 4 measures the number of orders for goods that have been received divided by the number of total orders for goods created in MFMP. This metric excludes orders for services or orders paid via Pcard.Calculation:
Supporting Documentation:
Total number of POs for goods that were received
/ Description: The Total number of POs for goods that were received was obtained from orders issued during the utilization report timeframe where there was at least one line item with a goods-based commodity code (begins with 70 – 94) and at least one item was received. Excludes PCard.MFMP Secure Reports Website Report Name: There are individual reports for each month titled “Utilization Details - POs for goods that were received” with the month number and fiscal year included in the filename (for example: “Utilization Details - POs for goods that were received- 10 FY17-18” is for October data during fiscal year 2017-18).
Total number of POs for goods
/ Description: The total number of POs for goods was obtained from orders issued during the utilization report timeframe with a line item that has a “goods” commodity code. Excludes PCard.MFMP Secure Reports Website Report Name: There are individual reports for each month titled“Utilization Details - POs for goods”with the month number and fiscal year included in the filename (for example: “Utilization Details - POs for goods - 10 FY17-18” is for October data during fiscal year 2017-18).
Metric 5: eQuote Utilization
Metric 5 measures the number of issued and completed eQuotes divided by the number of orders requiring an informal quote for Method of Procurement (MOP) B, F or 16.Calculation:
Supporting Documentation:
Number of eQuote events marked as “completed” or “pending selection”
/ Description: The number of eQuote events marked as “completed” or “pending selection” was obtained from the Sourcing application for eQuotes that are completed or are in “pending selection” status during the utilization report timeframe.MFMP Secure Reports Website Report Name: There are individual reports for each month titled “Utilization Detailed -Completed eQuotes” with the month number and the fiscal year included in the filename (for example: “Utilization Details – Completed eQuotes - 10 FY17-18” is for October data during fiscal year 2017-18).
Number of POs with Method of Procurement “B”, “F” or “16”
/ Description: The Number of POs with MOP was obtained from orders issued during utilization report timeframe with a MOP equal to B, F or 16. Due to the nature of purchase orders, data may vary daily based on change and cancelled orders. Orders with MOP B, F or 16 issued on July 1 are excluded from this calculation.MFMP Analysis Report Name: “Agency eQuote Utilization - 6B Number of POs of Procurement B F and 16 – Month YYYY.”
Instructions for accessing the reports:
MFMP Secure Reports Website Reports:
All reports listed as available on the MFMPSecure Reports Website can be found within the specific agency folders. If your agency’s metric is listed as zero, there will not be a report in your agency folder. A username and password is required for access; contact your agency system administrator for your agency’s credentials, if needed.
MFMP Analysis Reports:
All reports listed as available in MFMP Analysis can be found in a folder called “Utilization Metrics” within the MFMP public reports folder. Below are the detailed steps on where to find and how to view these reports for your agency.
In MFMP Analysis, access the MFMP Public Reportsfolder outlined in the box below. Once you have selected the MyFloridaMarketPlace folder, scroll to the end of the list to find the Utilization Metrics folder.
Locate and right-click the appropriate report titleand thenselect Open:
Hold your mouse over your agency’s Total Invoice Spend (in the right column) and click on Detail View to drill down into the details for your agency:
View the details (for example,invoice reconciliation IDs):
This data can then be exported from MFMP Analysis to Microsoft Excel. At the top of the page, click the Actionsbutton and then select Configure Export.
The next page should already have the radio buttons selected to export to “comma-separated value (CSV) format” and “current pivot table contents”; if not, select both. Click Export Data to open and save your file.
MFMP Analysis will then export the detailed data (see example below).
1