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 how hr evolved throughout this process, HR has moved from an admin...

HR has moved from an administrative function to a transformational function. This change is based on automating HR functions through an HRIS system. Explain how HR evolved througho

Explain work study, Explain work study. Definition of Work Study: it,...

Explain work study. Definition of Work Study: it, as defined by British Standard Institution, is a generic form for those techniques mainly 'Method Study' and 'Work Measureme

Explain safety stock would provide a stock out risk, The injection moulding...

The injection moulding department of a company uses an average of 30 gallons of special lubricant a day. The supply of the lubricant is replenished when the amount on hand is 170 g

Depict a project network that includes all the activities, Operations and S...

Operations and Supply Chain Management : CELL PHONE DESIGN PROJECT 1. Draw a project network that includes all the activities 2. Calculate the start and finish times for each

Explain improve motivation of the employees, You are a manager of a Consult...

You are a manager of a Consulting firm, with 25 employees under your supervision. Employee Motivation appears to be slipping as well as employee performance. Employees seem to have

Explain goals should be articulated by teams, Clearly-defined goals are the...

Clearly-defined goals are the essence of great teamwork. Which of the following statements is most true about how goals should be articulated by teams

Explain what use of the term sale rather than demand presume, What does use...

What does use of the term sales rather than demand presume?

Examples of productivity measures, Examples of Productivity Measures  ...

Examples of Productivity Measures  Sales ($)/labour costs ($)  Sales ($)/pay ($)  Total value of sales (billed) ($)/labour costs($) + investment ($)  Sales/salespeopl

Describe integrated systems management, Read the Location Selection through...

Read the Location Selection through Integrated Systems Management article. Define Integrated Systems Management in your own words and discuss the application of the 3 stages of fac

Calculate the path mean and network diagram, For the following data: ...

For the following data:   Time (in Days)   Activity Immediate Predecessor Optimistic Most Likely

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