Operational Cost Tracker is a tool designed to monitor and manage the expenses associated with the day-to-day operations of your organization.
- Available for Work Order and Asset Management Premium and Ultimate subscription levels
Here are some key features associated with an Operational Cost Tracker:
- Operational Cost Tracker helps you record and categorize all operational expenses, allowing your organization to maintain a detailed record of costs. This information can be used to analyze spending patterns and identify areas where costs can be reduced.
- By aggregating and organizing expense data, Operational Cost Tracker enables your organization to analyze costs across various types. This analysis helps in understanding the distribution of expenses and identifying cost drivers.
- Operational Cost Tracker helps in setting and managing budgets for different activities. It provides real-time visibility into actual expenses, allowing your organization to make adjustments and take proactive measures to control costs.
- With the insights gained from Operational Cost Tracker, organizations can identify inefficiencies, eliminate wasteful spending, and optimize operational costs. It enables them to make data-driven decisions to improve resource allocation and streamline processes.
Reporting and Visualization:
- Operational Cost Tracker provides Views and a Summary to present expense data in a clear and meaningful way. Graphs, charts, and customizable reports help stakeholders understand cost trends, patterns, and areas of concern.
Go to Modules, then click Operational Cost Tracker
Once you are on the Operation Cost Tracker page, you will see the following options on the left navigation bar:
- Cost Data: This is the page you are on and displays each Cost Type that you add and its associated data that you upload (with the template provided on the page)
- Settings: This is the area of adjustments to this feature
A. Cost Types: These are the kinds of costs you can track (i.e. Electricity, Water, Gas, etc.)
B. Sources: The ways your Cost Types are tracked (i.e. usually meters)
C. Users: This page is where you can manage the users of this feature
- My Profile: This is the page you can manage your own profile settings and preferences
You will also see your Cost Data displayed on this page as follows:
- All Cost Types are displayed here and you can add by clicking the plus sign (+)
- Set your Time Range to display your Cost Type (default is for the past 12 months)
- Set your Location
- Filter by Usage, Demand or Other Costs
- Choose to aggregate selected Locations
- Choose to include previous period when displaying your costs
- Create a View that you can share internally and/or as a public (non-editable) link
- Choose a Saved View
- Add New Data for a selected Cost Type (i.e. add an individual Electric bill)
- Click Export to first export the template needed from eSPACE in order to add your data to so then you can upload it. Once added, then you can export the current data on that tab.
- Click Import to upload the completed template that you previously downloaded and filled out with your specific information from step 10.
Exporting & Filling Out the Template
- When you fill out the exported template, you need to fill out the Electricity, Cost, Month, Year, Location, and Source columns (and Demand and Other if you add those to your OCT Cost Data tab).
- Don't fill in "Cost Per Sq Ft" or "Yearly Avg Cost Per Sq Ft" because those will be calculated by eSPACE once you upload the spreadsheet.
- Spell out the name of each month.
- Fill in the Location column with the exact spelling of your location under Settings/Locations in Event Scheduler/Work Order & Asset Management.
- You do not need to round all values up or down to whole numbers, but you can if you want to.
- Do not add or delete any columns
- If you need the demand or "Other Cost" columns, make sure that you selected those to be included when you initially created the tab on Cost Data. If you need to add them, then go to Settings > Cost Types and edit the tab so that those are included and then go back and export the template.
- Do not rename any column headers.
- Below is an example of an Excel template that is correctly filled out.
Importing the Template
When you click to Import, you will see the following prompt:
After you have entered your data into a file, selected it and imported, you will see the following:
Now you can explore your newly imported data: