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 improve motivation of the employees, You are a manager of a Consult...

You are a manager of a Consulting firm, with 25 employees under your supervision. Employee Motivation appears to be slipping as well as employee performance. Employees seem to have

Explain largest category of households, By 2015, projections indicate that ...

By 2015, projections indicate that the largest category of households will be composed of a. childless married couples and empty nesters b. singles living with non

Role or forecasting in capacity planning, Role or Forecasting in capacity P...

Role or Forecasting in capacity Planning The marketing department plays a major role in providing demand forecasts based on which both long term as well as short term capacity p

Explain focuses on the customer relationship, Choosing which processes are ...

Choosing which processes are core to a firm's competitive postition is a key strategic decision. For example, Nike, a popular sports shoe company, focuses on the customer relations

Explain supply chain is inappropriate for services, Explain why the goods a...

Explain why the goods analogy of a supply chain is inappropriate for services

Explain typical complaints, Do results from the survey illustrate typical c...

Do results from the survey illustrate typical complaints about teams and specifically about team incentive rewards?

Explain what sales would you predict for the first quarter, The following t...

The following table shows a tool and die company's quarterly sales for the current year. What sales would you predict for the first quarter of next year? Quarter relatives are SR1=

Explain reduce time in calculating customers, New software has been purchas...

New software has been purchased to reduce time in calculating customers' accounts. Establishing report and effective communication with team members is primary importance to make t

Implementation of the quality planning and control activity, Question : ...

Question : (a) Discuss the various stages involved in the development and implementation of the quality planning and control activity. (b) Checking should be carried out at

Supply chain, to what extent is SCM applicable to a service operation

to what extent is SCM applicable to a service operation

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