Project Partners Blog


Posts Tagged ‘Oracle project costing’

 

MANAGING PERFORMANCE BASED REVENUE RECOGNITION

Accounting Standards Codification (ASC) 606

-CURRENT UPDATES-

This paper provides an update to one of our previous six-part blog series “Are you Ready for the New Revenue Recognition Standards?”

It outlined the May 28, 2014 announcement that the FASB and IASB jointly issued ASC 606, Revenue from Contracts with Customers.  The intention around this change was to standardize revenue recognition practices across industries as existing practices fall short when it comes down to how value is delivered to the client based on obligations explicitly or implicitly specified in contracts.

IN THIS LATEST SERIES, WE WILL RECAP AND HIGHLIGHT THE MOST CURRENT CHANGES SINCE THE DEADLINES FOR COMPLIANCE HAS PASSED.

On May 28, 2014, FASB and IASB jointly issued ASC 606, Revenue from Contracts with Customers.  Due to inconsistencies in revenue recognition among industries, and the disconnect between U. S. GAAP and IFRS reporting, the Boards collaborated to reduce or eliminate those inconsistencies and thereby improve comparability between domestic and international best practices.  The resulting standards will therefore significantly affect the revenue recognition practices of many companies.

Depending upon the business’ current model and revenue recognition practices, this standard could have a significant impact on the amount and timing of revenue recognition, which in turn will impact key performance measures and debt covenant ratios, and may even change the way the company looks at capital investment and compensation.  The new standards are poised to change budgets, contract negotiations and current business practices.

Industry-Neutral Revenue Recognition

The core principle in the converged standard requires that an entity recognize revenue to depict the transfer of promised goods or services to a customer in an amount that reflects the consideration in exchange for those goods and services.  To accomplish this goal, a five-step process has been outlined in the new standard.  Every contract with a customer should be analyzed using these five steps to afford accurate reporting.

Step 1 – Identify the Contract with the Customer – A contract is defined as an agreement between two or more parties that creates enforceable rights and obligations.  The guidance applies to all contracts that meet specific criteria as defined within the standard.

Step 2 – Identify the Performance Obligations in the Contract – Performance obligations are promises to deliver certain goods and services to a customer.

Step 3 – Determine the Transaction Price – The transaction price is the amount an entity is expected to receive in exchange for transferring goods and services to a customer.

Step 4 – Allocate the Transaction Price – The relative standalone transaction price of each good or service being transferred to a customer, including discounts and other variable amounts of consideration.

Step 5 – Recognize Revenue as Performance Obligations are Satisfied – This step happens when the goods or services are transferred to the customer.  The customer will have taken control of the goods or services at this time.  The amount of revenue that is recognized is the amount allocated to satisfy a performance obligation.

HOW CAN WE HELP YOU SUCCESSFULLY NAVIGATE THROUGH THESE CHANGES?

Project Partners will demonstrate how project-centric companies, using Oracle Projects and/or Oracle Project Contracts, can comply to the new standards with minimum disruption to existing business practices.  View 5-Step recap below.

ASC 606:  REVENUE FROM CONTRACTS WITH CUSTOMERS

PART 1

The core principle in the converged standard requires that an entity recognize revenue to depict the transfer of promised goods or services to a customer in an amount that reflects the consideration in exchange for those goods and services.  To accomplish this goal, a five-step process has been outlined in the new standard.  Every contract with a customer should be analyzed using these five steps to afford accurate reporting.

STEP 1   IDENTIFY THE CONTRACT WITH A CUSTOMER

The new revenue guidance defines a contract as an agreement between two or more parties that creates enforceable rights and obligations.  Essentially, all parties to the contract have to approve the agreement, are committed to fulfilling their obligations, and have Identifiable rights.  The contract must have commercial substance and collectability is probable.

STEP 2   IDENTIFY THE PERFORMANCE OBLIGATIONS IN THE CONTRACT

This step requires an entity to identify all the distinct performance obligations in a contract or arrangement.  A performance obligation (commonly referred to as deliverables) is a promise to transfer goods or services to a customer.  A good or service is distinct when the customer can benefit from said good or service on its own or with resources the customer already has, and the good or service can be transferred to the customer independent of other performance obligations in the contract.  Goods and services that are not distinct should be combined with other goods or services until the whole group is distinct.

