Find forecasted sales for week first, 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.


Mumbai

Chennai

Lucknow

Delhi

Kolkata

OP Bal

120

350

270

250

350

Safety Stock

60

125

150

100

200

Min Ord Qty

80

200

200

100

300

Lead time Wk

1

2

3

2

3

Transit





300

Sales Forecast






Wk 1

50

100

150

50

100

Wk 2

35

75

100

75

150

Wk 3

55

125

150

80

200

Wk 4

65

100

200

55

135

Wk 5

80

200

300

75

125

Wk 6

125

150

200

80

165

Wk 7

50

100

100

90

200

 


Related Discussions:- Find forecasted sales for week first

Explain statistical process control, Which one of the following is NOT one ...

Which one of the following is NOT one of the basic elements of the strategic management process A. Strategy formulation B. Strategy implementation C. Statistical process control D.

Explain effect on a service delivery system, Why does volatility of demand ...

Why does volatility of demand have a higher effect on a service delivery system than on a manufacturing system?

Compute the start and finish times for each activity, Calculate the start a...

Calculate the start and finish times for each activity and determine the minimum number of weeks for completing the project. Find the critical set of activities for the project.

Case study, After working for 30 years, Ramjee Somjee Dutt opted for VRS an...

After working for 30 years, Ramjee Somjee Dutt opted for VRS and started a courier company and did very well in the first four years. He was now looking for expansion of his busin

Sample range chart - control charts for variables, Sample Range Chart - Con...

Sample Range Chart - Control Charts for Variables Whilst the sample mean chart provides control over the process setting, it provides no protection from change (increase) in t

Explain the basic idea underlying the contingency view, Explain the basic i...

Explain the basic idea underlying the contingency view. How would you go about identifying key contingencies facing an organization?

What is the number of orders per year if the manager uses, A flower shop us...

A flower shop uses 800 clay pots a month. The pots are purchased at $2 each. Annual carrying costs are estimated at $0.60 per pot per year and ordering costs are $20 per order. The

Soft factors - factors affecting productivity improvement, Soft Factors - F...

Soft Factors - Factors Affecting Productivity Improvement People are the most important factor in any organisation, not only by the way in which they apply themselves to their

Impact of internet on new product development, Question 1: Illustrate t...

Question 1: Illustrate the different types of stores layout Free-Flow Layout Grid Layout Loop Layout Spine Layout Question 2: Describe the ingredient

Explain what is the functionality of the function strstr, What is the funct...

What is the functionality of the function strstr and stristr?

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