• Title/Summary/Keyword: Inventory Turnover

Search Result 42, Processing Time 0.018 seconds

Development of Distributed MRP System for Production Planning and Operation in Korean OEM/ODM Cosmetics Manufacturing Company (국내 OEM/ODM 화장품 제조기업의 생산계획 및 효율화를 위한 분산형 MRP시스템 개발)

  • Jang, Dongmin;Shin, Moonsoo
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.43 no.4
    • /
    • pp.133-141
    • /
    • 2020
  • Up to date cosmetic OEM/ODM (original equipment manufacturing/original development manufacturing) industry receives attention as a future growth engine due to steady growth. However, because of limited research and development capability, many companies have employed commercial management platforms specialized for large-sized companies; thus, overall system effectiveness and efficiency is low. Especially, MRP (material requirement planning) system introduced originally in 1970s is employed to calculate the requirement of the parts. However, dynamic nature of production lead time usually results in incorrect requirements. In addition, its algorithm does not consider the capability of the production resources. Also, because the commercial MRP system calculates all subcomponent for fixed period, the more goods have subcomponent, the slower calculation is. Therefore, conventional MRP system cannot respond complicated situation in time. In this study, we will suggest a new method that can respond to complicated situations resulting from short lead time and urgent production order in Korean cosmetic market. In particular, a distributed MRP system is proposed, that consists of multi-functional and operational modules, based on the characteristic of the BOM (bill of material). The distributed MRP system divides components (i.e. products and parts) into several fields and decrease the problem size; thus, we can respond to dynamically changed data any time. Through this solution, we can order components quickly, adjust schedules and planned quantity, and manage stocks reasonably. In addition, a prototype of the distributed MRP system is presented in this paper, in which ERP (enterprise resource planning) sever data is associated with an excel spreadsheet via MSsql. System user interface is implemented by a VBA (visual basic for applications) tool. According to a case study, response rate for delivery and planning achievement rate were enhanced about 20%, and inventory turnover was also decreased. Consequently, the proposed system improves overall profit.

Development of a Detection Model for the Companies Designated as Administrative Issue in KOSDAQ Market (KOSDAQ 시장의 관리종목 지정 탐지 모형 개발)

  • Shin, Dong-In;Kwahk, Kee-Young
    • Journal of Intelligence and Information Systems
    • /
    • v.24 no.3
    • /
    • pp.157-176
    • /
    • 2018
  • The purpose of this research is to develop a detection model for companies designated as administrative issue in KOSDAQ market using financial data. Administration issue designates the companies with high potential for delisting, which gives them time to overcome the reasons for the delisting under certain restrictions of the Korean stock market. It acts as an alarm to inform investors and market participants of which companies are likely to be delisted and warns them to make safe investments. Despite this importance, there are relatively few studies on administration issues prediction model in comparison with the lots of studies on bankruptcy prediction model. Therefore, this study develops and verifies the detection model of the companies designated as administrative issue using financial data of KOSDAQ companies. In this study, logistic regression and decision tree are proposed as the data mining models for detecting administrative issues. According to the results of the analysis, the logistic regression model predicted the companies designated as administrative issue using three variables - ROE(Earnings before tax), Cash flows/Shareholder's equity, and Asset turnover ratio, and its overall accuracy was 86% for the validation dataset. The decision tree (Classification and Regression Trees, CART) model applied the classification rules using Cash flows/Total assets and ROA(Net income), and the overall accuracy reached 87%. Implications of the financial indictors selected in our logistic regression and decision tree models are as follows. First, ROE(Earnings before tax) in the logistic detection model shows the profit and loss of the business segment that will continue without including the revenue and expenses of the discontinued business. Therefore, the weakening of the variable means that the competitiveness of the core business is weakened. If a large part of the profits is generated from one-off profit, it is very likely that the deterioration of business management is further intensified. As the ROE of a KOSDAQ company decreases significantly, it is highly likely that the company can be delisted. Second, cash flows to shareholder's equity represents that the firm's ability to generate cash flow under the condition that the financial condition of the subsidiary company is excluded. In other words, the weakening of the management capacity of the parent company, excluding the subsidiary's competence, can be a main reason for the increase of the possibility of administrative issue designation. Third, low asset turnover ratio means that current assets and non-current assets are ineffectively used by corporation, or that asset investment by corporation is excessive. If the asset turnover ratio of a KOSDAQ-listed company decreases, it is necessary to examine in detail corporate activities from various perspectives such as weakening sales or increasing or decreasing inventories of company. Cash flow / total assets, a variable selected by the decision tree detection model, is a key indicator of the company's cash condition and its ability to generate cash from operating activities. Cash flow indicates whether a firm can perform its main activities(maintaining its operating ability, repaying debts, paying dividends and making new investments) without relying on external financial resources. Therefore, if the index of the variable is negative(-), it indicates the possibility that a company has serious problems in business activities. If the cash flow from operating activities of a specific company is smaller than the net profit, it means that the net profit has not been cashed, indicating that there is a serious problem in managing the trade receivables and inventory assets of the company. Therefore, it can be understood that as the cash flows / total assets decrease, the probability of administrative issue designation and the probability of delisting are increased. In summary, the logistic regression-based detection model in this study was found to be affected by the company's financial activities including ROE(Earnings before tax). However, decision tree-based detection model predicts the designation based on the cash flows of the company.