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 variations in the material characteristics, Rivets used to secure t...

Rivets used to secure the stainless steel sheet metal of aircraft wings are designed to withstand certain shearing forces. It is known that because of random variations in location

Explain firewalls and encryption, 1. Since the creation of DHS, the Postal ...

1. Since the creation of DHS, the Postal Service is no longer in the business of fighting computer-generated crimes such as child pornography. True or False 2. During the first era

Disadvantages, What are the disadvantages of operation management?

What are the disadvantages of operation management?

Explain what monthly penalty is the company incurring, A food processor use...

A food processor uses approximately 29,730 glass jars a month for its fruit juice product. Because of storage limitations, a lot size of 4,000 jars has been used. Monthly holding c

Explain strategic marketing plan and tactical marketing plan, Differences a...

Differences and similarities between marketing plan, strategic marketing plan and tactical marketing plan

Compute the labour productivity, 10 person assembly line, 160 valves produc...

10 person assembly line, 160 valves produced during 8 hour shift, calculate the labour productivity

Explain what are the pros and cons of the control system, What kind of cont...

What kind of control systems are being used to measure the performance of hospitals and their different kinds of employees such as doctors and nurses? What are the pros and cons

Explain what is the recommended production rate, The forecasted demand for ...

The forecasted demand for fudge for the next four months is 140, 160, 90 and 70 pounds. A) What is the recommended production rate if a level strategy is adopted with no back order

Explain about the just in time philosophy, Explain about the just in time p...

Explain about the just in time philosophy. Just in time (JIT): This philosophy requires which products must only be produced when there is an internal/external customer w

Explain the rop that will provide a risk of stockout, Given this informatio...

Given this information: Expected demand during lead time = 300 units Standard deviation of lead time demand = 30 units Determine each of the following, assuming that lead time dema

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