To be distinct, a good or service must meet two criteria:

  1. It must be capable of being distinct, and
  2. It must be separately identifiable.

STEP 3   DETERMINE THE TRANSACTION PRICE

The Transaction Price is the amount of consideration an entity expects to receive for the transfer of goods or services to the customer.  The amount can be fixed, variable or a combination of both.  Transaction Price is allocated to the identified performance obligations in the contract.  These amounts are what are recognized as revenue when the performance obligation is fulfilled.

STEP 4   ALLOCATE THE TRANSACTION PRICE

Allocation of the Transaction Price comes into play when a contract contains more than one performance obligation.  The seller should allocate the total amount of the selling price to each performance obligation based on its relative Standalone Selling Price (“SSP”).  The Standard permits any method of allocation of the SSP, just as-long-as that estimation is an accurate representation of what price would be charged in separate transactions.

STEP 5   DELIVER SERVICES AND RECORD OUTCOME

The last step in the new revenue recognition standard is to recognize revenue when or as the performance obligations in the contract are completed.  A performance obligation is completed when or as control of the good or service is transferred to a customer.  The Standard defines control as “the ability to direct the use of and obtain substantially all of the remaining benefits from the asset.” (ASC 606-10-20).

The Standard allows for revenue recognition based upon two methods for measuring progress, Output and Input.

Outputs are the result of inputs and processes   of a business and are goods or services finished and transferred to the customer.  The output method measures results achieved.  Surveys, appraisals, milestones reached, and units produced or delivered are all examples of output methods.  Value to the customer is the objective measure of an entity’s performance.

Examples of an output method would include the number of feet of pipe used for a specific distribution project, or the number of electrical poles used from a transmission plant, to a final destination.

The input method is a more indirect measure of satisfying a performance obligation.  Inputs are measured by determining the amount of effort put into completing the contract.  The input method is implemented by estimating the inputs required to satisfy a performance obligation, and then comparing the effort expended to date against that estimate.

Examples of input methods would be cost-to-cost, labor hours, or material quantities.

The Board decided that, at least conceptually, an output measure is the best depiction of the entity’s performance because it directly measures the value transferred to the customer.  Although the Boards did not state that the output method is the preferred method, they felt that in most cases it is the most appropriate method that is consistent with recognizing revenue as value is transferred to the customer.  A drawback to this method is that there may not always be a directly observable output to reliably measure progress.

 

CLICK HERE for a more in-depth discussion of this topic and read full posts to the ASC 606 Series on our website.

CONTINUE TO NEXT POST 2 OF 2…

“Let’s take another in-depth look at how to use Oracle to comply with the newest revenue recognition rules”  

 

www.projectp.com | Phone: +1.650.712.6200

 

 

 

Through this three (3) part educational web-series, Project Partners will arm you with critical steps and insight into a Project Financials cost-effective solution. This unique solution offering will assist administratively burdened organizations like yours to effectively manage Project Financials around Capital spend through all phases of the Capital Lifecycle (Concept Definition, Funding Approvals, Execution, Reporting, and Managing Project Costs).

WHY CAPITAL PROJECTS? – WEBINAR REGISTRATION INFORMATION

CLICK TO REGISTER HERE for our FINAL PART (3) of the three (3) part series as we explore how Project Partners has addressed the pain associated with AFE’s and the manual efforts.  We will showcase how we’ve developed an easy to use Authorization for Expenditure solution that extends the functionality of Oracle EBS Projects applications and walk you through the solution focused around project costing to your specific business requirements, robust functionality, and use of authorizations for expenditures to further efficiency gains and extensive return on investments.

MISSED PART 2?  Don’t Worry…CLICK HERE to get a downloadable recording so you will be up-to-speed!   

Have Questions?
Simply reach out to us and our experts will immediately assist, provide additional information, and ensure you have associated playbacks. We look forward to your attendance, and will set up a call to fully understand your needs, and offer next steps around a Project Financials cost-effective solution that best fits your organization.

P: #1.650.712.6203 Email: cfryc@projectp.com

