Use Lingo please.

Instructions For all questions except Question 4. you are not required to write the ob- jective function and constraints separately from the LINGO or the Excel Solver models. However, all variables must be defined, either in Word or pdf, or be imbedded on the LINGO or Excel Solver models. 3. (25 marks) A licence to shoot a moose costs $115 for residents and $920 for non- residents. The government must decide how many licences to issue in both cate- gories. There is a demand for up to 30,000 resident licences, and up to 12,000 non- resident licences; these are system constraints. The government has several goal priorities which in descending order of importance are (i) earn at least $12,006,000 in revenue (ii) issue at least 80% of licences to residents, and (iii) limit the total number of licences to 40,000. (a) Formulate this goal programming model. (b) Give the algebraic model for the first sub-problem, and solve this using LINGO or the Excel Solver (c) Embedding the solution from (b), give the algebraic model for the second sub- problem, and solve this using LINGO or the Excel Solver. (d) Embedding the solution from (c), give the algebraic model for the third sub- problem, solve this using LINGO or the Excel Solver, and state the overall solution in words. Instructions For all questions except Question 4. you are not required to write the ob- jective function and constraints separately from the LINGO or the Excel Solver models. However, all variables must be defined, either in Word or pdf, or be imbedded on the LINGO or Excel Solver models. 3. (25 marks) A licence to shoot a moose costs $115 for residents and $920 for non- residents. The government must decide how many licences to issue in both cate- gories. There is a demand for up to 30,000 resident licences, and up to 12,000 non- resident licences; these are system constraints. The government has several goal priorities which in descending order of importance are (i) earn at least $12,006,000 in revenue (ii) issue at least 80% of licences to residents, and (iii) limit the total number of licences to 40,000. (a) Formulate this goal programming model. (b) Give the algebraic model for the first sub-problem, and solve this using LINGO or the Excel Solver (c) Embedding the solution from (b), give the algebraic model for the second sub- problem, and solve this using LINGO or the Excel Solver. (d) Embedding the solution from (c), give the algebraic model for the third sub- problem, solve this using LINGO or the Excel Solver, and state the overall solution in words