CRS_CEU   CRS_CLP   START_DATE   END_DATE     There are no records available. Records per page: 1 2 3 4 5 6 7 8 9 10 50 100 500 - - Records: 0 to 0 of 0 - Pages  ob_gridCEPEditControl0valuetrue ob_gridCEPEditControl1valuetrue ob_gridCEPEditControl2valuetrue ob_gridCEPEditControl3valuetrue DAU Courses ACQ ACQ 0030 ACQ 0040 ACQ 0061 ACQ 0150 ACQ 0200 ACQ 0490 ACQ 0500 ACQ 0710 ACQ 0720 ACQ 0760 ACQ 0770 ACQ 0800 ACQ 0820 ACQ 0830 ACQ 0840 ACQ 1010 ACQ 110 ACQ 1300 ACQ 160 ACQ 1650 ACQ 1700 ACQ 1700V ACQ 2020 ACQ 2030 ACQ 2030V ACQ 2551 ACQ 265 ACQ 265V ACQ 305 ACQ 305V ACQ 3110 ACQ 3120 ACQ 3130 ACQ 3140 ACQ 315 ACQ 3150 ACQ 315V ACQ 3160 ACQ 3170V ACQ 3200 ACQ 3700V ACQ 380V ACQ 401 ACQ 404 ALD ALD 0010 ALD 0020 ALD 0030 ALD 0040 ALD 0050 ALD 0060 ALD 0070 ALD 0090 ALD 0100 ALD 0110 ALD 0120 ALD 0130 ALD 0140 ALD 0150 ALD 0160 ALD 1100V ALD 2100V ALD 3100 AUD AUD BCE BCE 0010 BCE 0020 BCE 0040 BCE 0060 BCE 0150 BCE 0230 BCE 0420 BCE 1000 BCE 1700 BCE 1710 BCE 2000V BCE 2060V BCE 2160 BCE 2300V BCE 2500 BCE 3000 BCE 3160V BFM BFM 0010 BFM 0020 BFM 0030 BFM 0040 BFM 0050 BFM 0060 BFM 0370 BFM 1000 BFM 2000 BFM 2300 BFM 2710V BFM 2720 BFM 2730 BFM 2740 BFM 2750V BFM 2990V BFM 3000 BFM 4000 BUS BUS 1100 CLB CLB 025 CLB 036 CLC CLC 002 CLC 003 CLC 006 CLC 008 CLC 011 CLC 024 CLC 028 CLC 030 CLC 031 CLC 038 CLC 040 CLC 041 CLC 042 CLC 043 CLC 044 CLC 045 CLC 046 CLC 049 CLC 052 CLC 053 CLC 054 CLC 056 CLC 058 CLC 060 CLC 062 CLC 065 CLC 068 CLC 104 CLC 106 CLC 107 CLC 108 CLC 110 CLC 113 CLC 114 CLC 120 CLC 125 CLC 132 CLC 206 CLC 222 CLE CLE 001 CLE 002 CLE 003 CLE 004 CLE 007 CLE 008 CLE 009 CLE 010 CLE 015 CLE 017 CLE 019 CLE 022 CLE 023 CLE 026 CLE 028 CLE 030 CLE 035 CLE 036 CLE 047 CLE 064 CLE 065 CLE 066 CLE 068 CLE 069 CLE 070 CLE 074 CLE 075 CLE 076 CLE 077 CLE 078 CLE 079 CLE 080 CLE 083 CLE 084 CLE 085 CLE 301 CLG CLG 0010 CLG 006 CLI CLI 004 CLI 007 CLM CLM 002 CLM 023 CLM 025 CLM 031 CLM 037 CLM 038 CLM 039 CLM 040 CLM 047 CLM 048 CLM 058 CLM 059 CLM 060 CLM 071 CLM 072 CLM 073 CLM 075 CLM 090 CLM 091 CLM 092 CLM 093 CLM 094 CLM 095 CLM 103 CLV CLV 016 CLV 017 CLV 019 CLV 020 CMA CMA 100 CMA 241 CMA 2410 CMA 2410V CMA 241V CMC CMC 1000 CMC 1040 CMC 1050 CMC 130 CMC 1500 CMC 1510 CMC 170 CMC 2060 CMC 210 CMC 2310V CMC 2320V CMC 233 CMC 234 CMC 235 CME CME 103 CME 130 CME 201 CME 202 CME 203 CME 204 CME 230 CME 250 CME 260 CMI CMI 100 CMI 101 CMI 103 CMI 1180 CMI 1210 CMI 1220 CMI 1230 CMI 1240 CMI 1250 CMI 1300V CMI 140 CMI 2010V CMI 207 CMI 2100V CMI 2220 CMI 2300V CMQ CMQ 1000 CMQ 101 CMQ 1010V CMQ 1030 CMQ 1040 CMQ 1080 CMQ 1100 CMQ 1110 CMQ 1120 CMQ 1130 CMQ 1140 CMQ 1150 CMQ 1310 CMQ 140 CMQ 142 CMQ 200 CMQ 201 CMQ 206 CMQ 210 CMQ 211 CMQ 212 CMQ 215 CMQ 216 CMQ 220 CMQ 230 CMQ 231 CMQ 232 CMQ 242 CMQ 261 CON CON 0010 CON 0040 CON 0074 CON 0090 CON 0120 CON 0130 CON 0140 CON 0150 CON 0161 CON 0170 CON 0180 CON 0210 CON 0270 CON 0330 CON 0390 CON 0470 CON 0510 CON 0520 CON 0590 CON 0640 CON 0660 CON 0760 CON 0780 CON 0800 CON 0810 CON 0820 CON 0830 CON 0840 CON 1100 CON 1100V CON 1200V CON 1210 CON 1300V CON 1400V CON 1770V CON 216 CON 2310 CON 2370 CON 2420V CON 2430V CON 2440V CON 2450V CON 2880V CON 2990V CON 3900V CON 3910 CON 3990V CON 7020 CON 7030V CON 7040 CON 7050 CON 7060 CON 7100 CON 7110 CON 7120 CON 7140V CON 7150 CON 7160 CON 7170V CON 7180 CON 7200V CON 7210V CON 7220V CON 7300V CON 7310V CON 7320V CON 7400V CON 7410V CON 7420V CON 7430 CON 7440 CON 7450 CON 7460 CON 7471 CON 7480 CON 7500 CON 7510 CON 7520 CON 7600 CON 7610 CON 7620 CON 7630 CON 7640 CON 7700 CON 7710 CON 7800 CON 7810V CON 7900 CON 8300V CON 8400V COR COR 222 COR 222V CYB CYB 0030 CYB 5610 CYB 5620V CYB 5630V CYB 5640 CYB 5640V DOD DOD 0020 ENG ENG 0620 ENG 0720 ENG 0810 ENG 0850 ENG 0860 ENG 0870 ENG 0880 ENG 0890 ENG 0900 ENG 1110 ENG 260 ENG 5510 ETM ETM 1010 ETM 1020 ETM 1030 ETM 1040 ETM 1050 ETM 1060 ETM 1070 ETM 1080 ETM 1090 ETM 2010V ETM 2020V ETM 2030V ETM 2040V ETM 2050V ETM 2060 ETM 2070V ETM 2080V ETM 2090V ETM 3110 ETM 3120 ETM 3130 ETM 3140 ETM 3150 EVM EVM 0020 EVM 0030 EVM 0040 EVM 0050 EVM 0060 EVM 101 EVM 2100 EXE EXE 4000V EXE 4050V FE FE 101 FE 2010 FE 302V GRT GRT 0010 GRT 0020 GRT 0030 GRT 0040 GRT 201V IND IND 105V IND 2050V INT INT 1110 INT 1140 INT 2110 INT 2300V INT 3800V ISA ISA 1011 ISA 220 LOG LOG 0010 LOG 0020 LOG 0030 LOG 0050 LOG 0060 LOG 0070 LOG 0080 LOG 0110 LOG 0120 LOG 0130 LOG 0140 LOG 0150 LOG 0160 LOG 0170 LOG 0220 LOG 0230 LOG 0240 LOG 0250 LOG 0260 LOG 0270 LOG 0290 LOG 0300 LOG 0310 LOG 0320 LOG 0330 LOG 0360 LOG 0370 LOG 0380 LOG 0390 LOG 0400 LOG 0430 LOG 0440 LOG 0450 LOG 0460 LOG 0470 LOG 0510 LOG 0520 LOG 0530 LOG 0540 LOG 0550 LOG 0570 LOG 0580 LOG 0590 LOG 0600 LOG 0610 LOG 0620 LOG 0630 LOG 0640 LOG 0650 LOG 0660 LOG 0670 LOG 1000 LOG 104 LOG 1050 LOG 2000 LOG 2010 LOG 2010V LOG 2040 LOG 2060 LOG 211 LOG 211V LOG 2150 LOG 2350 LOG 3400 LOG 3400V LOG 3500V LOG 3510 LOG 3550 LOG 3560 LOG 3570 LOG 3600 LOG 4650V PMT PMT 0120 PMT 0130 PMT 0140 PMT 0170 PMT 2570V PMT 3400 PMT 3500 PMT 3600 PMT 3600V PMT 4010 PMT 4010V PMT 4020 PMT 4020V PMT 4800V PMT 4810 PMT 4890V PMT 4900V PMT 4910 PMT 4990V RQM RQM 1010 RQM 1101 RQM 1510 RQM 2100 RQM 2500 RQM 2520 RQM 3100V RQM 4030V RQM 4130 SBP SBP 1010 SBP 120 SBP 2010 SBP 2020V SBP 2100V SBP 301V SPS SPS 100 SPS 101 SPS 102 SPS 103 SPS 104 SPS 105 SPS 106 STM STM 0010 STM 0020 STM 1010 STM 2040 STM 2050 STM 2060V SWE SWE 0001 SWE 0002 SWE 0004 SWE 0005 SWE 0006 SWE 0007 SWE 0009 SWE 0010 SWE 0012 SWE 0013 SWE 0014 SWE 0016 SWE 0017 SWE 0018 SWE 0019 SWE 0020 SWE 0021 SWE 0024 SWE 0025 SWE 0026 SWE 0027 SWE 0028 SWE 0029 SWE 0032 SWE 0033 SWE 0034 SWE 0039 SWE 0040 SWE 0041 SWE 0042 SWE 0044 SWE 0045 SWE 0046 SWE 0048 SWE 0049 SWE 0050 SWE 0051 SWE 0052 SWE 0053 SWE 0054 SWE 0055 SWE 0056 SWE 0057 SWE 0058 SWE 0062 SWE 0063 SWE 0064 SWE 0070 SWE 0072 SWE 0074 SWE 0075 SWE 0077 SWE 0078 SWE 0079 SWE 0084 SWE 0085 SWE 0089 SWE 0093 SWE 0096 SWE 0097 SWE 0098 SWE 0099 SWE 0100 SWE 0101 SWE 0102 SWE 0103 SWE 0104 SWE 2002 SWE 2003 SWE 2006 SWE 2014 SWE 2015 SWE 2016 SWE 2017 SWE 2025 SWE 2030 SWE 2031 SWE 2040 SWE 2046 SWE 2047 SWE 2048 SWE 2049 SWE 2050 SWE 2060 TST TST 102 TST 1100 TST 2040 TST 2040V TST 2100 WSA WSA 001 WSA 002 WSA 004 WSA 006 WSA 010 WSB WSB 002 WSB 004 WSB 011 WSB 012 WSB 018 WSC WSC 005 WSC 006 WSC 015 WSC 023 WSC 027 WSC 030 WSC 031 WSC 032 WSC 035 WSC 036 WSD WSD 003 WSD 004 WSD 005 WSD 006 WSD 007 WSD 009 WSD 010 WSD 011 WSD 012 WSD 013 WSD 014 WSD 016 WSD 018 WSD 019 WSD 020 WSD 021 WSD 022 WSD 023 WSD 024 WSE WSE 005 WSE 006 WSE 018 WSE 023 WSE 026 WSE 027 WSE 030 WSE 031 WSE 032 WSL WSL 001 WSL 002 WSL 003 WSL 008 WSL 010 WSL 011 WSM WSM 002 WSM 005 WSM 007 WSM 008 WSM 009 WSM 010 WSM 011 WSM 012 WSM 013 WSM 014 WSM 016 WSM 017 WSM 019 WSM 021 WSM 022 WSM 024 WSM 025 WSM 026 WSM 027 WSM 028 WSM 029 WSS WSS 001 WSS 003 WSS 004 WSS 005 WSS 008 WSS 011 WSS 012 WSS 013 WSS 016

CON 0780 Using ERP and Excel to Analyze Labor (Last Modified:21-Jun-2024)   Description 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: Excel Skills for Business: Intermediate I Excel Skills for Business: Intermediate II Excel Skills for Business: Advanced Objectives Download Course Objectives Target Attendees Any acquisition workforce member who needs to analyze labor on a major program using ERP data Prerequisite(s) See the Notes section of this course's concept card for recommended prerequisites. Predecessor Course(s) Predecessor Predecessor Course Title PDS Code Expires On None None None None Course Length Approximately 1 hour to complete Additional Course Information Delivery Mode Online Training Equivalent Courses None Availability Department of Defense (DoD) Only PDS Code 03S Walk-ins Authorized N/A Pre-work required No First Offering 11/21/2023 ACE Recommended Credits None Continuing Education Units   0 Continuous Learning Points  1 Reservist Retirement Points  0 Historical Allocations Mouse Over for Past CEU/CLPs Fulfillment Eligible N/A Technical Requirements Click Here Notes Recommended Prerequisites: Excel Skills for Business: Intermediate I Excel Skills for Business: Intermediate II Excel Skills for Business: Advanced 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).