Compute forecasted sales, 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 . The Table datas are as follows....... Mumbai: Op Bal = 120, safety Stk = 60, Min Ord Qty = 80, Lead Time = 1 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 50,35,55,65,80,125 & 50 Respectively. Chennai: Op Bal = 350, safety Stk = 125, Min Ord Qty = 200, Lead Time = 2 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 100,75,125,100,200,150 & 100 Respectively. Lucknow: Op Bal = 270, safety Stk = 150, Min Ord Qty = 200, Lead Time = 3 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 150,100,150,200,300,200 & 100 Respectively. Delhi: Op Bal = 250, safety Stk = 100, Min Ord Qty = 100, Lead Time = 2 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 50,75,80,55,75,80 & 90 Respectively. Kolkata: Op Bal = 350, safety Stk = 200, Min Ord Qty = 300, Lead Time = 3 Week, Transit = 300, Sales Forecast Week 1 to Week 7 = 100,150,200,135,125,165 & 200 Respectively


Related Discussions:- Compute forecasted sales

Calculate seasonal indices using all of the data, Attendance at Los Angeles...

Attendance at Los Angeles's newest Disneylike attraction, Vacation World, has been as follows- Quarter Guest in Thousands Quarter Guest in Thousands Winter 07 73 Summer 08 12

Describe mpc can run independent of the operation plan, Which of the follow...

Which of the following is true? MPC can run independent of the operation plan. Business failure can result from poor MPC performance. In PAC, order release directly affect

What do you think joe thomas must do about this matter?, What do you think ...

What do you think Joe Thomas should do about this matter?

After working for 30 years, In the table given below the Distribution Manag...

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 woul

Explain what capability would an organization have, What capability would a...

What capability would an organization have to have to not need forecasts?

Explain perform an analysis of the social, Perform an analysis of the socia...

Perform an analysis of the social / demographic, technological, economic, environmental / geographic, and political/legal / governmental segments to understand the general environm

What factors are likely cause faults in valuing google stock, The managemen...

The management and Directors of Google have stated that there is no plan for Google to ever pay dividends. Yet, the stock trades at a very high price in dollar terms (around $490 p

Explain kudler fine foods virtual organization, Resources: University Libra...

Resources: University Library, Kudler Fine Foods Virtual Organization Use the Virtual Organization link on the student website to access additional company information on Kudler

Explain the pros and cons of the theory, Explain the McGregor's Theory x-y,...

Explain the McGregor's Theory x-y, the pros and cons of the theory

Explain objective of value stream mapping is to improve data, 1) Bill of ma...

1) Bill of material errors can cause serious problems for MRP system calculations of dependant demands 2) No matter what forecasting technique is used, the probability of a prod

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