Cost of Operations Dashboard
The Cost of Operations Dashboard helps self-supporting units analyze the drivers of their costs and changes to those costs over time. It can be used to support development of recharge rate proposals or other cost recovery proposals. The dashboard uses PPM and Labor Ledger data.
The Cost of Operations Dashboard is available from the Business Analytics Hub (bah.ucsd.edu) under the Campus Recharges tab.
The dashboard includes four pages:
- Summary
- Payroll
- Non-Payroll
- Federally Unallowable Costs
Access
Access has been provisioned to anyone with the Oracle BI Consumer JR role. Staff who do not have access should request the Oracle role. Access failure appears as error "Unable to load requested view. Displaying home view instead."
- Navigate to bah.ucsd.edu.
- Select Budget & Finance.
- If using the List View, look for Cost of Operations Dashboard in the list or use the search bar at the top right and click the dashboard name
- If using the Card View, click the Campus Recharges tab and click Launch on the Cost of Operations Dashboard tile
- Use your Active Directory credentials to sign in, if prompted.
Navigation
Here you can find various tips and tricks on navigating Cognos report functionality
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
- Use the prompt that best represents the unit of operation you wish to analyze. For example, a recharge facility may search for their Recharge License Number to view all costs for the facility regardless of project or financial unit; a department or other operational unit may search by financial unit; a PI or fund manager may search by PI/Project Manager/Task Manager to analyze the cost of running a lab.
- Time prompts: Select the fiscal years you wish to compare and analyze. If you wish to analyze a specific part of the year, you may select one or more fiscal periods. 1=July; 12=June.
Summary
Summary
The Summary page summarizes costs year over year by Expenditure Category and Expenditure Type. Use this page to understand at a high level what has driven increases or decreases in costs.
Report Views
Payroll
Summary
Use the payroll page to understand how changes in staffing have driving changes in costs. The page does not list individual personnel names, but rather the number and cost of the types of positions that were used to support the operation.
Report Views
Field | Definition |
---|---|
Position |
Name of the position |
Employee Headcount |
Number of different employees who were in that position over the selected period |
FTE |
The number of full-time equivalents in the position over the selected period. For example, if two people worked in the position each at 50% time, employee headcount would be 2 and FTE would be 1. If specific fiscal periods are selected, the FTE is prorated to the period. For example, one person working full-time would display as 1 regardless of the number of fiscal periods selected. |
Compensation Rate | The amount that employees in the position are paid, on average, on a monthly or hourly basis. |
Compensation Frequency Code | Indicates the basis for the compensation rate. M for monthly; H for hourly. Other values such as UC_FY are for academic positions and indicate a monthly rate. |
Total | The total cost of the position for the year, including salary and benefits. |
Non-Payroll
Summary
The Non-Payroll has tables for Purchased Items and Other Costs.
- Purchased Items includes invoice-based purchases. Use this table to analyze how the cost of purchases has changed over time, including whether the cost of individual items has increased or whether more of those items were purchased year over year.
- The Purchased Items table defaults to showing a year over year summary by supplier. You can view additional detail about the items purchased from each supplier by changing the dropdown displaying Without Item Description to With Item Description. With Item Description displays the quantity of each item purchased over the year, the average cost of each unit of the item, and the total cost of the item over the year. You can focus in on a specific supplier by selecting that supplier from the Expenditure Supplier dropdown menu.
- The Other Costs table includes all costs not included in the Payroll or Purchased Items tables. These might include recharges, freight and taxes on purchased items, and other costs.
Report Views
Federally Unallowable Costs
Summary
Recharge facilities may incur costs in the course of their operations that are unallowable on federally sponsored projects. These costs may not be included when developing rates if those rates will be charged to sponsored projects. The Federally Unallowable Costs table displays costs on expenditure types that are restricted in Oracle from being charged to federal sponsored projects.
Report Views
Release Notes & Communications
Date | Release Notes & Communications |
---|---|
11/26/2024 Budget & Finance Weekly Digest |
New Report: Cost of Operations Dashboard This dashboard helps self-supporting units analyze the drivers of their costs and changes to those costs over time. It can be used to support development of recharge rate proposals or other cost recovery proposals. The dashboard uses PPM and Labor Ledger data. Further information on how to access, navigate, and understand this report can be found here. |
11/26/2024 Dedicated Email |
The Business Intelligence (BI) and Financial Reporting team is excited to announce the launch of a new report designed to help you as a recharge facility manager improve your processes: Cost of Operations Dashboard This dashboard helps self-supporting units analyze the drivers of their costs and changes to those costs over time. It can be used to support development of recharge rate proposals or other cost recovery proposals. The dashboard uses PPM and Labor Ledger data. It answers questions like:
|