1. Formulate an LP model for this problem and answer the following . You must type your do not hand-write. Let Model 1 production unhtodel 2 production units, =.X and so on . a. Write the objective function b. Write the minimum and maximum production constraints for Model 1 C. Write the constraint that the total Frame Cusage for the production must not exceed d. Write the constraint that the total Fuel Tank Busage must not be below 50. e. Write the constraint that the combined usage of tanks A and B must be at most 110. f. Write the integer constraints for all decision variables. 2. Solve the problem by using the Spreadsheet (Excel) solver (analytic solver platform template provided . Show your answer in the spreadsheet 3. Answer the following question theoretically (without solving the model). If you ch integer tolerance from 0 to 0.1, how does your solution valuechaoptions include the following (1) solution becomes better, (2) solution becomes worse, (3) solution cannot b solution cannot be worse , and (3) solution will be unaffected . 4. Answer the following question theoretically (without solving the model). Can the comp more profit by negotiating with supplier to increase the availability of Engine B? Why or w 5. The company is considering eliminating the production of model 4 (least environ friendly model) to allocate more resources to production of other (greener) models. Can more profit by doing so? Re-solve the problem under this scenario. What is the new prof scenario? (Note: do not change anything in the Analytic Solver Platform; you only need some parameters in your spreadsheet before resolving the model .) 6. Considering the two options discussed above (with and without limitation on model 4 recommendation to the company as to what they should do with production planning ( should they choose ). Discuss pros and cons of each option