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 what order quantity will enable the refinery, A refinery in Houston...

A refinery in Houston replaces all of the 3" full-open ball valves in its facility according to a very strict maintenance policy which spaces replacements fairly uniformly througho

Find required return on similar risk bonds, Bond validation-Semi-annual int...

Bond validation-Semi-annual interest. Find the value of a bond maturing in 6yrs. with a $1,000 par value and a coupon interest rate of 12% (6% paid semi-annually) if the required r

Find how much does the airport need to set aside now to pay, Orlando Intern...

Orlando International Airport plans to extend passenger capacity of its existing terminal to accommodate its forecasted growth. A new terminal would be needed once the state's busi

Layout decisions, advantages and disadvantages of product-oriented layout

advantages and disadvantages of product-oriented layout

Goldratt - theory of constraints, Goldratt - Theory of Constraints 1 i...

Goldratt - Theory of Constraints 1 identify the systems constraints  2 exploit the systems constraints  3 subordinate everything else to the above decision  4 elevate

Get a financial analysis of coca cola comparing the past 5y, Where can i fi...

Where can i find a financial analysis of coca cola comparing the past 5yrs from 2009-2013. Something in a word format would be help

Trade off between delivery and flexibility, Trade off Between Delivery and ...

Trade off Between Delivery and Flexibility Pagell et al (2000) argue that the trade-off concept is based on Skinner's quandary that a manufacturing plant could not be configur

Explain efects in the accounts receivable department, Category- 1) Invoi...

Category- 1) Invoice Amount does not agree with check amount 2) Invoice not on record 3) No formal invoice issued 4) Check (payment) not recieved on time 5) Check no

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