Question

In: Operations Management

Bilbo owns a gas station. He refills his gas tank once a day early in the...

Bilbo owns a gas station. He refills his gas tank once a day early in the morning. Historical data show that daily demand at his gas station is relatively stable and has mean = 1000 gallons and standard deviation = 200 gallons. His gas tank has a capacity of holding up-to 3000 gallons of gasoline so that is not an issue. Holding gasoline will occupy financial resources, though, and therefore Bilbo does not want to hold too much gasoline in his tank. He wants to maintain a service level of 90%; that is, he wants to have a 90% chance that he does not run out of gas on any day and only wants a 10% chance to face angry customers by running out inventory. How much gas should Bilbo hold by refilling his tank at the begining of the day? (Hint: use the NORMINV or NORMSINV function on Excel to find out where the 90th percentile is under the given normal distribution.)

Group of answer choices

A: =NORMINV(0.9,200,1000) = 1481.55 gallons

B: =1000+200*NORMSINV(0.9) = 1256.31 gallons

C: =1000+200*0.9 = 1180 gallons

D: =1000*NORMSINV(0.9) = 1281.55 gallons

Solutions

Expert Solution

Theory:

Norminv returns the inverse of normal cumulative distribution for a specified mean and standard deviation. Has 3 parameters of probability, mean, and standard deviation.

Normsinv returns a standard normal cumulative distribution(Mean = 0 & standard deviation of 1). Has only one parameter of probability.

Option evaluation:

A: =NORMINV(0.9,200,1000) = 1481.55 gallons

The formulation is correct but the final answer is incorrect. Hence this option is incorrect.

B:=1000+200*NORMSINV(0.9) = 1256.31 gallons

Both formulation and the final answer are correct. This is the correct option.

C:  =1000+200*0.9 = 1180 gallons

Doesn't utilize any excel function to ensure normal distribution. Both formulation and final answer incorrect. Hence this option is incorrect.

D. =1000*NORMSINV(0.9) = 1281.55 gallons

Doesn't utilize standard deviation value hence both formulation and final answer incorrect. Hence this option is incorrect.


Related Solutions

Mr. Cherry owns a gas station on a highway in Vermont. In the afternoon hours, there...
Mr. Cherry owns a gas station on a highway in Vermont. In the afternoon hours, there are, on average, 30 cars per hour passing by the gas station that would like to refuel. However, because there are several other gas stations with similar prices on the highway, potential customers are not willing to wait—if they see that all of the pumps are occupied, they continue on down the road. The gas station has three pumps that can be used for...
Mr. Cherry owns a gas station on a highway in Vermont. In the afternoon hours, there...
Mr. Cherry owns a gas station on a highway in Vermont. In the afternoon hours, there are, on average, 30 cars per hour passing by the gas station that would like to refuel. However, because there are several other gas stations with similar prices on the highway, potential customers are not willing to wait—if they see that all of the pumps are occupied, they continue on down the road. The gas station has three pumps that can be used for...
Darren Mack owns the​ "Gas n'​ Go" convenience store and gas station. After hearing a marketing​...
Darren Mack owns the​ "Gas n'​ Go" convenience store and gas station. After hearing a marketing​ lecture, he realizes that it might be possible to draw more customers to his​ high-margin convenience store by selling his gasoline at a lower price.​ However, the​ "Gas n'​ Go' is unable to qualify for volume discounts on its gasoline​ purchases, and therefore cannot sell gasoline for profit if the price is lowered. Each new pump will cost ​$125,000 to​ install, but will increase...
Darren Mack owns the​ "Gas n'​ Go" convenience store and gas station. After hearing a marketing​...
Darren Mack owns the​ "Gas n'​ Go" convenience store and gas station. After hearing a marketing​ lecture, he realizes that it might be possible to draw more customers to his​ high-margin convenience store by selling his gasoline at a lower price.​ However, the​ "Gas n'​ Go' is unable to qualify for volume discounts on its gasoline​ purchases, and therefore cannot sell gasoline for profit if the price is lowered. Each new pump will cost ​$95 comma 00095,000 to​ install, but...
his is summary of the regression set of data for a gas station profit for 108...
his is summary of the regression set of data for a gas station profit for 108 days, interpret the values? Regression Statistics Multiple R 0.148500807 R Square 0.02205249 Adjusted R Square 0.01282657 Standard Error 4411.401754 Coefficients P-value Intercept 36341.0736 2.04468E-68 X Variable 1 -21.05107088 0.125072539
Bilbo Baggins wants to save money to meet his retirement objectives. He would like to be...
Bilbo Baggins wants to save money to meet his retirement objectives. He would like to be able to retire 30 years from now with a retirement income of $13,174 per month for 20 years, with the first payment received 30 years and 1 month from now. After he passes on at the end of the 20 years of withdrawals, he would like to leave an inheritance of $751,229 to his nephew Frodo. Before his retirement, he plans to deposit $2,000...
Wildhorse Energy Company owns several gas stations. Management is looking to open a new station in...
Wildhorse Energy Company owns several gas stations. Management is looking to open a new station in the western suburbs of Baltimore. One possibility that managers at the company are evaluating is to take over a station located at a site that has been leased from the county. The lease, originally for 99 years, currently has 73 years before expiration. The gas station generated a net cash flow of $95,710 last year, and the current owners expect an annual growth rate...
Sunland Energy Company owns several gas stations. Management is looking to open a new station in...
Sunland Energy Company owns several gas stations. Management is looking to open a new station in the western suburbs of Baltimore. One possibility that managers at the company are evaluating is to take over a station located at a site that has been leased from the county. The lease, originally for 99 years, currently has 73 years before expiration. The gas station generated a net cash flow of $93,580 last year, and the current owners expect an annual growth rate...
Blossom Energy Company owns several gas stations. Management is looking to open a new station in...
Blossom Energy Company owns several gas stations. Management is looking to open a new station in the western suburbs of Baltimore. One possibility that managers at the company are evaluating is to take over a station located at a site that has been leased from the county. The lease, originally for 99 years, currently has 73 years before expiration. The gas station generated a net cash flow of $91,570 last year, and the current owners expect an annual growth rate...
Vincent randomly selected a bag of M&Ms from a randomly selected gas station as he was...
Vincent randomly selected a bag of M&Ms from a randomly selected gas station as he was driving down the interstate. Being bored while riding in the car he decided to evaluate his green M&Ms. From the simple random sample there were 19 green M&Ms with a sample mean weight of 0.8635 g any sample standard deviation of 0.0570 g. Use a 0.05 significance level to test the claim that Janine week of all the M&Ms is equal to 0.8535
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT