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 sells radio frequency inventory, National Scan, Inc., sells radio f...

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month/Sales (000) Units Feb 16 Mar.17 Apr. 11 May. 29 Jun. 19 Jul

Explain decision making under uncertainty, Even though independent gasoline...

Even though independent gasoline stations have been having a difficult time, Susan Helms has been thinking about starting her own independent gasoline station. Susan's problem is t

Makw or to Buy ?, • ABC Ltd. is in the business of manufacturing one type o...

• ABC Ltd. is in the business of manufacturing one type of valves for last 3 years. • Their sales have grown from 10,000 to about 50,000 valves per month. • Now they are planning t

Explain what factors have limited the ability of local law, 1. What factors...

1. What factors have limited the ability of local law enforcement agencies to respond to the growing threat of computer crime? Answer A. lack of training B. lack of diagnostic equi

Presume semi-annual coupon payments, What is the yield to maturity of a 16-...

What is the yield to maturity of a 16-year bond that pays a coupon rate of 8% per year, has a $1,000 par value, and is currently priced at $916? Round your answer to the nearest wh

Explain when conflicting medical opinions are presented, When conflicting m...

When conflicting medical opinions are presented, should the advice of a medical expert count more heavily than the opinion of a general physician? Explain your answer.

Explain interested in obtaining a measure of overall perform, Cunningham Pe...

Cunningham Performance Auto, Inc. modifies 375 autos per year. The manager, Peter Cunningham, is interested in obtaining a measure of overall performance. He has asked you to provi

We want to consider some accounting ideas, We need to consider some account...

We need to consider some accounting ideas in order to cover this weeks Objective # 3. So in that regard, for your own business, which method of accounting would you use, the "accru

How to designing the marketing strategy, In designing the "marketing strate...

In designing the "marketing strategy" for your own business, how might you use "segmentation variables" to help you identify your "target market"?

Explain asset has negative risk, Suppose rf is 5% and rM is 10%. According ...

Suppose rf is 5% and rM is 10%. According to the SML and the CAPM, an asset with a beta of -2.0 has a required return of negative 5% [= 5 - 2(10 - 5)]. Can this be possible? Does t

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