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

Problem on abc analysis of inventory, Problem on ABC Analysis of Inventory:...

Problem on ABC Analysis of Inventory: The ABC Analysis of Inventory divides inventory into three classes: Class A - high annual dollar volume Class B - medium annual doll

Explain what is the workstation cycle time, 1. Some tasks and the order in ...

1. Some tasks and the order in which they must be performed according to their assembly requirements. These are to be combined into workstations to create an assembly line. The

Dipict the network diagram, Four parts (A, B, C, and D) are processed throu...

Four parts (A, B, C, and D) are processed through a sequence offour operations (1, 2, 3, and 4). Not all parts are processed inall operations. Part A, which has weekly quantities o

Explain investment spending sharply declined in the us, In early 2001, inve...

In early 2001, investment spending sharply declined in the U.S.. In the two months following the Sept. 11, 2001 attacks on the U.S., consumption also declined. Use AD-AS analysis t

Define the investigation of the purchasing department, Q. Define the invest...

Q. Define the investigation of the purchasing department. Investigation of a purchasing department: It is the responsibilities of a purchasing department. a. Receiving material

A food manufacturer wants to know facts to buy organic foods, Which type re...

Which type research design - exploratory, descriptive, or casual - is appropriate for the following examples? Explain why? A food manufacturer wants to know the demographics of peo

Explain assess the importance of slack, Assess the importance of "slack" to...

Assess the importance of "slack" to the project manager

Explain annual demand for an airport metal detector, ABC distributors has a...

ABC distributors has an annual demand for an airport metal detector of 1,400 units. The cost of a typical detector to ABC is $400. Carrying cost is estimated to be 20% of the unit

Describe questionable behaviour, Please answer a detailed explanation for t...

Please answer a detailed explanation for the following scenario: Your Company has recently hired a new employee for an upper level management position. They have performed exceptio

Describe why it is both a business pressure, Explain why IT is both a busin...

Explain why IT is both a business pressure and an enabler of response activities that counter business pressures?

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