Docstoc

First

Document Sample
First Powered By Docstoc
					                                                Launch Version 2.2

              Care Funding Calculator
                     Fair Price, Fair Care

First you need to save this spreadsheet with a different name.

Click on "File", "Save as" and press the delete button

Now type in the new file name


This should be the service user's index number from your
information system, then their surname, then IND followed by v1

For example, "123456 Smith IND v1"


When you need to amend or add information to what you have
entered before, change the version number from v1 to v2 etc.

Then click here
INDEPENDENT LIVING
     VERSION
                   Care Funding Calculator
                           Fair Price, Fair Care
Introduction
The spreadsheet is designed to assist you in the process of assessing what is a
reasonable fee for the independent living care of your service user.
Independent living comes in several variations. In this model we have two types
covered. These will cover the majority of schemes. To ensure you get the results
you want, please make sure you select the right option in the "Provider" section.
The two areas are:
Accommodation Based - This is where the staff team and their immediate
management are based on site or nearby in another unit that is part of the same
scheme. Each service user will have their own accommodation (although this
may be only a bedroom) and tenancy and the care will be provided by a staff
team dedicated to the scheme. The level of care may be very intensive or at any
level through to a minimal level. The key element is that it is based at one of the
accommodation units in the scheme and will be charged for as an overall
package. If the care is funded through "Supporting Peole" it will be attached to
the property, not the individual service user.

Floating Support - This is where the care is based at an office away from the
tenancies and service users. The staff are likely to support a number of people at
a variety of locations. Their care needs again will vary, but the care will be
expressed more clearly as a number of hours at a set rate per hour including all
the management and other costs. If the care is funded through "Supporting
People" the funding will be specific to the person, and would move with them if
they moved to alternative accommodation.
In both cases many costs, for example food and energy costs, will be paid for by
the service user from their benefits.
The spreadsheet to help you calculate the costs comes in several parts which
you can see in the "tabs" at the bottom of the screen. The tabs and the different
parts of the spreadsheet are colour coded to help you find your way around.
These are:
It may be that in your authority you will not be expected to complete every section.
These arrangements vary, so make sure you know which areas you should be
completing. There's no point wasting your time on the others.
There are areas which will generally be completed by Care Managers
• Day Programme
• Needs
• Time Advice
•Outcomes


There are areas which will be completed by the Team Manager of the Care
Manager
• Agree Needs

There are areas which will generally be completed by Contracts / Procurement
staff or Brokers.
• Location
• Provider
• Supp Req
• Calculations
• Agree Price
• Checklist

These guidance notes take you through what you need to do at each stage. You
will probably find it easiest to work through the spreadsheet in the order of the
tabs, although you may not have all of the information you need when you start.

If you have a problem with completing the spreadsheet, you should refer to the
more detailed printed guidance. If you cannot solve the problem this way, consult
your authority's "super-user". Don't suffer in silence - ask for help!
If you look at the various parts of the spreadsheet on the screen, you will see the
cells or boxes are shaded different colours.

In the white cells like this one, you should enter text. There aren't many of these.

In blue ones like this you will find a "pick list". Here there are only two or three
possible responses, and you need to pick one. This is explained below.

In yellow ones like this you should enter a figure.


In some of the areas there may be only two or three answers possible, like "Yes"
and "No". For these there are "pick lists" to save you typing the answers. There is
an example below. When you click on this cell a small down arrow appears on
the right hand side. If you click on this the possible answers appear. Click on the
one you want and the cell will change to this. You can practice here if you want.
                                         Yes
The other areas are "locked" to stop you altering them. Some of these contain
formulas to calculate costs for you or to alert you to areas where you may need to
reconsider what you have entered.
Some areas are completed automatically for you. If you enter the name of the
service user, for example, in "Needs", it will appear automatically in other areas of
the spreadsheet where it needs to. The same happens with other areas that
appear more than once.

