IEAI-UTG

Process Narrative
 




Document Preferences 

Table of Contents

   1.0   Overview
1.1   Pre-Sales
1.2   Order Intake
1.3   Project Administration
1.4   Service Delivery
   2.0   Project Administration
2.1   Internal Weekly Reporting
2.2   Customer Invoicing
2.3   Supplier Payments
2.4   Month-close Project Audit
   3.0   Pre-Sales
3.1   Contract Review (QP-002-PCR)
3.2   Lead Qualification
3.3   Customer Negotiation
3.4   Proposal Development
   4.0   Order Intake
4.1   Process Order Intake Ticket
4.2   Update SFS
   5.0   Service Delivery
5.1   under construction...
   6.0   Process Order Intake Ticket
6.1   Ready to make Order Intake Ticket
6.2   Access to Project360?
6.3   Complete Excel spreadsheet OI ticket
6.4   Complete OI ticket in Project360
6.5   Email OI ticket for approval
6.6   Transfer OI ticket to Project360
6.7   Review OI ticket
6.8   OI ticket complete?
6.9   OI Ticket Template (xls)
6.10   Project360
6.11   Rework OI ticket
6.12   Publish OI ticket
6.13   Finished with Order Intake ticket processing
6.14   OI ticket email distribution
6.15   Executed Contract for Services
6.16   OI Ticket (xls)
   7.0   Update SFS
7.1   under construction...
   8.0   Internal Weekly Reporting
8.1   Update PMS
8.2   Review & Complete PMS
8.3   Extract Delivery highlights for Division
8.4   Weekly Delivery Report
8.5   Extract Highlights for Corporate
8.6   Record Account Activity
8.7   Weekly AM Activity Post
8.8   Extract Sales Highlights for Division
8.9   Weekly Sales Report
8.10   PMIS
8.11   Weekly Division Report
8.12   President (IEA-UTG)
8.13   COO
8.14   Director of Sales and Marketing
8.15   AM
8.16   PM
8.17   Weekly Delivery Report Template
8.18   Weekly Delivery Report Template
   9.0   Customer Invoicing
9.1   Customer Recognizes Invoice Trigger
9.2   Generate draft request
9.3   Invoice Request Email
9.4   Generate Draft Invoice
9.5   Review Draft Invoice
9.6   Draft Invoice OK by PM?
9.7   Invoice Correction Request
9.8   AM Review Draft Invoice
9.9   Draft Invoice OK by AM?
9.10   Generate Live Invoice
9.11   Issue soft-copy and supporting docs
9.12   Customer Receives Invoice
9.13   Customer
9.14   Finance
9.15   AM
9.16   PM
9.17   Invoice Request Template
9.18   Draft Invoice
9.19   Invoice Hardcopy
9.20   Customer Backup Email
9.21   Project360
9.22   enter invoice information
9.23   QuickBooks
9.24   PSO
   10.0   Contract Review (QP-002-PCR)
10.1   Entry Criteria
10.2   Verify Scope and DAT
10.3   Verify Price and Cost
10.4   Exec Reveiw - Operations
10.5   Exec Review - Sales
10.6   Exec Review - President
10.7   Exit Criteria
10.8   President (IEA-UTG)
10.9   COO
10.10   Director of Sales and Marketing
10.11   AM
10.12   PM
11.0   Lead Qualification 
12.0   Customer Negotiation 
13.0   Proposal Development 
   14.0   Supplier Payments
14.1   Receive external invoice
14.2   Receive internal invoice
14.3   Review supplier invoices
14.4   Supplier invoice valid?
14.5   Return supplier invoice for correction
14.6   Record supplier invoice as cost in Project360
14.7   Request supplier payment
14.8   Pay supplier
14.9   Supplier Invoice (Internal)
14.10   Supplier Invoice (external)
14.11   Project360
14.12   QuickBooks
14.13   COO
14.14   Administrative Assistant
14.15   PSO
14.16   PM
14.17   Finance
14.18   Supplier (internal)
14.19   Supplier (external)
   15.0   Month-close Project Audit
15.1   Enter
15.2   Receive invoices
15.3   Record billed cost
15.4   Record unbilled cost
15.5   Record other direct cost
15.6   Record customer invoice
15.7   Determine revenue recognition method
15.8   Record earned revenue
15.9   Recalibrate business plan
15.10   Generate Project360 month-close report
15.11   Project360
15.12   Supplier Invoice (Internal)
15.13   Supplier Invoice (external)
15.14   Draft Invoice
15.15   ADP Expense eXpert
15.16   Project360 Report
15.17   Exit


1.0  
Overview Process Narrative

Overview
Overview

1.1   Pre-Sales 

This is the collection of activities leading up to an executed contract or service agreement.  It includes lead qualification, proposal development, customer negotiation and contract review.

Owner

Name Description Type
Director of Sales and Marketing Director of Sales and Marketing Role


1.2   Order Intake 

Order Intake


1.3   Project Administration 

Project Administration


1.4   Service Delivery 

Service Delivery




2.0  
Project Administration Process Narrative

Project Administration
Description Project Administration
Project Administration

2.1   Internal Weekly Reporting 

Internal Weekly Reporting


2.2   Customer Invoicing 

Customer Invoicing


2.3   Supplier Payments 

Document ID
Revision 09a
Last Reviewed
Next Review

Process for handling supplier invoices from receipt of invoice to payment request.

Linked Resources

Name Description Type
PSO Project Support Officer Role

Owner

Name Description Type
COO Cheif Operations Officer Role

Approval List

Name Description Type
COO Cheif Operations Officer Role
Finance Finance Role

Distribution List

Name Description Type
COO Cheif Operations Officer Role
Finance Finance Role
PM Project Manager Role
President (IEA-UTG) President of IEA-UTG Role
PSO Project Support Officer Role


