Question: Please show Excel/lingo for all c,b,d 2. (25 marks) A licence to shoot a moose costs $115 for residents and $920 for non- residents. The

Please show Excel/lingo for all c,b,d

2. (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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

PLEASE DO D 2. (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...

****USE LINGO**** answers hsing excel woll be reported as incorrect. please state all relevant steps and give lingo code. 2. (25 marks) A licence to shoot a moose costs $115 for residents and $920...

PLEASE DO C 2. (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...

Please solve using Lingo. 2. (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....

2. (25 marks) A licence to shoot a moose costs $115 for residents and $920 for nonresidents. The government must decide how many licences to issue in both categories. There is a demand for up to...

IF YOU USE EXCEL SOLVER IT WILL BE HEAVILY DOWNVOTED. USE LINGO PLEASE!!!!! 3. (25 marks) A licence to shoot a moose costs $115 for residents and $920 for non- residents. The government must decide...

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....

Please use LINGO to solve! Thank you 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-...

Fairmont Textile has a plant in which employees have been having trouble with carpal tunnel syndrome (CTS, an inflammation of the nerves that pass through the carpal tunnel, a tight space at the base...

For this project you are developing part of an application for a small college to retrieve and display student records. As part of the project you will create three classes,(Classroom, Course,...

14. Supernormal Growth (LO1) Rabbit Town Corp. is experiencing rapid growth. Dividends are expected to grow at 30 percent per year during the next three years, 20 percent over the following year, and...

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....