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

Justify the duration of the simulation and assumptions, Alabama Airlines op...

Alabama Airlines opened its doors in June 1995 as a commuter service with its headquarters and only hub located in Birmingham. A product of airline deregulation, Alabama Air joined

Explain planning of the project, You have been appointed as a project manag...

You have been appointed as a project manager for a high dollar project for the private sector and you have been asked by your boss to identify the stakeholder groups and the indivi

Valuate the production quantity, Using the data, suppose the manufacturer h...

Using the data, suppose the manufacturer has an inflated demand forecast as follows: Quantity Probability 2,200 5% 2,300 6% 2,400 10% 2,500 17% 2,600 30% 2,700

Theory of constraints -toc, Theory of constraints -TOC The theory of c...

Theory of constraints -TOC The theory of constraints was first proposed in 1986 by Dr Eliyahu M. Goldratt in his widely read book The Goal. The theory of constraints is the pr

Explain various types of media that attracted your attention, List five adv...

List five advertisements from various types of media that attracted your attention. Discuss the characteristics that determined your selection

Why competitive priorities are important, Androsia manufactures batik fabri...

Androsia manufactures batik fabrics in a labor intensive, low-volume process on the island of Andros. The Hershey tour shows how cocoa beans are processed into chocolate using a hi

Depict a graph of the exponential function, Solve for x: log_10?x=3 5. You'...

Solve for x: log_10?x=3 5. You've earned your degree and have been hired by an established company. You were able to negotiate a beginning salary of $2500 per month with annual 6%

Explain work in an information technology department, You are talking with ...

You are talking with another MIS 200student who is complaining about having to learn about the information systems development life -cycle (SDLC- Chapter 6), because he is not goin

Limitations of e-business, Limitations of E-Business 1.      Problems ...

Limitations of E-Business 1.      Problems relating to the security of the data  2.      Limitations of bandwidth (speed of data transmission)  3.      Standardisation o

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