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 good business practices and ethics, Kim was in a financial bind. Ju...

Kim was in a financial bind. Just last year, she had purchased a personal plane and an exclusive home that housed the plane in its garage. The total costs were $1 million and Kim's

Describe what you would/could do as a manager, Discuss what you would/could...

Discuss what you would/could do as a manager, or what you have experienced, to create 3 different "orange splats" or emotional episodes at work that are low cost with high emotion

Explain visual inspection, Develop a forecast for years 2 through 12 using ...

Develop a forecast for years 2 through 12 using exponential smoothing with ? = .4 and a forecast for year 1 of 6. Plot your new forecast on a graph with the actual data and the nai

Calculate the standard time for the job, An  industrial  engineer  has obta...

An  industrial  engineer  has obtained the  following data  in connection  with a  time  study on  the lines  of the Hawthorne  studies  taking  four different  elements  and five

Explain disadvantages from the healthcare organizations, Determine two adva...

Determine two advantages and two disadvantages from the healthcare organizations perspective for requiring a Certificate4 of Need (CON). Identify 3 states that require a Certificat

Logistics, suggested modification in enhancing logistics system

suggested modification in enhancing logistics system

Calculate percentage of the time the inspector is idle, At a border vehicle...

At a border vehicles arrive at the rate of 9 per minute in a Poisson distribution. For simplicity in this problem assume that there is only one lane and one inspector who can inspe

Explain college management and faculty, Pretend you are attending a college...

Pretend you are attending a college if you are not and answer the following questions. Putting together college classes for a given term is no mean problem in production scheduling

Industrial policy, Industrial Policy The course of action set by the go...

Industrial Policy The course of action set by the government to influence the development of domestic industrial sectors in particular and the direction of the national organiz

Explain everything else remaining constant what will occurs, Everything els...

Everything else remaining constant, when the sample size increases, which of the following occurs? The sampling error decreases. The sampling error increases. The sampling

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