2.4   Month-close Project Audit 

This task group includes activities performed by the COO and PSO to complete project-level audits at month close.

Additional tasks involving Finance to develop the departmental MIS are in the task group called "Month-close MIS"




3.0  
Pre-Sales Process Narrative

Pre-Sales
Description Pre-Sales
Pre-Sales

This is the collection of activities leading up to an executed contract or service agreement.  It includes lead qualification, proposal development, customer negotiation and contract review.

Owner

Name Description Type
Director of Sales and Marketing Director of Sales and Marketing Role


3.1   Contract Review (QP-002-PCR) 

Contract Review Process (reference QMS procedure QP-002-PCR)


3.2   Lead Qualification 

Lead Qualification

Owner

Name Description Type
AM Account Manager Role


3.3   Customer Negotiation 

Customer Negotiation

Owner

Name Description Type
Director of Sales and Marketing Director of Sales and Marketing Role


3.4   Proposal Development 

Proposal Development

Owner

Name Description Type
Director of Sales and Marketing Director of Sales and Marketing Role




4.0  
Order Intake Process Narrative

Order Intake
Description Order Intake
Order Intake

4.1   Process Order Intake Ticket 

Process Order Intake Ticket


4.2   Update SFS 



5.0  
Service Delivery Process Narrative

Service Delivery
Description Service Delivery
Service Delivery

5.1   under construction... 



6.0  
Process Order Intake Ticket Process Narrative

Process Order Intake Ticket
Description Process Order Intake Ticket
Process Order Intake Ticket

6.1   Ready to make Order Intake Ticket 

Requirements

Name Description Type
Executed Contract for Services Contract for services is fully executed. Requirement


6.2   Access to Project360? 

Depending on the conditions in the field, some Account Managers may not have suitable access to Project360.  If access is not available, or connection speed is too slow, an order intake ticket can be developed off-sline using an Excel template.  Otherwise, it is preferable to develop the Order Intake ticket online in Project360.

Incoming Links

Name Description Link Label
Ready to make Order Intake Ticket

Outgoing Links

Name Description Decision
Complete Excel spreadsheet OI ticket Complete Excel spreadsheet OI ticket no
Complete OI ticket in Project360 Complete OI ticket in Project360 yes


6.3   Complete Excel spreadsheet OI ticket 

Access a copy of the Excel template (see hyperlink on Excel icon in the proces map).  Save out a copy of the template, renaming to the project number.  Fill out the yellow fields in the template.  Most fields have comments to describe the intent of the field.  If you have questions about the template, contact the PSO or the COO.

Linked Resources

Name Description Type
OI Ticket Template (xls) [hyperlink]  Order Intake Ticket Template Spreadsheet

Owner

Name Description Type
AM Account Manager Role


6.4   Complete OI ticket in Project360 

Complete OI ticket in Project360

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Owner

Name Description Type
AM Account Manager Role


6.5   Email OI ticket for approval 

Send a copy of the Excel order intake ticket to the PSO with CC to the COO and Director of Sales and Marketing.

Owner

Name Description Type
AM Account Manager Role


6.6   Transfer OI ticket to Project360 

Transfer OI ticket to Project360

Linked Resources

Name Description Type
OI Ticket Template (xls) [hyperlink]  Order Intake Ticket Template Spreadsheet
Project360 Project360 database in SQL server Database

Owner

Name Description Type
PSO Project Support Officer Role


6.7   Review OI ticket 

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Owner

Name Description Type
COO Cheif Operations Officer Role


6.8   OI ticket complete? 

Is the Order Intake ticket complete and representative of the baseline budget and accepted business case?

Owner

Name Description Type
COO Cheif Operations Officer Role

Incoming Links

Name Description Link Label
Review OI ticket

Outgoing Links

Name Description Decision
Publish OI ticket Publish Order Intake ticket
Rework OI ticket Rework Order Intake ticket


6.9   OI Ticket Template (xls) 

Hyperlink

URL / File Path
\\Var01\varfiles\SALES\Order Intake Tickets\Order Intake Ticket 0 ...  

This is an Excel template that can be used to complete an order intake ticket off-line.  

NOTE: If you open this file from a hyperlink, please remember to SAVE AS another file before you edit.

Owner

Name Description Type
PSO Project Support Officer Role


6.10   Project360 

This is the central repository of project financial information residing on the company SQL server.  Applications which make use of the database include the Project360 Project Editor as well as various spreadsheets and reports which can access the information through ODBC linkages stored as DSN data sources.

Owner

Name Description Type
Software Services Delivery Manager Software Services Delivery Manager Role


6.11   Rework OI ticket 

Rework Order Intake ticket

Owner

Name Description Type
PSO Project Support Officer Role


6.12   Publish OI ticket 

Publish Order Intake ticket

Owner

Name Description Type
PSO Project Support Officer Role


6.13   Finished with Order Intake ticket processing 

6.14   OI ticket email distribution 

Order Intake ticket email distribution


6.15   Executed Contract for Services 

This can be a purchase order, service agreement, task order, purchase authorization, etc.  The document must clearly state that the customer is requesting specific goods or services for a defined fee, and the document must have the signature approval of a representative of the customer with sufficient authority to bind the customer to the terms of the contract.

Owner

Name Description Type
COO Cheif Operations Officer Role


6.16   OI Ticket (xls) 

Order Intake ticket (xls)




7.0  
Update SFS Process Narrative

Update SFS
Update SFS

7.1   under construction... 



8.0  
Internal Weekly Reporting Process Narrative

Internal Weekly Reporting
Description Internal Weekly Reporting
Internal Weekly Reporting

