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 what is the contribution ratio, Foster Company makes power tools. T...

Foster Company makes power tools. The budgeted sales are $420,000, budgeted variable costs are $147,000, and budgeted fixed costs are $227,500. What is the budgeted operating in

Describe under what conditions purchase the new equipment, Assume that you ...

Assume that you are offered a new piece of equipment for $10,000. The equipment will produce 10,000 units per year with a margin of $6.00 per unit. Demand for the product being pro

Competitor charges for same golf clubs in that market, Gibson Golf Clubs ma...

Gibson Golf Clubs manufactures titanium golf clubs and sells them in retail outlets all over the U.S. and Europe. GGC is revising its current pricing structure. Would the following

Explain the network is overloaded, Information asymmetry exists when - T...

Information asymmetry exists when - The network is overloaded - Sellers and buyers have the same information - One party in a transaction had more important information th

Explain level of threshold service of a least-cost system, What is meant by...

What is meant by the level of threshold service of a least-cost system

Explain primarily used to help design products, Which of the following is p...

Which of the following is primarily used to help design products that will connect product attributes with customer desires?

A trial balance discloses how many types of errors, A Trial Balance disclos...

A Trial Balance discloses how many types of errors? A Trial Balance discloses errors that are given below:   i)    An item posted double.   ii)   A mistake into posting.

Explain ambrose undergoes a restructuring, Marta is 57 and has been a store...

Marta is 57 and has been a store manager for Ambrose & Company for 10 years. Ambrose & Company is a retail store for fashion forward women. Ambrose undergoes a restructuring and re

Explain why do companies that advertise their csr policies, 1. Why do compa...

1. Why do companies that advertise their CSR policies so often face serious controversies anyway 2. Identify an area in which Apple is regarded as responsible to a stakeholder

Explain when managing organizational change, When managing organizational c...

When managing organizational change, which would be more effective in overcoming resistance to change: rational persuasion, leader-follower relationship, both, or something else

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