At what inventory level should he place order

Assignment Help Operation Management

Reference no: EM132252178

Can you please answer and explain this question.

Gentle Ben's Bar and Restaurant uses 6,200 quart bottles of an imported wine each year. The effervescent wine costs $8 per bottle and is served only in whole bottles because it loses its bubbles quickly. Ben figures that it costs $20 each time an order is placed, and holding costs are 25 percent of the purchase price. It takes three weeks for an order to arrive. Weekly demand is 124 bottles (closed two weeks per year) with a standard deviation of 30 bottles.

Ben would like to 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?

Economic order quantity=

b. At what inventory level should he place an order? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.)

Hint: this is a continuous review system, similar to Alt-Cat 20.3. If you don't know how to use NORMSINV() function to find the z-value for a given % level, watch the "Hint" video by clicking the "Hint" button on the left.

Inventory Level=

Reference no: EM132252178

Questions Cloud

Synthetic oil that could be manufactured at very low cost : During the time when he was employed by the company, Edison discovered a synthetic oil that could be manufactured at a very low cost.

What is the central challenge of social security payments : What is the central challenge of Social Security payments? How are they addressed? Provide examples and discuss.

What creative approachs would you use to gain job interview : Why you picked them? What made them successful? What creative approachs would you use to gain a job interview with them?

Is outsourcing wise corporate strategy : Is Outsourcing a Wise Corporate Strategy? Does Expanding via Mergers and Acquisitions Make for Sound Corporate Strategy?

At what inventory level should he place order : What is the economic quantity for Ben to order? At what inventory level should he place an order?

Relating to business communications audiences : What purpose does empathy play in relating to business communications' audiences?

Under franchise agreement with major hotel chain : A local hotel operated under a franchise agreement with a major hotel chain.

Automobile accident that resulted in the death : A woman was involved in an automobile accident that resulted in the death of a passenger in her car.

Discrimination main reason women being paid less than men : Is Gender Discrimination the Main Reason Women being Paid Less Than Men?

User Account

All Pages