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

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

How is capacity management important in the organisation, How is capacity m...

How is capacity management important in the organisation? Capacity management: Capacity management is a procedure which seeks to make sure that the organisation can contr

Explain appropriate technique to develop a forecast, Air travel on Mountain...

Air travel on Mountain Airlines for the past 18 weeks was: Week Passengers Week Passengers 1 406 10 440 2 410 11 446 3 420 12 451 4 415 13 455 5 412 14 464 6 420 15 466 7 424 16 47

Find what is the labour productivity per dollar, Klein Karpet cleaned 65 ru...

Klein Karpet cleaned 65 rungs in October, consuming the following resources: Labour: 520 hours at$13 per hour Solvent: 100 gallons at $5 per gallon Machine rental: 20 days at $50 p

Benefits of effective operations management, what are the benefits of effec...

what are the benefits of effective operations management. Discuss.

Explain what are the pros and cons of the control system, What kind of cont...

What kind of control systems are being used to measure the performance of hospitals and their different kinds of employees such as doctors and nurses? What are the pros and cons

Explain comparable worth, In detail, express your opinion regarding the "Co...

In detail, express your opinion regarding the "Comparable Worth" issue.

Monte carlo, explain the monte carlo simulation

explain the monte carlo simulation

What impacts are there if any of the project team is leftout, There are 3 m...

There are 3 main components to the systems implementation process, which are, organizing the team, determining project scope and expectations and establishing a project plan. Each

Explain managers for a large retail department store, Recently the managers...

Recently the managers for a large retail department store stated that a study has revealed that female shoppers spend on average 23.5 minutes longer in the store per visit than do

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