The spreadsheet will provide you with a guide on the cost of the care for the
service user you are working with. It will not give you an exact answer.
Please also remember that you are not compelled to agree a price within the
guideline range. A higher or lower price might be appropriate. The amounts the
calculator provides are the basis for negotiation, not absolute limits.
MAKE SURE YOU KNOW EXACTLY WHAT YOU ARE AUTHORISED TO
AGREE ON BEHALF OF THE COUNCIL, BEFORE MAKING ANY VERBAL OR
WRITTEN COMMITMENT ON ANY CONTRACT ISSUE.
A price higher than the spreadsheet gives may well be the right decision. But
think very carefully before agreeing this. If you are a care manager be sure to ask
for advice from your manager or the procurement team, who will be involved in
these discussions much more frequently than you.
Remember any expenditure you commit the authority to unnecessarily is
money you and your colleagues cannot spend on meeting the needs of
other service users.
Acknowledgements - The calculator is the result of input of many people. Initial
work was undertaken in Gloucestershire and the South West region, and then
Hampshire, East Sussex and the South Eastern region. Further work was then
done in the Eastern and London regions. This national version was developed
from this work in a project involving over 70 authorities.
Detailed work was undertaken by Jonathan Tipler, a consultant. He can be
contacted on jonathantipler@aol.com.
             Care Funding Calculator                                   Service User:                    0                         Outline of plan of activities / support plan
             Monday                       Tuesday                      Wednesday                     Thursday                       Friday           Saturday           Sunday



                            1:1 or more




                                                         1:1 or more




                                                                                       1:1 or more




                                                                                                                    1:1 or more




                                                                                                                                                  1:1 or more




                                                                                                                                                                               1:1 or more




                                                                                                                                                                                                            1:1 or more
                             needed?




                                                          needed?




                                                                                        needed?




                                                                                                                     needed?




                                                                                                                                                   needed?




                                                                                                                                                                                needed?




                                                                                                                                                                                                             needed?
             Activities /                 Activities /                  Activities /                 Activities /                  Activities /                 Activities /                 Activities /
  Time of
              Support                      Support                       Support                      Support                       Support                      Support                      Support
    Day
              Needs                        Needs                         Needs                        Needs                         Needs                        Needs                        Needs

   Early
  Morning

 Breakfast

   Mid
  Morning

   Late
  Morning

 Lunchtime

   Early
 Afternoon

    Mid
 Afternoon

    Late
 Afternoon

  Dinner

   Early
  Evening

   Late
  Evening




D:\Docstoc\Working\pdf\ea77d288-3ca3-4e53-91af-a2cfe7f04559.xlsea77d288-3ca3-4e53-91af-a2cfe7f04559.xlsDay Prog 4/29/2010 12:25 AM                                                                             Page 12
Care Funding Calculator
Service user:                                                                                    Name of assessor:
Reference no.:                                                                                   Date comp: (dd/mm/yy)
Date birth: (dd/mm/yy)                                                                           Placing Authority
What are the areas my assessment needs to cover?
I spend time at home and away from my home with no support from the provider's staff                                     No

I need support with looking after myself? (Areas like washing, dressing, toilet / continence, feeding, medication etc)   No

I need support with organising my life / preparing for independent living? (Areas like dealing with landlord or
                                                                                                                         No
neighbours, claiming benefits, helping me to cook & prepare food, etc)
I need support with living my life? (Areas like arranging to see family friends, accessing community and activities,
                                                                                                                         No
dealing with impairments and communication, etc)
I need support with keeping myself safe? (Areas like relationships, managing anger, depression, anxiety, damaging
                                                                                                                         No
things, wandering off, etc.)

I need support from other professionals (e.g Psychologist, Psychiatrist, SALT) which will be billed to the
                                                                                                                         No
purchaser

I need support using assistive technology                                                                                No

I need support at night. (somebody to be awake where I am and/or somebody sleeping where I am)                           No




D:\Docstoc\Working\pdf\ea77d288-3ca3-4e53-91af-a2cfe7f04559.xls 12:25 AM 4/29/2010                                            Page 13
Service user:                                                                        Name of assessor:




