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

What is the difference among personal and business ethics, What is the diff...

What is the difference between personal and business ethics?

Explain the current organizational culture, Using the competing values fram...

Using the competing values framework as a point of reference, how would you describe the current organizational culture? Provide examples to support your conclusions.

Explain when you go shopping for a new computer, When you go shopping for a...

When you go shopping for a new computer, is your real objective to import a computer into your apartment, or is it to export cash from your wallet? What does this tell you about th

Explain chooses to refurbish the equipment, Ski Boards, Inc., wants to ente...

Ski Boards, Inc., wants to enter the market quickly with a new finish on its ski boards. It has three choices: (a) refurbish the old equipment at a cost of $800, (b) make major mod

Explain flexible manufacturing system, Meile Machine Shop, Inc., has a 1-ye...

Meile Machine Shop, Inc., has a 1-year contract for the production of 225,000 gear housings for a new off-road vehicle. Owner Larry Meile hopes the contract will be extended and th

Explain how can data mining be used to accomplish objective, Your company w...

Your company wants to increase revenues from its existing customers. How can data mining be used to accomplish his objective?

Explain charlotte inventory levels, L. Houts Plastics is a large manufactur...

L. Houts Plastics is a large manufacturer of injection moulded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the informat

Explain how many people would you expect to be waiting, Suzy, a bartender, ...

Suzy, a bartender, can serve drinks at the average rate of one every 35 sec. During a hot evening recently, the bar was particularly busy and every 45 sec someone was at the bar as

What is objective function, FestiveMeadow3308 Baseballs (z1) requires 3 ...

FestiveMeadow3308 Baseballs (z1) requires 3 minutes/unit for cutting and 2 minutes/unit for glueing. Basketballs (z2) requires 2 minutes/unit for cutting and 4 minutes/unit for

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