Through this three (3) part educational web-series, Project Partners will arm you with critical steps and insight into a Project Financials cost-effective solution. This unique solution offering will assist administratively burdened organizations like yours to effectively manage Project Financials around Capital spend through all phases of the Capital Lifecycle (Concept Definition, Funding Approvals, Execution, Reporting, and Managing Project Costs).

WHY CAPITAL PROJECTS? – WEBINAR REGISTRATION

CLICK TO REGISTER HERE for PART 2 of the three (3) part series as we explore the WHY and HOW to leverage EBS Project Financials for Capital Projects. We’ll walk you through the solution focused around project costing to your specific business requirements, robust functionality, and use of authorizations for expenditures to further efficiency gains and extensive return on investments.

MISSED PART 1?  Don’t Worry…CLICK HERE to get a downloadable recording so you will be up-to-speed!   

Have Questions?
Simply reach out to us and our experts will immediately assist, provide additional information, and ensure you have associated playbacks. We look forward to your attendance, and will set up a call to fully understand your needs, and offer next steps around a Project Financials cost-effective solution that best fits your organization.

P: #1.650.712.6203 Email: cfryc@projectp.com

Project Partners, and our customer, Atkins North America, were pleased to present several sessions at Collaborate 15 in Las Vegas earlier this month. Now you can easily access the white papers and even view on-demand web casts of those sessions here.

We presented the following sessions at Collaborate 15. There is no charge to view any of this content, all it requires is a quick registration and approval. Read the rest of this entry »

By Wendy Lamar

Pay when paid functionality has been added to Oracle E-Business Suite as part of integration with procurement. The pay when paid functionality improves cash flow management by preventing payment to subcontractors until the customer invoice has been collected. Further, the supplier workbench provides the Project Manager improved visibility to the vendor invoice information, as well as enabling the management of invoice holds directly from the workbench. Read the rest of this entry »

By Neeraj Garg

Oracle E-Business Suite Project Costing

Labor Costing Enhancements: Labor transactions in Oracle Projects can now be costed via several new methods:

  1. Costing using HR Rates (includes support for multiple rates and rate by criteria). This feature now enables support for the Davis-Bacon Act.
  2. Support in Oracle Time and Labopr for additional data to be captured to support rate by Criteria.
  3. Total Time reporting. This feature allows the standard/actual cost for Exempt employees to be automatically pro-rated over all hours charged to projects by the employee. Prior to this enhancement, exempt employee costs could be over-counted if they charged more than the standard working hours.
  4. Labor costing using Payroll actuals. This feature supports using actual payroll costs to drive project labor costs. Support is included for Oracle Payroll or a third party payroll system.
  5. When using Payroll actuals for labor costing, you can choose to accrue labor cost using standard rates prior to payroll run. This allows you to continue billing all project costs using the accrued standard cost and then post adjustment entries to invoices based on the actual payroll run. When combined with the “Adjusted transactions on standard invoice” feature in Oracle Project Billing, this makes the accrual adjustment feature seamless to the end client.
  6. Expenditure Batch Reversal: In order to support the payroll feature of reversing a payroll run, Oracle Project Costing now supports reversing the costing for an expenditure batch and reverting the costed transactions to an uncosted state.

Integration to Oracle Complex Maintenance,Repair, and Overhaul (cMRO):  Support for unplanned and non-routine  maintenance has been added to the integration to Oracle cMRO in addition to existing support for Regular maintenance. Such maintenance visits/activities can now be associated to new or existing projects/tasks.

Enhanced Cost Collection by Cost Code: A new classification –Cost Code – is now available on a project/task. A Cost Code can be a multi-segmented attribute and can be setup to represent a hierarchy of values.  These cost codes are predefined during implementation and can be associated to a project. Each task can then be assigned one or more values for the cost code. Once this is done, all actuals must now include valid cost code values in addition to project and task. This allows for more granularity in setup and collection of actual costs and easy comparison of similar types of costs across projects and tasks for metrics like productivity that are key in the Engineering and Construction industry.

Self-Assessed Tax from Payables: Oracle E-Business Suite Projects Applications will now bring over any self-assessed tax on project related supplier invoices from Oracle Accounts Payable as a project expense.

Oracle E-Business Suite Project Billing

