U.S. flag

An official website of the United States government

Dot gov

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Https

Secure .gov websites use HTTPS
A lock () or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Breadcrumb

  1. Home
  2. Courses
  3. CON 0780

White graduation cap icon CON 0780  Using ERP and Excel to Analyze Labor

Using ERP and Excel to Analyze Labor

This is an Online Training (OLT) course. One of the major cost elements when analyzing any contractor proposal is labor. All major contractors (and many mid-tier and smaller contractors as well) use some level of Enterprise Resource Planning (ERP) software to manage the many business systems that exist within the corporation. There are a variety of ERP systems, but most major defense contractors use a system called SAP. SAP is a useful tool for contracting personnel since we can work with our counterparts at the Defense Contract Management Agency (DCMA) and Defense Contract Audit Agency (DCAA) to “pull” data from the SAP system to use in our analysis. This data consists of actual, historical data for the same or similar program. One such report is the CJI3 report. This is a standardized report used to analyze proposed costs using actual historical data. In this course, you'll learn about ERP systems and how to import data from SAP into Excel and analyze support and touch labor on a major program.

In order to successfully complete this course, students should have a strong Excel background to include the ability to import Excel data from an SAP database, create pivot tables, and run a learning curve analysis on the data. To learn more about these skills or to refresh your excel skills, DAU offers an Excel credential, CCON 018, Excel Skills for Business Credential as well as the recommended prerequisite courses below which allow you to tailor your training.

Those courses include:

REQUIRED PREREQUISITES

See the "Notes" section of this course's concept card for recommended prerequisites.

PREDECESSOR COURSES

TARGET AUDIENCE

Any acquisition workforce member who needs to analyze labor on a major program using ERP data

NOTES

Recommended Prerequisites: Additional Information:
  • Any exams in this course must be passed with a minimum score of 80%.
  • There is no time limit for completing this course.
  • After completing the course, please be sure to complete the survey at the end.
  • The CLPs assigned to this learning activity may be used to meet professional certification and/or licensure requirements (PDUs/CPE credits).