INDIAN JOURNAL OF SCIENCE AND TECHNOLOGY RESEARCH ARTICLE OPEN ACCESS Received: 20-01-2022 Accepted: 02-05-2022 Published: 21-06-2022 Citation: Chanda R, Pabalkar V, Gupta S (2022) A Study on Application of Linear Programming on Product Mix for Profit Maximization and Cost Optimization. Indian Journal of Science and Technology 15(22): 1067-1074. https://doi.org/ 10.17485/IJST/v15i22.164 * Corresponding author. ruby.chanda@sims.edu Funding: None Competing Interests: None Copyright: © 2022 Chanda et al. This is an open access article distributed under the terms of the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited. Published By Indian Society for Education and Environment (iSee) ISSN Print: 0974-6846 Electronic: 0974-5645 A Study on Application of Linear Programming on Product Mix for Profit Maximization and Cost Optimization Ruby Chanda 1* , Vanishree Pabalkar 2 , Sudeepa Gupta 3 1 Associate Professor Symbiosis Institute of Management Studies, Pune, India 2 Assistant Professor Symbiosis Institute of Management Studies, Pune, India 3 Research student, Symbiosis Institute of Management Studies, Pune, India Abstract Objectives: This research aims to sneak into the retailer’s perception about that customer segment and plan a product mix accordingly. The focus is on small players in small towns not having deep pockets to synergize the product mix decisions effectively. Methods: The data used in this research paper is from Hatchers, a medium-sized enterprise with zero budget for software for product mix decisions. The data was collected through face-to-face interviews with ten representatives and five supervisors in compliance with the existing documents and existing datasheet obtained from the production department, which was slightly updated to make the final output. The data was for one season, i.e., April to March. The data was analyzed to study pre-Linear Programming and post-Linear Programing profits. Findings: This examination distinguishes the current asset usage level and the benefit of every period of one of the apparel producing organizations, utilizing a linear programming procedure. Actual consumption of resources (product wise) was calculated to evaluate profit post applying Linear Programing to see the wastage and cost. There was a 54% increase post LP compared to the product-wise resource utilization. Similarly, the profit using Linear programming was more than double as wastage and costing were minimum, and revenue was high. Novelty: The article focused on the simple basic principle of linear programming for identifying product mix using Excel(Solver). LINGO. The software solutions become costlier for small firms, whereas Excel is more accessible and cost-efficient. There is a gap in existing literature as previous research has not focused on this aspect for small business houses where adapting software solutions is challenging. Keywords: Linear Programming; Profit maximization; Product Mix; Production; cost optimization 1 Introduction Every organization aims to make a proft for its continuous existence and growth. In present times, the challenge is more critical and prominent for manufacturing industries at all levels of creating goods of the right quality, quantity, and at the right time at the https://www.indjst.org/ 1067