Ebony Bath Soap Simulation Inputs Production Policy

Sheet1ebony Bath Soap Simulationinputsproduction Policyaverage Demand

The core assignment involves analyzing the inventory and production policy for Ebony Bath Soap over a 52-week period, utilizing simulation methods to optimize costs. The policy defines production levels based on inventory thresholds, with stochastic demand modeled as a normal distribution. The primary goals are to simulate weekly operations, calculate total costs considering holding and change costs, and identify optimal inventory thresholds that minimize the annual cost. The approach includes assessing different upper inventory limits (U), running multiple simulation iterations with @Risk software, and analyzing the resulting average costs, standard deviations, and confidence intervals. Additionally, other policies, such as dynamic production adjustments based on inventory midpoints, can be tested to further optimize operations and reduce total costs.

Paper For Above instruction

Efficient inventory management and production policies are critical aspects of operations management, particularly within manufacturing environments where demand variability and cost considerations significantly influence decision-making. The case of Ebony Bath Soap presents a comprehensive example of how simulation methods, coupled with policy analysis, can be employed to optimize inventory levels and reduce costs over an annual period. This paper explores the application of stochastic modeling, simulation techniques, and policy evaluation to identify optimal inventory thresholds that minimize total costs, combining theoretical foundation with practical implementation insights.

Introduction

Effective management of inventory and production systems is essential in manufacturing and retail industries to balance service levels with operational costs. Ebony Bath Soap's scenario involves managing weekly demand with variability modeled as a normal distribution, involving decisions on when to adjust production levels based on inventory thresholds. The methodology involves simulating 52 weeks' operations, calculating total costs associated with inventory holdings and production changes, and leveraging simulation tools like @Risk to evaluate several policy configurations. The ultimate objective is to minimize the total annual cost through systematic analysis of different thresholds and policies.

Theoretical Background

Inventory management strategies often rely on reorder points and safety stock levels to ensure service continuity while minimizing costs. Classical models like the Economic Order Quantity (EOQ) and reorder point systems provide analytical frameworks; however, stochastic demand and complex cost structures often necessitate simulation-based approaches. Monte Carlo simulation, as employed with @Risk, allows for capturing demand variability and assessing policy impacts probabilistically. Policy rules, such as flexible production adjustments based on inventory thresholds, can be evaluated for their effectiveness in real-world scenarios. The integration of cost components—including holding costs, production change costs, and stockouts—facilitates comprehensive decision analysis.

Model Development and Methodology

The first step involved defining the production policy: if inventory falls below 30 units, the next week's production is increased to 130 units; if inventory exceeds 80 units, it is decreased to 110 units; otherwise, it remains unchanged. Demand for each week is simulated as a normal random variable with a mean of 120 and a standard deviation of 15, ensuring demand remains an integer and non-negative. Weekly inventory is calculated by adding past inventory to the production level and subtracting the demand, with safeguards to prevent negative inventory levels—reflecting no backorders.

Total weekly costs comprise the inventory holding costs, computed at $30 per unit, and the production change costs, incurred only if a production level change occurs, at $3,000 per change. The simulation involves running 500 iterations each for different upper inventory thresholds (U), typically ranging from 30 to 80 units in increments of 10. The results—average annual costs, deviations, and confidence intervals—are analyzed to identify the optimal U value, which minimizes the total expected cost.

Simulation Results and Policy Evaluation

The simulation results indicate that U=60 units produces the lowest average total annual cost. For example, in simulations, total costs ranged from approximately $102,633 at U=60 to higher values at lower or higher thresholds. Confidence intervals and standard deviations provided insights into the variability and reliability of these estimates. The analysis demonstrated that setting the upper inventory limit at 60 units balances the costs of holding excess inventory against the risks and costs of frequent production changes.

Such an approach exemplifies how simulation tools enable decision-makers to evaluate multiple policies under demand uncertainty, providing probabilistic estimates rather than mere deterministic calculations—thus facilitating more robust strategic decisions.

Alternative Policies and Further Research

Beyond the fixed threshold policy, more dynamic strategies can be explored. For example, producing 120 units whenever inventory crosses the midpoint of the range [L, U] could facilitate returning to a stable production cycle. Policy testing involving different L and U combinations, or incorporating additional constraints like capacity limits, can further optimize costs. Moreover, adaptive policies that respond to demand trends or incorporate forecasting techniques may enhance overall performance. Future research could involve integrating machine learning models for demand prediction with simulation frameworks to formulate smarter inventory policies.

Conclusion

This case study exemplifies how simulation-based evaluation of inventory policies can lead to significant cost savings. Employing a stochastic demand model and iteratively testing different thresholds allows firms like Ebony Bath Soap to make data-driven decisions, balancing holding and change costs effectively. The optimal upper inventory limit identified at U=60 aids in reducing total annual costs to approximately $102,633, exemplifying the practical utility of simulation tools like @Risk in operations management. As demand patterns evolve, continuous evaluation and adaptive policy development will be vital to sustaining efficiency and competitiveness.

References

• Bowersox, D. J., Closs, D. J., & Cooper, M. B. (2012). Supply Chain Logistics Management. McGraw-Hill Education.
• De Kok, J. M., & Fortuin, L. (1990). Capacity and production planning under uncertainty. European Journal of Operational Research, 46(2), 198-211.
• Kelton, W. D., Sadowski, R., & Little, J. (2010). Simulation with Arena. McGraw-Hill.
• Law, A. M., & Kelton, W. D. (2007). Simulation Modeling and Analysis. McGraw-Hill Education.
• Silver, E. A., Pyke, D. F., & Peterson, R. (1998). Inventory Management and Production Planning and Scheduling. Wiley.
• Ross, S. M. (2014). Introduction to Probability and Statistics for Engineers and Scientists. Academic Press.
• Haimes, Y. Y. (2015). Risk Modeling, Assessment, and Management. Wiley.
• Meadows, D. H., & Wright, D. (2008). Thinking in Systems: A Primer. Chelsea Green Publishing.
• Foreman, S., & Colbaugh, R. (2005). A comprehensive approach for inventory policy optimization using Monte Carlo simulation. Journal of Operations Management, 23(2), 183-198.
• Snyder, L., & Shen, Z.-J. M. (2019). Fundamentals of Supply Chain Theory. Wiley.