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 calculated values in descending order on the same, Create a procedu...

Create a procedure in VBA to do the following actions: -Create a linear series of numbers starting at 1 (e.g. 1, 2, 3,) -Display a Message Box asking if you'd like to calculate ano

Explain the role of managers in quality and patient safety, What is the rol...

What is the role of managers in quality and patient safety?

State the term shamrock organisation, State the term Shamrock Organisation?...

State the term Shamrock Organisation? Shamrock Organisation: According to Charles Handy the 'Shamrock Organisation' used to apply a model to the workforce flexibility. Th

Marketers position and distinguish their company’s products, How do markete...

How do marketers position and differentiate their company's products/services relative to competition?

What does b stand for in the bcg matrix, Which of the following does B stan...

Which of the following does B stand for in the BCG Matrix? (a) Boom (b) Balance (c) Bankruptcy (d) Boston

Describe mpc can run independent of the operation plan, Which of the follow...

Which of the following is true? MPC can run independent of the operation plan. Business failure can result from poor MPC performance. In PAC, order release directly affect

Explain what is the bonds'' coupon rate, Metal Fabricators just issued $1,0...

Metal Fabricators just issued $1,000 par 20-year bonds. The bonds sold for $758.18 and pay interest semi-annually. Investors require a rate of 9% on the bonds. What is the bonds' c

Explain what is the maximum number of defectives allowed, In a double sampl...

In a double sampling plan the two acceptance numbers are: c1 = 8 and c2 = 12. The number of defectives found in the first sample is 9. Therefore, a second sample is taken. What is

Scheduling - aggregate planning, Scheduling - Aggregate Planning Mean...

Scheduling - Aggregate Planning Meaning and Definition Scheduling may be defined as the assignment of work to the facility with the specification of times ,and the sequence

Describe with specific ethical reasons, When a government is corrupt and it...

When a government is corrupt and it is taking the life of innocent people, do we have the moral right to destroy the government by force? Please explain with specific ethical reaso

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