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

Compute the seasonal index, A seasonal index for a monthly series is about ...

A seasonal index for a monthly series is about to be calculated on the basis of the past four years' accumulation of data. the four previous July values were 110, 135, 125, and 130

Explain the advise to manager to take advantage of the offer, A manager rec...

A manager receives a forecast for next year. Demand is projected to be 580 units for the first half of the year and 930 units for the second half. The monthly holding cost is $2 pe

Distinctive of the growth stage of the product life cycle, Which of the fol...

Which of the following is a characteristic of the growth stage of the product life cycle? Advertising emphasis switches to selective demand. There is a growing proportion of

Find revenue growth and overall financial performance, What actions do you ...

What actions do you think management at Sam's Club should take to boost revenue growth and overall financial performance? What actions do you think management at BJ's Wholesale sho

Describe what is a learning organization, What is a learning organization a...

What is a learning organization and how do you develop one

Simultaneous motion cycle, Simultaneous Motion Cycle: It is sometimes ...

Simultaneous Motion Cycle: It is sometimes  required  to record in  minute  detail the  simultaneous  movement    of the different    parts of  the body  of an  operator  duri

Sunshine enterprises case study answers, what is the average value of loyal...

what is the average value of loyal customer at abby''s restaurants?

Explain difference between two population means, In estimating the differen...

In estimating the difference between two population means, if a 95 percent confidence interval includes zero, then we can conclude that there is a 95 percent chance that the differ

Asseyment, what used materials for made the Turbine blades which endures vi...

what used materials for made the Turbine blades which endures vibrations and saline conditions and why?

How to determine the sample standard deviation, Determine the sample standa...

Determine the sample standard deviation(s) for the following data: 7, 9, 2, 0, 1, and 5. s = 2.805 s = 3.266 s = 2.927 s = 3.578

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