Dunstreet's Department Store would like to develop an inventory ordering policy with a 95 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 3,200 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 15 days for the sheets to be delivered. Standard deviation of demand for the sheets is three per day. There are currently 180 sheets on-hand. How many sheets should you order? Note: Use Excel's NORM.S.INV() 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. Number of sheets

Dunstreet's Department Store would like to develop an inventory ordering policy with a 95 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 3,200 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 15 days for the sheets to be delivered. Standard deviation of demand for the sheets is three per day. There are currently 180 sheets on-hand. How many sheets should you order? Note: Use Excel's NORM.S.INV() 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. Number of sheets

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

The chapter presented various approaches for the control of inventory investment. Discuss three additional approaches not included that might involve supply chain managers.
Dunstreet's Department Store would like to develop an inventory ordering policy with a 95 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 5,000 per year. The store is open 365 days per year. Every two weeks (14 days) inventory is counted and a new order is placed. It takes 10 days for the sheets to be delivered. Standard deviation of demand for the sheets is five per day. There are currently 150 sheets on-hand. How many sheets should you order? Note: Use Excel's NORM.S.INV() 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.
Dunstreet's Department Store would like to develop an inventory ordering policy with a 90 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,300 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 9 days for the sheets to be delivered. Standard deviation of demand for the sheets is five per day. There are currently 100 sheets on-hand. How many sheets should you order? (Use Excel's NORM.S.INV() 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.) Number of sheets
Dunstreet's Department Store would like to develop an inventory ordering policy of a 90 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 3,400 per year. The store is open 365 days per year. Every two weeks (14 days) inventory is counted and a new order is placed. It takes 12 days for the sheets to be delivered. Standard deviation of demand for the sheets is five per day. There are currently 170 sheets on hand. How many sheets should you order?
Dunstreet’s Department Store would like to develop an inventory ordering policy with a 95 percent probability of not sticking out. To illustrate your recommended procedure, use as an example the ordering policy for white percale sheets. The demand for white percale sheets is 5,000 per year. The store is open 365 days per year. Every two weeks (14 days) inventory is counted and a new order is placed. It takes 10 days for the sheets to be delivered. The standard deviation of demand for the sheets is 5 per day. There are currently 150 sheets on-hand.How many sheets should you order?
Energyzer , a regional electronics retailer , estimates that sells 13 , 000 4-packs of batteries per year (or 250 per week). Each 4-pack of batteries costs the retailer $2.00; with a carrying cost rate of 32%; and ordering costs of $40.00 per order. a. Calculate the optimum order period—in terms of weeks , b. Calculate the economic order quantity PLEASE SHOW WORK
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 97,200 units per year, an ordering cost of $4 per order, and carrying costs of $1.50 per unit. What is the economic ordering quantity? How many orders will be placed during the year? What will the average inventory be? What is the total cost of ordering and carrying inventory?
As the Manager of Branson’s Department Store, you are responsible for ensuring that reorder quantities for the various items have been correctly established. You decide to test one item and choose product Z. A continuous review inventory policy has been used, so you examine this as well as other records and come up with the following data: Cost per unit $35 Holding cost 20 percent of unit cost Average daily demand 10 units Ordering cost $30 per order Standard deviation of daily demand 3 units Delivery lead time 4 days Because customers generally do not wait but go elsewhere, you decide on a service probability of 90 percent. Assume that Branson’s Department Store operates 320 days per year. [What is the annual demand (D)? Determine the optimal order quantity, Q*. Determine the reorder point (R) if demand is constant. Determine the reorder point (R) if demand is varies.
Please do not give solution in image format thanku Regional Supermarket is open 360 days per year. Daily use of cash register tape averages 10 rolls. Usage appears normally distributed with a standard deviation of 2 rolls per day. The cost of ordering tape is $1 per order, and carrying costs are 40 cents per roll a year. Lead-time is three days. a) Ignoring the demand uncertainty (i.e., looking only at average values), find the economic order quantity (EOQ) and the reorder point (ROP). b) Consider now the uncertainty. The order quantity remains the same. If the target is to have a 99% annual service level, what should be the ROP
The materials manager for a billiard ball maker must periodically place orders for resin, one of the raw materials used in producing billiard balls. She knows that manufacturing uses resin at a rate of 50 kilograms each day, and that it costs $.04 per day to carry a kilogram of resin in inventory. She also knows that the order costs for resin are $100 per order, and that the lead time for delivery is four days. If the order size was 1,000 kilograms of resin, what would be the average inventory level?
A regional supermarket is open 360 days a year. Daily use of cash register tapes is 15 rolls. The purchase price of the tape is $ 2 and inventory carrying cost is 60 cents per roll a year. Ordering cost is $ 20 per order. The order replenishment lead time is 7 days. What is the Order Point (re-order point) assuming demand is known and constant?
How do you do this? Please list step by step instructions.