How many sheets should you order use excels normsinv


Dunstreet's Department Store would like to develop an inventory ordering policy of a 98 percent probability of not stocking out. To illustrate your recommended procedure, use as an example the ordering policy for white percale sheets.

Demand for white percale sheets is 4,700 per year. The store is open 365 days per year. Every four weeks (28 days) inventory is counted and a new order is placed. It takes 7 days for the sheets to be delivered. Standard deviation of demand for the sheets is five per day. There are currently 140 sheets on hand.

How many sheets should you 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.)

Number of sheets

Request for Solution File

Ask an Expert for Answer!!
Operation Management: How many sheets should you order use excels normsinv
Reference No:- TGS02578779

Expected delivery within 24 Hours