Effective inventory management primarily relies on precise demand forecasting, an essential yet challenging aspect for companies pursuing operational excellence. This paper outlines the design and implementation of a forecasting interface integrated with a sales dashboard to enhance demand prediction accuracy and inventory decision-making. The interface incorporates four established forecasting techniques—Naïve, Moving Average, Weighted Moving Average, and Exponential Smoothing—to systematically address demand fluctuations. Created in Excel and automated with VBA, it provides reorder points, safety stock levels, and forecasted demand, along with other distinctly user-friendly inputs and outputs. In addition, a dynamic sales dashboard has been developed with visual features representing historical and projected demand, sales distribution by products and regions which further facilitate detailed analysis and informed inventory management decisions. This study outlines the interface and dashboard development process along with important codes. It also highlights the practical implications of integrating technical forecasting methods with intuitive visualization tools to enhance inventory management substantially. The forecasting interface and sales dashboard were further verified and validated through different scenarios including: high demand in season peaks, managing with variation in lead time issues, and forecasting in case of launching new product.

In this study, an Economic Return Quantity (ERQ) model for the Empty Container Reposition (ECR) problem using the reverse logistics (RL) approach is developed. Some of the model’s primary considerations are the return rate that depends on the quantity and quality of the empty container, and the capacity constraints to hold the empty container in the port. The model of ERQ is optimized using an analytical approach. Based on the result of the hypothetical case, the authors examined that the acceptable quality level of reusable containers should be set at 67%, 55%, and 50% for the three types of containers to be able to obtain minimum inventory costs. Two cases of binding and nonbinding constraints are investigated, and it is found that the binding constraint gives 3.4% higher cost than the latter. The results of this study help the container depots to plan, manage, and handle empty containers so that the container utility can be increased, and inventory costs can be minimized.

Today, improving machine availability is vital for industries to compete in the global market. Spare parts play an essential role in the maintenance and repair of equipment, but planning an extensive network in strategic industries with various spare parts can be very challenging due to the existence of different decision factors. The spare parts supply chain deals with inventory management issues, which necessitates considering the related decisions such as determining the stock level and order quantity. Moreover, demand uncertainty and long supply time make decision-making more complex. This paper presents a repair and supply planning model for repairable spare parts while considering a modified formulation of demand uncertainty to minimize costs. The model determines the optimal stock level, lateral transshipment, assignment of spare part orders to suppliers, equipment to repair centers, and the number of intervals over the planning horizon used in demand estimation. This research contributes to the literature by integrating recent decisions, using demand approximation by piecewise linearization, and considering backorder in warehouses evaluated by queuing models. A hybrid approach, including heuristic and genetic algorithms, is used to optimize the model using data from an oil company. The results show that using piecewise linearization and integrated repair and supply planning decisions optimizes costs and improves performance. Also, the availability is affected by the demand estimation, which necessitates precision prediction.

Deteriorating inventory models are used as decision support tools for managers primarily, although not exclusively, in the retail trade. The mathematical modeling of deteriorating items allows managers to analyze their inventory management systems to identify areas that can be improved and to measure the corresponding potential benefits. This study develops an enhanced deteriorating inventory model for optimizing the inventory control strategy of companies operating in sectors with deteriorating products. In contrast with previous studies, our model holistically accounts for the overall financial effect of a company’s policies on product price discounting and on inventory shortages while considering the time value of money (TVM). We aim to find the optimal replenishment strategy and the optimal price reductions that maximize the discounted profit function of this analytical model over a fixed planning horizon. To this end, we use an economic order quantity model to study the effects of the TVM and inflation. The model accounts for pre- and post-deterioration discounts on the selling price for non-instantaneous deteriorating products with the demand rate being a function of time, price-discounts and stock-keeping units. Shortages are allowed and partially backordered, depending on the waiting time until the next replenishment. Additionally, we consider the effect of discounts on the selling price when items have either an instant deterioration or a fixed lifetime. We propose five implementable solutions for obtaining the optimal values, and examine their performance. We present some numerical examples to illustrate the applicability of the models, and carry out a sensitivity analysis. The study reveals that accounting for TVM and inventory shortages is complex and time-consuming; nevertheless, we find that accounting for TVM and shortages can be valuable in terms of increasing the yields of companies. Finally, we provide some important managerial implications to support decision-making processes.

A real inventory system for single item with specific demand characteristics motivates this works. The demand can be seen as two types of independent demand, where compound Poisson process describes the characteristics of each demand. The first type of demand is rarely occurred with relatively large size, while the second type of demand is often happened with relatively small size. In order to maintain inventory level, every time the first type of demand occurs a replenishment of stock is conducted which follows order-up-to-level inventory policy. In order to find the optimal inventory decision for that system, a mathematical model of the system is developed with the objective to minimize expected total inventory cost. Some of model assumptions are infinite replenishment, deterministic lead time, and completely backlogged shortages. To solve the model, it is then divided into two sub-problems and classical optimization technique is employed to help find the solution of each sub problem.

