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 is the probability that you will make money, The owner of Fire...

The owner of Firewood-2-Go is considering buying a hydraulic wood splitter which sells for $50000. He figures it will cost an additional $80 per cord to purchase and split wood wit

Transportation and assignment problem, Transportation and Assignment Proble...

Transportation and Assignment Problem: Transportation  problem is the  problem of determining the minimum  cost for  allocating a product from  several supply sources to sever

Expensive car you can afford if you finance it for months, You have saved $...

You have saved $5000 for a down payment on a new car. The largest monthly payment you can afford is $350. The loan would have a 10% APR based on the end of month payments. What is

Explain authorities under the industrial disputes act, Explain the authorit...

Explain the authorities under the Industrial Disputes Act, 1947. Ans: One of the authorities under the Industrial Disputes Act, 1947 for investigation and settlement of indu

Determine the full study sample size, 1. An element of work has been measur...

1. An element of work has been measured 6 times, with the following results (units of 0.01 minutes): 18, 20, 19, 21, 19, 22. What should be the full-study sample size?  Answer:

Poms-Exercise 01 Decision Tree for Capacity Planning, Ask Poms-Exercise 01 ...

Ask Poms-Exercise 01 Decision Tree for Capacity Planning Expando, Inc. is considering the possibility of building an additional factory that wouldproduce a new addition to its prod

Explain business systems analysis, Subject: Business Systems Analysis. Assi...

Subject: Business Systems Analysis. Assignment 4 Using the book 'Essentials of System Analysis and Design, 4th Edition Read the Hoosier Burger scenario on page 199 in Chapter 6 of

Explain advantages of matrix organization, Explain advantages of matrix org...

Explain advantages of matrix organization. Advantages of matrix organization (i)  Permitting better planning and control to meet deadline if effectively focuses resource

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