you will formulate an lp for a given problem and then you will solve it using cplex optimization studio. remember that you need to pull your parameters frim an excel file. please clearly indicate your decision variables,parameters,objectives fucntion and your constrains.

IE 220 - Operations Research Cplex Modelling Homework Casper Computer(CC) produces X model of computers of its own brand by assembling computer parts supplied from abroad and domestically, and sells them mainly domestically. The daily production capacity of CC is 30 computers. Assume that production continues throughout a week (7 days). The corresponding cost components for assembling, inspecting and packaging per computer is $90, S80 and $20, respectively. Additionally. CC has a warehouse to hold finished computers in inventory for future deliveries and the weekly inventory holding cost per computer is $15. In order to provide quality service, CC wishes to meet all customer orders without shortage. Orders for the next 6 weeks are as follows: Weeks Computer Orders 1 105 2 170 3 230 180 150 250 cim In the beginning of the first week, there are 15 units of finished X model of computers. First build the mathematical model and then use Cplex to solve the question. Also, provide all the details of your mathematical model and Cplex code clearly when submitting your homework. a) Assume that CC hired new workers and the daily production capacity is increased 5 units. Do you observe any change in the solution? b) CC is planning to consider overtime production to provide better service quality. If CC chooses to overproduction, CC can produce up to 30 computers overtime (in addition to regular production) at twice the regular production costs. How would you revise your mathematical model? Do you suggest overtime production? c) Assume that CC is planning to produce new product "Model Y" after improving production processes. The forecasted orders for this new model is provided below. Similar to Model X, CC can hold extra units of inventory in the warehouse with same inventory cost. Assume that the remaining cost parameters are same with Model X. CC can produce at most 40 units of computers (Model X and Model Y together) per day after the improvements. Note that the demand for "Model X" is same as given above. Weeks Computer Orders 1 55 2 100 - 80 120 100 110