Question

A gasoline mini-mart orders 50 copies of a monthly magazine. Depending on the cover story, demand...

A gasoline mini-mart orders 50 copies of a monthly magazine. Depending on the cover story, demand for the magazine varies. The gasoline mini-mart purchases the magazines for $1.50 and sells them for $4.00. Any magazines left over at the end of the month are donated to hospitals and other healthcare facilities. The magazine publisher estimates that (if enough magazines were stocked) demand would be normally distributed with mean 50 and standard deviation 10. Run a 1000-trial simulation using the attached model. Set the Sim. Random Seed to 5 and the Sampling Method to Monte Carlo.

Using the results from your 1000-trial simulation, what is the mean profit when the gasoline mini-mart stocks 50 magazines? (Select the closest value)

Find a 95% confidence interval for the mean profit. A 95% confidence interval for the mean profit would be [$  ,$  ] (round to two decimal places).

How likely is the gasoline mini-mart to observe a profit greater than $110? (Select the closest value.)

Using the results from your 1000-trial simulation, what is the probability that the gasoline mini-mart will have a profit less than $100 when it stocks 50 magazines? (Select the closest value)

What quantity of stocked magazines (purchased quantity) yields the highest average profit?

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
A gasoline mini-mart orders 50 copies of a monthly magazine. Depending on the cover story, demand...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A gasoline mini-mart orders 25 copies of a monthly magazine. Depending on the cover story, demand...

    A gasoline mini-mart orders 25 copies of a monthly magazine. Depending on the cover story, demand for the magazine varies between 10 and 30 copies each month. The mini-mart purchases the magazines for $1.50 and sells them for $4.00. Any magazines left over at the end of the month are donated to hospitals and other health care facilities. Use the Minimart spreadsheet to model this situation. Identify the best order quantity using a simulation with 100 trials. To generate the...

  • A gasoline mini-mart orders 24 copies of a monthly magazine. Depending on the cover story, demand...

    A gasoline mini-mart orders 24 copies of a monthly magazine. Depending on the cover story, demand for the magazine varies. The mini-mart purchases the magazines for $1.63 and sells them for $3.78. Any magazines left over at the end of the month are donated to hospitals and other health care facilities. Modify the newsvendor example spreadsheet to model this situation. Use what-if analysis to investigate the financial implications of this policy if the demand is expected to vary between 10...

  • 45. A gasoline mini-mart orders 25 copies of a monthly magazine. Depending on the cover story,...

    45. A gasoline mini-mart orders 25 copies of a monthly magazine. Depending on the cover story, demand for the magazine varies. The mini-mart purchases the magazines for $1.50 and sells them for $4.00. Any magazines left over at the end of the month are donated to hospitals and other health care facili- ties. Modify the newsvendor example spreadsheet to model this situation. Use what-if analysis to inves- tigate the financial implications of this policy if the demand is expected to...

  • Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your...

    Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your answers directly in your Excel file using text boxes or comment boxes. Please show formulas used within excel. NCAA Sweatshirt Problem An enterprising OU student is trying to decide how many sweatshirts to print for an upcoming NCAA Basketball Tournament game. The final four teams have emerged from the quarterfinal round, and there is a week left until the semi-finals, which are then followed...

  • Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your...

    Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your answers directly in your Excel file using text boxes or comment boxes. Please show formulas used within excel. NCAA Sweatshirt Problem An enterprising OU student is trying to decide how many sweatshirts to print for an upcoming NCAA Basketball Tournament game. The final four teams have emerged from the quarterfinal round, and there is a week left until the semi-finals, which are then followed...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT