deltek insight 2011: tips and tricks of costpoint project setup
TRANSCRIPT
CP-161 Tips and Tricks of Costpoint Project Setup
Presented by
Martha Manning, Deltek
Project
Manufacturing
Human
Resources
Project
Management
Financial
Management
Enabling Success
Winning More
Business
Reducing the Cost
of Compliance
Increasing Project
Visibility
Improving Cash
Flow
CRM and Capture
Management
Teaming
Solutions
Market
Intelligence
Business Performance Management
Know More
Win More
Do More
5/22/20122 ©2011 Deltek, Inc. All Rights Reserved
Project
Manufacturing
Human
Resources
Financial
Management
Project
Management
Do More
CRM and Capture
Management
Teaming
Solutions
Market
IntelligenceWin More
Do More
Project Execution
& Management
Reporting, GRC &
Compliance
Project & Corp
Accounting
Time, Expense,
Labor, Payroll
Business Performance Management
Know More
5/22/20123 ©2011 Deltek, Inc. All Rights Reserved
Introduction
5/22/20124 ©2011 Deltek, Inc. All Rights Reserved
Welcome!
Martha Manning – Principal Support Analyst
Deltek Costpoint Support – 4 years
Government Project Accounting – 20 years
Agenda
5/22/20125 ©2011 Deltek, Inc. All Rights Reserved
Define a project
Describe control screens
Discuss prominent setup screens
Project Master
Subtask screens
List differences for Time and Materials (T & M) projects
Project Labor Setup
Rate Setup
Work Force and Define Rate Sequence
Explain use of alternate project
Options for entering projects
Summary
Question and answers
Key Takeaways
6 ©2011 Deltek, Inc. All Rights Reserved
The required fields in Maintain Project Master
Prior to charging costs to a project, Project Billing Info must be setup
To bill a project, Project Billing Info must be setup
Basic Revenue Info screen must be setup to recognize revenue on a project
Revenue and Billing have controls through Modifications and Ceilings
Additional setup screens for Time and Material projects
Greater reporting flexibility using Alternate projects
There are other options for entering new projects
5/22/2012
Define a Project
Attributes and Types of Projects
5/22/20127 ©2011 Deltek, Inc. All Rights Reserved
Attributes
5/22/20128 ©2011 Deltek, Inc. All Rights Reserved
Attributes
30 Characters in length
Multi-level
Hierarchical
Alphanumeric
10000
10000.A 10000.B
10000.A.01 10000.A.02 10000.B.01 10000.B.02
Types of Projects
5/22/20129 ©2011 Deltek, Inc. All Rights Reserved
Contracts
Transactional (Cost Plus, T&M)
Fixed Price
Delivery Orders
CLINs (Contract Line Items)
WIP
Indirect
Project Setup Requirements
Control Screens and Project
Master Screen
5/22/201210 ©2011 Deltek, Inc. All Rights Reserved
Setup Screens
5/22/201211 ©2011 Deltek, Inc. All Rights Reserved
Control screens
Project settings
Project account group
Project types
Project Limitations (Project/Acct, Project/Org)
Project Master screen
Project number
Project name
Project classification
Project type
Project account group
Owning org
Control Screens – Project Settings
5/22/201212 ©2011 Deltek, Inc. All Rights Reserved
Use project settings to determine top level length
Control Screens – Project Account Groups
5/22/201213 ©2011 Deltek, Inc. All Rights Reserved
Must have at least one project account group (PAG)
Control Screens – Project Types
5/22/201214 ©2011 Deltek, Inc. All Rights Reserved
Drives project reporting
User defined
Control Screens – Limitations
5/22/201215 ©2011 Deltek, Inc. All Rights Reserved
Project /Account
Project/Org
Project Master
Required Fields and Subtasks
5/22/201216 ©2011 Deltek, Inc. All Rights Reserved
Project Master Screen – Required Fields
17 ©2011 Deltek, Inc. All Rights Reserved
Project number
Project name
Project classification
Project type
Project account group
Owning organization
5/22/2012
Project Master Screen – Other Fields
18 ©2011 Deltek, Inc. All Rights Reserved
Billable Project
Export Project
Apply Cost of Money
Active/Inactive
Allow Charging
Allow Edit
Project Work Force
Top Level Work Force
Cobra Program
5/22/2012
Additional Subtask Screens
19 ©2011 Deltek, Inc. All Rights Reserved
Revenue – basic revenue info
Billing – project billing info
Funding – modifications
Limiting billing and revenue - ceilings
5/22/2012
Levels – Revenue, Billing, Funding, Unbilled
5/22/201220 ©2011 Deltek, Inc. All Rights Reserved
Revenue level
At or Above Funding
At or Above Ceilings/Limits
Billing level
At or Above Funding
At or Above Ceilings/Limits
Unbilled
At the higher of Revenue or Billing
Funding
Should match the level of work that is funded
10000
10000.A 10000.B
10000.A.01 10000.A.02 10000.B.01 10000.B.02
Our example has
funding and
billing at level 3
Revenue and
Unbilled at level 2
Subtask Screens – Basic Revenue Info
21 ©2011 Deltek, Inc. All Rights Reserved
Used to calculate revenue on the project
5/22/2012
Subtask Screens – Project Billing Info
22 ©2011 Deltek, Inc. All Rights Reserved
Used to invoice project
Required Fields
Formula
Format
Remittance
Customer
5/22/2012
Subtask Screens - Modifications
23 ©2011 Deltek, Inc. All Rights Reserved
Tracks funding and contract value
5/22/2012
Subtask Screens – Total Ceilings
24 ©2011 Deltek, Inc. All Rights Reserved
Limits revenue and billing to funding or contract values
5/22/2012
Subtask Screens – Direct Cost Ceilings
25 ©2011 Deltek, Inc. All Rights Reserved
Limits billing and revenue based on general ledger account
5/22/2012
Subtask Screens – Burden Cost Ceilings
26 ©2011 Deltek, Inc. All Rights Reserved
Enforces ceiling on target, provisional and actual burden rates
Overrides rates on target and provisional burden rates
5/22/2012
Time and Material (T&M) Setup Requirements
5/22/201227 ©2011 Deltek, Inc. All Rights Reserved
T&M Setup -Project Labor
28 ©2011 Deltek, Inc. All Rights Reserved
Project Labor Categories (PLC)
Workforce
PLC Rates
Rate Sequence
5/22/2012
T&M Setup – (PLC) Project Labor Categories
29 ©2011 Deltek, Inc. All Rights Reserved
Required on each labor transaction
Used to apply billing rates
5/22/2012
T&M Setup – Assign PLC to Projects
30 ©2011 Deltek, Inc. All Rights Reserved
Denotes which Project Labor Categories (PLC) a project can use
5/22/2012
T&M Setup – PLC Rates
31 ©2011 Deltek, Inc. All Rights Reserved
Used for billing and revenue purposes
5/22/2012
T&M Setup - Workforce
32 ©2011 Deltek, Inc. All Rights Reserved
Controls who can charge to the project
Helps drive PLC defaulting
5/22/2012
T&M Setup – Rate Sequence
33 ©2011 Deltek, Inc. All Rights Reserved
Must be defined at the charging level of the project
Tells Costpoint where the workforce is located (from the first line)
Tells Costpoint where to get the PLC rate (from first line, then second line)
5/22/2012
Alternate Projects
5/22/201234 ©2011 Deltek, Inc. All Rights Reserved
Using Alternate Projects
35 ©2011 Deltek, Inc. All Rights Reserved
Benefits
Enhances Costpoint reporting capabilities
Can reduce charging project structure
Considerations
Cannot bill by alternate project
Separate maintenance
5/22/2012
Alternate Project Sample
36 ©2011 Deltek, Inc. All Rights Reserved
10000 20000
10000.A 10000.B 20000.A 20000.B
10000.A.01 10000.A.02 10000.B.01 10000.B.02 20000.A.01 20000.A.02 20000.B.01 20000.B.02
A0000
A0000.01 A0000.02
A0000.01.A A0000.01.B A0000.02.A A0000.02.B
5/22/2012
Alternate Project Setup
37 ©2011 Deltek, Inc. All Rights Reserved5/22/2012
Other options for entering Projects
5/22/201238 ©2011 Deltek, Inc. All Rights Reserved
Options for entering Projects
5/22/201239 ©2011 Deltek, Inc. All Rights Reserved
Clone projects from one to another
Use Mass Add Projects
Upload Projects to all the required tables using Project Upload
Summary
40 ©2011 Deltek, Inc. All Rights Reserved
The required fields in Maintain Project Master
Prior to charging costs to a project, Project Billing Info must be setup
To bill a project, Project Billing Info must be setup
Basic Revenue Info screen must be setup to recognize revenue on a project
Revenue and Billing have controls through Modifications and Ceilings
Additional setup screens for Time and Material projects
Greater reporting flexibility using Alternate projects
There are other options for entering new projects
5/22/2012
Questions and Answers
41 ©2011 Deltek, Inc. All Rights Reserved
www.twitter.com/deltek
www.facebook.com/deltekinc
www.linkedin.com/company/163414
www.youtube.com/user/deltekinc
5/22/2012