Skip to main content

Learning Path - SourceDay Insights - Understanding Cost Increase Impact 

Erin
  • Updated
Follow

The Mission

This dashboard can help you to understand how cost increases or decreases are affecting your business and also includes the line items that are driving the numbers, allowing you to quickly find out where costs are hitting your bottom line.

 

Let's Take a Look

Use the numbers in the image to help identify the sections for a deep dive of the functionality below.

mceclip0.png

  1. Filters
  2. Overall Impact %
  3. Overall Impact $
  4. % Increases
  5. Visual Drilldown for Costs
  6. Item Detail Comparison
  7. Download Data

1) Filters

Filters will help you to make this report work for your business.  By changing timeframes you can see how seasonality affects your costs across suppliers.  The % threshold will help you focus on the suppliers that are outside of the guidelines of what is acceptable for your company.  If you are looking for more information on the filters and what they mean, you can see in depth information on each filter here.

  

2) Overall Impact %

This is the percentage change in average item costs when comparing the time period that was chosen for your time range filter.  It is the calculated percentage impact of cost increases and decreases for your company.  This number will help you to understand how cost overages or decreases are affecting your bottom line.

 

3) Overall Impact $

This is the total dollar value (USD) in average item costs when comparing the time period that was chosen for your time range filter.  While it's good to be able to see percentage change, sometimes seeing the actual dollar amount can help to drive the necessary changes needed to drive change.  This number will help you to understand how these increases and decrease are affecting your bottom line and your ability to run your business while staying within budget.

 

4) % Increases

This is the percentage of items that showed and increase in the time period set by the filter.   This can help you to understand and anticipate how cost changes are impacting your business. The more items being hit with cost increases can drive significant changes in how you are able to run your business.

 

5) Visual Drilldown for Costs

In this section you can see:

  • Costs That Increased - The number of items that showed an average increase (considering threshold value) when comparing periods
  • Costs That Stayed the Same - The number of items that stayed the same (considering threshold value) when comparing periods
  • Costs That Decreased - The number of items that showed an average decrease (considering threshold value) when comparing periods

The number to the right is the number of items that fell into this category.  By clicking on the bar you can see the actual items and suppliers that made up the section. 

Step5CostDrillDownAnimation.gif

From this view you can see:

  • - Cost Impact - What did the increases in cost cost you?
  • - Costs That Increased - Number of items from the supplier with a cost increase
  • - Percentage of Costs That Went Up - Percentage of spend increase across supplier spend

 

6) Item Detail Comparison

The bottom section allows you to see where you have potential for savings.  It is based off of part number and will show you:

  • The item number - What is the item that was ordered
  • The item description - How do you describe your parts
  • The supplier's name - Who did you purchase from
  • PO cost before the report timeframe - Average cost of the item on purchase order lines in SourceDay with matching Item Name, during the baseline timeframe (based on the Item Timeframe filter).
  • PO cost after the report timeframe - Average cost of the item on purchase order lines in SourceDay with matching Item Name, during the period specified in the Item Timeframe filter.
  • Cost Variance - The difference between the above 2 averages
  • Sum of quantity ordered - Sum of all quantities from associated purchase orders of that item during the timeframe selected
  • Estimated cost impact - The total increase/decrease in dollars paid for that item during the period specified in the Item Timeframe filter.

From this report you can see and compare your suppliers and see if there is potential for savings by looking at other trusted relationships that may sell the same parts.

 

7) Download Data

You can download any of your data from these charts for use and additional analysis.  You can download to either excel or csv.

  1. Click the download data link
  2. When you are taken to the downloads tab, click on "Choose your data download"
  3. You will see a pop up box that will allow you to choose either:
    1. Lead Time:  Data Download
    2. Moves:  Data Download
    3. OTIF:  Data Download
    4. PPV:  Data Download
  4. Choose the format:  Excel or CSV
  5. Then click download

The download will include all lines of data that were used to make the dashboard (it will not contain the actual charts)

 

Keep Going

Next Up:  Let's take a look at understanding the cash flow protection dashboard

 

 

 

Related articles

Powered by Zendesk