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 keeping your personal customer data the cloud, Some companies run t...

Some companies run their entire business by offering cloud services called Software as a Service (SaaS). There are several advantages for companies and individuals to use SaaS. But

Determine the optimal order size and total inventory cost, Case Study: ...

Case Study: The ePoint Store stocks paint in its warehouse and sells it online on its Internet Web site. The store stocks several brands of paint; however, its biggest seller i

Availability of raw materials , Factors responsible for plant location choi...

Factors responsible for plant location choice - Availability of Raw Materials Areas where industrial raw materials are easily available obviously exert greater pull on locatio

Statistical Process Control (SPC), I have an excel assignment for the SPC, ...

I have an excel assignment for the SPC, so I want to know if you could do it and how much will it cost?

Determine the layout decision, Determine the Layout Decision Consider ...

Determine the Layout Decision Consider a layout decision which has been made in your own organisation. How was the layout devised? What were the key issues?

Explain what is the labor productivity, The weekly output of a fabrication ...

The weekly output of a fabrication process is shown below together with data for labor and material inputs. Standard selling price is $100 per unit. Overhead is charged weekly at t

Explain what is the expected value of perfect information, Renesmee Corpora...

Renesmee Corporation is a chemical company. The research and development manager is trying to decide whether or not to develop a new solvent that would work at all conditions. It i

Explain developing the project plan, In terms of developing the project pla...

In terms of developing the project plan, identify which, if any, of the project steps are more integral to the project plan than any others. Support your response

Industrial production index, Industrial Production Index The measure of...

Industrial Production Index The measure of the combined output of all products like mining, manufacturing, and electric and natural gas utilities organization in the United Sta

Explain levels of management, Explain levels of management. Levels o...

Explain levels of management. Levels of Management: Industrial management has got the given activity levels: 1)  Top Management : this includes Board of Directors, Ma

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