please answer eith excel!!

4. (20 marks) A licence to shoot a moose costs $120 for residents and $900 for nonresi- dents. The government must decide how many licences to issue in both categories. There is a demand for up to 30,000 resident licences, and up to 10,000 nonresident licences; these are system constraints. The government has several goal priorities which in descending order of importance are (i) earn at least $11,500,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. I (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 subproblem, and solve this using LINGO or the Excel Solver. (d) Embedding the solution from (e), give the algebraic model for the third subproblem solve this using LINGO or the Excel Solver, and state the overall solution in words