August 2010 --Link-Belt is now in the process of deploying the Insights Analytics Purchase Price Variance (PPV) Data Mart for MAC-PAC XE. The data mart provides faster, easier access to historical vendor, purchase order (PO) and PPV information for analysis purposes. This is one of several solutions available within the MAC-PAC XE Insights Analytics framework delivered jointly with TDCI partner, Vizion Solutions, LLC.
Using Insights Analytics PPV, Link-Belt finance personnel can now easily report and analyze differences in purchase prices between the amount paid to the vendor and the planned or standard cost.
The PPV solution is accessed through Microsoft Excel which is a familiar and widely used application at most companies. The PPV solution comes with several pre-built Excel report templates with data that is refreshed daily from MAC-PAC XE. This reduces the burden on IT resources to build and run reports.
Link-Belt expects the PPV solution will save them considerable time every month as compared to the previous process of using MAC-PAC and custom reports. With the PPV data mart, information is updated daily instead of having to wait until month-end. The data is comprehensive and Excel is very flexible. The ability to drill down to vendor, invoice, item and PO detail will help Link-Belt better understand issues that need to be addressed, and can now be addressed sooner based on the timeliness of the data.
Link-Belt’s experience with the Insights Analytics PPV data mart will be highlighted at the September TDCI Customer Forum – Perspectives 2010. Plan now to attend.
Reporting and analytics solutions available for Insights Analytics for MAC-PAC XE include:
- Sales
- Finance
- Income Statement
- Balance Sheet
- Profitability
- Purchase Price Variance
- Inventory
- Movement
- Balance
- Manufacturing
- Order Analysis
- Efficiency Analysis
“Insights Analytics for MAC-PAC XE are standardized solutions that we tailor to each client’s unique requirements and implement very quickly,” says Ron Baerson, Sr. Solution Developer, Vizion Solutions, LLC.
