Question

In: Operations Management

Daily demand for a product is 90 units, with a standard deviation of 20 units. The...

Daily demand for a product is 90 units, with a standard deviation of 20 units. The review period is 10 days and the lead time is 8 days. At the time of review there are 70 units in stock.

If 99 percent service probability is desired, how many units should be ordered? (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.)

Ordered quantity

units

Solutions

Expert Solution

Z value for 99 percent of service probability = NORMSINV ( 0.99) = 2.326

Given are following data :

Lead time =8 days

Review period = 10 days

Therefore , Protection period = Lead time + review period = 8 + 10 = 18 days

Standard deviation of daily demand = 20 units

Therefore,

Standard deviation of demand during protection period

= Standard deviation of daily demand x Square root ( Protection period)

= 20 x Square root ( 18 )

= 20 x 4.242

= 84.84

Therefore, Safety stock = Z value x Standard deviation of demand during protection period = 2.326 x 84.84 = 197.33 ( 197 rounded to nearest whole number )

Theoretical Reorder point

= average daily demand x Protection period + Safety stock

= 90 x 18 + 197

= 1620 + 197

= 1817

However, number of units in stock at the time of review =70

Therefore , number of units should be ordered

= Reorder point – Number of units in stock

= 1817 – 70

= 1747

ORDERED QUANTITY = 1747 UNITS

keosha answered 1 week ago

Next > < Previous

Related Solutions

Daily demand for a product is 100 units, with a standard deviation of 35 units. The...

Daily demand for a product is 100 units, with a standard deviation of 35 units. The review period is 10 days and the lead time is 5 days. At the time of review there are 40 units in stock. If 95 percent service probability is desired, how many units should be ordered? (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...

Average for a normally distributed demand of a product is 35 units per day. Standard deviation...

Average for a normally distributed demand of a product is 35 units per day. Standard deviation of lead time demand is 10. Lead time is 3 days. Service level is 95%. a) Calculate reorder point and safety stock. b) Reconsider 10 units as daily standard deviation of demand and re-calculate reorder point. c) Reconsider that demand is constant, but lead time varies with a standard deviation of 1 day. Recalculate reorder point. d) Assume both demand and lead time are...

A sample of 20 items provides a sample standard deviation of 5. a. Compute the 90%...

A sample of 20 items provides a sample standard deviation of 5. a. Compute the 90% confidence interval estimate of the population variance b. Compute the 95% confidence interval estimate of the population variance. c. Compute the 99% confidence interval estimate of the population variance.(2pts) please explain step by step clearly with eligible writing

Construct a 90% confidence interval for the population standard deviation if a sample size 20 has...

Construct a 90% confidence interval for the population standard deviation if a sample size 20 has standard deviation of 10. (a) Find the critical value(s). (Round to three decimal places) (b) Construct the confidence interval. (Round to three decimal places) (c) Conclusion.

Average lead time demand in a warehouse is 24000 units. The standard deviation of lead time...

Average lead time demand in a warehouse is 24000 units. The standard deviation of lead time demand is 5500 units. The warehouse orders 60000 units whenever inventory reaches 28000 units. What is the service level? A) around 72% B) around 81% C) around 77% D) around 89% E) none of the above

Store B orders on a weekly basis. Its weekly demand is 50 units with a standard deviation of five units.

Store B orders on a weekly basis. Its weekly demand is 50 units with a standard deviation of five units. The holding cost is $10 per unit per week and a 0.99 in-stock probability is desired.C&A reports annual sales of $30 million, cost of goods sold of $15 million, inventory of $5 million, and net income of $2 million. What is C&A’s:

NFLX's standard deviation is 46% and the market's standard deviation is 20%. The correlation between the...

NFLX's standard deviation is 46% and the market's standard deviation is 20%. The correlation between the returns of NFLX and the market is -0.4. What percent of NFLX's variance is systematic? Provide your answer in percent, rounded to two decimals, omitting the % sign.

Liquid manufactures a single product that has a standard materials cost of $20 (2 units of...

Liquid manufactures a single product that has a standard materials cost of $20 (2 units of raw materials at $10 per unit), standard direct labor cost of $18 (1 hour per unit), and standard variable overhead cost of $8 (based on direct labor-hours). Fixed overhead is budgeted at $34,000 per month. The following data pertain to operations for May of this year: Raw materials purchased 3,600 units costing $31,620 Raw materials used in production of 1,500 units of finished product...

Find the 90% confidence interval for the standard deviation of the lengths of pipes if a...

Find the 90% confidence interval for the standard deviation of the lengths of pipes if a sample of 22 pipes has a standard deviation of 10.6 inches. a. (8.3, 13.8) b. (8.5, 13.3) c. (8.5, 14.3 ) d. (8.1, 15.3)

calculate the mean daily return, Variance and standard deviation for each stock?

BAFB-0.01209-0.009810.002052-0.00471-0.0050.0151010.0039630.0063530.0034920.0008790.003253-0.00160.005702-0.001440.0054430.000160.000752-0.000160.01172-0.007850.002525-0.00484-0.002070.0086780.002078-0.0037-0.00415-0.002820.0040910.004775-0.00630.001772-0.00634-0.00716-0.002330.00332-0.005640.0086370.0050670.012644-0.01573-0.00553-0.01040.0022250.0034760.0003960.00970.0026950.0139520.025452-0.002630.0101750.00196-0.00595-0.03288-0.024330.0123710.01251-0.01045-0.0115-0.008470.0044020.0007830.004539-0.008370.005610.006156-0.003250.002432-7.8E-050.0216760.0101060.0100340.001077-0.00068-0.0163-0.00918-0.005080.0057440.010840.006930.004196-0.00908-0.008820.0054190.0014050.0048580.003898-0.00098-0.00450.0182230.002184-0.001780.002102-0.004240.0019420.0148670.009691-0.01546-0.01044-0.004340.0013190.001652-0.009530.00090.0004690.003745-0.002660.0082090.0080760.0079940.011978-0.0025-0.00085-0.001550.0159230.0134190.0091620.011422-0.007430.0469-0.00945-0.01532-0.0103-0.002090.012337-0.00406-0.00228calculate the mean daily return, Variance and standard deviation for each stock?

Subjects