Question

A gasoline mini-mart orders 24 copies of a monthly magazine. Depending on the cover story, demand for the magazine varies. Th1 Newsvendor Model 3 Data 5 Selling price 6 Cost 7 Discount price $3.78 $1.63 $0 9 Model 11 Demand 12 Purchase Quantity 14 Qu

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Newsvendor Model
Data
Selling Price $       3.78 $       3.78 $       3.78 $       3.78 $       3.78 $       3.78 $   3.78 $    3.78 $   3.78 $       3.78 $       3.78 $       3.78 $       3.78 $       3.78 $       3.78 $       3.78 $       3.78 $       3.78 $       3.78 $       3.78 $       3.78
cost $       1.63 $       1.63 $       1.63 $       1.63 $       1.63 $       1.63 $   1.63 $    1.63 $   1.63 $       1.63 $       1.63 $       1.63 $       1.63 $       1.63 $       1.63 $       1.63 $       1.63 $       1.63 $       1.63 $       1.63 $       1.63
Discount Price $           -   $           -   $           -   $           -   $           -   $           -   $        -   $         -   $        -   $           -   $           -   $           -   $           -   $           -   $           -   $           -   $           -   $           -   $           -   $           -   $           -  
Model
Demand 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00 23.00 24.00 25.00 26.00 27.00 28.00 29.00 30.00
Purchase Quantity 24.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00
Quantity Sold 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00 23.00 24.00 24.00 24.00 24.00 24.00 24.00 24.00
Surplus Quantity 14.00 13.00 12.00 11.00 10.00 9.00 8.00 7.00 6.00 5.00 4.00 3.00 2.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Profit $     -1.32 $       2.46 $       6.24 $    10.02 $    13.80 $    17.58 $ 21.36 $ 25.14 $ 28.92 $    32.70 $    36.48 $    40.26 $    44.04 $    47.82 $    51.60 $    51.60 $    51.60 $    51.60 $    51.60 $    51.60 $    51.60
Add a comment
Know the answer?
Add Answer to:
A gasoline mini-mart orders 24 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
  • 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...

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

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