Validation Session
Finance Team
Project Systems December 10 & 11, 2008
Validation Session Validation Session
Finance Team Finance Team
Project Systems Project Systems December 10 & 11, 2008 December 10 & 11, 2008
LaGov LaGov Validation Session Agenda Validation Session Agenda - - PowerPoint PPT Presentation
Validation Session Validation Session Validation Session Finance Team Finance Team Finance Team Project Systems Project Systems Project Systems December 10 & 11, 2008 December 10 & 11, 2008 December 10 & 11, 2008 LaGov LaGov
Validation Session
Finance Team
Project Systems December 10 & 11, 2008
Validation Session Validation Session
Finance Team Finance Team
Project Systems Project Systems December 10 & 11, 2008 December 10 & 11, 2008
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
2
Validation Session Agenda Validation Session Agenda
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
3
Purpose of Validation Sessions Purpose of Validation Sessions
participants regarding the TO-BE process design:
differing
points
the TO-BE process design Note: Validation sessions are an affirmation of work session decisions, and assume the SAP functionality knowledge covered in TO-BE session. Note: Validation sessions are an affirmation of work session decisions, and assume the SAP functionality knowledge covered in TO-BE session.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
4
Purpose of Today Purpose of Today’ ’s Validation Session s Validation Session
project creation.
control of projects.
FHWA projects
and activities for Project Management
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
5
Workshop Session Recap Workshop Session Recap
Business Process Workshop Codes Goals Work Session Date AM/P M
Project Structures-DOTD FI-PS-001
2008 AM/ PM Project Structures- FPC FI-PS-002
13, 2008 AM/ PM Project Structures- Others FI-PS-003
2008 AM/ PM Project Budgeting and Control FI-PS-004
2008 AM/ PM Project Planning FI-PS-005
2008 AM/ PM
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
6
Session Recap Continued Session Recap Continued… …
Business Process Workshop Codes Goals Work Session Date AM/P M
Project Accounting FI-PS-006
Receipt, to Invoice
2008 AM/ PM FHWA Billing FI-PS-007
15, 2008 AM/ PM Project Management FI-PS-008
2008 AM/ PM Capital Projects Periodic Processing FI-PS-009
periodic processing
2008 AM/ PM
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
7
Topic Topic
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
8
Project Structures Project Structures – – Design Considerations Design Considerations
– Smart Numbering for Reporting?
– To what level of detail should we drive down postings and budget?
– When to create Projects and the Master Data without cluttering the database
– Who will create the Project in SAP? – Who will populate the Master Data?
– What important dates need to be Captured?
– Do Project Managers require CPM functionality?
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
9
Project Structures Project Structures – – Key Decisions Key Decisions
Naming Convention for DOTD Projects
– T.000001.01.1
Construction phase by Control Section
expenditures are identified by control section.
Sections.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
10
Project Structures Project Structures – – Key Decisions Key Decisions Naming Convention for FPC State Projects
– FS.000001.01 for State Projects (Project.Phase)
Equipment
FS.000001.01 Land FS.000001 LSU New Box Stadium FS.000001.02 Planning FS.000001.03 Construction FS.000001.04 Misc FS.000001.05 Equipment
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
11
Project Structures Project Structures – – Key Decisions Key Decisions
Naming Convention for FPC State Projects
– FS.000001.001.01 for State Projects (Project.Sub-project.Phase)
using the SAP template.
Equipment
between Project Number and Phase.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
12
Project Structures Project Structures – – Key Decisions Key Decisions
Naming Convention for FPC Non-State Projects
– FN.000001.01 for Non-State Projects (Project.Phase)
Equipment
and vendor
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
13
Project Structures Project Structures – – Key Decisions Key Decisions
Naming Convention for Projects
– CP.000001.1 for Coastal Protection Projects – CR.000001.1 for Coastal Restoration Projects – CC.000001.1 for Combined Projects
Construction, Monitoring
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
14
Project Structures Project Structures – – Key Decisions Key Decisions
Naming Convention for Projects
– CP.000001.1 for Coastal Protection Projects – CR.000001.1 for Coastal Restoration Projects – CC.000001.1 for Combined Projects
Construction, Monitoring, Operations/Maintenance, CRMS
CP.000001.1 Planning/ Feasibility CP.000001.2 Design CP.000001 Coastal Protection Project CP.000001.3 Land Rights CP.000001.4 Construction CP.000001.5 Monitoring CP.000001.6 Operations / Maintenance CP.000001.7 CRMS
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
15
Project Structures Project Structures – – Key Decisions Key Decisions
Status Management
– Created – Released – Technically Closed – Closed
STATUSES
DOTD FPC OCPR Created Created Created Released Released Released Hold Hold FHWA Statuses De-Authorized Technically Complete Technically Complete Technically Complete Closed Closed Closed FHWA Status: Add, Change, Close, Re-Open
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
16
Project Structures Project Structures – – Key Decisions Key Decisions
Milestones DOTD
– Bid Date – Contract Date – Work Order Date – Final Inspection – Final Acceptance Date (Chief Engineer’s Approval) – Final Estimate
– Project Delivery Date (PDD) – Environmental Clearance Date – Final ROW Maps – Construction Completion Date (Target date required by FHWA)
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
17
Project Structures Project Structures – – Key Decisions Key Decisions Milestones FPC
– Acceptance Date – Consent Surety Date – Clear Lien Date – As-Built Date – Phases of Design (PC, SD, DD, CD, BD…) – Liens (See STARS dates)
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
18
Project Structures Project Structures – – Key Decisions Key Decisions
Milestones FPC
Execution and Revision
– Data Form Received from Non-State Entity Date – Draft Co-op to Entity Date – Draft Co-op received from Entity Date – Draft Co-op to FPC Project Manager Date – Draft Co-op Approved by FPC Date – Final Co-op to Entity Date – Final Co-op Received by FPC Date – Final Co-op Signed by FPC Date – Executed Co-op to Entity Date – Executed Co-op Processed in ISIS Date
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
19
Project Structures Project Structures – – Key Decisions Key Decisions Milestones OCPR will not utilize Milestones (Key dates will be tracked in the Networks and Activities)
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
20
Project Structures Project Structures – – Key Decisions Key Decisions
– DOTD
– FPC
– OCPR
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
21
Project Structures Project Structures – – Key Decisions Key Decisions Networks and Activities
– Overall, the Option is open, the need is not defined – Decision was made to keep Primavera scheduling engine and interface to SAP PS – SAP Resource / Material Management are not a requirement for Project Management
Management
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
22
Project Structures Project Structures – – Key Decisions Key Decisions
Timing of Project Creation
Blueprint session to create at Stage 2. Budget Preparation Validation session recommended creating at Stage 1.
Timing depends on Means of Finance, State General Fund projects can be set-up as soon as the Appropriation Bill is signed by the Governor, Bond projects are based on Bond Commission approval of funding.
selected projects advance and need to be created in PS.
All project definitions will be created in SAP, TOPS to be retired (DOTD) Office of Information Technology (OIT) decided to defer use of SAP to track IT-10 projects until after initial implementation.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
23
Project Structures DOTD Project Structures DOTD – – Flow Chart Flow Chart
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
24
Project Structures FPC Project Structures FPC – – Flow Chart Flow Chart
Capital Outlay Coordinator Project Budgeting Entity Project Control Capital Outlay Coordinator12/23/2008 Project Systems Validation Session Slide Deck - FINAL
25
Project Structures OCPR Project Structures OCPR – – Flow Chart Flow Chart
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
26
Project Structures Project Structures – – Changes & Challenges Changes & Challenges
and shared in common data cubes
data entry will require a re-alignment of roles and responsibilities according to functionality
longer include the Control Section embedded in the project number
and terminology
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
27
Project Structures Project Structures – – Open Issues Open Issues Action Items
– Identify User Fields that need to be tracked in the system
fields required in order to write the Functional Specification
– Explore options for projects not tied to Control Sections
Control Sections – TOPS impact on other systems
– FHWA and State requirements for minority business set asides
– Data cleansing
– Roles and responsibilities for project creation
– TOPS Project Data conversion / archive to BI or Business Objects
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
28
Project Structures Project Structures – – Open Issues Open Issues Action Items
– Activities currently being tracked for Non-State projects
– Check with Budget Prep module to see if user fields can be brought into PS automatically
IBM team will investigate/explore options for PS master data retraction during Realization – Get list of Milestones to include in project structure
– Future consolidation of Coastal Restoration and Coastal Protection into single entity
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
29
Project Structures Project Structures – – Open Issues Open Issues Parking Lot
– Assignment of Project Engineer
– “SUBS” Vendor List- Can outside vendors be set up in SAP according to business origin? – “Phases” for non-road and bridge projects. Applies to Public Works projects versus Highway projects
– How to handle merged projects?
– Review roof system to ensure data resides in SAP
– Review Bond process/system
– How to handle payables vs. non-payables?
– Ability to retrieve project data on “closed” and/or “complete” projects not converted into SAP?
– Flood Protection components (sub-projects done by Corp of Engineers need to be tracked for project timeliness).
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
30
Project Structures Project Structures – – Benefits & Improvements Benefits & Improvements
properly account for project expenditures at an overall project level and broken down into sub-levels as required
accounting in one system
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
31
Project Structures Project Structures – – FRICE FRICE-
W
is active
– Conversion of project master data, budget, expenditures, encumbrances, etc.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
32
Topic Topic
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
33
Project Budgeting and Control Project Budgeting and Control
Design Considerations Design Considerations
– Points to keep in mind:
budget vs. actual reporting
budget transfer, but still gives controls required for effectively managing the project
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
34
Project Project Budgeting and Budgeting and Control Control –
– Key Decisions Key Decisions
stop if budgeted funds are depleted.
– DOTD projects that cross multiple control sections (multiple construction phases for each control section) will be controlled together using FM Availability Control
budgeted funds are depleted. This item was revisited during FI-PS-008 resulting in a decision to control at the phase level.
the rest of the State
ISIS Group, with the exception of Salary and Benefits. Art GL expense will be budget controlled separately for Facilities projects
consumable budget to take place on a project-by-project basis as funding is approved.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
35
Decision: Retraction into which FM objects? Decision: Retraction into which FM objects?
Plan in BI-IP ECC FM
are ready to begin.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
36
Project Budgeting and Control Project Budgeting and Control
Changes & Challenges Changes & Challenges
– Training will be necessary in order for users to be able to post budget to varying projects levels
– Hard stops to prevent overspending on project budgets. – In the future, budget transfers will take place after additional funding has been approved.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
37
Project Budgeting and Control Project Budgeting and Control
Open Issues Open Issues
– Track budget partitions to STIP
– STIP (Planning) versus Financials reporting capability (PS-IP)
Projects against STIP – Meet with G/L team about object codes
to the level required
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
38
Project Budgeting and Control Project Budgeting and Control
Open Issues Open Issues (cont
(cont’ ’d) d)
– Will SAP replace/interface SONRIS for OCPR coastal projects?
SONRIS. – Capture contracts between local entity, track at task level and vendor for Coastal Protection projects
clear understanding of the work effort required if captured in SAP
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
39
Project Budgeting and Control Project Budgeting and Control
Open Issues Open Issues (cont
(cont’ ’d) d)
– Research order/preference of means of finance
Realization. – Determine appropriate budgeting controls for revenue bond projects
– Cash versus budget: existing requirement to collect cash
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
40
Project Budgeting and Control Project Budgeting and Control
Benefits & Improvements Benefits & Improvements
1. Creation of a project accounting sub-ledger and master data to properly account for project budgets and expenditures at an overall project level and broken down into sub-levels as required 2. Ability for Project Managers to review budget information real time (or close to real time in BI) 3. Availability of plan-to-budget-to-actual reporting for the overall project 4. Creation of discrete project budgetary control objects 5. Use of soft stops as an early warning of possible overruns using tolerances 6. Use of hard stops to prevent overspending. A budget transfer will be required to continue. 7. Elimination of offline spreadsheets and tracking of all projects in one integrated system 8. Ability to view all fund sources so that the oldest fund may be chosen first when appropriate
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
41
Project Budgeting and Control Project Budgeting and Control – – FRICE FRICE-
W
session
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
42
Topic Topic
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
43
Project Accounting Project Accounting – – Design Considerations Design Considerations
– RFQ, Contracts, PR and PO
– Is Goods Receipt required?
– Approval levels
– Use of Payroll postings Actual values for Project Billing
– CO Cost Allocations
– Federal Funds other than FHWA will be tracked in Grants
– Will maintenance resources be used on Projects?
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
44
Project Accounting Project Accounting – – Key Decisions Key Decisions
entered into SAP. Postings for construction activities will be interfaced from Trns.port
Account Assignment:
– WBS Element for the State Project – Fund – Functional Area (if applicable) – GL Account
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
45
Project Accounting Project Accounting – – Key Decisions Key Decisions
– Outbound to give Trns.port the Project Number – At the Preconstruction stage, Advertising and receiving bids will be captured in Trns.port via Bid Express / Expedite. Any bid awards processed through Bid Express will be interfaced from Trns.port to SAP (Inbound) to create the Contract / Purchase Order. (This is assuming that the SAP accounting codes can be captured in Trns.port.) – Contract/Purchase Orders, Invoices, Change Orders, Contract Closeout data will originate from Trns.port and feed into SAP (Inbound) via interface. At the construction stage, Projects will be monitored and tracked in Trns.port and feed via interface with SAP. – Invoices for payment will be initiated in Trns.port. Approval process for the invoice occurs in Trns.port, the Project Engineer, District Administrator and/or Construction Audit provide the approvals needed for final signoff of an invoice in Trns.port.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
46
Trns.port Trns.port Integration Integration
SAP
Initial Set-up
Trns.port
Trns.port
Preconstruction
Advertise and Receive Bids BidExpress Expedite Prepare Estimate
SAP
Monitor/Track Project Prepare Progress Estimates
SAP
Trns.port
SiteManager and SiteManager Materials Manage Change Orders Close Out Contract
SAP SAP
Project Master Data Contract / PO Invoice Change Orders Contract Closeout
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
47
Project Accounting Project Accounting – – Key Decisions Key Decisions
– All three agencies agreed that Individual Agency Accounts Payable sections will enter invoices into SAP, rather than Centralized Accounts Payable Agency
– Both (PS) Project System and (GM) Grants use WBS elements as cost collectors. At time of posting, user will enter WBS Element and Grant. A derivation rule in the GM module will capture costs for billing purposes. All costs against the project WBS will settle from the WBS Element to AuC or Final Asset.
– DOTD:
– FPC:
– OCPR:
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
48
Project Accounting DOTD Project Accounting DOTD – – Flow Chart Flow Chart
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
49
Project Accounting FPC Project Accounting FPC – – Flow Chart Flow Chart
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
50
Project Accounting OCPR Project Accounting OCPR – – Flow Chart Flow Chart
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
51
Project Accounting Project Accounting – – Changes & Challenges Changes & Challenges
integrated in one system.
work together.
accountable for review of invoices.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
52
Project Accounting Project Accounting – – Open Issues Open Issues Action Items
Advance Construction of Federal Aid Projects
– PS team and CM team will need to discuss further during Realization
Parking Lot
– Assumption is that the SAP accounting codes can be captured in Trns.port. Need to follow up with DOTD.
reimbursable contracts
– Will be discussed further during Realization.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
53
Project Accounting Project Accounting – – Benefits & Improvements Benefits & Improvements
contracts to payment of the invoice
integrated system
project unless there is budget and project has been released) Accounting system of record is updated in real-time during the invoicing and payment processing
access to the same information
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
54
Project Accounting Project Accounting – – FRICE FRICE-
W
Trns.port.
from Trns.port to SAP
(Given Trns.port can house the financial details)
Report
funded project phases)
entering contract
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
55
Topic Topic
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
56
FHWA Billing FHWA Billing – – Design Considerations Design Considerations
– Manage federal appropriations (One federal agreement might fund multiple appropriations. Prioritization of these required)
– Interface to Federal FMIS for Authorization
– Split transactions for multi funded projects – Federal Billing interface to RASPS – Integration with Trns.port BidExpress, Preconstruction and SiteManager
– Manage project attributes and data elements
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
57
FHWA Billing FHWA Billing – – Key Decisions Key Decisions
SAP Federal Project
SAP
3rd level WBS elements H 1
Prefix Sequential No.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
58
FHWA Billing FHWA Billing – – Key Decisions Key Decisions
standard functionality will not be capable of capturing this data.
– State project will capture actual costs – Federal project will not collect costs; it will hold requirements such as date limits, ceiling, percentages, and final voucher date – Custom Z table in SAP will capture which State projects can be funded by which Federal projects and in what order
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
59
FHWA Billing FHWA Billing – – Key Decisions Key Decisions
– Triggered by status
– Frequency: Daily – Outbound interface for authorization of FHWA Program Codes (Funding Types) – Inbound interface for Approval Date and Transaction Number – Custom Tables
– Triggered by costs sitting in the Participating WBS – Frequency: Weekly – Outbound interface of billings will create AR document – Inbound interface of payment confirmations – Once payment is received, AR document is cleared – Custom tables will be required to capture amount billed to date by project
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
60
Example Example
(80/10) and H080002 (90/10)
interface will send transaction number and authorization date
participating/participating)
SAP Federal project will calculate how much to bill FHWA (80/20 rules) Validation is required against custom Billed to Date table.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
61
FHWA Billing FHWA Billing – – Changes & Challenges Changes & Challenges
billing information - single source of data
project data
and Indirect Cost billings
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
62
FHWA Billing FHWA Billing – – Open Issues Open Issues
Action Items
in interface vs. going into FMIS to approve
– Need decision from DOTD on which option to go forward with
contractor receives payment. RASPS billing may have to have to look at AP/AR.
– Look at PAYR Table in SAP to look up invoice payments (Closed)
Who has access?
– PS Team to revisit security during Realization
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
63
FHWA Billing FHWA Billing – – Open Issues Open Issues
Parking Lot
for percentages allocated for indirect costs.
– Currently charged from same source. Can indirect and direct charges be tracked/controlled separately?
budget at a higher level.
– Controlling budget at a higher level would lose tracking by improvement type. Decision was made to control budget at phase level.
– Refer to FM team. Validation session 12/15, 12/16
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
64
FHWA Billing FHWA Billing – – Benefits & Improvements Benefits & Improvements
in one central location (PS)
be automated through the use of interfaces in SAP, eliminating redundant processing
the invoicing and payment processing
better tracking of unbilled costs.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
65
FHWA Billing FHWA Billing – – FRICE FRICE-
W
update status to approved.
State of Louisiana (Annual report)
(FAST), expenditures (PMFS), encumbrances (PMFS), etc.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
66
Topic Topic
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
67
Project Planning Project Planning – – Design Considerations Design Considerations
– If planning is not an activity currently performed in the As-Is, could this functionality be of use in the To-Be? – Does this activity bring value to the State? – Is Top-Down or Bottom-Up Planning required for each area? – Is Annual or Overall planning required for each project type?
– Open planning – Top-down – Bottom-up
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
68
Project Planning, DOTD Project Planning, DOTD – – Key Decisions Key Decisions
– Bottom-up planning to be used to enter first “version” (data to be entered by Project Managers & Task Managers with input from Planning Section) – Overall (vs annual) Cost Planning to be used (STIP considerations)
– Open Planning (without hierarchical dependencies) best fit for DOTD; provides greatest flexibility
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
69
Project Planning, FPC Project Planning, FPC – – Key Decisions Key Decisions
– Top-down planning to be used for “regular” projects – Bottom-up planning to be used for statewide projects – Overall (not annual) Cost Planning by project to be used
– Open Planning (without hierarchical dependencies) best fit for FPC; provides greatest flexibility
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
70
Project Planning, OCPR Project Planning, OCPR – – Key Decisions Key Decisions
Networks and activities will be used to capture dates.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
71
Project Planning Project Planning – – Changes & Challenges Changes & Challenges
– Maintenance of cost plan and start and finish dates of WBS elements, milestones and network activities
their projects
– Compare planned, budgeted, and actual expenditures – Cost planning for projects does not impact the project budget
(Planning versions and cost elements)
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
72
Project Planning Project Planning – – Open Issues Open Issues
– Meeting scheduled with Bill Morrison to discuss further (This will be an ongoing effort)
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
73
Project Planning Project Planning – – Benefits & Improvements Benefits & Improvements
costs for future projects
actuals
actual dates of milestones and WBS element dates
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
74
Project Planning Project Planning – – Organizational Impacts Organizational Impacts
reporting capabilities for projects assigned to them (through PM field & Applicant field)
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
75
Project Planning Project Planning – – FRICE FRICE-
W
session
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
76
Topic Topic
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
77
Project Management Project Management -
Design Considerations
– What are your business-critical PS reports? – What decisions do those reports support? – What are their required format/layout/filter/sort? – Does data have to be visible in a report? Or can it remain in text? – Who uses those reports? – What is the frequency that they are generated? – Custom development considerations (Custom reports)
– Networks and activities require extensive work effort – Roles: Who will create network and activities and build the relationships between them? – Use of templates to reduce work effort
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
78
Project Management Project Management – – Key Decisions Key Decisions
– Reporting by Program Manager by Fiscal Year – Letting – Tier Reports (Currently out of FMIS) – 10 year Engineering -> Status Update in ROW – 20 ROW -> Construction Status – 500 Series (statewide reporting requirement) – Task Manager Report (accountability)
– Other reports outside of standard budget/actuals, etc – Key performance indicator Dashboards
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
79
Project Management Project Management – – Key Decisions Key Decisions (contd.) (contd.)
– Real Design Project List – Real Construction Project List – Graphical view of project timelines – Ad hoc reporting for FPC staff – Reports from Excel spreadsheets
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
80
Project Management Project Management – – Key Decisions Key Decisions (contd.) (contd.)
– Status and Schedule Report – Task Due List (sent to PM via Outlook)
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
81
Project Management Project Management – – Key Decisions Key Decisions (contd.) (contd.)
not be captured in SAP
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
82
Project Management Project Management – – Changes & Challenges Changes & Challenges
– Maintenance of cost plan, and start and finish dates of WBS elements, milestones and network activities – Today’s Business Object reports will be replaced by standard SAP reports and BI reports. Users will need to be trained on:
their projects
– Compare planned, budgeted, and actual expenditures – Cost planning for projects does not impact the project budget
cleanup, and closeout
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
83
Project Management Project Management – – Open Issues Open Issues
Action Items- DOTD
– Meet with each area to define reporting requirements
– Obtained list of systems FHWA currently has display access to.
– DOTD will have access to BI. May need to discuss a role to create new BI cubes or relationships between existing BI cubes.
– Sarah Collins to provide reports from LETS
– Ongoing activity throughout realization
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
84
Project Management Project Management – – Open Issues Open Issues
– Follow-up with John Davis
– Will be reviewed during the Validation Session
captures co-op status in SAP
– Requirement to capture specific dates can be met through the use of milestones, but custom user fields preferred.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
85
Project Management Project Management – – Open Issues, OCPR Open Issues, OCPR
1. Check on ability to send reports through MS Outlook 2. DNR Report Status - hot linked from web 3. Email capability from BI to Outlook email 4. OCPR uses templates for network and activities (approx 10). These templates will be re-aligned for new phases. Gather templates for networks and activities. 5. Budget levels need to be reviewed @ Validation Session 6. Gather PTS report samples from OCPR 7. Gather reporting requirements and communicate to BI team
1. “Parent/Children” Projects tracked as individual projects, budgeted at the Parent level 2. Assign Manager @ Overall Project and individual phases. Exception: Design phase has up to 3 Managers.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
86
Project Management Project Management – – Benefits & Improvements Benefits & Improvements
the project and view a roll up at the overall project level
against projects and ensure that expenditures have been accounted for and approved
budget reporting, with drill down capability
ways, instead of creating several different reports (e.g. project master)
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
87
Project Management Project Management – – FRICE FRICE-
W
including comment type, dates, comment so that they can be reported on. (May need to be captured in Z fields)
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
88
Topic Topic
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
89
Capital Projects Periodic Processing Capital Projects Periodic Processing – – Design Considerations Design Considerations
receivers?
settlement to AuC(s)?
determined?
determined that item does not meet asset criteria?
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
90
Capital Projects Periodic Processing Capital Projects Periodic Processing – – Key Decisions Key Decisions
Update to the Settlement Profiles for DOTD and FPC
– Settle 3rd level WBS elements to 2nd level – Settle 2nd level WBS elements to the appropriate Cost Object
– State project: settle 3rd level WBS elements to the appropriate Cost Object – Non-State project: expensed to Cost Center. Do not settle to assets of the State.
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
91
Capital Projects Periodic Processing Capital Projects Periodic Processing – – Flow Chart Flow Chart
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
92
Capital Projects Periodic Processing Capital Projects Periodic Processing– – Changes & Challenges Changes & Challenges 1. Training – extensive training will be required on project settlement and the project close-out procedure, triggers for providing documentation to related parties for creation/update of master records and settlement rules/processing. 2. Extensive training will be required for asset creation and update (sub- numbering by funding source and at AuC & final AMR stages) 3. Project managers (or equivalent) will be responsible for updating project statuses, managing which actions can be performed against the project at any given time 4. Evolving roles and responsibilities for project management, cleanup and closeout 5. Significant organizational impact since agency finance staff needs to be routinely reviewing financial documentation (e.g. settlement rules, AuC and Asset master records). 6. New tasks for management of the integrated settlement process
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
93
Capital Projects Periodic Processing Capital Projects Periodic Processing – – Open Issues Open Issues
Action Items
posting of project costs paid in a subsequent year be handled?
– OSRAP guidance needed
segments that are transferred to DOTD from a local entity, DOTD is responsible for repair and maintenance. How is the asset recorded? Are any costs capitalized?
– OSRAP guidance needed
– PS Team to meet with Denise to design project structure during Realization
software projects that may impact PS
– Follow up with OSRAP
for the life of the asset, does state have ownership? What document denotes
– CWPPRA to follow up
OSRAP by asset category to help define costs to be included in items that will be capitalized (either during purchase or construction). This will assist in coding of costs and developing settlement rules.
– OSRAP guidance needed
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
94
Capital Projects Periodic Processing Capital Projects Periodic Processing – – Open Issues Open Issues
Parking Lot
than creating manually. Potentially a significant workload driver for FPC & DOTD, so may require an enhancement if can’t be accommodated through configuration. (TBD if this is FRICE-W)
– PS Team to investigate further during Realization
– Program code will be captured on the SAP federal project (Closed)
Needs to be in the project in order to bill FHWA.
– Salary costs will be captured against projects. Incoming revenue from FHWA will be posted against appropriate budget. (Closed)
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
95
Capital Projects Periodic Processing Capital Projects Periodic Processing– –Benefits & Benefits & Improvements Improvements
Under Construction (AuC) & the final depreciating assets in Asset Accounting
expenses
favor of true asset accounting
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
96
Capital Projects Periodic Processing Capital Projects Periodic Processing – – FRICE FRICE-
W
session
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
97
Overall Organizational Impact Overall Organizational Impact
business system
the State’s needs
– Allow multiple contracts against a project
processes
– Budget vs. Actual – Purchase Orders by Project – Project Master Data by WBS element
and filter capabilities for reporting on projects
– PS will facilitate the settlement of the State’s assets acquired through construction projects
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
98
12/23/2008
98
Next Steps Next Steps -
General
– Validation sessions are currently being held for all modules – Process Design Documents are being developed – Other related Design Definition documents are being developed
– System Configuration – Follow on meetings to gather detailed requirements (Ex. User Fields and Reports) – Unit and Confirmation Testing – Documenting of Business Process Procedures (BPP’s) – Define and Develop FRICE objects – Integration Testing – User Acceptance Testing
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
99
Visit DOA website for Blueprint Presentations, Meeting Minutes a Visit DOA website for Blueprint Presentations, Meeting Minutes and Project News! nd Project News!
www.doa.louisiana.gov/ERP/index.htm www.doa.louisiana.gov/ERP/index.htm
DOA web DOA web-
site for the ERP project
12/23/2008 Project Systems Validation Session Slide Deck - FINAL
100
Questions? Questions?