part b only

Q.1 ADN Company has contracted to deliver home doors over the next 6 months. The demands for each month are 100,250, 190, 140, 220, and 110 units, respectively. Production cost per door varies from month to month depending on the cost of labor, material, and utilities. ADN estimates the production cost per door over the next 6 months to be $50, $45, $55, $48, $52, and $50, respectively. To take advantage of the fluctuations in manufacturing cost, ADN may elect to produce more than is needed in a given month and hold the excess units for delivery in later months. This, however, will incur storage costs at the rate of $8 per door per month assessed on end-of-month inventory. a. Develop a LP to determine the optimum production schedule (Multiple Period Production-Inventory Model) b. olve the model using Excel Solver, create the reports. (Upload your excel file) c. [Bonus] Solve using Cplex