• Arnav Desai
• Arham Jain
• Ayush Joshi

The main purpose of this paper is to improve the production planning of the selected company, by creating an optimum product mix and subsequently maximizing the total profit. As the company produces a variety of products, we found out the optimum quantities of each product. To keep the cost minimum, we have used Linear Programming Problem in Excel Solver to arrive at these optimum quantities, while also keeping in mind certain Time and Demand constraints. The result obtained through this entire process showed us the individual quantities in (Kgs per month) of the 5 products, in consideration with the maximum margin generation possible for the company in INR. The decision analysis also has a few specified assumptions such as quick and unlimited availability of raw materials. Our results showed that there was a potential for the company to earn a maximum margin of INR 4,149,565.86 by keeping a product mix that amounted to a total of 11,172.92 Kgs per month. These results will allow the top management of the company to take corrective decisions well in time, gain a core competency in cost reduction, and make the supply chain process more efficient.

Specialty Lubricants, Excel Solver, LPP, Profit Maximizing

"Profit Maximising for a Specialty Lubricants Company Via LPP", International Journal of Emerging Technologies and Innovative Research (www.jetir.org), ISSN:2349-5162, Vol.6, Issue 1, page no.356-363, January-2019, Available :http://www.jetir.org/papers/JETIR1901246.pdf

"Profit Maximising for a Specialty Lubricants Company Via LPP", International Journal of Emerging Technologies and Innovative Research (www.jetir.org | UGC and issn Approved), ISSN:2349-5162, Vol.6, Issue 1, page no. pp356-363, January-2019, Available at : http://www.jetir.org/papers/JETIR1901246.pdf