Each variable and solution must be clearly indicated on the excel worksheet, do not just solve the question, clearly define each variable and comment on the objective function and sensitivity analysis (explain each resulting sensitivity analysis page). Sensitivity analysis pages without your comments will not be graded.

2. The manufacturing process of a product consists of two successive operations, I and II. The following table provides the pertinent data over the months of June, July, and August: Producing a unit of the product takes .6 hour on operation I plus .8 hour on operation II. Overproduction of either the semifinished product (operation I) or the finished product (operation II) in any month is allowed for use in a later month. The corresponding holding costs are $.20 and $.40 per unit per month. The production cost varies by operation and by month. For operation 1, the unit production cost is $10,$12, and $11 for June, July, and August. For operation 2, the corresponding unit production cost is $15,$18, and $16. Determine the optimal production schedule for the two operations over the 3-month horizon