Average daily sales of a product are 8 units. The actual number of sales each day is either 7, 8, or 9, with probabilities 0.3, 0.4, and 0.3, respectively
The lead time for delivery of this averages 4 days, although the time may be 3, 4, or 5 days, with probabilities 0.2, 0.6, and 0.2. The company plans to place an order when the inventory level drops to 32 units (based on the average demand and average lead time). The following random numbers have been generated: 60, 87, 46, 63 (set 1 ) and 52, 78, 13, 06, 99, 98, 80, 09, 67, 89, 45 (set 2 ). Use set 1 of these to generate lead times and use set 2 to simulate daily demand. Simulate 2 ordering periods with this and determine how often the company runs out of stock before the shipment arrives. Assume 32 units on-hand and an order was just placed.
Interval of
Random #s Time Interval of
Random #s
7 01-30 3 01-20
8 31-70 4 21-80
9 71-00 5 81-00
First order: RN = 60 so lead time = 4 days. Inventory Balance
Demand: day 1 8 (RN = 52 ) 24
day 2 9 (RN = 78 ) 15
day 3 7 (RN = 13 ) 8
day 4 7 (RN = 06 ) 1
Total demand during lead time = 31. Since the reorder point is 32, there is no stockout.
Second order: RN = 87 so lead time = 5 Inventory Balance
Demand: day 1 9 (RN = 99 ) 23
day 2 9 (RN = 98 ) 14
day 3 9 (RN = 80 ) 5
day 4 7 (RN = 09 )
day 5 8 (RN = 67 )
Total demand during lead time = 42. So, the company experienced a stockout during this time at Day 4.
You might also like to view...
Forward-buying is purchasing extra inventory while it is on-deal so it can be sold later when it is off-deal
Indicate whether the statement is true or false
In countries like India and Vietnam, and other emerging markets, amenities such as refrigerators, flush toilets, and cell phones are considered status symbols
Indicate whether the statement is true or false
The Securities and Exchange Commission requires that Subscriptions Receivable be disclosed on the financial statements filed with it as a(n)
A) current asset as long as collection is to be made within one year or the normal operating cycle, whichever is longer. B) other asset if collection is to be made beyond one year from the date of the financial statements. C) contra-accounts receivable account. D) contra-shareholders' equity account.
Online analytical processing (OLAP) applications are powerful tools created specifically for shift employees.
Answer the following statement true (T) or false (F)