Example $4$: Production planning $2$

A manufacturing facility uses two production lines to produce three products

over the next $6$ months. Backlogged demand is not allowed. However, a

product may be overstocked to meet demand in later months. The following

table provides the data associated with the demand and storage of the three

products:

There is a fixed cost for switching a line from one product to another. The

following table gives the switching cost, the production rates and the unit

production cost for each line:

Develop a model for determining the optimal production schedule $16$ Develop an Excel Sheet that solves the optimum production scheduling problem