Year-Over-Year Cost Comparison Dashboard

Take a deep dive into your invoice, labor, and material cost changes with this Year-Over-Year Cost Comparison dashboard. What sets this dashboard apart is its utilization of median values instead of averaging costs, giving you a clearer and more reliable understanding of your spend over time. Cost changes are measured from the selected period and the year prior to the selected period. Filter to focus on specific types of cost, such as on-demand repairs or capital expenditures. Then quickly compare these changes by trades, providers, regions, and districts to examine what is driving cost changes.

You can find this dashboard under the Standard Dashboards folder in Analytics.

Navigation

This dashboard is broken up into 4 main sections:

1. Filters
2. Looks:
   1. 
   2. 
   3. 
   4. 
   5. 
   6. 
3. Facilities Spend Index
4. Provider Cost Comparison

Filters

• Selected Period

Choose the best time frame combination to compare data from that time frame to that time frame in the previous year. Ex: Today is July 10, 2023 and you choose previous month. Data shown will compare June 1-30, 2022 to June 1- 30, 2023.

• Category / Trade / Priority / Invoice Amount per WO / Provider Name

Filter by these parameters to focus on specific types of work and costs. Category,Trade, Priority will be the primary one chosen by ServiceChannel. See Work Order Properties to view and update yours if needed.

• More + 6: Region / District / Location Note Header Name / Location Note Header Value / Location Number / Location Name

Click on More + 6  to focus your filtering on specific geographical or organizational alignments.

Looks

Invoice Amount / Labor Amount /Material Amount

These looks give two visuals to the filtered data:

1. YOY look at Median Invoice Amount from Previous Period, Change Percentage, and Selected Period Median Invoice Amount
2. Month-over-month trend over the last 12 complete months.

You can:

• Drill into the data on each time period to see which work orders were calculated in the YOY comparison by clicking on the number (blue box in visual above).
• Drill into the data on the Month-over-Month trend line to see calculated work orders by clicking anywhere on the line. 

Invoice Amount

Compare the year-over-year change in the Median Invoice Amount.

In this example below, we can see last year in the month of June had a median invoice amount of $333. In June this year, there was a decrease by 29.6% with median invoice amount of $235.

Labor Amount

Compare the year-over-year change in the Median Labor Amount for invoices that have a non-zero Labor Amount specified. If you do not have line item invoicing set up, you will not see anything here. See Configuring Require Line Items to change your set-up.

In this example below, we can see last year in the month of June had a median invoice labor amount of $132. In June this year, there was a decrease by 9.1% with median invoice amount of $120.

Material Amount

Compare the year-over-year change in the Median Material Amount for invoices that have a non-zero Material Amount specified. If you do not have line item invoicing set up, you will not see anything here. See Configuring Require Line Items to change your set-up.

In this example below, we can see last year in the month of June had a median invoice labor amount of $90. In June this year, there was an increase by 67.7% with median invoice amount of $151.

Breakdown by Trade

Compare the year-over-year change in Median Invoice Amount broken down by trade. In this example, we are still comparing June of last year with June of this year.

Breakdown by Provider

Compare the year-over-year change in Median Invoice Amount broken down by provider. In this example, we are still comparing June of last year with June of this year.

Breakdown by Region

Compare the year-over-year change in Median Invoice Amount broken down by region. In this example, we are still comparing June of last year with June of this year.

Companion Info

After using the YOY Cost Comparison dashboard, it is likely that you will want to dive further into cost. You can do that through the Facilities Spend Index and the Provider Cost Comparison dashboard.

Facilities Spend Index

The ServiceChannel Facilities Spend Index™ monitors commercial trade service costs and spending patterns based on $35 billion dollars in services delivered to 500,000 locations on the Service. Check out the Facilities Spend Index to:

› See where your budgets are growing faster than industry spend overall.
› Compare your invoice cost trends to the Service Cost Index.
› Choose between trades and regions to explore different markets.

Provider Cost Comparison

The Provider Cost Comparison dashboard can be a tool to compare individual providers within your network to the baseline of your total network’s median costs. You might find that some trade baselines have a larger cost change than others. Using this dashboard, you can filter to a trade in question and investigate whether certain providers are driving that cost change.