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 control board meeting to approve a scope change, Which of the follo...

Which of the following is normally not addressed in a change control board meeting to approve a scope change? Answer Cost of the change Which functional unit will perform

How reduce the safety stock, The annual demand for a product is 15,600 unit...

The annual demand for a product is 15,600 units. The weekly demand is 300 units with a standard deviation of 90 units. The cost to place an order is $31.20, and the time from order

Explain low customer contact and are capital intensive, What are companies ...

What are companies that have low customer contact and are capital intensive; yet provide a service, called?

Explain about changing the layout of empty cubicles, Is there an optimal si...

Is there an optimal size for all organizations? Also how should one go about changing the layout of empty cubicles?

Explain writing the final case study and strategic plan, Read the Starbucks...

Read the Starbucks Global Quest 2006: Is the Best Yet to Come? Case provided in the Course Materials section. From the perspective of an executive with the firm, prepare a 10-12 pa

Explain how does this sort of thing happen in organizations, We have all wo...

We have all worked with someone who did not seem to fit the role for which he or she was hired, or did not seem to fit in with the organization, or did not have the right skills fo

Explain why was the federal food and drug, 1. How does the Fair Debt Collec...

1. How does the Fair Debt Collection Practices Act benefit consumers? 2. Why was the Federal Food, Drug, and Cosmetic Act passed? Please use at least one research site to sup

MBA 2ND SEM, Q3. What do you understand by “line balancing”? What happens i...

Q3. What do you understand by “line balancing”? What happens if balance doesn’t exist?

Explain carpet cleaning machine, Gabriela Manufacturing must decide whether...

Gabriela Manufacturing must decide whether to insource or outsource a new toxic-free miracle carpet cleaner that works with its Miracle Carpet Cleaning Machine. If it decides to in

Explain implementing large database systems and data, What issues can organ...

What issues can organizations experience when implementing large database systems and data warehouses? What best practices would you recommend to an organization to mitigate these

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