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

What benefit would utilize the optimal order quantity yield, Garden Variety...

Garden Variety Flower Shop uses 750 clay pots a month. The pots are purchased at $2 each. Annual carrying cost per pot are estimated to be 30 percent of the cost and ordering costs

Define the information security issues facing the government, Evaluate: Eva...

Evaluate: Evaluate the information security issues facing the government and identify its three biggest concerns. Application: Demonstrate how the government can use authentication

Question 2, Exercise 2: Use of a Grid Analysis (Weighted Scoring Model) to ...

Exercise 2: Use of a Grid Analysis (Weighted Scoring Model) to Help Make the North American Plant Location Decision for the RX 330 This exercise illustrates how when deciding among

Explain what are the activities required to produce, What are the outputs o...

What are the outputs of your work unit if you are a manager at a fast-food restaurant? What are the activities required to produce those outputs? What are the inputs?

Explain what type of transmission path, What type of transmission path does...

What type of transmission path does a fixed wireless signal require? a. line-of-sight b. non-line-of-sight c. omni-directional d. code divided

Explain a plan of viable business options for family fabrics, Case 1: You a...

Case 1: You are a consultant for a Fabric company that burned down, this company was the only source of income for many of the town people they all worked there, as a consultant to

Explain professor alan assured that he would do so, The University of North...

The University of North is the major state university. The University was preparing for its upcoming re-accreditation, so the University board set aside extra funds to make sure th

Explain leadership is more important in today''s flatter, Do you think lead...

Do you think leadership is more important in today's flatter, team based, employee empowered organizations? Why or why not?

Line balancing, Describe What happens if balance doesn’t exist

Describe What happens if balance doesn’t exist

Explain better plan capacity, The number of students enrolled at Spring Val...

The number of students enrolled at Spring Valley Elementary has been steadily increasing over the past five years. The school board would like to forecast enrolment for years 6 and

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