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

Describe how to do in excel, Can you show how to do in excel? Bowman Bui...

Can you show how to do in excel? Bowman Builders manufactures steel storage sheds for commercial use, Joe Bowman, president of Bowman Builders, is contemplating producing sheds

Define cross-cultural communication, When referring to Cross-Cultural Commu...

When referring to Cross-Cultural Communication, what would be the best approach to dealing with a multicultural environment.

Explain system for evaluating the productivity, As the administrative manag...

As the administrative manager in a law office, you have been asked to develop a system for evaluating the productivity of the 15 lawyers in the office. What difficulties are you go

Simultaneity of production & consumption of service product, Simultaneity o...

Simultaneity of Production and Consumption of Service Products There is no opportunity to place the service in inventory. This is not always completely, for instance, petrol i

Define conflict within a project team, What are the consequences of ignorin...

What are the consequences of ignoring a conflict within a project team?

Explain violate a federal law, Agents and employees of Apples Corporation a...

Agents and employees of Apples Corporation and Oranges Corporation are convicted of conspiring to violate a federal law that is punishable by a term of imprisonment and a fine. Can

Attract as well buyers to complete the on-line buying proce, It appears tha...

It appears that the potential to lose web site customers is a high rate (75%), so to provide research into troubleshooting to determine how to get customers to purchase product is

Case study, what are the most significant events in the story of how the pl...

what are the most significant events in the story of how the plant survived because of its adoptation of quality based principles?

Organisations operations strategy, Question: Operations strategies are ...

Question: Operations strategies are developed to ensure managers deliver goods or services that are better, cheaper and more responsive to customer needs. Comment on any three

Theory of constraints -toc, Theory of constraints -TOC The theory of c...

Theory of constraints -TOC The theory of constraints was first proposed in 1986 by Dr Eliyahu M. Goldratt in his widely read book The Goal. The theory of constraints is the pr

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