Performance Rating Calculator V8 Feb12

Document Sample
Performance Rating Calculator V8 Feb12 Powered By Docstoc
					Version:                           Version 8 Feb 12
Funder                             Please insert funder name.
Contract                           Please insert project name.
Provider                           Please insert provider name
Sub or Prime contractor            e.g. 'sub' or 'prime'
Contract start date                Please insert contract start date
Year of contract                   e.g. year 1 of 3, 2 of 3 etc.
                                   Please include which client group you are targeting and which boroughs you deliver in.


Project description




Worksheet                          Description                                                                                        Action required
                                   This worksheet automatically calculates the Star Rating based on information from all other
1. Star Rating                     worksheets                                                                                         No data entry required
                                   This worksheet requires the Provider or Contract Manager to input the raw data for the Contract    Data entry required by the
2. Contract Performance raw data   Targets KPA                                                                                        Provider
                                   This worksheet automatically calculates the Star Rating points achieved for the Delivery
                                   against contract targets and Delivery against beneficiary target s indicators, using the data
3. Contract Performance points     from the contract performance raw data worksheet                                                   No data entry required

                                   This worksheet automatically calculates the Star Rating points achieved for the Conversion
4. Conversion rate points          Rate indicator, using the data from the contract performance raw data worksheet                    No data entry required
                                   This worksheet requires the Provider to complete the self assessment template for the Quality self Data entry required by the
5. Self assessment template:       assessment indicator                                                                               Provider

                                   This worksheet automatically calculates the Star Rating points achieved for the Quality self
6. Self Assessment points:         assessment indicator based on the data from the self assessment template worksheet                 No data entry required
                                   This worksheet requires the Provider or Contract Manager to input the raw data for the Client      Data entry required by the
7. Client Satisfaction raw data    satisfaction indicator                                                                             Provider

                                   This worksheet automatically calculates the Star Rating points achieved for the Client
8. Client Satisfaction points      Satisfaction indicator based on the data from the client satisfaction raw data worksheet           No data entry required
                                                                                                                                      Data entry required by the
                                   This worksheet requires the Contract Manager or Prime Contractor to complete the self              Contract Manager or Prime
9. Contract Compliance template    assessment template for the Contract compliance indicator                                          Contractor

                                   This worksheet automatically calculates the Star Rating points achieved for the Contract
10. Contract Complaince points     Compliance indicator based on the data from the contract compliance template worksheet             No data entry required




                                                                                                                                                    V8 - Feb2012
Guidance for using the performance rating calcuator
All cells shaded GREY require data entry in order to calculate
1. Star Rating points worksheet
No data entry is required for this worksheet, it automatically calculates the results based on the information from all other worksheets
2. Contract Performance Raw Data worksheet
Step 1 - insert performance rating period; e.g 'April - September'. This is updated with cumulative targets & actuals for this time period,
giving a progress rating for 6 months delivery. April - March cumulative targets and actuals provide the final annual rating.
Step 2 - insert the total number of types of outputs & outcomes in cell G1
Step 3- insert the name of each output or outcome in cell C5, C10 etc, ensuring that the name of the primary outcome is inserted into cell
C5. Cell C10 must be used for your 'starts' targets.
Step 4 - Insert the monthly or quarterly targets in cell E5, I5 etc
Step 5 - insert the annual contract target in C6, C11 etc.
Step 6 - insert the diversity targets as a percentage for each of the targets in column C cells 7,8,9, and 12,13,14 and 17,18,19 etc.
Step 7 - insert the cumulative contract target to date as a number for each target in cell D6, D11 etc. Data input in this cell informs the
formula in column W to show the % delivered. At year end this must equal the annual target.
Step 8 - insert actual results by month for each target in columns F to H, J to L, N to P, R to T.
The totals and percentages in columns U, V and W will fill in automatically
3. Contract performance points worksheet
No data entry is required for this worksheet, it automatically calculates the results based on the information inserted in the contract

4. Conversion rate points worksheet
No data entry is required for this worksheet, it automatically calculates the results based on the information inserted in the contract

5. Self assessment template
Complete the self assessment template using the guidance available on the website
If a paper copy of the self assesment template is completed, please insert the four-point self assessment rating for each statement in column E
6. Self Assessment points
No data entry is required for this worksheet, it automatically calculates the results based on the information inserted in column E of the
Self assessment template worksheet
7. Client Satisfaction raw data
Step 1 - In the "Quarter 1" table, insert the total number of clients who have responded to each response option per question
Step 2 - repeat for Quarter 2 -4
8. Client Satisfaction points
No data entry is required for this worksheet, it automatically calculates the results based on the information from the client satisfaction raw
9. Contract compliance template
The Contract Manager (or prime contractor for sub-contractors) completes the template using the guidance available on the website
If a paper copy of the contract compliance template is completed, please insert the rating for each statement in column F
10. Contract compliance points
No data entry is required for this worksheet, it automatically calculates the results based on the information inserted in column F of the
Contract Compliance template worksheet




                                                                                                                                                  V8 - Feb2012
