Question: Q4. (25 points) The 40 week demand data for a product is given below. Replenishment cycle is weekly and lead time is 3 days. Week

Q4. (25 points) The 40 week demand data for a

Q4. (25 points) The 40 week demand data for a product is given below. Replenishment cycle is weekly and lead time is 3 days. Week Sales 2 328 19 4 254 6 272 8 173 9 305 10 535 11 253 12 157 13 224 14 285 15 3631 16 332 17 184 18 46 20 149 2101 330 242 26 29 39 Week Sales 21 293 22 450 23 24 96 295 25 3351 28 304 30 238 31 605 32 274 34 357 35 3331 36 182 37 273 38 269 40 251 405 1) Draw the sales vs. time graph 2) Draw the demand profile histogram 3) Calculate average value of demand 4) Calculate safety stock 5) Calculate the target inventory for a service level of 90 %

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q4. (25 points) The 40 week demand data for a product is given below. Replenishment cycle is weekly and lead time is 3 days. Week Sales 220 328 330 354 431 271 242 173305 Week 33 24 25 26 27 28 29...

Calculate the target inventory for a service level of 90% _______________________________________________ Q4. (25 points) The 40 week demand data for a product is given below. Replenishment cycle is...

Given the below values for a product Annual Sales Weekly standard deviation of sales Reorder point Leadtime Order size 780 units/year 15 units 40 units 2 weeks 70 units Questions. 1. Plot inventory...

FILL THE ENTIRE SHEET ( GIVEN IN THE PICTURE ATTACHED) BECAUSE ANSWER SHOULD BE IN THE SHEET. DONT JUST WRITE THE ANSWER IN PARAGRAPH FORM. I NEED THE ANSWER IN THE SHEET GIVEN IN PICTURE PLEASE....

Brands in the Salesforce Dilem DS. INC: SPECTRUM BRAN company's individual and maintain customer relationships, and to clude competition from tak ing advantage of any perceived disruptions during...

8.8. The daily demand for an item is distributed normally, with a mean of 5 and a variance of 2. The cost to place an order is $10, and the carrying charge per day is estimated at 10 percent of the...

Lo 3. Be Able To Check The Level Of Stock On Sale In A Retail Environment. 3.1 calculate when to check stock levels, taking into account: Expected demand or stock The time needed to order replacement...

WalterCola: The Coffee Project As a financial consultant at Alexandra Anderson & Co., you and your team have been assigned to work on the WalterCola account, a fortune 500 soft drink beverage...

Homework Assignment 5 (Chapter... i Saved Help Save & Exit Submi Consider a profit-maximizing firm in a competitive industry. Under which of the following situations would the firm choose to produce...

Recently, Phil Harris, the production control manager at Brunswick, read an article on time-phased requirements planning. He was curious about how this technique might work in scheduling Brunswick's...

Alex is given the choice between two games. In Game 1, a fair coin is flipped and if it comes up heads, Alex receives $100. If the coin comes up tails, Alex receives nothing. In Game 2, a fair coin...

Develop a brief marketing plan for the event of your choice. Make sure to identify the competitive advantages, target market(s), strategies, tactics, budgets, schedule and evaluation methodologies....

A broker-dealer has flexibility in terms of the capacity in which it can act in a securities transaction. When buying a security from a client, the trade confirmation would A) include the amount of...

What is an example of constructive feedback? provide reference