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 assess the impact of group think and slackers, Assess the impact of...

Assess the impact of group think and slackers to the overall performance of the team and make two recommendations for how that impact could be mitigated. Provide specific examples

Compute the expcted inflation rates for each year, The Fed is concerned wit...

The Fed is concerned with interest rate levels and the possibilitiy of inflation. Given the gollowing information, calculate the expected inflation premiums over hte next three yea

Analyze on the price of heating oil, Question For the financial year 20...

Question For the financial year 2012-2013, it has been decided the equalization of the tax on heating oil with the tax on fuel, thus increasing the price of heating oil. Do you

When is the ordering cost decreased, When is the ordering cost decreased? ...

When is the ordering cost decreased? Ordering cost falls while the size of order increases. It is because when the size of order raises for the similar quantity of inventory pu

Explain ethical for employers to use information technologie, Is it ethical...

Is it ethical for employers to use information technologies to extend work into employees home lives?

Factors considered when recruiting salesmen, SUMIT Products Ltd. is a compa...

SUMIT Products Ltd. is a company that produces and markets steel cups, teaspoons, knives and forks for the catering industry. The company was established in 1958 in response to the

Describe objective functions for an lp model equivalent, Are the following ...

Are the following objective functions for an LP model equivalent? That is, if they are both used, one at a time, to solve a problem with exactly the same constraints, will the opti

Public Administration, Is the city management form of government better tha...

Is the city management form of government better than the mayor and council form of government?

Fraction defective p chart - control charts for attributes, Fraction Defect...

Fraction Defective P Chart - Control Charts for Attributes This type of chart is used when it is impractical or inconvenient to maintain a constant sample size. Instead of pl

Explain roles and function of an hr professional, 1. What do you see as th...

1. What do you see as the most interesting part of HR as a career field? 2. What do you think are the roles and function of an HR professional?

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