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

Calculate the regression equation, The I-10 carpet outlet wants to develop ...

The I-10 carpet outlet wants to develop a means to forecast its sales. The store manager believes that the stores sales are directly related to the number of new housing starts in

Explain employment eligibility, Prospective employers can conduct a credit ...

Prospective employers can conduct a credit check along with a background check to determine employment eligibility. Do you feel this is good business practice or an invasion of pri

Define advantage and disadvantages of using optical scanners, What are the ...

What are the advantage and disadvantages of using optical scanners to score the results of a test?

Line balancing, what is line balancing and what happens if it doesn''t exis...

what is line balancing and what happens if it doesn''t exist?

Describe how problems can arise with a functional structure, As organizatio...

As organizations grow and differentiate, problems can arise with a functional structure. Describe and explain the problems that may arise and how organizations may respond.

Goldratt - theory of constraints, Goldratt - Theory of Constraints 1 i...

Goldratt - Theory of Constraints 1 identify the systems constraints  2 exploit the systems constraints  3 subordinate everything else to the above decision  4 elevate

Which kind of portable computer will meet everyones needs, Your organizatio...

Your organization plans to acquire 250 new portable computers. The finance vice president has asked you to lead a project team assigned to define users' computer hardware needs and

Scope of production and operation management , Scope of Production and Oper...

Scope of Production and Operation Management Production management mainly associated with the factory management as the problem of production crept with the development of facto

Explain increase retention of employees, If you became the new manager at r...

If you became the new manager at restaurant with high employee turnover, what actions would you take to increase retention of employees?

Which is a group of products that are closely related, A _____ is a group o...

A _____ is a group of products that are closely related because they satisfy a class of needs, are used together, are sold to the same customer group, are distributed through the s

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