Input files to help set up a price index in ProcureAnalytiq

Here are some excel file templates that will help to set up a price index

CSV file to load My Data Series data

Here is an template for loading My Data Series data.  It is a CSV file, which i use Excel to edit and make changes. 

Column B requires the price data. You can delete the rows (months) that you do not need. 

Click here to download file

Excel file to calculate Category Index

This file helps to calculate a category index. It is a simple template for a complex process. 

Click here to download the file

File to estimate cost driver %

Here is a simple Excel template to work out the feedstock and cost driver % to use in the price index model.  

Click here to download file

Procure Analytiq

DELIVER DIRECT MATERIAL SAVINGS

ProcureAnalytiq is an online cloud-based software tool to track market developments and leading indicators related the direct material purchases for your business. 

ProcureAnalytiq enables user to faster reaction to market changes, better negotiations, automated forecasting of material pricing, better internal and external communication, and ultimately reduces direct Raw Material prices.

Interested to explore more?  

businessanalytiq