Linear Programming problem

Introduction to Linear Programming Problem (LPP): The video discusses LPP using MS Solver, focusing on Gunjan Sports Product Limited, a company that manufactures cricket balls. The assembly line has three processes: cutting and dying, stitching and assembling, and inspection and packaging.

Manufacturing Process and Constraints: The process involves specific time constraints for each stage: 12 minutes for cutting and dying (season ball), 6 minutes (tennis ball); 9 minutes for stitching (season ball), 15 minutes (tennis ball); and 6 minutes for inspection and packaging for both. Maximum production is 2,000 units each.

Formulating the LPP: The problem is formulated with decision variables X (season ball) and Y (tennis ball), and the objective is to maximize profit using the equation Z = 50X + 40Y. Constraints include production time limits and non-negativity.

Using Excel Solver: Instructions are provided for setting up and using Excel Solver, including enabling the solver add-in and defining the objective function, decision variables, and constraints. The solution yields a maximum profit of ₹94,000 by producing 1,400 season balls and 600 tennis balls.

Conclusion and Next Steps: The video concludes with a mention of the next topic, sensitivity analysis for the same problem. Viewers are encouraged to ask questions in the comments.