CIS Reports Section 1

1. CIS Reports Section 1 Technical Assistance Cost of Programs

2. Section 1: Technical Assistance Cost of Programs

3. What are some questions Section 1 reports can answer? • What is the true cost of carrying out the EQIP Program? • How much are the support costs for AMA • Have we spent more hours on CTA in 3rd or 4th quarter

4. Report Purpose The primary purpose of this report series is to answer questions on the true cost of our programs Information in this report illustrates the associated salaries/benefits using WebTCAS and allocated support cost (FFIS) by conservation program which occurred in the current fiscal year.

5. Use of Report • What are the total costs of a program? • What are the National costs for a program? • What are the State, County, Field Office costs of a program? • What are the support costs prorated to programs?

6. What Report Features do most CIS have? Selections for Location, Period, Modifier, Activity Refresh Button Home and Print buttons Report Title Hide filters Report Number Data currency NRCS appropriations and CCE Funds Expose

7. …more Report Features? Information Tab to access report metadata Report Title Data Definitions Report Generation Date Selection Criteria

8. Report Selection Criteria • Location –Selections are available for national, regions, sub-regions where applicable, and states, centers and institutes and NHQ. National will show national grand totals for all data. Region will show regional totals. State will show a state total. • Time Period –Selections are available for each fiscal year month. Reports are cumulative through the month selected. Therefore, fiscal year first quarter totals are provided when December is selected. • Program Modifier – Selections are the program modifiers for WebTCAS NRCS conservation programs. NRCS employees use modifiers when recording time to indicate whether the hours are: Reimbursable Federal, Reimbursable Non Federal, for Current Year Contract Activities, Prior Year Contract Activities, CRP signup, or combinations of these. • Activity –Selections are the activities used by NRCS employees when recording time in WebTCAS.

9. What is Report 1.1 Content? State Data Current through Program Worked and Leave Hours Salaries & Benefits Costs Support Costs

10. CIS Prorations • To accommodate consistent county, congressional district, and office data reports for all data in CIS, a number of proration processes are used. • Two important prorations include: • Distributing Support to County and Offices • Prorating county data to congressional district Lets look at some example of how this is done-

11. How are Support Costs Calculated? • Support Cost – Non Personnel cost reflected in FFIS. Support Costs are prorated to Program worked using salaries for hours worked by program worked as a percentage of state total salaries for hours worked. Includes non salary support costs such as travel, rent, utilities, transportation, equipment, and supplies. Support Cost for CTA (D) Salaries and Benefits by Program (A) Total Salaries All Programs(B) * Support all Program(C) = B C A D

12. How do we get the data? WebTCAS/ACRES Worked and Leave hours by program, activity, modifier, and county Nightly update CIS Database Cube End of Pay Period Data Feed FFIS OIP Monthly Data Feed Real Time Feed Support Costs by State Office Information

13. What is Report 1.2 Content? All Programs listed across top State State Totals County Totals Costs by Program including: Salaries (Worked and Leave), Benefits, Support Costs Offices reporting costs to a program

14. County-Office or Congressional District-County? Select State and refresh data

15. Report 1.2 by Office-County or Congressional Districts Office-County Congressional District-County Congressional District-County County-Office • Report summarizes data for State, County, Office • Report summarizes data for State, CD and Counties in CD

16. How is Congressional data prorated from County Data Congressional District Boundary (106th) 4220 • 18% of the acres in Allegheny County are in Congressional District 20 Allegheny County Boundary

17. Step 1: Find what percentage Congressional District is of County 45% of acres in Evangeline County are in Congressional District 05 Evangeline is 45% of Congressional District 05

18. Step 2: What is County Total for all Offices for Program? $68,886 Offices reporting work in Evangeline County

19. Step 3: Multiply CD % and County Dollars 45% * $68,886 = $30,999

20. What is Report 1.3 Content? Shows complete list of Activities for all programs Worked and Leave Hours Salaries & Benefits Costs Support Costs Each Program has separate section

21. What is Report 1.4 Content? Standard filters including modifier and activity Support Costs Worked and Leave Hours Salaries & Benefits Costs Cost of program for each Office location

22. Section 1 Metadata • Data Source: Staff years worked is based on actual hours worked and paid leave from WebTCAS. Salaries and benefits are for both hours worked and paid leave from WebTCAS. Support costs are from FFIS and are prorated based on salaries for hours worked by program from WebTCAS. • Data Updating Frequency: Federal Financial Information System (FFIS) data is updated monthly. Web Time Cost Accounting System ( WebTCAS) data is updated Bi-weekly.

23. Section 1 Metadata • Staff Years –Based on Hours worked and paid leave hours divided by annual hours. Staff years displayed in this report will be different than the staff years extracted from FFIS, other CIS reports, budget formulation, and human resources. • Worked Hours -Hours worked from WebTCAS are based upon county worked. • Includes regular time, overtime, compensatory time earned, and credit earned. • Does not include time charged to leave categories. • Employees of Centers and Institutes are always shown on the Center and Institute Report and not on a State's report. • State totals are based upon county worked rather than duty station state.

24. Section 1 Metadata • Leave Hours –Paid leave hours charged in WebTCAS are prorated to program using salaries for hours worked by a program as a percentage of state total salaries. Leave categories include: • Annual Leave, Annual Leave/Donated From Others, • Annual Leave/FMLA, Annual Leave/Restored, • Home Leave, Leave as an Award, • Military Leave/Emergency, Military Leave/Regular, • OWCP Injury Leave, Other Leave/ Administrative, • Other Leave/ Federal Holiday, Other Leave/Other, • Other Leave/State/Local Holiday, Other Leave/Transfer, • Sick Leave, Sick Leave/FMLA, Sick Leave/Family Care. • Total Hours - Sum of worked hours and paid leave hours.

25. Section 1 Metadata • Salaries/Benefits –Associated wages and benefits for hours worked and paid leave hours from WebTCAS. Salary data per employee from iCAMS • Support Cost –Non Personnel cost reflected in FFIS. Support Costs are prorated to county worked using salaries for hours worked by county worked as a percentage of state total salaries for hours worked. Includes non salary support costs such as travel, rent, utilities, transportation, equipment, and supplies. • Total Cost –Associated wages and benefits based on hours worked (WebTCAS) & allocated support cost (FFIS).

26. Thank you!