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

What is grapevine, What is Grapevine? Ans: Grapevine is an informal ...

What is Grapevine? Ans: Grapevine is an informal communication system.

Explain what was the net gain or loss for the year, 1. A venture capitalist...

1. A venture capitalist company had invested in five new businesses during the last year. The results at the end of one year were as follows: Business A: Loss $500,000, Business B:

I have some charts that i need help to put it in excel, I have soem charts ...

I have soem charts that were done i word how do I gt them to you for someone to put in excel for me

Draw a 3-sigma p-chart using this information, The results of inspection of...

The results of inspection of DNA samples taken over the past 10 days are given below. Sample size is 100. Days: 1 2 3 4 5 6 7 8 9 10 Defectives: 7 6 6 9 5 6 0 8 9 1 a) Con

Difference between, Give difference between assembler, compiler and interpr...

Give difference between assembler, compiler and interpreter

Describe the company''s strategic goals, At the conclusion of Baidu's final...

At the conclusion of Baidu's final strategic planning session, Robin Li (Cofounder, Chairman, and CEO) assigned you to prepare a written report and announcement that would be prese

Explain lifestyle entrepreneur, Define the following in your own words, do ...

Define the following in your own words, do not copy and paste, won't give points for that Lifestyle Entrepreneur Serial Entrepreneur Classic Entrepreneur

Presentation of performance measures - operations strategy, Presentation of...

Presentation of Performance Measures - Operations Strategy A useful way of presenting performance measures is to sketch them in a polar representation with each line represent

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