Question

Dunstreet's Department Store would like to develop an inventory ordering policy of a 98 percent probability...

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,600 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 13 days for the sheets to be delivered. Standard deviation of demand for the sheets is nine per day. There are currently 180 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.)

Homework Answers

Answer #1

We have following information

Service Level probability P = 98% (Probability of not stocking out)

From Standard normal distribution, z = 2.053 for 98% Service Level (Use excel function”=NORMSINV(0.98)”)

Annual demand D = 4,600 per year

Therefore, daily demand d = 4,600/365 = 12.60 sheets

Time between orders (review) T = 14 days

Lead time L = 13 days

Standard deviation of daily demand SD = 9 per day

Current Inventory in hand = 180 sheets

Number of sheets you should order = Average daily demand *(Time +lead time) + z * √ (time + lead time) *√Standard deviation of demand - Current Inventory in hand

= 12.60 * (14 days + 13 days) + 2.053 *√ (14 days + 13 days) *√9 – 180

= 340.27 + 32.01 -180

=192.37 sheets

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Dunstreet's Department Store would like to develop an inventory ordering policy of a 90 percent probability...
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,000 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 11 days for the sheets to be delivered. Standard deviation of...
Dunstreet's Department Store would like to develop an inventory ordering policy of a 95 percent probability...
Dunstreet's Department Store would like to develop an inventory ordering policy of 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...
A local service station is open 7 days per week, 365 days per year. Sales of...
A local service station is open 7 days per week, 365 days per year. Sales of 10W40 grade premium oil average 25 cans per day. Inventory holding costs are $0.90 per can per year. Ordering costs are $7 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.)   Economic order...
After graduation, you decide to go into a partnership in an office supply store that has...
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...
15. A store has an ordering cost of $250, a carrying cost of $4 per unit,...
15. A store has an ordering cost of $250, a carrying cost of $4 per unit, annual product demand of 6,000 units, and it purchases product from a supplier for $500 per unit, however, the supplier has offered the store a discount price of $400 if it will purchase 1,200 units; the store’s minimum total inventory cost is a. $2,407,300 b. $3,607,200 c. $3,464,000 d. $2,987,400 16. If a store has annual demand (365 days per year) of 6,000 units...
Inventory Control a. A department store in the town of Napar sells cell a popular brand...
Inventory Control a. A department store in the town of Napar sells cell a popular brand of cell phones to customers in the area. This cell phone is fairly durable and it has lots of features. The demand for this phone is normally distributed with a mean of 50 cell phones per day and a standard deviation of 10 phones. The store operates 350 days per year. Ordering cost is $300 per order and the holding cost is 5% of...
Retailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to...
Retailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to stock enough items for a 90 percent service probability. A stainless steel knife set is one item it stocks. Demand (1,800 sets per year) is relatively stable over the entire year. Whenever new stock is ordered, a buyer must assure that numbers are correct for stock on hand and then phone in a new order. The total cost involved to place an order is...
OM 540: Supply Chain Management Assignment 6: Inventory and Risk Pooling                               &
OM 540: Supply Chain Management Assignment 6: Inventory and Risk Pooling                                                                                                                                                                          Question #1 Harley-Davidson has its engine assembly plant in Milwaukee, and its motorcycle assembly plant in York, Pennsylvania. Engines are transported between the two plants using trucks, with each trip costing $1,600.  The motorcycle plant assembles and sells 100 motorcycles each day. (Assume 300 workdays in a year.)  Each engine costs $600, and Harley incurs a holding cost of 25 percent per year. How many engines should Harley load onto...
Founded in 1962 by Bernard Sliwin, Athletic Knit (AK), a manufacturer of sports team uniforms, specialized...
Founded in 1962 by Bernard Sliwin, Athletic Knit (AK), a manufacturer of sports team uniforms, specialized in hockey jerseys, with 80 per cent of its revenue coming from the sales of hockey-related products. AK sold both stock and customized products in Canada and the United States. The company’s mission was to provide high quality sportswear and high quality service to its customers. Daniel Sliwin, the founder’s grandson, became AK’s vice president in 2009. He and his brother David improved the...
1. What is an ISP (Integrated Service Provider) for supply chains? (1 point) A. A consultant...
1. What is an ISP (Integrated Service Provider) for supply chains? (1 point) A. A consultant agency which integrates the supply chain for companies B. A 2 PL or a 3PL, but not a 4PL C. A company supplying transportation and warehousing services D. A logistics service company specialized in suppling VAS (value added services) 2. What characterizes a 4 PL? (1 point) A. They are non-asset based and provides integrated services primarily supplied by asset based providers, for example...