8.1   Update PMS 

Do Weekly, no later than Monday 9:00 AM Eastern Time

Under Home | Project Risk Review...

1) Select project to update

2) Date is auto-populated

3) Availability of PO/WO for IEA-UTG will always be "Yes" unless we are working at risk in advance of a contract execution.

4) Work flow - pick from list.

5) Delivery - pick from list.

6) Quality - pick from list. Note that if the project has an institutionalized review cycle with no option for first-time-acceptance, then the first round should be counted as business as usual, so select "No issues." Select "RW required" only after the first opportunity for acceptance.

7) Customer Acceptance - pick from list.

8) Quality of Communications - pick from list (in your judgment).

9) Meeting Projections - enter 100% unless you have missed milestones in the last review period.

10) COQ - This is the Cost of Quality. Enter 10% for projects running normally.

11) COPQ - This is the Cost of Poor Quality. Enter 0% if you have no avoidable rework; otherwise, estimate impact of rework.

12) Eff - This is production efficiency, not normally measured in IEA-UTG projects. Enter 100% unless you need to draw attention to a known problem.

13) This can be read from the "Margin" project property in the Project360 editor. For most IEA-UTG projects, it is 20%.

14) Payment Issues - pick from list

15) Manpower - Enter IEA-UTG headcount involved on the project.

16) Color Code - this is auto-populated based on responses to questions 3-14.

17) Score - this is auto-populated based on responses to questions 3-14.

18) Risk Rating - this is auto-populated based on responses to questions 3-14

19) Reasons - this is a general purpose comment field, primarily for you to explain why the project is at the risk level it is calculated to be. This field must have some comment for projects in Yellow or Red condition.

20) Action Taken - this is a second general-purpose comment field to log notable activity for the past period. Try to always have at least a brief sentence here to characterize how the project is running.

Owner

Name Description Type
PM Project Manager Role


8.2   Review & Complete PMS 

Do Weekly, no later than 5:00 PM Monday

Under Home | Consolidated report

1) Check to see if all active projects have a log for the past week.  If not, call the PM or supply a risk evaluation from what can be known from other correspondance.

2) Review entries made by PMs.  Take note of escalation items.  Edit language if necessary for project archives.

3) Add executive comments as necessary.

Owner

Name Description Type
COO Cheif Operations Officer Role


8.3   Extract Delivery highlights for Division 

Do Weekly, no later than 5:00 PM Monday.

1) Initialize a Weekly Delivery Report from the Word Template for IEA-UTG Delivery

2) Copy selected logs from PMS into the report; sort alphabetically by common project name.

3) Add overall summary and attachments as necessary.

4) Distiribute to President of IEA-UTG, with CC to the Director of Sales and Marketing as an email attachment.


8.4   Weekly Delivery Report 

This is the Weekly Delivery Report email from the COO to the President.

Subject line should read "IEA-UTG Weekly Delivery Report for Week Ending yyyy-mm-dd"

For PDA convenience, the text of the report should also appear in the email message.

Owner

Name Description Type
COO Cheif Operations Officer Role


8.5   Extract Highlights for Corporate 

Extract Highlights for Corporate

Owner

Name Description Type
President (IEA-UTG) President of IEA-UTG Role


8.6   Record Account Activity 

Do Weekly no later than 9:00 AM Monday

Record a brief note of account activity for the previous week.

Owner

Name Description Type
AM Account Manager Role


8.7   Weekly AM Activity Post 

This is the weekly post of activity from each Account Manager.

Owner

Name Description Type
AM Account Manager Role


8.8   Extract Sales Highlights for Division 

Do Weekly, no later than 5:00 PM Monday.

1) Initialize a Weekly Delivery Report from the Word Template for IEA-UTG Delivery

2) Copy selected logs from AM posts into the report; sort alphabetically by common project name.

3) Add overall summary and attachments as necessary.

4) Distiribute to President of IEA-UTG, with CC to the COO.

Owner

Name Description Type
Director of Sales and Marketing Director of Sales and Marketing Role


8.9   Weekly Sales Report 

This is the Weekly Sales Report email from the Director of Sales & Marketing to the President.

Subject line should read "IEA-UTG Weekly Sales Report for Week Ending yyyy-mm-dd"

For PDA convenience, the text of the report should also appear in the email message.

Owner

Name Description Type
Director of Sales and Marketing Director of Sales and Marketing Role


8.10   PMIS 

Hyperlink

URL / File Path
http://203.200.218.51/pmis/  

This is the web-based repository of project monitoring information.  It contans summary tracking information as well as project risk assessment logs which should be completed on a weekly basis.  Note that the PM assignment of any project is based on the ID of the person creating the project record.  Once the project record is created, it can be edited by anyone with a defined role for the project.  Note also that many of the financial tracking fields are auto-populated from systems working for projects in India, but are not functional for projects edited in the US.

Owner

Name Description Type
Systems & Network Administrator Systems & Network Administrator Role


8.11   Weekly Division Report 

Weekly Division Report

Owner

Name Description Type
President (IEA-UTG) President of IEA-UTG Role


8.12   President (IEA-UTG) 

RESPONSIBILITIES

a. To provide leadership & strategic direction to IEA-UTG.

b. Formulate and execute strategies that will to strengthen the market position of IEA-UTG & Infotech.

c. Responsible for the Profit & Loss Statement (P&L) for IEA-UTG.

d. Define Responsibilities, Authorities of Personnel of IEA-UTG and assign KRA’s for them from time to time.

e. Determine the Customer requirements and ensure they are being met with the aim of enhancing customer satisfaction.

f. Ensure availability of resources to meet the organizational objectives.

g. To review the training needs of local IEA-UTG employees and approve the requisite training activities

