Solve the model you have formulated using solver. report, Ask an Expert

Statistics

The government is auctioning off oil leases at two sites: 1 and 2. At each site, 100,000 acres of land are to be auctioned. Cliff, Blake and Alexis are bidding for the oil. Government rules state that no bidder can receive more than 40% of the land being auctioned. Cliff has bid $1000 per acre for site 1 land and $2000 per acre for site 2 land. Blake has bid $900 per acre for site 1 land and $2200 per acre for site 2 land. Alexis has bid $1100 per acre for site 1 land and $1900 per acre for site 2 land. The government would like to maximize revenue from these bids.

a. Formulate this model and implement it in a sheet.
b. Solve the model you have formulated using Solver. Report the important decisions that the company must make. How much money will the solution yield for the government?

View complete question

Statistics and Probability, Statistics

Category:- Statistics and Probability
Reference No.:- M994719

Have any Question?Write your Review or question?

Related Questions in Statistics and Probability

Dude you ran that red light when conducting research on

Dude, you ran that red light! When conducting research on colorblindness in males, a research forms random groups of five males in each group. The random variable, x, is the number of males in the group who have a form o ...

Loking for guidancea distribution of exam scores has mu

Looking for guidance: A distribution of exam scores has μ = 90 and σ = 10. In this distribution, Sharon's score is 9 points above the mean, Jill has a z-score of +1.20, Steve's score is ½ standard deviation above the mea ...

Assume that the significance level is alpha equals alpha005

Assume that the significance level is alpha equals α=0.05. Use the given statement and find the? P-value and critical? value(s). The test statistic of z equals = -1.53 is obtained when testing the claim that p= 1/6 P-val ...

Simone founded her company using 175000 of her own money

Simone founded her company using $175,000 of her own? money, issuing herself 200,000 shares of stock. An angel investor bought an additional 200,000 shares for $125,000. She now sells another450,000 shares of stock to a ...

A random sample of 87 eighth grade students scores on a

A random sample of 87 eighth grade? students' scores on a national mathematics assessment test has a mean score of 278. This test result prompts a state school administrator to declare that the mean score for the? state' ...

Thirty-eight percent of consumers prefer to purchase

Thirty-eight percent of consumers prefer to purchase electronics online. You randomly select 16 consumers. Find the probability that the number who prefer to purchase electronics online is at most 5.

New varieties of corn with altered amino acid content are

New varieties of corn with altered amino acid content are being investigated for higher nutritional content. The two new varieties, opaque-2 and floury-2, were to be compared to the normal corn. Also different levels of ...

Let be a random variable with probability

Let be a random variable with probability function f ( x )=144/205 x^ 2 , where x =1,2,3,4. (a) Find the expected value of X (b) Find the expected value of Y =2 X +3

4m industries has 30 million shares outstanding trading at

4M Industries has 30 million shares outstanding trading at $20 per share. 4M also has $150 million in outstanding debt. Suppose firm's equity cost of capital is 12%, its debt cost of capital is 5%, and the corporate tax ...

1 suppose you purchase anbsp30-year zero-coupon bond with a

1) Suppose you purchase a 30?-year, ?zero-coupon bond with a yield to maturity of 6.5 % You hold the bond for five years before selling it. i. If the? bond's yield to maturity is 6.5 % when you sell? it, what is the ann ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Statistics and Probability Expert