KPA             Indicator                                     Star rating points   Total available   Star rating guidance
Contract        Delivery against contract targets                      0.0                48         4 stars      87.5 -    100    points
performance     Delivery against contract diversity targets            0.0                12         3 stars       75 -     87.4   points
                Conversion rate for positive outcomes                  0.0                12         2 stars      62.5 -    74.9   points
Quality         Self assessment of quality                             0.0                 9         1 star          40 -   62.4   points
                Customer satisfaction                                  0.0                 9         0 star           <     40     points
Contract
                Contract compliance                                   0.0                 10
compliance
Total Star Rating points                                              0.0


                                                              Star rating


Please insert project name.
Please insert provider name




                                                                                                                                   V8 - Feb2012
                                                         Number of
Performance Rating time                                  output/outcome                            Annual Target                     Cumulative Actual
period                                                   types:                                    number of starts:    0            number of starts     0

                                                                                                                             Contract delivery
                                              Cumulative
                                               Target To
                             Annual Target       Date    Quarter 1     APR       MAY       JUN     Quarter 2    JUL    AUG    SEP     Quarter 3   OCT    NOV   DEC   Quarter 4   JAN   FEB   MAR   Actual   % Diversity        % Delivery
Outcome 1 (primary outcome): Insert primary outcome 1 name here
Contract target                                                                                                                                                                                      0                            0%
BAME                                                                                                                                                                                                 0         0.0%               0%
Disabled                                                                                                                                                                                             0         0.0%               0%
Women                                                                                                                                                                                                0         0.0%               0%
Output 2 (starts):           Starts
Contract target                                                                                                                                                                                      0                            0%
BAME                                                                                                                                                                                                 0         0.0%               0%
Disabled                                                                                                                                                                                             0         0.0%               0%
Women                                                                                                                                                                                                0         0.0%               0%
Output 3:                    Insert output 3 name here
Contract target                                                                                                                                                                                      0                            0%
BAME                                                                                                                                                                                                 0         0.0%               0%
Disabled                                                                                                                                                                                             0         0.0%               0%
Women                                                                                                                                                                                                0         0.0%               0%
Output 4:                    Insert output 4 name here
Contract target                                                                                                                                                                                      0                            0%
BAME                                                                                                                                                                                                 0         0.0%               0%
Disabled                                                                                                                                                                                             0         0.0%               0%
Women                                                                                                                                                                                                0         0.0%               0%
Output 5:                    Insert output 5 name here
Contract target                                                                                                                                                                                      0                            0%
BAME                                                                                                                                                                                                 0         0.0%               0%
Disabled                                                                                                                                                                                             0         0.0%               0%
Women                                                                                                                                                                                                0         0.0%               0%
Output 6:                    Insert output 6 name here
Contract target                                                                                                                                                                                      0                            0%
BAME                                                                                                                                                                                                 0         0.0%               0%
Disabled                                                                                                                                                                                             0         0.0%               0%
Women                                                                                                                                                                                                0         0.0%               0%
Output 7:                    Insert output 7 name here
Contract target                                                                                                                                                                                      0                            0%
BAME                                                                                                                                                                                                 0         0.0%               0%
Disabled                                                                                                                                                                                             0         0.0%               0%
Women                                                                                                                                                                                                0         0.0%               0%
Output 8:                    Insert output 8 name here
Contract target                                                                                                                                                                                      0                            0%
BAME                                                                                                                                                                                                 0         0.0%               0%
Disabled                                                                                                                                                                                             0         0.0%               0%
Women                                                                                                                                                                                                0         0.0%               0%

Please insert project name.                                          Please insert provider name




                                                                                                                                                                                                                V8 - Feb2012
             No. of targets      0


BAME                                                                      Delivery against contract targets indicator
                             Total pts                      Star rating                               Total pts                    Star rating
Target                                      % Delivery                    Target                                   % Delivery
                             available                        points                                  available                      points
                               0.000
Insert primary outcome 1 name here             0.0%             0.0                                       24
                                                                          Insert primary outcome 1 name here          0.0%             0.0