h. Achieve KRA’s set from time to time.

Assigned Personnel

Name Description Type
Administrative Assistant Administrative Assistant Role
COO Cheif Operations Officer Role
Director of Sales and Marketing Director of Sales and Marketing Role


8.13   COO 

Cheif Operations Officer

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Assigned Personnel

Name Description Type
Director of Technical Services Director of Technical Services Role
PM Project Manager Role
Production Manager Production Manager Role
PSO Project Support Officer Role
Software Services Delivery Manager Software Services Delivery Manager Role


8.14   Director of Sales and Marketing 

Director of Sales and Marketing

Assigned Personnel

Name Description Type
AM Account Manager Role
Proposal Coordinator Proposal Coordinator Role


8.15   AM 

Account Manager


8.16   PM 

Project Manager


8.17   Weekly Delivery Report Template 

Hyperlink

URL / File Path
\\Var01\data05\Support\templates\IEA-UTG Weekly Delivery Rep ...  

This is a simple template used to standardize look and feel for weekly reports to the Division President so they are consistent with other reports.

Owner

Name Description Type
COO Cheif Operations Officer Role


8.18   Weekly Delivery Report Template 

Hyperlink

URL / File Path
\\Var01\data05\Support\templates\IEA-UTG Weekly Delivery Rep ...  

This is a simple template used to standardize look and feel for weekly reports to the Division President so they are consistent with other reports.

Owner

Name Description Type
COO Cheif Operations Officer Role




9.0  
Customer Invoicing Process Narrative

Customer Invoicing
Description Customer Invoicing
Customer Invoicing

9.1   Customer Recognizes Invoice Trigger 

Customer Recognizes Invoice Trigger


9.2   Generate draft request 

Once the PM has confirmed that the Customer agrees that an invoicing trigger has been met, the PM will draft an invoice request following the form of the IEA-UTG Invoice Request template.  The template ensures that the following information is present on every invoice request:

1) Project Name

2) Project Number (IEA)

3) Project Reference (Customer's PO for example)

4) Invoice Date

5) Task Detail

6) Previous Invoice Value (if any)

7) Current Invoice Value

8) Notes (optional)

9) Billing Address

The Task Detail section will be expressed in a way that allows the invoice to show a unit count, a price per unit and an extend amount (unit count * unit price).

Linked Resources

Name Description Type
Invoice Request Template [hyperlink]  Invoice Request Template Spreadsheet

Owner

Name Description Type
PM Project Manager Role

Performed By

Name Description Type
PM Project Manager Role


9.3   Invoice Request Email 

The invoice request email will have a subject line in this format:

Invoice Ready to Go: [job number] - [project name] - [optional invoice trigger description]

For example:

Invoice Ready to Go: B709201 - Cox Communications SOW1 - April Deliveries

The message field of the invoice request email will be a copy/paste of the information developed using the IEA-UTG Invoice Request Template spreadsheet.

Distribute to Finance and Admin, with a CC to the project's AM and the COO.  Also include the President and the Director of Sales and Marketing if the invoice amount exceeds $100k.

Owner

Name Description Type
PM Project Manager Role


9.4   Generate Draft Invoice 

Using the information in the Invoice Request Email, develop a draft invoice and save out to a pdf file.

Linked Resources

Name Description Type
Draft Invoice Draft Invoice PDF
QuickBooks QuickBooks Database

Owner

Name Description Type
Finance Finance Role

Performed By

Name Description Type
Finance Finance Role


9.5   Review Draft Invoice 

Compare the invformation in the Invoice Request Email to ensure that it is correctly reflected in the Draft Invoice.  Pay particular attention to see that the representation of tasks, units, unit pricing and current amount will be understood by the customer in the context of services delivered.  Also take note of the invoice date and payment terms to ensure that these follow the terms of our contractual agreement with the customer.

Linked Resources

Name Description Type
Draft Invoice Draft Invoice PDF

Owner

Name Description Type
PM Project Manager Role

Performed By

Name Description Type
PM Project Manager Role


9.6   Draft Invoice OK by PM? 

If the Draft Invoice passes inspection, then forward the Draft Invoice to the AM for additional review and approval.

If not, then issue a corrections request email to finance.

Linked Resources

Name Description Type
Draft Invoice Draft Invoice PDF

Owner

Name Description Type
PM Project Manager Role

Incoming Links

Name Description Link Label
Review Draft Invoice Review Draft Invoice

Outgoing Links

Name Description Decision
AM Review Draft Invoice AM Revuew Draft Unvoice yes
Invoice Correction Request Invoice Correction Request no


9.7   Invoice Correction Request 

This is a brief email describing changes required to the Draft Invoice.

Linked Resources

Name Description Type
Draft Invoice Draft Invoice PDF

Owner

Name Description Type
AM Account Manager Role
PM Project Manager Role


9.8   AM Review Draft Invoice 

The AM performs a cursory review of the invoice to insure that it is consistant with customer accounts and commercial terms in force at the time of issue.

Linked Resources

Name Description Type
Draft Invoice Draft Invoice PDF

Owner

Name Description Type
AM Account Manager Role

Performed By

Name Description Type
AM Account Manager Role


9.9   Draft Invoice OK by AM? 

If the Draft Invoice passes inspection, then send a confirmation notice to Finance with a CC to the PM.

If not, issue an Invoice Corrections Request.

Linked Resources

Name Description Type
Draft Invoice Draft Invoice PDF

Owner

Name Description Type
AM Account Manager Role

Incoming Links

Name Description Link Label
AM Review Draft Invoice AM Revuew Draft Unvoice

Outgoing Links

Name Description Decision
Invoice Correction Request Invoice Correction Request no
Generate Live Invoice Generate LIve Invoice yes


