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 linear programming problem graphically, Solve the following linear ...

Solve the following linear programming problem graphically by enumerating the corner points. MAX: 3X1 + 4X2 Subject to: X1 X2 4X1 + 6X2 X1, X2 > 0 First

Explain which if any of the resources are over allocated, 1. Which if any o...

1. Which if any of the resources are over allocated? 2. Assume that the project is time constrained and try to resolve any over allocation problems by levelling slack. What happ

Explain car rental agency that calculates rental charges, Create a project ...

Create a project for the local car rental agency that calculates rental charges. The agency that calculates $15 per day plus $0.12 per mile. Form: Use text boxes for the customer n

Explain what design capacity would be needed, In a job shop, effective capa...

In a job shop, effective capacity is only 50% of design capacity, and actual output is 80% of effective output. What design capacity would be needed to achieve an actual output of

Explain what is an industry, What is an industry? (a) Industry is a grou...

What is an industry? (a) Industry is a group of diverse businesses under common owners. (b) Industry is a group of firms whose products have same and similar attributes such

Explain marketing and selling, What is your understanding of the terms: mar...

What is your understanding of the terms: marketing and selling? Are they the same? How do you differentiate the two terminologies? Provide examples to support your points.

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

What is lost while no feedback is required, What is lost when no feedback i...

What is lost when no feedback is required? What can an employee do to change this situation when it is a specific company policy NOT to provide feedback? Name two possible re

Explain first step in your data analytical project, Your final project enta...

Your final project entails systematic extraction of decision-aiding insights out of a dataset provided to you in the Doc Sharing area. This project will provide you with hands-on e

Factors for plant location choice, Factors for plant Location choice ...

Factors for plant Location choice Safety Requirements : Some production units may present, or may be believed to present potential dangers to the surrounding neighbourhood, e

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