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

Is focused factory concept applicable in service sector, Is the 'focused fa...

Is the 'focused factory' concept described by Skinner applicable in the service sector? Answer:  Yes, think of Schmenner's service-process matrix and the lower quadrant entitled

Explain total quality improvement organizational downsizing, Analyze how ea...

Analyze how each has changed healthcare delivery on both the macro and micro levels. Provide specific examples of how both macro and micro impacts/changes: Total quality improvemen

Define number of units where either choice has the same cost, Stan Fawcett'...

Stan Fawcett's company is considering producing a gear assembly that it now purchases from Salt Lake Supply, Inc. Salt Lake Supply charges $4 per unit with a minimum order of 3000

Explain preparation and analysis of balance sheet, Explain preparation and ...

Explain preparation and analysis of balance sheet. Preparation and Analysis of Balance Sheet: Balance Sheet is one of the significant financial statements of a company provid

Explain the fixed cost and the variable cost of production, The fixed cost ...

The fixed cost and the variable cost of production of product are 200000USD and demand is 500units to break even unit price of first 300 item will be?

Compute expected value for the add assembly line option, Howard Weiss, Inc....

Howard Weiss, Inc., is considering building a sensitive new airport scanning device.His managers believe that there is a probability of 0.40 that the ATR Co. will come out with a c

How to use the financial ratios presented, Which of the three warehouse clu...

Which of the three warehouse club rivals has been the strongest financial performer in recent years? Support your answer with calculations based on the data in case Exhibits 2,6, a

Describe potential market share, From my experience, companies need to fact...

From my experience, companies need to factor in the competition and determine their market share. How might a company determine its potential market share?

Discuss the factors affecting productivity increases, 1. Define productivit...

1. Define productivity both as a mathematical ratio and as a systems diagram?  2. Outline how the productivity of an organisation may be improved.  3. Discuss the factors aff

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