9.10   Generate Live Invoice 

Assuming the Draft Invoice is already registered in QuickBooks, change the status of the Invoice to reflect that it is actually being raised to the customer.  Print out a hardcopy (if required) and mail to the Billing Address.  Include hard-copy backup information, if provided by the PM in the original Invoice Request.  Notify the PM and AM that the invoice was actually released.

Linked Resources

Name Description Type
Invoice Hardcopy Invoice Hardcopy Mailer

Owner

Name Description Type
Finance Finance Role

Performed By

Name Description Type
Finance Finance Role


9.11   Issue soft-copy and supporting docs 

Once the PM recieves confirmation from Finance that an Live Invoice was actually issued to the customer, he/she follows up with a soft-copy invoice and supporting documentation as may be required by the customer.

Owner

Name Description Type
PM Project Manager Role

Performed By

Name Description Type
PM Project Manager Role


9.12   Customer Receives Invoice 

This process ends when the customer receives the invoice and supporting documentation.  For a logical continuation of this process, see Account Receivable Processing.

Linked Resources

Name Description Type
Customer Backup Email Customer Backup Email Email
Invoice Hardcopy Invoice Hardcopy Mailer

Owner

Name Description Type
Customer Customer Role


9.13   Customer 

Customer


9.14   Finance 

Finance

Linked Resources

Name Description Type
QuickBooks QuickBooks Database


9.15   AM 

Account Manager


9.16   PM 

Project Manager


9.17   Invoice Request Template 

Hyperlink

URL / File Path
\\Var01\data05\Support\templates\IEA-UTG Customer Invoice Re ...  

Invoice Request Template


9.18   Draft Invoice 

This is a draft of the invoice before it is sent to the customer.

Owner

Name Description Type
Finance Finance Role


9.19   Invoice Hardcopy 

Invoice Hardcopy


9.20   Customer Backup Email 

This is an email package of the soft-copy invoice and supporting documentation prepared for the customer by the PM.  Supporting documentation typically includes a PDF of the Live Invoice and a spreadsheet with progress unit details.

Owner

Name Description Type
PM Project Manager Role


9.21   Project360 

This is the central repository of project financial information residing on the company SQL server.  Applications which make use of the database include the Project360 Project Editor as well as various spreadsheets and reports which can access the information through ODBC linkages stored as DSN data sources.

Owner

Name Description Type
Software Services Delivery Manager Software Services Delivery Manager Role


9.22   enter invoice information 

Enter invoice information into Project360 as a cost record in the month for which the invoice is dated.

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Owner

Name Description Type
PSO Project Support Officer Role

Performed By

Name Description Type
COO Cheif Operations Officer Role
PSO Project Support Officer Role


9.23   QuickBooks 

QuickBooks


9.24   PSO 

Project Support Officer




10.0  
Contract Review (QP-002-PCR) Process Narrative

Contract Review (QP-002-PCR)
Description Contract Review Process (reference QMS procedure QP-002-PCR)
Contract Review (QP-002-PCR)

10.1   Entry Criteria 

Entry Criteria


10.2   Verify Scope and DAT 

Verify that the scope of work is clearly defined in the contract and that it corresponds with all the assumptions used for the last iteration of proposals to the customer and that the schedule of services is achievable.  Also verify that a data acceptance testing strategy is included in the contract which is executable and provides reasonable assurance that first-time acceptance of product is achievable.  Any exceptions or variations need to be escalated to the COO.

Owner

Name Description Type
PM Project Manager Role


10.3   Verify Price and Cost 

Verify that the price schedule in the contract corresponds with the last iteration of the proposal to the customer.  Double check all mathematical functions used in pricing model.  Verify that all pricing assumptions are clearly linked to the pricing page.  Verify that the costs for internal transfer prices are supported by written estimates from the production team.  Verify that any costs for external suppliers are supported by written offers from respective suppliers.  Assemble cost and price summary information by month for executive review of business case.  Any exceptions or variations need to be escalated to the Director of Sales and Marketing.

Owner

Name Description Type
AM Account Manager Role


10.4   Exec Reveiw - Operations 

Executive Review - Operations

Owner

Name Description Type
COO Cheif Operations Officer Role


10.5   Exec Review - Sales 

Executive Review - Sales

Owner

Name Description Type
Director of Sales and Marketing Director of Sales and Marketing Role


10.6   Exec Review - President 

Executive Review - President

Owner

Name Description Type
President (IEA-UTG) President of IEA-UTG Role


10.7   Exit Criteria 

Exit Criteria


10.8   President (IEA-UTG) 

RESPONSIBILITIES

a. To provide leadership & strategic direction to IEA-UTG.

b. Formulate and execute strategies that will to strengthen the market position of IEA-UTG & Infotech.

c. Responsible for the Profit & Loss Statement (P&L) for IEA-UTG.

d. Define Responsibilities, Authorities of Personnel of IEA-UTG and assign KRA’s for them from time to time.

e. Determine the Customer requirements and ensure they are being met with the aim of enhancing customer satisfaction.

f. Ensure availability of resources to meet the organizational objectives.

g. To review the training needs of local IEA-UTG employees and approve the requisite training activities

h. Achieve KRA’s set from time to time.

Assigned Personnel

Name Description Type
Administrative Assistant Administrative Assistant Role
COO Cheif Operations Officer Role
Director of Sales and Marketing Director of Sales and Marketing Role


10.9   COO 

Cheif Operations Officer

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Assigned Personnel

Name Description Type
Director of Technical Services Director of Technical Services Role
PM Project Manager Role
Production Manager Production Manager Role
PSO Project Support Officer Role
Software Services Delivery Manager Software Services Delivery Manager Role


10.10   Director of Sales and Marketing 

