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

Construct the control chart, Telephone inquiries of 100 cell phone company ...

Telephone inquiries of 100 cell phone company customers are monitored daily at random.  Incidents of incorrect information or other nonconformities (such as rudeness to customers)

Find project labour hours and cost and what profit amount, Midway through t...

Midway through the project your design and production people realize that a 75 percent improvement curve is more appropriate. What impact does this have on the project labour hours

Structural adjustment - factor affecting productivity, Structural Adjustmen...

Structural Adjustments - Factors Affecting Productivity Improvement Structural adjustment relates to the composition of society, the industries in which people work, fashions

Linear Programming Problem, A paper mill produces two grades of paper viz.,...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

Demerits of absolute standards and relative standards, Contrast the advanta...

Contrast the advantages and disadvantages of absolute standards and relative standards.

Define how communicate this decision to your employees, Case Study: Social ...

Case Study: Social Media Policies, Concerted Activity and HR Management In the last few years, companies have begun initiating and implementing Social Media policies for their e

Distinguish between legal and employee rights, Q1. What is the biggest chal...

Q1. What is the biggest challenge posed by egoisn Q2. Distinguish between legal and employee rights Q3. How is strategy different from a business model? How is it similar?

Linear trend equation, A cosmetics manufacturers marketing department has d...

A cosmetics manufacturers marketing department has developed a linear trend equation that can be used to predict annual sales of its popular Hand and Foot Cream. We are given F sub

Location, what are the globalization and geoghacical dispersion of operatio...

what are the globalization and geoghacical dispersion of operation

Assignment, What do you understand by “line balancing”? What happens if bal...

What do you understand by “line balancing”? What happens if balance doesn’t exist?

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