Interviewer.
Hello everyone, today we have Sun Shangliang here for our CDA licensee interview. Can you tell us a little bit about what you do?

GUEST.

Hello everyone! My name is Sun Shangliang. I graduated from Harbin Institute of Technology and worked in New Industry Investment Group Co.

Question 1.
What must we do before a good production plan can be made?

GUEST.
To prepare a qualified production plan, the first requirement is that the operator has a sufficient understanding of the product to be produced, which includes the demand cycle of the product itself, manufacturing cycle, technical processes, manufacturing processes, manufacturing difficulties, etc., specifically subdivided into technical preparation stage, this stage is mainly to draw drawings and write technical specifications, raw materials procurement stage, production and receiving processing stage and assembly Of course, the theoretical summary is that on the one hand to meet the customer requirements of the three elements of "delivery, quality, cost" to plan, on the other hand is to make the enterprise itself to obtain appropriate benefits, and the three elements of production "materials, personnel, machinery and equipment "On the other hand, it is a plan to allocate the use of resources by making appropriate preparations for the three elements of production: materials, personnel, and machines and equipment.

A qualified production plan needs to be clear, unambiguous, and executable, so that the intent of the production plan is well understood by the executors, from the company's senior management to the specific job holders. To prepare a qualified production plan, we need to quickly identify the main bottlenecks or key influencing elements of product manufacturing, which may include the procurement of important raw materials, the processing and manufacturing of key components, the assembly of key parts, etc. We need to focus on the main bottlenecks, multi-level and multi-angle analysis, and the manufacturing department together, around the human, machine, material, method and environmental aspects, to find the cost, efficiency and We need to analyze the main bottlenecks from multiple levels and perspectives, and work with the manufacturing department to find an optimal solution in terms of cost, efficiency and cycle time.

Question 2.
What problems can data analysis solve in the material management procurement process?

GUEST.
As we all know, material procurement management is one of the important aspects of product manufacturing, limited by the enterprise's own technical capacity and manufacturing level, many key raw materials or processing processes we choose to outsource or outsource, where we usually consider several key elements, which are procurement cost, procurement efficiency, product or process quality and prevention of major risks, in the procurement process. Data analysis is of extreme strategic importance and is the core brain for optimizing the supply chain and procurement decisions, so doing a good job of data analysis is one of the most important aspects of the procurement process.

Here I can give a simple example, for example, we want to import a batch of important raw materials from abroad, the manufacturing cycle of this batch of raw materials itself is highly correlated with the procurement cost, while the subsequent processing of raw materials manufacturing difficulties, high scrap rate, this time we usually do it, generally will determine a specific analysis of the target, clear to achieve the final effect, while collecting data needed for data analysis, and The data needed for data analysis is collected, further organized and analyzed, and reflected in a very visual way.

In the example mentioned earlier, the main objective is to consider the optimal relationship between our stock material preparation and procurement cycle, to ensure that we have a low inventory backlog and low procurement costs, while ensuring that manufacturing is carried out properly, and that we have a comparative advantage in the whole morning negotiation process.

Question 3.
Purchasing is an important link in the enterprise inventory, providing data basis, can start from those aspects?

GUEST.
Procurement process data analysis and business processing, the link is actually relatively simple, but there are still more dimensions, of course, we must first determine a reason, that is, why we want to analyze, what is the purpose of the analysis, usually from the purchase price, procurement cycle, inventory, quality assurance period, the original inspection cycle, incoming re-inspection cycle, the stability of the supplier's supply quality, the actual performance, payment, the supplier's capacity. For example, the analysis of the weak link suppliers, all centralized procurement or single-source procurement, are not in line with the principle of maximizing benefits, we need to find the real root cause of the problem through analysis, so as to solve the outstanding problems and troubles.

Question 4.
Are there some good frameworks to recommend for enterprise operation data analysis?

Guest.
The company I used to work for is a diversified conglomerate, with subordinate segments including electricity, investment, real estate, manufacturing and other business clusters. We may be more concerned about the future market penetration of this industry, the degree of technological leadership, product market recognition and so on.

At the same time, we will also pay attention to and enter some new industries and some new projects. Overall, from the group company level, some of the more basic data indicators include normal financial indicators, such as revenue, profit, assets, liabilities and owners' equity.

For example, for the power sector, we will analyze its annual power generation, its overhaul cycle, its subsidies, its equipment operation, and its overall cost reduction, and for real estate companies, we will analyze its sales situation, including seasonal, time and location sales, consumers' willingness to consume, consumers' age composition, household assets and liabilities, etc. Household assets and liabilities, etc.

Question 5.
What are the most interesting or meaningful experiences you have encountered in your work? What did you learn from them? How do you think these experiences have influenced your professional development?

Guest.
At the end of each year, we will hold an annual business analysis meeting, which will be divided into departments and sections to explain the basic situation of the year, and will also put forward the target requirements for the coming year, and even make some reasonable suggestions on the market situation in the next few years. Some data comparison, can be counted as boring.

Since contact with data analysis, our analysis work has become much more vivid, on the basis of graphs, tables, text display, but also dynamic data display and exercise, the original relatively boring meeting was suddenly infected by such a new intuitive atmosphere, many colleagues and leaders will not help but to integrate into the common discussion and thinking, the meeting is no longer the original one-sided report, into I think this is the fun of learning data analysis, and the biggest gain from it.