Director of Sales and Marketing

Assigned Personnel

Name Description Type
AM Account Manager Role
Proposal Coordinator Proposal Coordinator Role


10.11   AM 

Account Manager


10.12   PM 

Project Manager




11.0  
Lead Qualification Process Narrative

Lead Qualification
Description Lead Qualification
Lead Qualification

Owner

Name Description Type
AM Account Manager Role




12.0  
Customer Negotiation Process Narrative

Customer Negotiation
Description Customer Negotiation
Customer Negotiation

Owner

Name Description Type
Director of Sales and Marketing Director of Sales and Marketing Role




13.0  
Proposal Development Process Narrative

Proposal Development
Description Proposal Development
Proposal Development

Owner

Name Description Type
Director of Sales and Marketing Director of Sales and Marketing Role




14.0  
Supplier Payments Process Narrative

Supplier Payments
Description Process for handling supplier invoices from receipt of invoice to payment request.
Supplier Payments

Owner

Name Description Type
COO Cheif Operations Officer Role

Linked Resources

Name Description Type
PSO Project Support Officer Role

Approval List

Name Description Type
COO Cheif Operations Officer Role
Finance Finance Role

Distribution List

Name Description Type
COO Cheif Operations Officer Role
Finance Finance Role
PM Project Manager Role
President (IEA-UTG) President of IEA-UTG Role
PSO Project Support Officer Role


14.1   Receive external invoice 

External invoices may come by mail, fax or email, and may be addressed to any number of people within the organization.  Contract terms should be normalizing the invoice addressee to a limited number of possible recipients (COO, for example), but some suppliers may be sending invoices directly to the PM or may be using obsolete contact information.  The main function of receiving an external invoice is to normalize all possible channels into a single workflow, which is based currently on a paper trail.  This means that invoices received by email should be printed out.  Paper invoices are then stamped with a standardized review template which identifies the date of receipt and the routing for approval.  The administrative assistant also logs the receipt of the invoice into the financial accounting system (Quickbooks) so that the invoice is not lost in transit.

Linked Resources

Name Description Type
Finance Finance Role
QuickBooks QuickBooks Database

Owner

Name Description Type
Administrative Assistant Administrative Assistant Role

Performed By

Name Description Type
Administrative Assistant Administrative Assistant Role


14.2   Receive internal invoice 

Internal invoices are generally distributed at month end via email from the supplying entity in the form of a multi-page pdf file and an Excel spreadsheet summarizing the monthly activity.  Internal invoices should be logged directly to Quickbooks and AP such that, in the absence of any contrary notices from operations, the invoices will be paid according to the terms negotiated for internal payments.  No further action is required from operations to pay the invoice.

Linked Resources

Name Description Type
QuickBooks QuickBooks Database

Owner

Name Description Type
Finance Finance Role

Performed By

Name Description Type
Finance Finance Role


14.3   Review supplier invoices 

Supplier invoices shall be validated in the following respects.

1) ADMINISTRATIVE CHECKS -- Is the invoice properly administered?

   a) The first check is to see if the invoice is issued in compliance with the contract terms. Since contract terms will vary, the reviewer must consult the supplier contract. Invoicing terms may also be summarized in the task order properties viewable in Project360. Take care to note the difference between invoicing terms and payment terms. Task orders should specify both.

   b) Common examples of administrative errors include the following.

      i) Invoice issued not at the correct time interval (weekly invoice instead of monthly, for example).

      ii) Invoice issued on the wrong event trigger (invoice on delivery instead of acceptance, for example).

      iii) Invoice expressed with the wrong units (invoice for square miles instead of tiles, for example).

      iv) Invoice referencing the wrong project number.

   c) Remember that what may be right for one supplier may not be right for another. The guiding document is the supplier’s task order.

   d) Minor irregularities, if they can be remedied, may be waived by the invoice reviewer. Examples of minor irregularities may include the following.

      i) Invoice addressed to the wrong person within the correct company.

      ii) Spelling errors.

   e) If the invoice does not pass the first check, then stop the invoice review and return to the supplier for correction. Otherwise, proceed to step 2).

2) QUANTIFICATION CHECKS -- Is the invoice properly quantified?

   a) The second check is to see if the invoice is issued for the right amount. Since contract terms will vary, the review must consult the supplier contract to understand the correct amount. A task order value schedule may also be consulted in the Project360 database.

   b) ACCUMULATIONS -- Take care with the handling of accumulated reporting in an invoice. A supplier may issue a fresh invoice for each service as a separate trail, or may list the accumulated progress with deductions for “previously invoiced amounts.” Both approaches can be valid. It is up to the reviewer to keep track of “previously invoiced amounts” to ensure accumulated tracking is accurate in the invoice. An invoice should not be approved if it repeats a value already invoiced. If a supplier wants to remind the company of an amount already due, such a reminder should be expressed as a “Billing Statement” not a repeated invoice.

   c) ACCEPTANCE TRIGGERS -- Take care to note whether the invoice amount is valid with regard to the status of product delivered or accepted. Some contract terms are very specific about what constitutes acceptance of product. In some cases, the definition of acceptance is determined by a third party or the end customer.

   d) CASH FLOW TRIGGERS – Take care to note whether the invoice amount is valid with regard to possible cash-flow triggers. Some contract terms specify that a supplier may invoice upon notification of payment received from our customer, for example.

   e) PROJECT BUDGET – The reviewer should consult the project budget in Project360 to verify that this supplier expense was anticipated in the project plan. The total accumulated invoicing from the supplier should not exceed the budgeted amount for that supplier for that project.

   f) EXEMPTIONS FOR INTERNAL INVOICES – Internal invoices may be received and validated for work in progress, even if the internal purchase order does not explicitly grant this option. For work-in-progress invoices, all aspects of the quantification check still need to be verified. The only exemption is with regard to the possible delivery/acceptance triggers.

   g) If the invoice does not pass the second check, then stop the invoice review and return to the supplier for correction.

