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.
Enrun Corporation expects to order 140,000 memory chips for inventory during the coming year, and it will use this inventory at a constant rate. Fixed ordering costs are $300 per order; the purchase price per chip is $20; and the firm’s inventory carrying costs is equal to 20 percent of the purchase price. (Assume a 360-day year.) What is the economic ordering quantity for chips? If Enrun holds a safety stock equal to a 30-day supply of chips, what is its average inventory level? Assume that Enrun holds a safety stock equal to a 30-day supply of chips. What is the maximum amount of inventory that Enrun will have on hand at any time, that is, what will be the inventory level right after a delivery is made?
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
Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand rate of 3,800 cases. A case of the soft drink costs R&B $3. Ordering costs are $20 per order and holding costs are 25% of the value of the inventory. R&B has 250 working days per year, and the lead time is 5 days. Identify the following aspects of the inventory policy. a. economic order quantity (round your answer to the nearest integer.) _____450_______ b. reorder point ______76______ c. cycle time (in days) (round your answer to two decimal places.) ______29.61______ d. total annual cost (in $) (round your answer to two decimal places.) _____?_______ ***I am asking the question with the ? symbol. I have been able to locate the numbers for the first three but I am having issues computing my answers for the last one.
A billiard ball maker must place orders for resin, a raw material for billiard balls. It uses resin at a rate of 120 kilograms each day, and incurs a cost of $0.4 per kilogram per day to hold inventory. The ordering cost is $150 per order. Lead time for delivery is 4 days. Assume 365 day in a year.What is the optimal length of the order cycle associated with the minimum total cost of ordering and inventory holding? [Round your final number with two decimals] 0.13 days 1.10 days 2.50 days 47.76 days None of the above PLEASE SHOW CALCULATIONS NOT JUST ANSWER
Items purchased from a vendor cost $250 each, and the forecast for next year’s demand is 2,000 units. The optimal order size is 100. The firm operates 52 weeks next year and lead time is 3 weeks. It costs $5 every time an order is placed for more units, and the storage cost is $2 per unit per year. What is the total ordering cost for a year? a.100 b.50 c.250 d.500 e.300
the company expects to sell 19,200 units next year. it operates 360 days a year. annual carrying cost is P32 per unit ordering cost is P150. A. what is the length of an order cycle in days? (4 decimals) B. what is the total annual cost at EOQ? show solution
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?
A local gas station is open 7 days per week, 365 days per year. Sales of 10W40 grade premium oil average 10 cans per day with a standard deviation of 4 canes. Inventory holding costs are 1.5$ per can per year. Ordering cost is $20 per order. Lead time is 8 days. In case of stockout, the motorist drives away and the sale is lost. So, the service station requires a service level of 95 %. If the station uses a fixed-quantity inventory management system, what would be the order quantity, the safety stock and the reorder level? If the station uses a fixed-review-period management system with 28 days review interval, what would be the order quantity if the inventory level is 55 cans at the moment of ordering?
Grey Wolf Lodge is a popular 500-room hotel in the North Woods. Managers need to keep close tabson all room service items, including a special pine-scented bar soap. The daily demand for the soap is275 bars, with a standard deviation of 30 bars. Ordering cost is $10 and the inventory holding cost is$0.30/bar/year. The lead time from the supplier is 5 days, with a standard deviation of 1 day. The lodgeis open 365 days a year.a. What is the economic order quantity for the bar of soap?b. What should the reorder point be for the bar of soap if management wants to have a 99 percentcycle-service level?c. What is the total annual cost for the bar of soap, assuming a Q system will be used?
Sunstar Ice Cream Sells 12,000 gallons of ice cream each month from its central storagefacility. Monthly carrying cost are P.10 per gallon and ordering cost are P50 per order.Ignore potential stockout cost and assume a 30 days month. What is the optimal length of the inventory cycle?How many orders will be placed per month?
All Seasons Flower Shop uses 870 clay pots a month. The pots are purchased at $ 6 each. Annual holding cost per pot is estimated to be 35% of purchase cost. Ordering cost is $ 40 per order. The shop operates 12 months in a year. What would be the difference in total cost if an order quantity of 1000 is used instead of the EOQ. Note: calculate the difference as “total cost with Q = 1000 – total cost with EOQ”.