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

Explain what is the evpi, State of nature decision ...

State of nature decision S1 S2 S3 D1 250 750 500 D2 300 -250

Coca colas change in sales remain competitive and profitable, How would you...

How would you respond to Coca Cola's change in sales policy? How would you ensure Pepsi's board that this response will allow you to remain competitive and profitable?

Explain adaption and culture shock, The first response to unfamiliar surrou...

The first response to unfamiliar surrounds, like those encountered in an overseas assignment, is: Answer: a. Adaption b. Culture shock c. Fascination d. Reverse culture shock

Explain recommendations with the external distribution, Lucille Jenkins, th...

Lucille Jenkins, the CEO for the Durham International Manufacturing Company (DIMCO), believes that the company can significantly increase its operating profit by implementing suppl

Describe the steps of the collaboration process, 1. State the primary reaso...

1. State the primary reasons for the organizations existence from an analysis of the mission, vision, values, and goals. & Intro. 2. Analyze the reason for the type of organizat

LINE BALANCING, What do you understand by “line balancing”? What happens if...

What do you understand by “line balancing”? What happens if balance doesn’t exist?

Explain inventory decreases, What happens to inventory as the number of kan...

What happens to inventory as the number of kanban cards increases? Inventory decreases Inventory increases Inventory remains the same The number of kanban cards has no

What protected in a bia plan, Select an organization and discuss what type ...

Select an organization and discuss what type of information should be protected in a BIA plan. How would you ensure protection of the confidentiality of such information and preven

Imagine which you just made manufacturing changes, Imagine that you just ma...

Imagine that you just made manufacturing changes to your product so it is now easily recyclable. How would you publicize these changes?

Short term financial conditions of improving productivity, What are the lon...

What are the long and short term financial consequences of improving productivity in a business?

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