Presented by David Chapman

1
LSC Time Recording project

• Presented by David Chapman
• CHL
• www.chl.co.uk

2
Session Content

• Background
• Business Rationale
• TS2000 Overview
• Deployment Plans
• Further Information
• Questions

3
Background

• In 2001 the National LSC instigated a Time
  Recording project, and after a supplier
  evaluation process CHLs TS2000 Activity Analysis
  system was chosen
• Since then progress has been made on
• National LSC and lead user requirements capture
• Xansa and ICL project management and
  infrastructure activity
• CHL system enhancement

4
Background

• The system must be available to all local LSCs
  via an intranet gateway or through the LSC WAN
• Key requirements include
• Multiple site input
• Time collection by individual to nearest 15
  minutes against specific projects
• Reporting by individual, project, objective
• Interfaces/integration with national financial
  systems

5
Business Rationale

• The obligation for ESF claims to be based upon
  actual expenditure places a heavy audit and
  process burden upon local LSCs
• The National Co-Financing Funding Agreement
  covers the 95 of funding directed to service
  providers
• The LSC Time Recording project is concerned with
  the remaining 5 of allowable administration
  funding

6
Business Rationale

• 5 of eligible co-financing is reclaimable for
  administration costs
• Detailed rules ensure that
• Only actual expenditure is allowed
• Individuals must be associated with measures and
  activities
• Non-project activity must be excluded

7
Business Rationale

• Significant changes must be reported to
  Government Office as soon as known or at least 3
  months before project completes, for example
• Overall unit cost varies by more than 15
• Variations to cost headings
• Match funding changes
• This requires a rigorous approach to project
  monitoring

8
Business Rationale

• The National LSC office anticipates
• Administration Control audits considering time
  recording records, administration cost reviews
  and proper overhead allocation
• Progressively more stringent audit and reporting
  standards
• Increased expectations on LLSCs to demonstrate
  proactive project monitoring through budget,
  forecasting and variance analysis mechanisms

9
TS2000 Overview

• Key roles

End Users
Administrators

• Time Sheets

• User Profiles
• System Management
• Audit and Control

Budget Holders
Knowledge Workers

• Budgets
• Projections
• Monitoring

• Activity Reports
• Cost Reports
• Data Mining

10
TS2000 Overview

• End users functionality
• Personalised time sheet captures project
  activity time
• Users can enter, edit, retrieve and print their
  personal time sheet
• Entry at week-level and/or day-level

11
TS2000 Overview

• Personalised time sheet

12
TS2000 Overview

• Budget Holders functionality
• Aids project management
• Actual, budgeted and variance costs
• Linear regression based forecasting
• Print-based reports

13
TS2000 Overview

• Budget management

14
TS2000 Overview

• Administrators functionality
• National LSC
• TS2000 structural setup
• Local LSC
• Management of end user activity profiles
• Control of data entry periods
• Exception management
• Control reports

15
TS2000 Overview

• Activity management

16
TS2000 Overview

• Knowledge workers functionality
• Activity analysis and cost analysis by
• Structure, e.g. objective, measure
• Time Period, e.g. monthly, reporting period
• Microsoft web services integration
• Pivot for data mining
• Data download into Microsoft Excel

17
TS2000 Overview

• Reports can be presented as web pages

18
TS2000 Overview

• Reports can be presented in Microsoft Excel

19
TS2000 Overview

• National and local LSC deployment

20
TS2000 Overview

• Local LSC deployment

21
Deployment Plans

• TS2000 is being deployed in phases
• Initial phase functional enhancements,
  technical integration, user acceptance testing
  with lead users
• Phase 1 rollout to LLSCs
• Phase 2 integration with CODA, CHRIS and
  functional enhancements
• Further phases -

22
Deployment Plans

• Planned timescales

23
Deployment Plans

• Training
• End-user minimal effort as browser-based
• Quick Reference Guide, User Manual and short
  training course
• LLSC Administrator full understanding of TS2000
  required
• Quick Reference Guide, User Manual and 1-day
  training course

24
Further Information

• PowerPoint and Word copies of this presentation
  and the accompanying document can be downloaded
  from www.chl.co.uk/lsc_natconf
• For TS2000 product details please visit
  www.chl.co.uk
• For implementation questions please email David
  Chapman at chapman_at_chl.co.uk