Homework Help is Here – Start Your Trial Now!
Business
Operations Management
The government is auctioning off oil leases at two sites. At each site, 150,000 acres of land are to be auctioned. Cliff Ewing, Blake Barnes, and Alexis Pickens are bid- ding for the oil. Government rules state that no bidder can receive more than 45% of the land being auctioned. Cliff has bid $2000 per acre for site 1 land and $1000 per acre for site 2 land. Blake has bid $1800 per acre for site 1 land and $1500 per acre for site 2 land. Alexis has bid $1900 per acre for site 1 land and $1300 per acre for site 2 land. a. Determine how to maximize the government’s revenue with a transportation model. b. Use SolverTable to see how changes in the government’s rule on 45% of all land being auctioned affect the optimal revenue. Why can the optimal revenue not decrease if this percentage required increases? Why can the optimal revenue not increase if this percentage required decreases?

The government is auctioning off oil leases at two sites. At each site, 150,000 acres of land are to be auctioned. Cliff Ewing, Blake Barnes, and Alexis Pickens are bid- ding for the oil. Government rules state that no bidder can receive more than 45% of the land being auctioned. Cliff has bid $2000 per acre for site 1 land and $1000 per acre for site 2 land. Blake has bid $1800 per acre for site 1 land and $1500 per acre for site 2 land. Alexis has bid $1900 per acre for site 1 land and $1300 per acre for site 2 land. a. Determine how to maximize the government’s revenue with a transportation model. b. Use SolverTable to see how changes in the government’s rule on 45% of all land being auctioned affect the optimal revenue. Why can the optimal revenue not decrease if this percentage required increases? Why can the optimal revenue not increase if this percentage required decreases?

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter7: Nonlinear Optimization Models
Section: Chapter Questions
Problem 56P
See similar textbooks
icon
Related questions
Question

