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 a leader who is self-centred, The dimensions describes a leader who...

The dimensions describes a leader who is self-centred, conflictual, and status conscious

Find forecast energy use for spring, An Electric Company estimates its dema...

An Electric Company estimates its demand trend line (in millions of kilowatt hours) to be D = 79 + 0.52 Q, where Q refers to the sequential quarter number and Q=1 for winter 2000.

Explain what is the asset turn over, Given the following information: sa...

Given the following information: sales:48,000,000 CGS:24,000,000 Variable expense:8,000,000 fixed expenses:8,000,000 inventory:6,000,000 account receivable: 3,000

Explain significance of the brainstorming suggestions, Assess the significa...

Assess the significance of the brainstorming suggestions and determine how you might use this information to improve the chances of the project's success

Discuss the existence of an agency at the time the contract, Paul Gett is a...

Paul Gett is a well-known wealthy financial expert living in the city of Torris. Adam Wade, Gett's friend, tells Timothy Brown that he is Gett's agent for the purchase of rare coin

Explain future trends in advertising, Either through research or through im...

Either through research or through imagination, describe future trends in advertising?

Why knowledge is vital supervisor''s tactical planning, Why should a first-...

Why should a first-line supervisor understand the organization's objectives? Why is this knowledge important to the supervisor's tactical planning?

Explain manufacturing and service processes using queuing, Briefly compare ...

Briefly compare and contrast the manufacturing and service processes using queuing and assembly lines as your items to compare and contrast

Formulate an integer programming model using excel solver, New fire station...

New fire stations are to be located in a city and the major of the city wants to decide where to locate the 2 fire stations. For planning purposes, the region has been divided into

Why the supply chain management such a topic of interest, Why is supply cha...

Why is supply chain management such a topic of interest lately, especially multifacility distribution?

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