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

What additional steps must the quality assurance team take, A quality analy...

A quality analyst wants to construct a sample mean chart for controlling a packaging process. He knows from past experience that the process standard deviation is two ounces. Each

Explain interactive design mean, What does the concept of interactive desig...

What does the concept of interactive design mean for a service such as the adventure playground described here?

Define effective sharing of knowledge within organization, Given the rate o...

Given the rate of technological change and global market pressures, there is considerable change and uncertainty in many organizations. Organizational value is determined more by

Objectives of operation process chart, Objectives of Operation Process char...

Objectives of Operation Process chart 1. It helps to decide whether a further and more detailed record is needed. 2. It is used in the design stages to assist the layout of th

Find loan payment than the lease payment, Sutton Corporation, which has a z...

Sutton Corporation, which has a zero tax rate due to tax loss carry-forwards, is considering a 5-year, $6,000,000 bank loan to finance service equipment. The loan has an interest r

Explain web based training, What are some of the various opportunities that...

What are some of the various opportunities that automation has afforded, such as: telecommuting; remote work arrangements; teleconferencing; web based training etc.? What you see a

Find distance of hospital to furthest town is minimizes, Suppose a new hosp...

Suppose a new hospital is to be built to provide emergency medical healthcare service to 5 town w coordinates (5,6), (1,3), 13,7), (11,2), (18,1) on a map. The existing transportat

Explain it by using a flowchart, Pizza USA is a chain of pizza restaurants ...

Pizza USA is a chain of pizza restaurants offers sit down and take out service. Part I as the customer: make a list of the attributes of a pizza delivery of pizza delivery that are

Explain should wang take the quantity discount, Wang Distributors has an an...

Wang Distributors has an annual demand for an airport metal detector of 1,400 units. The cost of a typical detector to Wang is $400. Carrying cost is estimated to be 20% of the uni

Explain what would be your total cost, A manufacturing firm is considering ...

A manufacturing firm is considering two locations for a plant to produce a new product. The two locations have fixed and variable costs as follows: Site Fixed Cost (Annual) Variabl

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