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

Comparison between method and work measurement, Comparison between method a...

Comparison between method and work measurement: Method  study  is the  principle   technique  for reducing  the work  involved  primarily by eliminating unnecessary  movement

Kaplan and norton balanced scorecard framework, Kaplan and Norton Balanced ...

Kaplan and Norton Balanced Scorecard Framework Kaplan and Norton (1992, 1993, and 1996) describe the concept of a 'balanced scorecard' that includes four categories of measure

Explain what are the two possible outcomes if this is done, It is generally...

It is generally not appropriate to apply control charts to the same data that were used to derive the mean and limits. Why? What are the two possible outcomes if this is done, how

Explain five key economic variables, Identify five key economic variables t...

Identify five key economic variables that could represent major opportunities or threats to a bank in your town or city. Identify which that you believe to be most important, and d

Explain test market prior to an advertising campaign, A research team condu...

A research team conducted a study of soft- drink preferences among residents in a test market prior to an advertising campaign for a new cola product. Of the participants, 130 are

Public Administration, Is the city management form of government better tha...

Is the city management form of government better than the mayor and council form of government?

Performance measurement in organisations, Performance Measurement 1. A...

Performance Measurement 1. An effective performance measurement framework rarely is derived from one single approach.  2. Each of the methods outlined comes with its own un

Explain the probability that the second item is defective, A production pro...

A production process is known to produce a particular item in such a way that 5% of these are defective. If two items are randomly selected as they come off the production line, wh

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