Compute forecasted sales, Operation Management

Assignment Help:

In the table given below the Distribution Manager is expected to service these DCs as per the demands placed. If the actual sales after completing week one is as follows, what would be the quantities that would need amendment as far as Distribution Manager is concerned to service for week two and onwards? After week one the actual sales to Forecasted sales for week one ratio is as under: Mumbai did 80 % of forecast , Lucknow did 75 % of forecast Kolkata did 60 % of week one forecast Chennai did 125 % of forecast and Delhi did 150 % of week one forecast Note : Kolkata will receive transit stocks in week 2 . The Table datas are as follows....... Mumbai: Op Bal = 120, safety Stk = 60, Min Ord Qty = 80, Lead Time = 1 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 50,35,55,65,80,125 & 50 Respectively. Chennai: Op Bal = 350, safety Stk = 125, Min Ord Qty = 200, Lead Time = 2 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 100,75,125,100,200,150 & 100 Respectively. Lucknow: Op Bal = 270, safety Stk = 150, Min Ord Qty = 200, Lead Time = 3 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 150,100,150,200,300,200 & 100 Respectively. Delhi: Op Bal = 250, safety Stk = 100, Min Ord Qty = 100, Lead Time = 2 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 50,75,80,55,75,80 & 90 Respectively. Kolkata: Op Bal = 350, safety Stk = 200, Min Ord Qty = 300, Lead Time = 3 Week, Transit = 300, Sales Forecast Week 1 to Week 7 = 100,150,200,135,125,165 & 200 Respectively


Related Discussions:- Compute forecasted sales

Describe the concepts of lean production, Explain the concepts of lean prod...

Explain the concepts of lean production. Describe its relation to Six Sigma. Please provide examples of the pros and cons for linking them.

Compute the trend-adjusting exponential smoothing forecast, Tough Face, a m...

Tough Face, a manufacturer of rock-climbing gear, been enjoying steady growth of it very reliable and colourful carabineer products. Using the following sales history, calculate th

Complete the below table using rationale, Complete the below table. Which o...

Complete the below table. Which one of these techniques would you recommend to use and indicate your rationale? Technique Ave Bias Ave MAD MSE Ave MAPE Naïve

Implications for operations manager - operations functions, 1. Reflecting o...

1. Reflecting on McGroddy's comments - what are the implications for the operations manager? Answer: The point to note here is that organisations resist change. It suggests that

Define management information system and its scope, Normal 0 fa...

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Determine the price and quantity of toasters, Determine the price and quant...

Determine the price and quantity of toasters: There are 100 producers of toasters. Half of the producers are "low quality," i.e. their products will break with probability of

Explain changing the manufacturing process, Your company makes baby seats f...

Your company makes baby seats for cars and RVs. Your main product was designed some time ago, and new and better engineering data are available, but your product has a good record

Explain what will be the percent increase or decrease, Refer to problems 1....

Refer to problems 1.13 and 1.14. If Charles lackey's utility costs remain constant at $500 per month, labour at $8 per hour, and cost of ingredients at $0.35 per loaf, but Charles

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd