Question: Please provide step-by-step explanation and solutions and put in Microsoft Exel file as needed. Thank you so much! Gentle Ben's Bar and Restaurant uses 5,000

Please provide step-by-step explanation and solutions and put in Microsoft Exel file as needed. Thank you so much!

Gentle Ben's Bar and Restaurant uses 5,000 quart bottles of an imported wine each year.The effervescent wine costs $3 per bottle and is served only in whole bottles because it loses its bubbles quickly.Ben figures that it costs $10 each time an order is placed, and hold costs are 20 percent of the purchase price.It takes weeks for order to arrive.Weekly demand is 100 bottles (closed two weeks per year) with a standard deviation of 30 bottles.Ben would like use an inventory system that minimizes inventory cost and will provide a 95 percent service probability.

a.What is the economic quantity for Ben to order?

b.At what inventory level should he place an order?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!