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

Aishat, A company has the following forecast demand for the next five month...

A company has the following forecast demand for the next five months: 1,600, 2,400, 3,200, 2,800, and 2,400. The following information is also available. current

Layout and flow, what are the objectives that an operation should seek in o...

what are the objectives that an operation should seek in order to ensure a good layout

What are the classified different stock items, What are the classified diff...

What are the classified different stock items? The ABC system of inventory management Various stock items are classified as like: a. High value (A) b. Medium value (B

Explain relationship between the company''s values, What is the relationshi...

What is the relationship between the company's values and strategy? Provide real world examples. Additional research is necessary by using scholarly publications. Cite accordingly

I need excel backup to understand a problem, Need Excel backup to understan...

Need Excel backup to understand how to answer this question. Bob White leaned back and wiped his forehead with his hand. He was the president of the home oven division of Winkley &

Explain cause and effect diagram and pareto analysis, What are the advantag...

What are the advantages and disadvantages of using a Cause and Effect diagram and Pareto Analysis in terms of analyzing quality issues? Respond to at least two of your classmates'

Explain medical facility does mris for sports injuries, A medical facility ...

A medical facility does MRIs for sports injuries. Occasionally a test yields inconclusive results and must be repeated. Using the following sample data and n = 195. SAMPLE 1 2 3 4

Explain what is product configuration, What is product configuration? Provi...

What is product configuration? Provide an example of how this practice is used in the sale of commercial stereo equipment

Explain global environmental concepts, Consider an international firm you a...

Consider an international firm you are familiar with, and consider what the firm needs to be concerned about when entering a foreign marketplace. Specifically, in terms of the chap

Calculate mad for each forecast, Weekly sales of copy paper at Cubicle Supp...

Weekly sales of copy paper at Cubicle Suppliers are in the table below. Forecast week 8 with a three-period moving average and with a four-period moving average. Compute MAD for ea

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