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

Explain how is production levelling related to 5s, How is production levell...

How is production levelling related to 5S and Value Stream Mapping?

Explain the value of the business you selected, Know discuss what business ...

Know discuss what business you selected and the best possible method for determining the value of the business you selected. Explain your rationale

Explain perspective of project manager to avoid the obstacle, Analyze why i...

Analyze why it is important to address risk through the entire project life cycle. Identify three possible negative results that can occur if an organization fails to address risk

Explain what additional steps should the quality assurance, A quality analy...

A quality analyst wants to construct a sample mean chart for controlling a packaging process. He knows from past experience that the process standard deviation is two ounces. Each

When are the holding costs raised, When are the holding costs raised? H...

When are the holding costs raised? Holding cost rises while the size of order rises. It is since a higher level of average stock will be kept during the year. Thus holding cost

Explain what are the three elements that require integration, What are the ...

What are the three elements that require integration to be successful in operations and supply chain management?

View of the cell used by jobs - process design, View of the Cell Used By Jo...

View of the Cell Used By Jobs - Process Design This figure gives a close-up view of the cell used by Jobs 1 and 2. Notice that neither of the jobs uses all of the processes in

Describe what the customer''s expectations, Explain what the customer's exp...

Explain what the customer's expectations are concerning the salesperson's attitude toward competition

Why health care cost are out of control in the united states, Discuss the f...

Discuss the following statement: "Health care cost are out of control in the United States, and increasing conflicts between employers and employees are likely as employers try to

Explain how the ebq change if the set-up costs is reduced, How would the EB...

How would the EBQ change if the set-up costs were reduced by 50 percent, and the holding costs were reassessed by 40 percent, taking account of the opportunity costs of capital at

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