When you go shopping in the supermarket, many people will take a rough inventory of the items they need to buy and then understand what they need to purchase and make targeted purchases. It is not difficult to find a lot of goods will be bundled sales, such as toothpaste and toothbrush, we buy toothpaste in mind may not have a special designated brand, this time in the eyes of the eyes swept a toothpaste, but also comes with a toothbrush, in the same price goods, I believe that the chances of everyone buy away this toothpaste will greatly increase ......
Companies purchasing related resources and looking for suppliers will also analyze the data by asking for quotes, comparing prices, etc. to find a reliable partner. ......
Small to our daily life procurement, large to the enterprise resource procurement, these are inseparable from the analysis of procurement data.
Nowadays, some small and medium-sized enterprises still need to manually analyze the data in a timely manner, for example, the purchasing manager wants to check the situation of purchasing from ordering to warehousing, and needs to log in to the supply chain module of the Kingdee or UFIDA system several times to check the data of the outsourcing purchase orders and other warehousing orders which need to be clicked on several times to check different documents. ...... These are all headaches for the purchasing department.
You want to do procurement analysis report, analyze which suppliers are better quality, to understand the company's annual procurement amount, material procurement details and so on, not only to take the number of complex and cumbersome, looking at the Excel table listed full of data, but also to extract effective information from it, the purchasing department said: "We are really too difficult to o (╥﹏╥)o ".
Then there is no ready-made report template, directly to the number of want to show together?
The answer is yes.
Today I will share with you the procurement analysis theme model provided by Digital Forest BI for enterprises, as follows:
In this analysis theme, the company's procurement situation at a glance.
From the "Annual Purchase Amount" and "Monthly Purchase Amount" bar charts, we can see the number of purchases per year and month.
From the "Material Purchase Amount Percentage" chart, double-click to see the breakdown of the percentage of each material. As shown in the following figure:
From the "Supplier Purchase Amount" figure, you can see the percentage of the purchase amount of suppliers in different regions, and double-click can also understand the specific supplier's share of the situation. As shown in the figure below:
From the "Material Distribution Scatter Diagram", you can clearly understand the amount and quantity of different materials, you can also double-click to drill down to get the material composition. In the figure below, we click on "Outsourced Semi-Finished Goods" to see the composition of all materials under this material.
From the "Supplier Purchases" chart, you can quickly view the number of varieties, purchase quantities, and amounts purchased by suppliers, as shown in the following chart:
From the "Material Purchases" chart, you can easily view the specific purchases of different materials, as shown in the following chart. The details of different materials can be easily viewed from the "Material Purchase" chart, as shown below.
From the "Material Purchase Details" chart, you can directly watch which suppliers of each commodity and the corresponding historical transaction prices.
......
Of course, the most powerful part of BI analytics is that it is a dynamic visualization. These charts are not just static displays, it can also be linked between the charts, drill down and other operations. For example, we can view a specific year and month of a supplier's procurement, the following chart, the relevant charts will be linked to each other.
In short, analyzing purchasing involves too many aspects, from different dimensions of sub-groups, companies, suppliers, commodities, purchasing departments, purchasers, etc., to look at the historical price trends of purchasing and analyze the bargaining power of purchasers; analyze the quality of suppliers in terms of the number of returned items, quantity, amount of the percentage, and the trend of the frequency of returns, etc.; analyze the return of funds in relation to the accounts payable, and analyze the timeliness in relation to the delivery date of the order. ......
If you have other logical needs, you can also use our BI Theme Design module to design a purchasing analysis report that meets your organization's needs. Due to the length of this article, we will share with you how the above purchasing analysis theme is implemented.
Want to know more? Welcome to enter our digital forest information official website to see other content Oh ~