Are my formulas, Solver inputs and SolverTable inputs correct? If not please show where I went wrong and how to fix it.

 
The government is auctioning off oil leases at two sites. At each site, 150,000 acres of land are to be auctioned. Cliff Ewing, Blake Barnes, and Alexis Pickens are bid- ding for the oil. Government rules state that no bidder can receive more than 45% of the land being auctioned. Cliff has bid $2000 per acre for site 1 land and $1000 per acre for site 2 land. Blake has bid $1800 per acre for site 1 land and $1500 per acre for site 2 land.
Alexis has bid $1900 per acre for site 1 land and $1300 per acre for site 2 land.
a. Determine how to maximize the government’s
revenue with a transportation model.
b. Use SolverTable to see how changes in the
government’s rule on 45% of all land being auctioned affect the optimal revenue. Why can the optimal revenue not decrease if this percentage required increases? Why can the optimal revenue not increase if this percentage required decreases?
A 1 Oil lease auction 2 3 Bids for sites (dollars/acre) 4 5 Ewing 6 Barnes 7 Pickens 8 9 Max % that can be sold to any bidder 10 11 Number of acres sold to bidders 12 13 Ewing 14 Bames 15 Pickens 16 Total 17 18 Available 19 20 Revenue (Smillions) 21 22 23 24 25 26 27 28 29 30 31 32 V 33 in 34 35 36 37 38 39 40 ent Point 91D P5-43 fx (6 B P5-46 Site 1 $2,000 $1,800 $1,900 Site 1 0 $150,000 C Site 2 $1,000 $1,500 $1,300 0.45 Site 2 0 $150,000 P5-46 part B D JUN 20 Total 0 0 0 $300,000 <= <= K= E Set Objective: Max allowed 135000 135000 135000 O Max F A Solving Method To: By Changing Variable Cells: $B$13:$C$15 $B$20 Stocks W Min G Solver Parameters Subject to the Constraints: SBS 16:$C$16 <= $F$13:$F$14 SD$13:$D$15 <= $B$18:$D$18 Value Of: Make Unconstrained Variables Non-Negative Select a Solving Method: Simplex LP Geography H 0 Add Change Delete Reset All Load/Save Options 27 J Y Sort Filter K L Clear Reapply Advanced M
Transcribed Image Text:A 1 Oil lease auction 2 3 Bids for sites (dollars/acre) 4 5 Ewing 6 Barnes 7 Pickens 8 9 Max % that can be sold to any bidder 10 11 Number of acres sold to bidders 12 13 Ewing 14 Bames 15 Pickens 16 Total 17 18 Available 19 20 Revenue (Smillions) 21 22 23 24 25 26 27 28 29 30 31 32 V 33 in 34 35 36 37 38 39 40 ent Point 91D P5-43 fx (6 B P5-46 Site 1 $2,000 $1,800 $1,900 Site 1 0 $150,000 C Site 2 $1,000 $1,500 $1,300 0.45 Site 2 0 $150,000 P5-46 part B D JUN 20 Total 0 0 0 $300,000 <= <= K= E Set Objective: Max allowed 135000 135000 135000 O Max F A Solving Method To: By Changing Variable Cells: $B$13:$C$15 $B$20 Stocks W Min G Solver Parameters Subject to the Constraints: SBS 16:$C$16 <= $F$13:$F$14 SD$13:$D$15 <= $B$18:$D$18 Value Of: Make Unconstrained Variables Non-Negative Select a Solving Method: Simplex LP Geography H 0 Add Change Delete Reset All Load/Save Options 27 J Y Sort Filter K L Clear Reapply Advanced M
A 1 Oil lease auction 2 3 Bids for sites (dollars/acre) 4 5 Ewing 6 Barnes 7 Pickens 8 9 Max % that can be sold to any bidder 10 11 Number of acres sold to bidders 12 13 Ewing 14 Barnes 15 Pickens 16 Total 17 18 Available 19 20 Revenue ($millions) 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 4 D Point fx 135000 P5-43 B Site 1 $2,000 $1,800 $1,900 P5-46 Site 1 135000 0 0 135000 $150,000 $472,500,000 C Site 2 $1,000 $1,500 $1,300 0.45 Site 2 0 135000 0 135000 $150,000 P5-46 part B D Total 135000 135000 0 $300,000 <= <= <= E Input cell: (Optional) Descriptive name for input: Specify the following information about the input to be varied and the outputs to be captured. Max allowed 135000 135000 135000 Parameters for oneway table $C$9 F Maximum value: Increment: Output cell(s): Values of input to use for table O Base Input values on following: Minimum value: 0.3 0.9 0.05 Land being auctioned Use the values from the following range: Input value range: Use the values below (separate with Input values: $8$20 G Note about specifying output cells: The safest way to select multiple output cells or ranges is to put your finger on the Ctrl key and then drag as many output cell ranges as you like. This will automatically insert commas between the ranges you select. H OK Cancel 1 J K L
Transcribed Image Text:A 1 Oil lease auction 2 3 Bids for sites (dollars/acre) 4 5 Ewing 6 Barnes 7 Pickens 8 9 Max % that can be sold to any bidder 10 11 Number of acres sold to bidders 12 13 Ewing 14 Barnes 15 Pickens 16 Total 17 18 Available 19 20 Revenue ($millions) 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 4 D Point fx 135000 P5-43 B Site 1 $2,000 $1,800 $1,900 P5-46 Site 1 135000 0 0 135000 $150,000 $472,500,000 C Site 2 $1,000 $1,500 $1,300 0.45 Site 2 0 135000 0 135000 $150,000 P5-46 part B D Total 135000 135000 0 $300,000 <= <= <= E Input cell: (Optional) Descriptive name for input: Specify the following information about the input to be varied and the outputs to be captured. Max allowed 135000 135000 135000 Parameters for oneway table $C$9 F Maximum value: Increment: Output cell(s): Values of input to use for table O Base Input values on following: Minimum value: 0.3 0.9 0.05 Land being auctioned Use the values from the following range: Input value range: Use the values below (separate with Input values: $8$20 G Note about specifying output cells: The safest way to select multiple output cells or ranges is to put your finger on the Ctrl key and then drag as many output cell ranges as you like. This will automatically insert commas between the ranges you select. H OK Cancel 1 J K L
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 8 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
SEE MORE TEXTBOOKS