Question: A local service station is open 7 days per week, 365 days per year. Sales of 10W40 grade premium oil average 20 cans per day.

A local service station is open 7 days per week, 365 days per year. Sales of 10W40 grade premium oil average 20 cans per day. Inventory holding costs are $0.50 per can per year. Ordering costs are $10 per order. Lead time is two weeks. Backorders are not practical the motorist drives away.

a) Based on these data, calculate the economic order quantity and reorder point. Hint: Assume demand is deterministic. (Round your answers to the nearest whole number.) EOQ=? and Reorder point=?

b) The boss is concerned about this model because demand really varies. The standard deviation of demand was determined from a data sample to be 6.15 cans per day. The manager wants a 99.5 percent service probability. Determine a new inventory plan based on this information and the data in a. Use Qopt from a. (Use Excel's NORMSINV() function to find the z value. Do not round intermediate calculations. Round z value to 2 decimal places and final answer to the nearest whole number.)

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!