Standard Invoicing for Adjusted Transactions: Adjusted transactions can now be included on a net new invoice instead of going to a credit memo. This is controlled via an option at the project and task level for labor transactions only, or for all transactions.

Oracle E-Business Suite Project Management

Planning with HR Rates: If you use the HR Rates option for labor costing, these rates are also available in the planning screens (WorkPlans and Financial Plans) to determine planned cost for labor lines.

Forecasting Using Updated Rates: When generating a forecast, ETC amounts are now computed using updated rates (from the rate schedules) for all rate based resources.

Planning Without Resource Classes: You can now plan for projects, tasks and resources without assigning a resource class. This allows additional flexibility in determining the planning granularity

Planning by Cost Codes: You can now plan by cost code (assigned to project/task) and further at any level of the cost code you choose.

Technology 

Online Patching: In addition to these features specific to Oracle E-Business Suite Projects, the biggest technology update is Online Patching.  Online Patching uses the Oracle Database 11g Release 11.2.0.2 feature of “edition-based” redefinition to significantly reduce the downtime traditionally needed for patching and related maintenance activities.

The way this works is fairly elegant. An “edition” is a private environment in which you can redefine database objects. With online patching, patches are applied to a separate edition while users are working with the original edition. After applying patches, the system is cut over to make the patch edition the new production edition. After the initial upgrade to Release 12.2, all future patches and maintenance packs will be applied online, requiring only a brief cutover period to make the new functionality active.

If you have any questions about the new features in Oracle E-Business Suite Applications, Release 12.2, don’t hesitate to contact us via our online form, or call me at +1.650+712.6200.

By Kimberly McDonald Baker

We want to be sure you don’t miss a new case study article featured in the November 2012 issue of Profit Magazine, titled “Unifying Financial and Project Management” In this article you will learn about Colonial Pipeline Company’s integrated Oracle E-Business Suite and Primavera systems, and a few of the benefits that Colonial is receiving.

With the new, integrated Oracle system, Colonial will have all project related financial records and information in one centralized repository. Project managers and the leadership team will be able to view individual projects or overall capital spend easily. With the new system, Colonial expects time spent on monthly status reporting to decrease by 75 percent, from 8,000 to 2,000 project management hours annually.

“This is a paradigm shift of work for our project managers from doing data manipulation to actually being a project manager,” says Phillip Chandler, Financial Controls Administrator at Colonial Pipeline Company. “This allows them to support our customers both internally and externally in a more effective manner.”

Chandler says Project Partners has helped Colonial implement best practices into its processes, making the company more efficient. “The Project Partners team is sensitive to the specific needs of Colonial. At the same time, they are able to present solutions from an outside perspective that we also need to grow as a business,” says Chandler. “Project Partners has provided the expertise and professionalism that we needed for developing and implementing our project.”

You can read the full article here.

By Neeraj Garg

This is the third of three articles discussing new enhancements in Oracle E-Business Suite Projects Applications Release 12.2. In this article we address the third of three key enhancements: Costing Using Payroll Actuals

Costing Using Payroll Actuals

This enhancement enables companies to use actual payroll costs from Oracle Payroll or a third-party payroll system to cost project labor transactions. These actual costs are distributed to the labor transactions on projects using new mapping rules that specify the expenditure type, cost type and distribution rules to be used for this purpose. Figure 1 shows an example of this mapping.

Payroll Actuals Figure 1

Figure 1


 

Drawing on this mapping and the amounts retrieved from the payroll system, the costing process will distribute payroll costs to various labor transactions, as illustrated in Figure 2.

Payroll Actuals Figure 2

Figure 2


 

The resulting distributed costs are shown in Figure 3.

Payroll Actuals Figure 3

Figure 3


 

Users also have the choice of accruing standard labor costs prior to a payroll run in order to report project costs and support billing. When payroll costs are distributed, the accrued costs are automatically reversed. In addition, a new process has been introduced in the solution to support payroll roll-backs needed for error correction. This process will reverse out an existing labor distribution to projects, making all the transactions re-eligible for costing. Then, when the new payroll run is completed, these transactions can be costed with the corrected payroll numbers. This process may also be used to correct errors in the setup of labor costing in Oracle Projects. For example, it can be used to reverse out a standard costing run and replace it with an actual costing run.

