Question

After graduation, you decide to go into a partnership in an office supply store that has existed for a number of years. Walking through the store and stockrooms, you find a great discrepancy in service levels. Some spaces and bins for items are completely empty; others have supplies that are covered with dust and have obviously been there a long time. You decide to take on the project of establishing consistent levels of inventory to meet customer demands. Most of your supplies are purchased from just a few distributors that call on your store once every two weeks.

You choose, as your first item for study, computer printer paper. You examine the sales records and purchase orders and find that demand for the past 12 months was 5,500 boxes. Using your calculator you sample some days' demands and estimate that the standard deviation of daily demand is 8 boxes. You also search out these figures:

Cost per box of paper: $11.

Desired service probability: 90 percent.

Store is open every day.

Salesperson visits every two weeks.

Delivery time following visit is four days.

Using your procedure, how many boxes of paper would be ordered if, on the day the salesperson calls, 90 boxes are on hand? (Use 365 days a year. 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.)

Number of boxes

Answer 1

To calculate how many boxes of paper would be ordered, we use Periodic review formula

d = daily demand = (5500/365)

L = Lead time = 4 days

T = no of days between reviews = 14 days

At service level 90% z = 1.28 (We get this using normsinv(0.90) in excel)

= standard deviation = 8

I = on hand inventory = 90

Q=224.68 or 225 (round off)

No of boxes Q = 225 units