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

Dave., Henrique Correa’s bakery prepares all its cakes between 4am and 6am ...

Henrique Correa’s bakery prepares all its cakes between 4am and 6am so they will be fresh when customers arrive. Day old cakes are virtually always sold, but at a 50% discount off

Advantage of least cost method, Advantage of Least Cost Method a.      ...

Advantage of Least Cost Method a.       This method   provides accurate solution as transportation cost is consider while making  allocation. b.      It is very simple  and

Explain protected group category, To be considered lawful, a voluntary affi...

To be considered lawful, a voluntary affirmative action plan must meet all of the following criteria except: a. it must be permanent b. It must exist to eliminate past imbalances b

Explain evolution of the supply chain concept, What is the relationship bet...

What is the relationship between the growth in worldwide competition and the evolution of the supply chain concept?

Explain complete the forward and backward pass, You are creating a customer...

You are creating a customer database for Winston-Salem Warthogs minor league baseball team. Draw a project network given the information below. Complete the forward and backward pa

Explain matching supply with demand, From "Matching Supply with Demand" Cac...

From "Matching Supply with Demand" Cachon/Terwiesch (Inventory Cost) A manufacturing company producing medical devices reported $60,000,000 in sales over the last year. At the e

Centre of gravity method, Hi, I am looking to find any potential benefits o...

Hi, I am looking to find any potential benefits of the centre of gravity locational theory, in addition to this, would like to know of any potential drawbacks that the theory entai

Explain what are the coordinates of the central location, A small rural cou...

A small rural county has experienced unprecedented growth over the past 6 years, and as a result, the local school district built the new 500-student North Park Elementary School.

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