EOQ Development Model in Optimize Raw Material Inventory

The purpose of this study was to determine the amount of safety inventory, order frequency, minimum inventory, maximum inventory limit, total Melon product inventory costs needed by PT. Rajawali Asia Bali uses the EOQ method. Data analyzed using the EOQ method shows that PT. Rajawali Asia Bali safety stock, it is very necessary to support the smooth distribution process that takes place. In accordance with the calculations with the formula, there is a safety stock that must be provided by PT. Rajawali Asia Bali is equal to 7,201 boxes. Planning for Sweet Corn products at PT. Rajawali Asia Bali using the EOQ method has 48.069 boxes.

Analisis Peramalan Volume Ekspor Melon di PT Bumi Sari Lestari Temanggung Jawa Tengah

Export is an activity of sending goods abroad carried out by a company to increase profits and obtain a better selling price. Companies can optimize profits by minimizing uncertainty in the future by calculating sales forecasting which is useful for planning product inventory to be marketed. PT. Bumi Sari Lestari is one of the exporters in Central Java which exports one of the vegetable and fruit horticultural commodities, namely melons. The purpose of this study was to determine how much the forecast value of the volume of melon exports for the first quarter and second quarter of 2020 at PT. Bumi Sari Lestari uses the trend analysis method. This research was conducted on January 13, 2020 - February 9, 2020 at PT. Bumi Sari Lestari, Temanggung, Central Java. Determination The location of the study was determined intentionally (purposive). The research method used in this research is a case study. The data used are PT Bumi Sari Lestari's melon export sales data in the period of 2017-2019 (time series), monthly data analyzed quarterly from January 2017 - December 2019 with a total of 12 observations. The data analysis method uses the quadratic trend analysis method. The data stationarity test results show that the data is stationary. Melon export volume forecasting results at PT. Bumi Sari Lestari using the quadratic trend method gets results for forecasting in the first quarter of 2020 amounted to 15,767,427 kg and in the second quarter of 2020 amounted to 9,916,788 kg.

Case Article—Swirltubs After-Market Product Inventory and Service Case

In the Swirltubs case, students apply expected value decision making to a knapsack problem for appliance repairmen. The case is based on a published research paper on work that was actually implemented for a major appliance manufacturer. The case features three parts: (1) problem understanding and definition; (2) optimization results for a small, test problem; and (3) creation and testing of a heuristic for a large-scale implementation that exceeds the limits of Microsoft Excel®. Optionally, an instructor can add risk-analysis simulation and reoptimization under uncertainty in subsequent parts of the project, making it a total of five parts. The case is highly interactive, owing to the relatively unstructured nature of the problem. I have implemented the case over a two- and three-week period format, with upper-level master’s in business administration or master’s in analytics students who have been exposed previously to optimization methods. It has been administered to dozens of students with generally positive feedback.

Perbandingan metode Double Exponential Smoothing dan Simple Moving Average pada kasus peramalan penjualan

Barokah Building Shop (TB. Barokah) located in Singosari, Malang, East Java is one of the shops that sells building materials. Some of the items being sold are white cement and black cement. The number of cement sales every month is very diverse and fluctuating. Black cement occupies a very high number compared to black cement on the sales chart every month. Likewise with the black cement from the Bosowa brand, white cement from the Gresik brand and the Tiga Roda brand, although demand is small, there is still a movement in the number of sales. The fluctuating amount of demand made the amount of product inventory prepared uncertain, which was influenced by the number of types and brands, so that the product inventory management had difficulty in supplying it. This study aims to predict the amount of cement sold in the following month, as well as to determine the performance between the two double exponential smoothing (DES) methods and the simple moving average (SMA) to forecast cement sales results in TB. Barokah. The SMA method is able and can perform forecasts with stable/constant demand or sales data. Meanwhile, the DES method is able and can provide values to the stratified weights with up to date data. DES is capable of forecasting cement sales each month with an average percentange error (PE) of 0.14%, while the SMA is with an average PE value of 1.35%. Based on the test results using data from TB. Barokah found that the most effective method is DES because it has a smaller PE value than the SMA.

Control of inventory system with random demand and product damage during delivery using the linear quadratic gaussian method

This study formulates a dynamical system for the control of a single product inventory system in accordance with the random value of demand and the percentage of damaged product during the delivery process. The formulated model has the form of a linear state-space system comprising of two disturbances, which represents the random value of demand and the percentage of the damaged product during delivery. The optimal value of the product amount ordered to the supplier is properly calculated by using the linear quadratic gaussian (LQG) method. The controller is used by the manager to make inventory level decisions under the uncertainty of demand and damaged items during the product delivery process. The result showed that the optimal product order for each review time was achieved, and the inventory level was used to obtain the right set point properly. Moreover, based on comparison with other research results, the proposed model was well performed.

Using Interactive Visual Analytics to Optimize in Real-Time Blood Products Inventory at a Blood Bank

Blood products and their derivatives are perishable commodities that require an efficient inventory management to ensure both a low wastage rate and a high product availability rate. To optimize blood product inventory, blood transfusion services need to reduce wastage by avoiding outdates and improve availability of different blood products. We used advance visualization techniques to design and develop a highly interactive real-time web-based dashboard to monitor the blood product inventory and the on-going blood unit transactions in near-real-time based on analysis of transactional data. Blood transfusion staff use the dashboard to locate units with specific characteristics, investigate the lifecycle of the units, and efficiently transfer units between facilities to minimize outdates.