Starts                         0.000           0.0%             0.0       Starts                           0          0.0%             0.0
Insert output 3 name here      0.000           0.0%             0.0       Insert output 3 name here        0          0.0%             0.0
Insert output 4 name here      0.000           0.0%             0.0       Insert output 4 name here        0          0.0%             0.0
Insert output 5 name here      0.000           0.0%             0.0       Insert output 5 name here        0          0.0%             0.0
Insert output 6 name here      0.000           0.0%             0.0       Insert output 6 name here        0          0.0%             0.0
Insert output 7 name here      0.000           0.0%             0.0       Insert output 7 name here        0          0.0%             0.0
Insert output 8 name here      0.000           0.0%             0.0       Insert output 8 name here        0          0.0%             0.0

                                       Star rating points       0.0                                     Total Star Rating points       0.0


Disabled
                             Total pts                      Star rating
Target                                      % Delivery
                             available                        points
                               0.000
Insert primary outcome 1 name here             0.0%             0.0

Starts                         0.000           0.0%             0.0       Delivery against diversity targets indicator
Insert output 3 name here      0.000           0.0%             0.0       BAME                                    0.0
Insert output 4 name here      0.000           0.0%             0.0       Disabled                                0.0
Insert output 5 name here      0.000           0.0%             0.0       Women                                   0.0
Insert output 6 name here      0.000            0.0%            0.0       Total Star Rating points               0.0
Insert output 7 name here      0.000            0.0%            0.0
Insert output 8 name here      0.000            0.0%            0.0       Please insert project name.
                                       Star rating points       0.0       Please insert provider name


Women
                             Total pts                      Star rating
Target                                      % Delivery
                             available                        points
                               0.000
Insert primary outcome 1 name here             0.0%             0.0
Starts                         0.000           0.0%             0.0
Insert output 3 name here      0.000           0.0%             0.0
Insert output 4 name here      0.000           0.0%             0.0
Insert output 5 name here      0.000           0.0%             0.0
Insert output 6 name here      0.000           0.0%             0.0
Insert output 7 name here      0.000           0.0%             0.0
Insert output 8 name here      0.000           0.0%             0.0
                                      Star rating points        0.0




                                                                                                                                       V8 - Feb2012
                                                                   Target number Actual number     Target       Actual     Actual conversion   Total Star
                                     Target number Actual number     of primary    of primary    conversion   conversion   rate minus target    Rating
Primary Outcome                         of starts     of starts      outcomes      outcomes         rate         rate       conversion rate     points
Insert primary outcome 1 name here          0             0               0             0          0.00%        0.00%            0.00%            0.0

Please insert project name.
Please insert provider name




                                                                                                                                           V8 - Feb2012
Please insert project name.                                               Please insert provider name
Question                                        In place?                 Evidence or examples of current practice   Assessment of level of      Priority for
                                                F = fully                                                            performance                 action?
                                                FI = fully in place but
                                                needs some
                                                improvement
                                                                                                                     Rate 1 – 4                  Rank 1 – 3
                                                P = partially in place                                               1 = Outstanding; 2=         1 = high priority
                                                N = not in place/being                                               Good; 3 = Satisfactory; 4
                                                developed                                                            = Inadequate


Quality of provision/meeting client needs
1. There is a comprehensive induction for all
clients




2. Clients receive appropriate advice and
guidance on starting and on completion of
participation in the service




                                                                                                                                                   V8 - Feb2012
3. Progress reviews are used effectively with
appropriate targets being set together with the
client, to assist progression and achievement of
goals




Continuous Improvement
4. Effectiveness is regularly monitored and
evaluated against the aims and objectives of
the service to ensure that it is responsive to
customer needs and local priorities




                                                   V8 - Feb2012
5. An effective quality assurance process is
embedded throughout the organisation




Leadership, management and infrastructure
6. There is a clear vision and associated aims
and objectives for the organisation with a
strategic plan/business plan/development plan
in place that is reviewed on a regular basis




                                                 V8 - Feb2012
7. An engagement and outreach strategy is in
place and reviewed regularly




8. Sub delivery partners are, effectively
managed to ensure that the needs of clients
are met NB: if no provision is sub contracted
please insert '0' in column E.




                                                0




                                                    V8 - Feb2012
9. Networks with key stakeholders are
effectively used, managed, maintained and
reviewed to ensure that the service meets the
needs of clients and employers are met and
promotes social cohesion




10. There is a commitment to continuous
professional development and staff are
appropriately trained and experienced to
provide the breadth of skills and interventions
to support and progress clients




                                                  V8 - Feb2012
11. Equality and Diversity are effectively
promoted, discrimination tackled and
reasonable adjustments provided for clients
and staff




                                              V8 - Feb2012
