Construction of linear programme model in excel solver

The article discusses the construction of a linear programming model in excel solver. It explains the optimal decision variable values, constraint levels, and potential areas of improvement. The article also provides a production schedule that can help the management of the company to distribute the resources in a way that assists the firm in cutting down the operating cost while increasing the revenue generated from the production and sales departments.