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 vertical integration as a supply chain strategy, Locate an organiza...

Locate an organization that has used vertical integration as a supply chain strategy. Describe in detail why you believe vertical integration was/was not the appropriate strategy.

Explain setup cost is independent of order size, 1. A stock out occurs when...

1. A stock out occurs when an item that is typically stocked is not available to satisfy a demand the moment it occurs. 2. A backorder occurs when a customer order cannot be fil

Compute a simple exponential smoothing forecast, The actual demand of the p...

The actual demand of the patients at Omaha Emergency Medical clinic for the first six weeks of the year are as follows: week Actual # of patients 1 65 2 62 3 70 4 48 5 63 6

Operation Management, A paper mill produces two grades of paper viz., X and...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

Explain important terms of the factories act 1948, Explain important Terms ...

Explain important Terms of the factories act 1948. Important Terms of act: (a) Factory:  A place wherein ten or more persons are working and wherein a manufacturin

Describe the response of the organization, The issue of fraud must be consi...

The issue of fraud must be considered when managing risk as it could present a major liability to the organization. Fraud is an act that requires an aggressive response and correct

Explain calculated values in descending order on the same, Create a procedu...

Create a procedure in VBA to do the following actions: -Create a linear series of numbers starting at 1 (e.g. 1, 2, 3,) -Display a Message Box asking if you'd like to calculate ano

How to find the order quantity, The supplier is reliable and maintains a co...

The supplier is reliable and maintains a constant lead time of 5 days. The cost of placing an order is $10 and the cost of holding inventory is $0.50 per unit per year. There are n

Define the investigation of the purchasing department, Q. Define the invest...

Q. Define the investigation of the purchasing department. Investigation of a purchasing department: It is the responsibilities of a purchasing department. a. Receiving material

How enhance organizational behaviour, According to Morgan (2006), "All theo...

According to Morgan (2006), "All theories of organization and management are based on implicit images or metaphors that lead us to see, understand, and manage organizations in dist

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