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

Why analysis phase in an hpt project is the most important, Some HPT practi...

Some HPT practicioners believe that the analysis phase in an HPT project is the most important. Do you agree? Why?

Explain job design be used to create a motivated workforce, How can job des...

How can job design be used to create a more motivated workforce? Be specific.

Explain the role of purchasing, Describe the role of purchasing in contribu...

Describe the role of purchasing in contributing to the profitability of the enterprise

CPM, CPM problems

CPM problems

Explain actual and forcasted demand level, The following are monthly actual...

The following are monthly actual and forcasted demand level for may through December for units of product manufactured by N. Month Actual demand Forecast demand May 100 102

Explain tie-in promotions with retailers like fast food, Some IMC campaigns...

Some IMC campaigns that seemed obvious to me as a consumer include Apple and Microsoft product launches where they do a lot of push strategies, e.g. getting product to retailers, s

Why is it important to view the whole person, Why is it important to view "...

Why is it important to view "the whole person" as a human services professional, rather than focus on the problem at hand?

Explain operating cost & labour cost, A location analysis for Temponi Contr...

A location analysis for Temponi Controls, a small manufacturer of parts for high-technology cable systems, has been narrowed down to 4 locations. Temponi will need to train assembl

Explain time-phased product structure, The demand for subassembly S is 100 ...

The demand for subassembly S is 100 units in week 7. Each unit of S requires 1 unit of T and 2 units of U. Each unit of T requires 1 unit of V, 2 units of W, and 1 unit of X. Final

Briefly explain the matrix form of organization design, Briefly describe th...

Briefly describe the matrix form of organization design. List its advantages and disadvantages. This structural form is most likely to be used under what conditions?

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