V8 - Feb2012
V8 - Feb2012
F    1   0
FI   2   1




P    3   2




             V8 - Feb2012
N   4   3




        4




            V8 - Feb2012
Indicator    Rating (1 - 4)   Star Rating points   Conversion table
     1            0                    0           Rating   Points
     2            0                    0             1         0.9
     3            0                    0             2       0.675
     4            0                    0             3        0.45
     5            0                    0             4       0.225
     6            0                    0
     7            0                    0
     8            0                    0
     9            0                    0
    10            0                    0
    11            0                    0

 Total Star Rating points             0

Please insert project name.
Please insert provider name




                                                                      V8 - Feb12
Please insert project name.                                             Please insert provider name
Quarter 1
         No of very                       No of                No of                  No of              No of very                 Total
          positive                      positive              neutral               negative              negative               number of
Question responses            Points   responses   Points   responses    Points    responses    Points   responses      Points   responses
  1a                            0                    0                     0                      0                       0           0
  1b                            0                    0                     0                      0                       0           0
   1c                           0                    0                     0                      0                       0           0
  1d                            0                    0                     0                      0                       0           0
  1e                            0                    0                     0                      0                       0           0
  2a                            0                    0                     0                      0                       0           0
  2b                            0                    0                     0                      0                       0           0
   2c                           0                    0                     0                      0                       0           0
  2d                            0                    0                     0                      0                       0           0
  2e                            0                    0                     0                      0                       0           0
   2f                           0                    0                     0                      0                       0           0
   3                            0                    0                     0                      0                       0           0
                                                                                                                Total                 0

Quarter 2
         No of very                       No of                No of                  No of              No of very                 Total
          positive                      positive              neutral               negative              negative               number of
Question responses            Points   responses   Points   responses    Points    responses    Points   responses      Points   responses
  1a                            0                    0                     0                      0                       0           0
  1b                            0                    0                     0                      0                       0           0
   1c                           0                    0                     0                      0                       0           0
  1d                            0                    0                     0                      0                       0           0
  1e                            0                    0                     0                      0                       0           0
  2a                            0                    0                     0                      0                       0           0
  2b                            0                    0                     0                      0                       0           0
   2c                           0                    0                     0                      0                       0           0
  2d                            0                    0                     0                      0                       0           0
  2e                            0                    0                     0                      0                       0           0
   2f                           0                    0                     0                      0                       0           0
   3                            0                    0                     0                      0                       0           0
                                                                                                                Total                 0

Quarter 3
         No of very                       No of                No of                  No of              No of very                 Total
          positive                      positive              neutral               negative              negative               number of
Question responses            Points   responses   Points   responses    Points    responses    Points   responses      Points   responses
  1a                            0                    0                     0                      0                       0           0
  1b                            0                    0                     0                      0                       0           0
   1c                           0                    0                     0                      0                       0           0
  1d                            0                    0                     0                      0                       0           0
  1e                            0                    0                     0                      0                       0           0
  2a                            0                    0                     0                      0                       0           0
  2b                            0                    0                     0                      0                       0           0
   2c                           0                    0                     0                      0                       0           0
  2d                            0                    0                     0                      0                       0           0
  2e                            0                    0                     0                      0                       0           0
   2f                           0                    0                     0                      0                       0           0
   3                            0                    0                     0                      0                       0           0
                                                                                                                Total                 0

Quarter 4
         No of very                       No of                No of                  No of              No of very                 Total
          positive                      positive              neutral               negative              negative               number of
Question responses            Points   responses   Points   responses    Points    responses    Points   responses      Points   responses
  1a                            0                    0                     0                      0                       0           0
  1b                            0                    0                     0                      0                       0           0
   1c                           0                    0                     0                      0                       0           0
  1d                            0                    0                     0                      0                       0           0
  1e                            0                    0                     0                      0                       0           0
  2a                            0                    0                     0                      0                       0           0
  2b                            0                    0                     0                      0                       0           0
   2c                           0                    0                     0                      0                       0           0
  2d                            0                    0                     0                      0                       0           0
  2e                            0                    0                     0                      0                       0           0
   2f                           0                    0                     0                      0                       0           0
   3                            0                    0                     0                      0                       0           0
                                                                                                                Total                 0




                                                                                                                                  V8 - Feb2012