Quality decisions are one of the major decisions in inventory management. It affects customer’s demand, loyalty and customer satisfaction and also inventory costs. Every manufacturing process is inherent to have some chance causes of variation which may lead to some defectives in the lot. So, in order to cater the customers with faultless products, an inspection process is inevitable, which may also be prone to errors. Thus for an operations manager, maintaining the quality of the lot and the screening process becomes a challenging task, when his objective is to determine the optimal order quantity for the inventory system. Besides these operational tasks, the goal is also to increase the customer base which eventually leads to higher profits. So, as a promotional tool, trade credit is being offered by both the retailer and supplier to their respective customers to encourage more frequent and higher volume purchases. Thus taking into account of these facts, a strategic production model is formulated here to study the combined effects of imperfect quality items, faulty inspection process, rework process, sales return under two level trade credit. The present study is a general framework for many articles and classical EPQ model. An analytical method is employed which jointly optimizes the retailer’s credit period and order quantity, so as to maximize the expected total profit per unit time. To study the behavior and application of the model, a numerical example has been cited and a comprehensive sensitivity analysis has been performed. The model can be widely applicable in manufacturing industries like textile, footwear, plastics, electronics, furniture etc.

Activity-Based-Model (ABC) is used for the purpose of significant improvement for overhead accounting systems by providing the best information required for managerial decision. This pa-per discusses implacability of ABC technique on inventory valuation as a management account-ing innovation. In order to prove the applicability of ABC for inventory control a material driven medium-sized and privately owned company from engineering (iron and steel) industry is select-ed and by analysis of its production process and its material dependency and use of indirect in-ventory, an ABC model is explored for better inventory control. The case revealed that the ne-cessity of ABC in the area of inventory control is significant. The company is not only able to increase its quality of decision but also it can significantly analyze its cost of direct material cost, valuation of direct material and use its implications for better decision making.

When a supplier announces a price increase at a certain time in the future, for each retailer it is important to choose whether to purchase supplementary stock to take benefit of the current lower price or procure at a new price. This article focuses on the possible effects of price increase on a retailer’s replenishment strategy for constant deterioration of items. Here, quadratic demand is debated; which is appropriate for the products for which demand increases initially and subsequently it starts to decrease with the new version of the substitute. We discuss two scenarios in this study: (I) when the special order time coincides with the retailer’s replenishment time and (II) when the special order time falls during the retailer’s sales period. We determine an optimal ordering policy for each case by maximizing total cost savings between special and regular orders during the depletion time of the special order quantity. Scenarios are established and illustrated with numerical examples. Through, sensitivity analysis important inventory parameters are classified. Graphical results, in two and three dimensions, are exhibited with supervisory decision.

The present study investigates an inventory model for non-instantaneous deteriorating items under inflationary conditions with partially backlogged shortages. In today’s market structure consumers are looking for goods for which there is a delay in deterioration. At the same time, the consumers’ willingness to wait has been decreased over time, which leads to lost sales. Moreover in financial decision-making, the effects of inflation and time value of money cannot be oblivious to an inventory system. In this scenario, managing inventory of goods remains a challenging task for the decision makers, who may also have to rent warehouse under different prevailing factors such as, bulk discount, limited space in the retail outlet, or increasing inflation rates. With a focus on reduction of costs and increasing customer service, warehouse decision models are crucial for an organization’s profitability. Hence a mathematical model has been developed in the view of above scenario, in order to determine the optimal policy for the decision maker, by minimizing the present worth of total cost. The optimization procedure has been illustrated by a numerical example and detailed sensitivity analysis of the optimal solution has been performed to showcase the effect of various parameters. Managerial implications has also been presented to aid the decision making process.

As the long arm of the grinding, deep financial crisis continues to haunt the global economy, the effects of inflation and time value of money cannot be oblivious to an inventory system. Inflation, defined as a general rise in the prices of goods and services over a period of time, has monetary depreciation as one of its major side effects. And, since inventories correspond to substantial investment in capital for any organization, it would be unethical if the effects of inflation and time value of money are not considered while determining the optimal inventory policy. Moreover, deterioration of items is a phenomenon which cannot be ignored, as it may yield misleading results. Further, under the inflationary conditions, the different cost parameters including the price are bound to vary from cycle to cycle over the planning horizon. Another important factor is shortages which no retailer would prefer, and in practice are partially backlogged and partially lost. In order to convert the lost sales into sales, the retailer offers such customers an incentive, by charging them the price prevailing at the time of placing an order, instead of the current inflated price. Therefore, bearing in mind these facts, the present paper develops an inventory model for a retailer dealing with deteriorating items under inflationary conditions over a fixed planning horizon. The objective is to derive the optimal number of cycles and cycle length that maximizes the net present value of the total profit over a fixed planning horizon. An appropriate algorithm has been proposed to obtain the optimal solution. Finally, a numerical example is provided to illustrate the proposed model. Sensitivity analysis of the optimal solution with respect to major parameters is carried out and some managerial inferences have been presented.