D:\Docstoc\Working\pdf\ea77d288-3ca3-4e53-91af-a2cfe7f04559.xls 12:25 AM 4/29/2010                       Page 14
Service user:                                                                        Name of assessor:




D:\Docstoc\Working\pdf\ea77d288-3ca3-4e53-91af-a2cfe7f04559.xls 12:25 AM 4/29/2010                       Page 15
Service user:                                                                        Name of assessor:




D:\Docstoc\Working\pdf\ea77d288-3ca3-4e53-91af-a2cfe7f04559.xls 12:25 AM 4/29/2010                       Page 16
Service user:                                                                        Name of assessor:




D:\Docstoc\Working\pdf\ea77d288-3ca3-4e53-91af-a2cfe7f04559.xls 12:25 AM 4/29/2010                       Page 17
Service user:                                                                        Name of assessor:




D:\Docstoc\Working\pdf\ea77d288-3ca3-4e53-91af-a2cfe7f04559.xls 12:25 AM 4/29/2010                       Page 18
Service user:                                                                              Name of assessor:
Daytime Support Hours - Summary
                                                              You have included      0.0   hours/week where 1:1 or more intensive care is needed
In all you have included the following number of hours per day at the various ratios. Does this appear correct? If not please check
that you have not miskeyed any information or duplicated any needs.
You have included:
            0.0                      0.0                       0.0                          0.0                        0.0
    hours 1:1 per day         hours 2:1 per day         hours 3:1 per day            hours 4:1 per day        hours 5:1 per day

                Please check the figures above in case of inadvertant miskeying entries like entering 400 instead of 40.




D:\Docstoc\Working\pdf\ea77d288-3ca3-4e53-91af-a2cfe7f04559.xls 12:25 AM 4/29/2010                                                     Page 19
Service user:                                                                        Name of assessor:




D:\Docstoc\Working\pdf\ea77d288-3ca3-4e53-91af-a2cfe7f04559.xls 12:25 AM 4/29/2010                       Page 20
INDEPENDENT LIVING CASES - How many minutes to support these areas?




                                                             No. Resp


                                                                         Average


                                                                                   Median
Things I might need support with to look after myself:
Washing myself                                               87         14.4       14
Having a bath / shower                                       107        29.5       30
Look after teeth / dentures                                  94          9.2       8
Look after skin and nails                                    91         11.4       9
Get dressed / undressed                                      65         17.4       15
Going to the toilet / catheter care & continence support     65         14.9       10
Eating and drinking                                          51         35.3       30
Support getting around (mobility difficulties)               45         47.2       40
Support getting to sleep                                     28         23.2       15
I have seizures                                              23         22.6       25
See the doctor, dentist,                                     133        25.2       19
Help me to take medicines                                    122        13.4       10
Things I might need support with to be independent:
Running my bank account and paying bills                     126        42.9       45
Doing my laundry                                             108        48.6       45
Cleaning my house / flat                                     106        45.2       45
Doing my shopping                                            136        80.9       60
Cooking & preparing food                                     112        50.5       45
Dealing with my landlord / paying rent                       92         16.5       23
Dealing with neighbours                                      48         15.7       26
Claiming benefits                                            88         14.6       10
Things I might need support with to live my life:
Arranging to see family and friends                          85   36.9  20
With my religion                                             18   81.8  43
With my cultural needs                                       16   33.2  10
I have difficulty seeing                                     10   32.2  15
I have difficulty hearing                                     7   10.6  10
I have difficulty communicating (Help me use equip., etc.)   39   41.9  79
Being in the community / access facilities                   127 127.6 105
Access to activities in the home                             74   51.3  60
Key working                                                  98   48.2  55
Things I might need support with to help me be safe:
If I get confused                                            58         25.9       29
If I hurt myself or get anxious or depressed                 95         35.4       30
To help me understand relationships or sexual                54         36.3       25
If I get physically angry                                    42         36.9       28
If I get verbally angry                                      64         38.9       30
To make sure I don't put myself in danger e.g.               53         43.3       55
If I break things or try to damage things                    28         28.6       25
To respect other people's personal space                     40         27.8       25
Areas where I want to increase my ability to do things on my own as much as possible:
                        To live more