3) PAYABLE STATUS -- Is the invoice payable?

   a) The third check is to validate whether the invoice is payable now or later. If later, then when? Since contract terms will vary, the reviewer must consult the supplier contract to understand payment terms. Note that payment terms are different from invoicing terms. Payment terms may also be captured in the task order properties in the Project360 database.

   b) Be sure to document on the hard-copy invoice (for external invoices) the date when the invoice is payable. If it is payable now, write today’s date.

   c) EXEMPTIONS FOR INTERNAL INVOICES -- For internal invoices, this consideration is irrelevant, since intercompany payments will be dictated by more general negotiations.

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Owner

Name Description Type
COO Cheif Operations Officer Role

Performed By

Name Description Type
PM Project Manager Role
PSO Project Support Officer Role


14.4   Supplier invoice valid? 

Is the supplier invoice validated by operations?

Incoming Links

Name Description Link Label
Review supplier invoices All supplier invoices need to be validated by operations before logging into Project360

Outgoing Links

Name Description Decision
Return supplier invoice for correction Return the supplier invoice for correction No
Record supplier invoice as cost in Project360 Record the invoice cost in Project360 Yes


14.5   Return supplier invoice for correction 

For external invoices, return the supplier invoice for correction and notify the Administrative Assistant that the invoice is invalid.

For internal invoices, notify the issuing manager directly of the invoicing defect, then notify Finance that payment of the invoice is suspended until the defect can be resolved.


14.6   Record supplier invoice as cost in Project360 

Enter the supplier invoice information into Project360 as a cost record for the month in which the valid invoice is received. Multiple invoices should be recorded as multiple records.  If the cost for the invoice was previously accrued, enter the cost as a new invoice record plus a negative accrual as a separate record in the same month for a net-0 recognition.  The Project360 cost record contains a memo field which can carry invoice detail as needed. Record at a minimum, the invoice number and some description of the scope of services the invoice is for.

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Owner

Name Description Type
COO Cheif Operations Officer Role

Performed By

Name Description Type
COO Cheif Operations Officer Role
PM Project Manager Role
PSO Project Support Officer Role


14.7   Request supplier payment 

In addition to completing the payment approval stamp (on external invoice hardcopy) send email notice to Finance to pay supplier.  If there are special payment terms that require expeditied processing, include this information in the payment request.  Do not forward the internal payment request to the supplier.  The supplier may be notified that an invoice has been approved for payment, but should not participate in internal correspondence for payment requests.

Owner

Name Description Type
COO Cheif Operations Officer Role

Performed By

Name Description Type
COO Cheif Operations Officer Role
PM Project Manager Role
PSO Project Support Officer Role


14.8   Pay supplier 

Pay supplier

Linked Resources

Name Description Type
QuickBooks QuickBooks Database

Owner

Name Description Type
Finance Finance Role

Performed By

Name Description Type
Finance Finance Role


14.9   Supplier Invoice (Internal) 

IEL invoices


14.10   Supplier Invoice (external) 

Format and medium will vary.  Frequency and payment terms will vary.


14.11   Project360 

This is the central repository of project financial information residing on the company SQL server.  Applications which make use of the database include the Project360 Project Editor as well as various spreadsheets and reports which can access the information through ODBC linkages stored as DSN data sources.

Owner

Name Description Type
Software Services Delivery Manager Software Services Delivery Manager Role


14.12   QuickBooks 

QuickBooks


14.13   COO 

Cheif Operations Officer

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Assigned Personnel

Name Description Type
Director of Technical Services Director of Technical Services Role
PM Project Manager Role
Production Manager Production Manager Role
PSO Project Support Officer Role
Software Services Delivery Manager Software Services Delivery Manager Role


14.14   Administrative Assistant 

Administrative Assistant


14.15   PSO 

Project Support Officer


14.16   PM 

Project Manager


14.17   Finance 

Finance

Linked Resources

Name Description Type
QuickBooks QuickBooks Database


14.18   Supplier (internal) 

Supplier of goods or services from within the corporate family


14.19   Supplier (external) 

Supplier of goods or services, not part of the coporate family




15.0  
Month-close Project Audit Process Narrative

Month-close Project Audit
Description Activities to conclude the financial month close from a project audit perspective
Month-close Project Audit

This task group includes activities performed by the COO and PSO to complete project-level audits at month close.

Additional tasks involving Finance to develop the departmental MIS are in the task group called "Month-close MIS"


15.1   Enter 

Constraints include the availability of supplier invoices and customer billings.


15.2   Receive invoices 

IEL invoices generally arrive by the last day of the month, with occasional stragglers coming in the first day of the following month.  Stragglers generally are delayed for T&M work involving timesheets that cannot be completed and reviewed before the end of the month.  External invoices will have been processed throughout the month according to process map "Supplier Payments."  Copies of external supplier invoices are collected in a network drive for ready reference by COO and PSO.

Linked Resources

Name Description Type
Supplier Invoice (external) Invoice from an external supplier Document
Supplier Invoice (Internal) Invoice from internal supplier, generally provided as pdf file at month end. PDF

Owner

Name Description Type
COO Cheif Operations Officer Role

Performed By

Name Description Type
COO Cheif Operations Officer Role
PSO Project Support Officer Role


15.3   Record billed cost 

Create one record for each invoice.

As credible evidence that a real bill was received, copy the critical information from the invoice into the comment field of the Project360 cost record.  This should include the invoice number, the invoice date, and the value schedule for the invoice.

