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

Plant location, factor relating methods for locating a plant

factor relating methods for locating a plant

Explain what is the difference among lead time and lag time, Remember that ...

Remember that once you start linking tasks in the Gantt chart, changes might become more cumbersome. What are some tools or techniques that you can use to save yourself some hea

Explain waste elimination plan, Do a lean waste analysis on the goal and cr...

Do a lean waste analysis on the goal and create a waste elimination plan. (List the seven forms of waste, list items in the goal by waste form, determine what could be done to redu

Types of benchmarking, Briefly discuss benchmarking as process improvement ...

Briefly discuss benchmarking as process improvement tool. Explain six types of benchmarking and give four reasons why some businesses have failed to derive maximum benefit from it.

Synthesis method, Synthesis In many industries the work done is of...

Synthesis In many industries the work done is of a repetitive nature that is the product is produced in large number or in batches or varying sizes at irregular in

Explain advantages and disadvantages of membership, Define the use of regio...

Define the use of regional trade organizations in international business. Identify the Regional Trade Organization of which the United States is a member. What are some of the adva

What steps must to be taken to maximize the sales-price, Identify key gaps ...

Identify key gaps in planning for the exit. Provide recommendations on the exit strategy. Is the sale the right one? What steps ought to be taken to maximize the sales-price? What

Models, under which topic in operations management are models found?

under which topic in operations management are models found?

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