Looking after myself:                               To live my life:          To help me be safe:
                        independently:
Washing myself               0   Bank / money                   0   See family & friends              0    If I get confused           0
Having a bath / shower       0   Doing my laundry               0   With my religion                  0    Hurt self or get anxious    0
Teeth / dentures             0   Cleaning                       0   With cultural needs               0    Understand relat'ships      0
Skin and nails               0   Shopping                       0   I have difficulty seeing          0    If I get physically angry   0
Get dressed / undressed      0   Cook & prep food               0   I have diff hearing               0    If I get verbally angry     0
Toilet / catheter care etc   0   Landlord / pay rent            0   Speak / comm.equip.               0    Put myself in danger        0
Eating and drinking          0   Deal w neighbours              0   In the community                  0    Break/damage things         0
Getting around               0   Claiming benefits              0   Activities in the home            0    Respect pers space          0
Getting to sleep             0   Other (please specify here)    0   Key working                       0    Other (please specify)      0
I have seizures              0   Other (please specify here)    0   Other (please specify)            0
See doctor, dentist, etc     0
To take my medication        0
Other (please specify        0
here)




D:\Docstoc\Working\pdf\ea77d288-3ca3-4e53-91af-a2cfe7f04559.xlsea77d288-3ca3-4e53-91af-a2cfe7f04559.xlsOutcomes 4/29/2010 12:25 AM     Page 22
                                                                                                                         Don't start from
What I want to achieve in these areas:                         Service User:         0                                   assumption this
 Areas where I                                                                      How many     How More than          will require extra
                                                                                                                Total
     want to      What I want to be able                                   Staffing   extra      many  basic              time - existing
                                               How we will try to do this                                      hours /
  increase my              to do                                           ratio 1:  minutes   times a grade
                                                                                                                week   support may need
      skills                                                                        each time? week?   req'd            to be refocussed
                                                                                                                        Review
                                                                                                                         Date
                                                                                                                       Was this
                                                                               1                         N       0.0 achieved          N
                                                                                                                            ?
                                                                                                                         When
                                                                                                                       achieved
                                                                                                                            ?
                                                                                                                        Review
                                                                                                                         Date
                                                                                                                       Was this
                                                                               1                         N       0.0 achieved          N
                                                                                                                            ?
                                                                                                                         When
                                                                                                                       achieved
                                                                                                                            ?
                                                                                                                        Review
                                                                                                                         Date
                                                                                                                       Was this
                                                                               1                         N       0.0 achieved          N
                                                                                                                            ?
                                                                                                                         When
                                                                                                                       achieved
                                                                                                                            ?
                                                                                                                        Review
                                                                                                                         Date
                                                                                                                       Was this
                                                                               1                         N       0.0 achieved          N
                                                                                                                            ?
                                                                                                                         When
                                                                                                                       achieved
             Total hours required to achieve increased independence (all - basic grade and more experienced) : 0.0          ?
                        Total hours required to achieve increased independence (more experienced staff only) :         0.0




D:\Docstoc\Working\pdf\ea77d288-3ca3-4e53-91af-a2cfe7f04559.xlsea77d288-3ca3-4e53-91af-a2cfe7f04559.xlsOutcomes 4/29/2010 12:25 AM     Page 23
Needs identified and to be signed off by manager
                                                                  Review
                                                         Agreed     (enter
                                                                  dd/mm/yy)
Total Daytime Contact Hours Required               0.0     N
Total Daytime Payable Staff Hours                  0.0     N
Additional Support Needs (eg Psychologist)          N      N
Assistive Technology                                N      N
Night cover - on-call                               N      N
Night cover - sleeping-in                           N      N
Night cover - waking                                N      N

Needs Levels Agreed by:                                            Date

				
DOCUMENT INFO