Review recent history of cost records to ensure value is not already covered by unbilled cost entries.  If so, add a record for the invoice in hand, and a separate record to wash out previous unbilled amount (negative unbilled expense).

Set the Project360 cost record status to "sure thing".

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Owner

Name Description Type
COO Cheif Operations Officer Role

Performed By

Name Description Type
COO Cheif Operations Officer Role
PSO Project Support Officer Role


15.4   Record unbilled cost 

For external suppliers, recognized progress must be based on some supporting evidence, such as delivered work product.  It is generally not sufficient to use a progress report only to recognize cost of revenue.

For internal supplier (IEL) any record of progress may be used to recognize cost of revenue, with or without an invoice, provided the following rule is not violated:

IEA cannot recognize WIP revenue based on IEL work without an invoice from IEL.

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Owner

Name Description Type
COO Cheif Operations Officer Role

Performed By

Name Description Type
COO Cheif Operations Officer Role
PSO Project Support Officer Role


15.5   Record other direct cost 

This includes expense reports from staff making business trips in support of project operations.

Do not include expenses related to sales and marketing.

Create one record for each expense type.

Record expense type and set the cost record status to "sure thing".

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Owner

Name Description Type
COO Cheif Operations Officer Role

Performed By

Name Description Type
COO Cheif Operations Officer Role
PSO Project Support Officer Role


15.6   Record customer invoice 

Use the pdf draft invoice from the email chain, after confirming that the PM and AM have approved the draft.  

Create one record for each invoice.

As credible evidence that a real invoice was issued, copy the critical information from the invoice into the comment field of the Project360 invoice record.  This should include the invoice number, the invoice date, and the value schedule for the invoice.

Set the Project360 invoice record status to "sure thing"

Linked Resources

Name Description Type
Draft Invoice Draft Invoice PDF
Project360 Project360 database in SQL server Database

Owner

Name Description Type
COO Cheif Operations Officer Role

Performed By

Name Description Type
COO Cheif Operations Officer Role
PSO Project Support Officer Role


15.7   Determine revenue recognition method 

Revenue recognition methods may be any of the following.

1) REVENUE=INVOICE - more precisely, accumulated revenue = accumulated invoice.

2) REVENUE in propotion to COR - using Cost of Revenue (COR) to determine percent complete, and recognizing that percent of total project revenue.

For simplicity, method 1) is prefered, except where significant investiment causes a delay between COR and invoicing.  In those cases, method 2) may be used.  Mode may shift from method 2) to method 1) at any time, and is advisable whenever a project exceeds 90% completion. Mode should not shift from method 1) to method 2).  T&M projects and projects with uncertain total scope should always be in mode 1).

In general, mode should be the same as in previous month unless there is a complelling reason to change.

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Owner

Name Description Type
COO Cheif Operations Officer Role

Performed By

Name Description Type
COO Cheif Operations Officer Role
PSO Project Support Officer Role


15.8   Record earned revenue 

Record earned revenue value and calculation notes in Project360

METHOD 1) ACCUMULATED REVENUE = ACCUMULATED INVOICE

a = sum of customer invoicing through the current month.

b = sum of earned revenue through the previous month.

c = 1 - b = earned revenue for the current month.

METHOD 2) REVENUE proportional to COR

a = sum of costs through the current month

b = total budget cost for the lifetime of the project

c = a / b = percent complete based on COR

d = total project value

e = c * d = accumulated earned revenue

f = sum of earned revenue through previous month

g = e - f = earned revenue for current month

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Owner

Name Description Type
COO Cheif Operations Officer Role

Performed By

Name Description Type
COO Cheif Operations Officer Role
PSO Project Support Officer Role


15.9   Recalibrate business plan 

Minor adjustments to future months of the business plan are common in the normal recording of monthly financials.

Major shifts in the business plan (extending schedule or chainging total project value or budget cost) need to be reviewed with the cognizant PM and AM.

Also record appropriate metadata, including project review records.

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Owner

Name Description Type
COO Cheif Operations Officer Role

Performed By

Name Description Type
COO Cheif Operations Officer Role
PSO Project Support Officer Role


15.10   Generate Project360 month-close report 

1) Change filename and cover-tab metadata to reflect today's date.

2) Change formatting of Summary tab to highlight current month and label current month's revenue on the graph.

3) Change tab name and header name for the tab that has the current month's accum values.

4) Copy paste data from the following Project360 queries in the Reports tab:

   Project List

   Snapshot Accum

   Revenue xtab

   Cost xtab

   IEA Value xtab

   Billing xtab

   ENB xtab

   Reviews

5) Send to President and Finance for review.

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database


15.11   Project360 

This is the central repository of project financial information residing on the company SQL server.  Applications which make use of the database include the Project360 Project Editor as well as various spreadsheets and reports which can access the information through ODBC linkages stored as DSN data sources.

Owner

Name Description Type
Software Services Delivery Manager Software Services Delivery Manager Role


15.12   Supplier Invoice (Internal) 

IEL invoices


15.13   Supplier Invoice (external) 

Format and medium will vary.  Frequency and payment terms will vary.


15.14   Draft Invoice 

This is a draft of the invoice before it is sent to the customer.

Owner

Name Description Type
Finance Finance Role


15.15   ADP Expense eXpert 

Hyperlink

URL / File Path
https://myprod.concureworkplace.com/ewp/Logon.asp?type=BB  

on-line expense report in ADP


15.16   Project360 Report 

Excel Spreadsheet with project-level detail of Revenue, Cost, IEA Value, Billing and ENB.

Linked Resources

Name Description Type
Project360 Project360 database in SQL server Database

Owner

Name Description Type
COO Cheif Operations Officer Role


15.17   Exit 

Continue to Month-close MIS