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

I need to describe forecasting, I need to explain forecasting, also how it ...

I need to explain forecasting, also how it is performed at St. Arnold's Brewery (Houston, TX) also what forecasting error is and if there has been any in the past.

Explain understanding of human behaviour, Explain understanding of human be...

Explain understanding of human behaviour. Understanding of Human Behaviour: Understanding human behaviour is significant for any one dealing along with human resources. This

Compute the estimated sample size needed, Practical Application Scenario 2 ...

Practical Application Scenario 2 To complete this scenario, use the Sample Size Estimator file provided in the Resources. The third shift at Microsoft's Windows' security uni

Mathematical analysis of the normal distribution curve, Mathematical Analys...

Mathematical Analysis of the Normal Distribution Curve Mathematical analysis of the normal distribution curve has produced data tables which provide population statistics in r

Least factors to a project manager when building a team, Compare and contra...

Compare and contrast attributes that are most and least important to a project manager when building a team. Provide a work or project example to support your answer. Back up your

Capacity planning and control , Analyse a given situation and select a capa...

Analyse a given situation and select a capacity planning and control approach

Construct a large wing on the existing hospital, Chris Suit is administrato...

Chris Suit is administrator for Lowell Hospital. She is trying to determine whether to build a large wing on the existing hospital, a small wing or no wing at all. POPULATION TR

Explain charlotte inventory levels, L. Houts Plastics is a large manufactur...

L. Houts Plastics is a large manufacturer of injection moulded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the informat

Define save money before announcing the restructuring plans, Should GM have...

Should GM have taken any additional steps to save money before announcing the restructuring plans?

Explain how would you make a needs assessment, Suppose you were conducting ...

Suppose you were conducting a marketing analysis for a new textbook about technology management. What would you need to know to identify a market segment? How would you make a need

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