Docstoc

ABC Procurement Dashboard 200806

Document Sample
ABC Procurement Dashboard 200806 Powered By Docstoc
					                                                                         Reporting Month Jun 2008

                                                                                                       Percentile
                      Measure                                     Values                             Ranking Place
                                                                                                                                             Measure Description

                                                                                                                                            % Oracle PO's Invoices Received
                % PO Invoices                                    36.2%                                        22nd                   (Calculated as % of Invoices Received n Month)
                                                                                                                                      Green is ≥ 60% Amber is ≥ 30% Red is < 30%
                                                                                                                                              % Invoices Matched First Time
         % Matched First Time                                  #DIV/0!                                    #DIV/0!                  (Calculated as % of PO Invoices Received in Month)
                                                                                                                                      Green is ≥ 30% Amber is ≥ 20% Red is < 20%
                                                                                                                                                 PO Invoice Creditor Days
           PO Invoice Creditor                                                                                                     (Calculated as Number of Days worth of PO Invoice
                  Days                                                  7.1                                   16th                       Notifications outstanding at Month End)
                                                                                                                                         Green is ≤ 7 Amber is ≤ 14 Red is > 14
                                                                                                                               % Purchase Orders Fully/Partially Receipted at Month End
           Receipted Purchase                                                                                                 (Calculated as % of Purchase Orders approved in Month with
                 Orders                                          85.4%                                        4th                                  at least 1 Receipt)
                                                                                                                                     Green is ≥ 90% Amber is ≥ 80% Red is < 80%
                                                                                                                                                % Catalogue PO's Raised
              % Catalogue PO's
                   Raised                                      #DIV/0!                                    #DIV/0!                  (Calculated as % of Total PO's Approved in Month)
                                                                                                                                      Green is ≥ 60% Amber is ≥ 40% Red is < 40%
                                                                                                                                                 % Catalogue PO Spend
        % Catalogue PO Spend                                   #DIV/0!                                    #DIV/0!                   (Calculated as % of Total PO Approved in Month)
                                                                                                                                      Green is ≥ 40% Amber is ≥ 20% Red is < 20%
                                                   Non-NHS                        NHS          Non-NHS               NHS                 PO Invoice PSPP (NHS and Non-NHS)
                     PO PSPP                                                                                                                  (Calculated as % by Volume)
                                                    94.0%                     100.0%                 34th            1st              Green is ≥ 95% Amber is ≥ 75% Red is < 50%
                                                                   Best Position = 1st Percentile Ranking Place
                                                    A summary Non Pay spend analysis is included on Page 3 of this Dashboard


                                                       Oracle PO Invoices Received and Matched First Time
       # Invoices
       4500                                                                                                                                                                             100%
       4000                                                                                                                                                                             90%
       3500                                                                                                                                                                             80%
       3000                                                                                                                                                                             70%
       2500
                                                                                                                                                                                        60%
                                                                                                                                                                                        50%
       2000
                                                                                                                                                                                        40%
       1500
                                                                                                                                                                                        30%
       1000                                                                                                                                                                             20%
        500                                                                                                                                                                             10%
          0                                                                                                                                                                             0%
                                   Apr-08                                                     May-08                                                Jun-08



                            Vol Matched 1st Time                          Vol Not Matched 1st time                          % PO                      % Matched 1st Time


                                      Apr-08                                                         May-08                                                  Jun-08
       % PO Invoices Received
                                       17th                                                          12th                                                    22nd
               Rank %
       % PO Invoices Matched
         First Time Rank %

                                                     PO Invoice Creditor Days (and Volume of Notifications)

         # Notifications                                                                                                                                              PO Invoice Creditor Days
        800                                                                                                                                                                                  7.2
                                                                                                                                                                                             7.1
        700
                                                                                                                                                                                             7
        600                                                                                                                                                                                  6.9
        500                                                                                                                                                                                  6.8
                                                                                                                                                                                             6.7
        400
                                                                                                                                                                                             6.6
        300                                                                                                                                                                                  6.5
        200                                                                                                                                                                                  6.4
                                                                                                                                                                                             6.3
        100
                                                                                                                                                                                             6.2
          0                                                                                                                                                                                  6.1
                                   Apr-08                                                        May-08                                                 Jun-08


                                 Client PO Notifications at Month End                          SBS PO Notifications at Month End                      Overall PO Creditor Days

                                      Apr-08                                                         May-08                                                  Jun-08
          Overall Rank %               19th                                                          23rd                                                    16th
          SBS RAG Status
         Client RAG Status




f2df6981-947b-4658-b8d0-5771e9763760.xls                                                                                                                                                           1 of 3
                                                                                   Receipted Purchase Orders

       # PO's Approved
       4,000
       3,500
       3,000
       2,500
       2,000
       1,500
       1,000
         500
           0
                                        Apr-08                                                   May-08                                               Jun-08

                                                   # Receipted POs at Month End                                   # Unreceipted POs at Month End

                                          Apr-08                                                May-08                                                      Jun-08
                    Rank %                 4th                                                    5th                                                        4th

                                                                   Catalogue and Non Catalogue PO's Raised
        # PO's Approved
           1
         0.9
         0.8
         0.7
         0.6
         0.5
         0.4
         0.3
         0.2
         0.1
           0
                                        Apr-08                                                   May-08                                                Jun-08
                                                               Cat PO's                                                Non Cat PO's

                                          Apr-08                                                May-08                                                      Jun-08
                    Rank %

                                                                                           Catalogue PO Spend

        % PO Spend
          100%
           90%
           80%
           70%
           60%
           50%
           40%
           30%
           20%
           10%
               0%
                                          Apr-08                                                  May-08                                               Jun-08
                                                             Cat PO Spend                                              Non Cat PO Spend
                                          Apr-08                                                May-08                                                      Jun-08
                    Rank %


                                      PO PSPP - Year to Date % of Number & Value of PO Invoices Paid to Terms

                                     Non-NHS Trade Suppliers                                                                              NHS Suppliers
       100%                                                                                                100%
                                                                                                           90%
                                                                                                           80%
                                                                                                           70%
                                                                                                           60%
        90%                                                                                                50%
                                                                                                           40%
                                                                                                           30%
                                                                                                           20%
                                                                                                           10%

        80%                                                                                                 0%
                          Apr-08                   May-08                     Jun-08                                   Apr-08                      May-08                   Jun-08
                      Non-NHS PO PSPP By Volume              Non-NHS PO PSPP By Value                                 NHS PO PSPP by Volume                     NHS PO PSPP by Value

                         Apr-08                    May-08                         Jun-08                                    Apr-08                  May-08                   Jun-08
                        141th                      42nd                           34th               Rank %                  2nd                     1st                      1st




f2df6981-947b-4658-b8d0-5771e9763760.xls                                                                                                                                               2 of 3
                                                                  Non Pay Spend Analysis

          Select Period     Jun-08
                                                              Click Here for TFR Analysis Report

                                                                                                                                                      Pop          Peer
           TFR Group                         NonPO                 PO            Interface Files      Other         Total               %
                                                                                                                                                      Rank         Rank
Building and Utilities                        £4,382,017.23        £156,371.63             £0.00   -£1,294,173.34    £3,244,215.52     18.71%             12        18
Clinical Supplies                             £1,516,404.86      £3,515,146.42             £0.00        £4,195.52    £5,035,746.80     29.04%              8        27
General Supplies and Services                 £1,169,714.92        £131,018.15             £0.00         £522.65     £1,301,255.72      7.50%             28        51
NonPay - Staff Cost                           £1,097,123.28         £12,932.08             £0.00       -£3,611.68    £1,106,443.68      6.38%             22        33
Other                                         £4,792,822.78      £1,099,763.34             £0.00      £762,824.96    £6,655,411.08     38.38%             94        87
Total                                        £12,958,083.07      £4,915,231.62             £0.00     -£530,241.89   £17,343,072.80
Percentage                                          74.72%             28.34%             0.00%            -3.06%


                                                                  Non Pay Spend by Invoice Type




                                                                                                                                                 NonPO
                                                                                                                                                 PO
                                                                                                                                                 Interface Files
                                                                                                                                                 Other


                                                              Non Pay Spend by Spend Classification




                                                                                                                             Building and Utilities
                                                                                                                             Clinical Supplies
                                                                                                                             General Supplies and Services
                                                                                                                             NonPay - Staff Cost
                                                                                                                             Other




  f2df6981-947b-4658-b8d0-5771e9763760.xls                                                                                                                         3 of 3

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:8
posted:2/14/2012
language:English
pages:3