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

Describe what is the productivity, A local market research firm has just wo...

A local market research firm has just won a contract for several thousand small projects involving data gathering and statistical analysis. In the past, the firm has assigned each

Aid how to enter the answer after the equal sign using excel, Can someone s...

Can someone show me how to enter the answer after the equal sign using excel 2010

Hospital management requirement, The local hospital's emergency department ...

The local hospital's emergency department has 5 trauma bays. On average, patients requiring a trauma bay arrive every 50 minutes (with a coefficient of variation of 1, no seasonali

Explain an approach to a business diversity program, Answer the following q...

Answer the following questions based on your readings. 1. Describe an approach to a business diversity program that would be pragmatic and ethical. 2. What are three possible

Describe what do the results of the questionnaire suggest, How do you react...

How do you react to conflict? Do you have a typical style as a leader when dealing with a conflict situation? Complete the Conflict Style Questionnaire. What do the results of the

Innovation and learning perspective - performance measures, Innovation and ...

Innovation and Learning Perspective - Performance Measures In this perspective, the company emphasises the design and application of business management initiatives that foste

Describe the appropriate marketing-mix strategy, Marketers traditionally cl...

Marketers traditionally classify products on the basis of characteristics: durability, tangibility, and use (consumer or industrial).  for each product type by way of real-life exa

Explain negotiation script for a job, Q1. What are some examples of a negot...

Q1. What are some examples of a negotiation script for a job Q2. Lori Cook produces "Final Exam Care Packages" for resale by her sorority. She is currently working a total of 5

Compute the operating characteristics of interest, An urn contains nine whi...

An urn contains nine white balls and 11 black balls. A ball is drawn and replaced. If the ball is white your opponent pays you 25 cents. If it is black you pay him 25 cents. You ha

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