Download original attachment
(Excel spreadsheet)
This is an HTML version of an attachment to the Freedom of Information request 'Use of Agency Social Work professionals'.

Sheet1


Current Average Mark Up Analysis          
           
Average mark up percentages calculated from analysis of temporary staff used by Staffordshire County Council from 1st November 2007 to 31st April 2008     
Average spend PAYE/LTD Company applied where insufficient data in category     
Job CategoryCurrent PAYECurrent LTD Company Future PAYEFuture LTD Company     
Call Centre/Customer Services** 54.15%** 28.93% 35%15%     
Catering/Hospitality** 53.24%** 28.93% 35%15%     
Driving** 54.15%** 28.93% 35%15%     
Education** 71.86%** 28.93% 42%18%     
Executive** 54.15%** 28.93% 38%16%     
Facilities Management/Building Services** 54.15%** 28.93% 38%16%     
Finance** 54.15%** 28.93% 37%15%     
General Industrial** 54.15%** 28.93% 34%15%     
Healthcare - Qualified** 54.15%** 28.93% 40%18%     
Healthcare - Unqualified** 54.15%** 28.93% 40%18%     
Housing** 54.15%** 28.93% 38%16%     
Human Resources** 54.15%** 28.93% 38%16%     
Information Technology** 54.15%** 28.93% 38%16%     
Legal** 76.35%** 35.34% 40%18%     
Leisure Services** 54.15%** 28.93% 38%16%     
Policy, Performance and Review** 54.15%** 28.93% 38%16%     
Procurement/Logistics/Supply Chain** 54.15%** 28.93% 38%16%     
Revenues and Benefits** 54.15%** 28.93% 37%15%     
Sales and Marketing** 54.15%** 28.93% 40%16%     
Secretarial & Admin** 38.45%** 28.93% 34%15%     
Socialcare - Qualified** 46.90%** 26.93% 40%18%     
Socialcare - Unqualifed** 67.99%** 51.30% 44%18%     
Technical** 52.14%** 28.93% 38%15%     
           
Pricing ScheduleStandard ESPO Agreement         
Cost ReductionDirect to line         
           
           
AVERAGE MARK UP AND REDUCTIONPAYELTD    
 PayChargeReductionPayChargeReduction    
Call Centre/Customer Services          
Catering/Hospitality26487.482142857140588.48142857144019.4519642857       
Driving          
Education9215.2857142857115837.42857142862388.22285714286       
Executive          
Facilities Management/Building Services          
Finance13963.632857142920926.44428571431776.87441428571       
General Industrial1616.071428571432391.78571428571161.607142857143       
Healthcare - Qualified   18229.285714285725598.57142857143894.08571428571    
Healthcare - Unqualified2439.357142857143940.5431.578571428572       
Housing          
Human Resources          
Information Technology          
Legal32895.942857142958011.842857142911539.1356178.428571428676029.35714285719218.79357142858    
Leisure Services          
Policy, Performance and Review          
Procurement/Logistics/Supply Chain   26571.428571428630822.8571428571-16.6071428571377    
Revenues and Benefits          
Sales and Marketing          
Secretarial & Admin347057.475714285480507.4357142861871.65932857175       
Socialcare - Qualified37362.861428571454887.44668571432117.68497142858670932.625714286851614.077452416.4704857143    
Socialcare - Unqualifed360010.728571429604794.13901428678336.628442857251652.785714285778150.607371428616326.5730857143    
Technical42113.031428571464069.065286.576628571433293.278571428573840.0071428571418.9867857142858    
Total873161.8692857141345954.56427143107929.414321429826857.8328571431066055.4776285781858.3025    
           
           
Total Markup based on average spendPAYE** 54.15% Ltd Company ** 28.93%     
           
Total Savings (%spend)PAYE** 8.02% Ltd Company** 7.68%     
Total Savings (%spend)** 7.87%         
Total Savings (Annual)455490.520371429         
           
Spreadsheet's Author: lstib1ir
Last Updated with Excel 97

** This cell's data may not be accurate.
 
Created with xlhtml 0.5.1