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 can you provide examples of voluntary boundaries, Can you provide e...

Can you provide examples of voluntary boundaries, core practices, and mandated boundaries in various industries? Why do the boundaries you identify fit within each category?

Explain how to do aon in excel 2010, Does anyone know how to do aon in Exce...

Does anyone know how to do aon in Excel 2010 and if so can they contact me and wlk me through it sso that I can understand it

Define a solid business strategy includes, 1.__?__________ are the basic un...

1.__?__________ are the basic unit of analysis and the focus of nonmarket action 2. The market environment of business includes___________.? 3. Firms typically deal with nonm

Airbus, 1)?An analysis of type of operations carried out and operating proc...

1)?An analysis of type of operations carried out and operating processes (i.e., project, batch, mass, professional service, service shop,?mass service, etc.) 2)?An identification

Explain what values of q and r is carmins boutique currently, Carmin's Bout...

Carmin's Boutique sells a large number of black dress shirts. The shirts, which bear the store label, are shipped from a manufacturer in Paris. Carmin's purchasing department manag

Define the importance of employees, Discuss the importance of employees and...

Discuss the importance of employees and information technology in the delivery of service quality. Use two examples of service firms to help support your discussion

Explain formulate and solve a linear optimization model, Klein Industries m...

Klein Industries manufactures three air compressors: small, medium, and large, which have unit profits of $20.50, $34, and $42 respectively. The monthly projected sales of small ar

Compute the minimum replenishment time to build model, Calculate the minimu...

Calculate the minimum replenishment time to build 2500 Model A fountains given the following beginning inventories?

Compute xpected top-down estimated cost for project, You have been asked to...

You have been asked to estimate the costs for a project to build an industrial power plant. Based on historical data, the steam turbine accounts for 30 percent of the total costs f

Explain union can legally dismiss the grievance, Joyce is a problem employe...

Joyce is a problem employee. She is often late and does low-quality work. The shop steward sees the performance problems. One day a new position opens and Joyce applies for it b

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