As with the Costing Using HR rates method described above, companies implementing this feature need consider the need for labor-cost information security, because actual labor costs may be exposed.

Conclusion

With this recent set of enhancements, Oracle E-Business Suite Projects has evolved into a more complete solution that can be used to address nearly any costing requirements that companies may have. Oracle users can more easily take advantage of various approaches to labor costing, using payroll data, HR rates and total time. These enhancements allow companies to manage and perform costing in ways that fit their specific needs, which in turn helps create a better understanding of project costs and, ultimately, profitability.

If you have questions about the new costing enhancements, the use of costing extensions, or any other issues pertaining to using Oracle Applications in an project-intensive environment, contact us! We are always very happy to help end-users make the best use of the applications that we at Project Partners originally invented.

By Neeraj Garg

Continuing from last week’s blog article, new enhancements in Oracle E-Business Suite Projects Applications Release 12.2 allow companies to address various project costing requirements without the use of extensions. There are three key enhancements:

  1. Total Time Costing
  2. Costing Using HR Rates, and
  3. Costing Using Payroll Actuals.

 

Total Time Costing

This enhancement addresses the need to cost labor transactions using effective rates, and especially to encompass exempt employees who do not get paid for overtime work. Like Standard Costing, this enhancement works with standard rates. However, it computes an effective rate for costing labor transactions based on total time charged for a period and the base hours for that period.

There are three new setup elements that are needed to enable Total Time Costing:

  1. Effective period (typically, this will be “weekly”)
  2. Base hours
  3. Enabling Total Time Accounting – new Costing Method for Labor Costing

With these three elements enabled, the effective rate used for costing labor transactions is now computed using the following three-step formula:

                 I.          Base Hours/Charged Hours * Derived Rate = Effective Rate
                II.          Effective Rate * Charged Hours = Raw Cost (Labor)
               III.          Labor Raw Cost * (1 + Burden Multiplier) = Total Burdened Cost (Labor)

In addition, if Total Time Costing is enabled and a new or adjusted transaction is introduced for a person for a previously costed period, the solution does not re-cost all transactions in that previous period. That is, it leaves them at the old rate rather than applying the new rate that was derived using the new total charged hours.

Overall, this enhancement allows users to accurately cost labor for exempt employees. It also allows organizations to meets federal contracting rules for exempt employees, as spelled out in the DCAA Contract Audit Manual, Section 9.

Costing Using HR Rates

This enhancement enables organizations that hold employee rate information in Oracle HR to directly use these rates for project labor costing. This feature is enabled by setting Rate Source in Oracle Projects to “HR” in the costing rule allocation. Rates are then retrieved from the Oracle HR rate matrix using “Rate by Criteria.”

There are many standard criteria available for setting up matrix rates in Oracle HR. Users can also add custom criteria to the rate matrix; these criteria can even call for rates at the project and task levels, if that degree of granularity is needed. Typically, the most commonly used criteria in a matrix are “job,” “location,” and “work type.” A new Project Timecard Template in Oracle Time and Labor has been seeded with these three attributes.

HR rates may also be enabled for use in planning when companies need to compute labor costs in budgets and forecasts.

This enhancement can also play a role in compliance. For example, many companies will benefit from the fact that it enables support for the Davis-Bacon Act in the U.S., which requires companies to pay minimum prevailing wage rates for construction work done at a given location. Also, because the HR rates used in calculations are the actual rates paid to employees, it is very important that labor-cost information security be carefully considered and implemented prior to enabling this enhancement.

In the next blog article we will discuss Costing using Payroll Actuals.

Try Us and Find Out How You Can Have It All Right Now!

By Pat Bowyer

On March 28, 2012, we presented an OAUG Sponsored webcast to discuss and demonstrate the timecard entry solutions we’ve developed, our mProjects Time Management™ mobile timecard and our TimeSpeed™ spreadsheet user-interface applications, both fully integrated with Oracle Time and Labor and Oracle Projects, and extending the functionality of those applications, that will help take the headache out of project timecard entry.

Sound interesting? You can register to view the recorded webinar here.
Read the rest of this entry »