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

Priority sequencing, Priority Sequencing In sequencing jobs on machine...

Priority Sequencing In sequencing jobs on machines on one the process time of each job and their due dates of delivery are required. A priority rule is then decided upon in or

Describe worker adjustment and retraining notification act, Outline the pro...

Outline the provisions of the Worker Adjustment and Retraining Notification Act (WARN) of 1988 stating its rules, liabilities, and loopholes. Discuss the reasons why this act was c

International merketing, . Define international marketing and furnish its f...

. Define international marketing and furnish its features

Make an aggregate plan, Prepare an aggregate plan for the coming year assum...

Prepare an aggregate plan for the coming year assuming that the sales forecast is perfect Use a spreadsheet Bradford Manufacturing in the spreadsheet an area has been designated fo

Explain product life cycle, How does a product life cycle differ from a pro...

How does a product life cycle differ from a product life cycle?

Quality management., examples of internal and external failure cost

examples of internal and external failure cost

Describe the mission- vision- values- and goals, The formal strategic plann...

The formal strategic planning process has five main steps. We are going to analyze at the first step involving corporate mission, vision, values and goals in the context of the com

Explain how the market value of the shares, St James Ltd. Has just paid a d...

St James Ltd. Has just paid a dividend of £0.22 per share. The market expects this dividend to grow constantly in each future year at the rate of 7% p.a. The cost of capital for St

Explain methods of quantitative analysis, Name four methods of quantitative...

Name four methods of quantitative analysis that are useful in informing the facility location decision. How can each of the methods assist you in location decisions? Provide exampl

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