Author(s) :

Dr. S. Usha, Ranjithamani K.

Volume/Issue :

Abstract :

This paper explores the application of mathematical optimization techniques to enhance production planning decisions using Excel Solver. The objective is to demonstrate how organizations can improve efficiency, reduce costs, and optimize resource utilization by formulating and solving linear programming models within a spreadsheet environment. The study involves the development of a production planning model that integrates constraints such as labor hours, material availability, demand requirements, and production capacities. Excel Solver is employed as a user-friendly and accessible tool for implementing these optimization models, enabling decision-makers without advanced programming skills to perform complex analyses. Results show that the optimized plans significantly outperform heuristic or manual approaches, yielding higher profitability and better resource alignment. The findings highlight the practicality and effectiveness of Excel Solver in operational decision-making contexts, particularly for small to medium-sized enterprises seeking low-cost optimization solutions. This research underscores the importance of incorporating quantitative methods into business processes and illustrates how spreadsheet-based tools can support data-driven, strategic production planning.

No. of Downloads :

0