ANNUAL
               No of very                                                                                         No of very
                positive                No of positive             No of neutral          No of negative           negative             Total number     Total
  Question     responses      Points     responses        Points    responses      Points  responses     Points   responses    Points   of responses     score
     1a            0            0             0             0            0           0           0         0          0          0            0            0
     1b            0            0             0             0            0           0           0         0          0          0            0            0
     1c            0            0             0             0            0           0           0         0          0          0            0            0
     1d            0            0             0             0            0           0           0         0          0          0            0            0
     1e            0            0             0             0            0           0           0         0          0          0            0            0
     2a            0            0             0             0            0           0           0         0          0          0            0            0
     2b            0            0             0             0            0           0           0         0          0          0            0            0
     2c            0            0             0             0            0           0           0         0          0          0            0            0
     2d            0            0             0             0            0           0           0         0          0          0            0            0
     2e            0            0             0             0            0           0           0         0          0          0            0            0
     2f            0            0             0             0            0           0           0         0          0          0            0            0
     3             0            0             0             0            0           0           0         0          0          0            0            0
                                                                                                                         Total                0            0


                                               Total score
                % score          =                                       x   100
                                           Total available score


                                               0
                   0%            =                           x     100
                                               0



             Total Star Rating points          0

             Please insert project name.
             Please insert provider name




                                                                                                                                                       V8 - Feb2012
PLEASE NOTE: TO BE COMPLETED BY THE CONTRACT MANAGER (FOR PRIME CONTRACTORS) OR PRIME CONTRACTOR (FOR SUB-CONTRACTOR)
A. Indicator                              B. Assessment criteria                                 C. Guidance     D. Rating       (1 - E. Comments
                                                                                                 for rating      10) (please insert)
                                                                                                                                      (please insert)
Variance of forecast from claim: annual   A RAG assessment should be given using the
                                                                                                 Red = 0 to 3
RAG rating based on the variation between following guidelines:
                                                                                                 points
output forecasts and actual outputs.      - Provider always forecasts their outputs accurately
                                                                                                 Amber = 4 to 7
                                          = Green.
                                                                                                 points
                                          - Provider always forecasts their outputs accurately
                                                                                                 Green = 8 to 10
                                          = Amber.
                                                                                                 points
                                          - Provider rarely forecasts their outputs accurately =
                                          Red
Timeliness of claim: annual RAG rating    A RAG assessment should be given using the
based on date claims are submitted        following guidelines:                                  Red = 0 to 3
                                          - Provider always submits their claim on time =        points
                                          Green                                                  Amber = 4 to 7
                                          - Provider usually submits their claim on time =       points
                                          Amber                                                  Green = 8 to 10
                                          - Provider rarely submits their claim on time = Red points

Accuracy of claim and associated returns:     A RAG assessment should be given using the
annual RAG rating based on the accuracy of    following guidelines:                                   Red = 0 to 3
claims and Progress Reports (including the    - Provider always returns accurate Claims and           points
PPR)                                          Project Progress Reports = Green                        Amber = 4 to 7
                                              - Provider usually returns accurate Claims and          points
                                              Project Progress Reports = Amber                        Green = 8 to 10
                                              - Provider rarely returns accurate Claims and           points
                                              Project Progress Reports = Red.
Responsiveness: annual RAG rating based       A RAG assessment should be given using the
upon timeliness of responses to funder’s      following                                               Red = 0 to 3
requests for information, including           - Requests are always addressed in the timescale        points
Management Information, Action Plans, and     specified = Green                                       Amber = 4 to 7
timely completion of agreed actions           - Requests are usually addressed in the timescale       points
                                              specified = Amber                                       Green = 8 to 10
                                              - Requests are rarely addressed in the timescale        points
                                              specified, = Red
Proactive management of Risk: Does the        A RAG assessment should be given using the
project identify and update risks?            following guidelines:                                   Red = 0 to 3
                                              - Risks are always identified and sufficient            points
                                              contingencies identified = Green                        Amber = 4 to 7
                                              - Requests are usually identified and sufficient        points
                                              contingencies identified = Amber                        Green = 8 to 10
                                              - Requests are identified or sufficient contingencies   points
                                              identified = Red
TOTAL SCORE                                                                                                                  0

Please insert project name.                                                                           Please insert

Breach of Contract: If a project is defined to have substantially breached their contract they would automatically be given a red rating on contract compliance. This supercedes any ratings that
they may have on any of the other contract compliance indicators
                                                                                                                                                                                V8 Feb2012
    Indicator         Star Rating points   Total points available
        1                      0                     2
        2                      0                     2
        3                      0                     2
        4                      0                     2
        5                      0                     2

Total Star Rating Points      0                     10

Please insert project name.
Please insert provider name




                                                                    V8 - Apr2012

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:11/5/2012
language:Latin
pages:21