please read insturctions to answer the question

Instructions Questions 1 and 2 are to be done by hand, showing all the steps needed to derive the answers. [Of course, you could use LINGO or the Excel Solver to verify your answers, but this is not to be submitted.] Use Word or pdf for this question; if making the solutions with cursive writing, please be neat. For Questions 3 and 4, a computer-based sensitivity analysis needs to be performed. For each question, on LINGO you need a file for the model, the solution report, and the range report. For Excel, one file with nine tabs can be used; for each of the three questions, there is the model, the Answer Report, and the Sensitivity Report. Use Word or pdf to give the answers to the sensitivity questions. For each give part, write a couple of sentences; don't just submit a numerical answer. 3. (20 marks) Every operating day an oil refinery requires at least 2100 kilograms (kg) of chemical A, 2780 kg of chemical B, and 1500 kg of chemical C. They externally purchase two types of bags which contain these chemicals. Each type 1 bag contains 17.5 kg of chemical A, 10 kg of B, and 2.5 kg of C. Each type 2 bag contains 8.75 kg of chemical A, 14 kg of B, and 15 kg of C. A type 1 bag costs $140, while a type 2 bag costs $200. Storage limitations mean that no more than 290 bags of both types combined) can be purchased each day. They wish to minimize the daily cost of buying these bags. (Because of the repetitive nature of the operations, the number of bags need not be integer.) We define X and X2 to be respectively the number of type 1 and 2 bags purchased each day. minimize 140X1+ 200X2 subject to Chemical A 17.5x, +8.75X2 > 2100 Chemical B 10X1 +14X2 > 2780 Chemical C 2.5X1 + 15X2 > 1500 Storage X1 + X2 3 290 X1, X2 > 0 (a) Use either LINGO or the Excel Solver to create the reports needed for sensitiv- ity analysis. (b) What happens to the OFV in the following scenarios? (each is independent of the others) (i) The storage capacity falls by 30 bags. (ii) The price per bag of Type I falls by $90. (iii) The price per bag of Type 2 falls by $10. (iv) The price per bag of Type 1 falls by $40 while the price per bag of Type 2 increases by $380. (v) The company could decrease what they have to buy of Chemical B by making up to 500 kgs of Chemical B in its own operations at a cost of $5/kg. (vi) The company could decrease what they have to buy of Chemical C by making up to 300 kgs of Chemical C in its own operations at a cost of $0.40/kg