Excel Estimation Software 【Case Study: Procurement Management in the Purchasing Department】
Procurement management in the purchasing department
Excel Estimation Software 【Case Study: Procurement Management in the Purchasing Department】
Case Study of the Implementation of Excel Software 'CHANGE' for Cost Estimation in Manufacturing Industry: 'Procurement Management in the Purchasing Department' [Needs] Purchasing Department (Procurement activities for raw materials and parts) ◇ In the purchasing department, which sources over 50% of product costs externally, suppliers were selected based solely on price through competitive bidding. However, as target costs have become stricter, it has become increasingly difficult to find companies that can meet these requirements. ◇ Due to procurement at unreasonable prices, there have been frequent quality issues after product completion, leading to an overall increase in costs when including hard-to-capture expenses. [Implementation Results] ◇ The ordering side can evaluate the costs of the receiving side, reducing unreasonable price reductions due to power dynamics. ◇ Potential issues after transactions can be prevented in advance. ◇ More appropriate item procurement considerations and feedback to development and design departments can be realized. ◇ Through cost evaluation, the desired suppliers for the company become clear, enabling supplier development and evaluation. *You can view the list of case studies from the catalog download.
Inquire About This Product
basic information
Case Study of the Implementation of Excel Software 'CHANGE' Created for Cost Estimation in Manufacturing Industry: 'Procurement Management in the Purchasing Department' 【Needs】 Purchasing Department (Procurement Activities for Raw Materials and Parts) ◇ In the purchasing department, which sources over 50% of product costs externally, suppliers were selected based solely on price through competitive bidding. However, as target costs have become stricter, it has become increasingly difficult to find companies that can meet these requirements. ◇ Due to procurement at unreasonable prices, there have been frequent quality issues after product completion, leading to an overall increase in costs when including hard-to-capture expenses. 【Implementation Results】 ◇ The ordering side can evaluate the costs of the receiving side, reducing unreasonable price reductions due to power dynamics. ◇ Potential issues after transactions can be prevented in advance. ◇ More appropriate item procurement considerations and feedback to development and design departments can be realized. ◇ Through cost evaluation, the desired suppliers for the company become clear, enabling supplier development and assessment. *You can view the list of case studies from the catalog download.
Price information
-
Delivery Time
Applications/Examples of results
[Field] Purchasing department of the manufacturing industry (procurement activities for raw materials and components)
catalog（1）
Download All Catalogs
Company information
We provide practical guidance on achieving target costs in product development, assessing and evaluating purchase prices in procurement, improving costs during the manufacturing stage, and advancing market development, with a focus on the manufacturing industry and enhancing profitability from the perspective of product and component costs. When advancing cost improvement activities for products and components, it is essential to first understand what costs make up the cost of those products or components. Then, we eliminate waste, inefficiency, and inconsistency from the factors that constitute the cost. As a result, cost reductions can be achieved. Our company offers guidance on cost management and provides estimation software for calculating the costs of products and components, aiming to enhance the efficiency of cost analysis.