Daily demand for a product is 130 units, with a standard deviation of 20 units. The review period is 10 days and the lead time is 10 days. At the time of review, there are 40 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 a-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Ordered quantity units

Daily demand for a product is 130 units, with a standard deviation of 20 units. The review period is 10 days and the lead time is 10 days. At the time of review, there are 40 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 a-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Ordered quantity units

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Tropical Seafoods is a small new restaurant that has opened in town. Sales have been steadily increasing as “word of mouth” has spread through the capital. In its first 12 weeks, sales at Tropical Seafoods (in $ 1000s) havebeen: WEEK SALES 1 18 2 22 3 26 4 24 5 28 6 32 7 32 8 40 9 38 10 42 11 40 12 46 1. Using a weighted moving average with three periods, determine the sales for period 13. Use 3, 2, and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively2. Find the MAD, MSE and MAPE 3. Use exponential smoothing with a smoothing constant of 0.50 to forecast the sales (Assume that last period’s forecast for period 1 is equal to actual to begin the procedure (Ft1=Yt1). Which method do you think is best? Is this an improvement over the weighted average- use MAD only
A store’s demand figures are given in the table. According to this, what is the linear regression forecast for Week 12?
Show your solution. Please write down your answer. No excel please. Thank you.
Which is the ideal evaluation design method for impact evaluation of Additional Financing for the Economic Governance Technical Assistance and Capacity Building Project?
q7
What is this slide talking about? What is the relationship between the provision test and operational test?
Assuming the following deseasonalized demand, what would your Level and Trend FORECAST factors be for future deseasonalized demand estimates? (Hint, you might want to use excel for this) period 1 2 3 4 5 6 7 8 9 10 13673 6640 2737 3486 141 13186) 5448 3485 7728 16591 8236 3316 855358 11 12 13 15 16 17 18 19 Demand Deseasonalized D₁ Demand D 3200 7658 4420 2384 3654 8680 5795 1953 4742 20 4472 4657 4956 5074 5157 5917 6646 6850 6791 6573 6363 6308 6932 7887 8662 8989 O Level-4696 Trend-343 O Level-3612. Trend-264 O Level 3629; Trend-263 O Level-2528: Trend-185
please answer in 30 mins. answer if 100% sure.