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

Calculate the percent change in the labor ratios, A department employs 3 ty...

A department employs 3 types of workers: laborers earning $5 per hour, machine operators earning $9 per hour and maintenance workers earning $16 per hour. For a certain job over 2

Explain process of designing a database, We are agree that the user should ...

We are agree that the user should be involved in the design of the database. Class, how would you go about the process of designing a database? What processes are involved?

Bar chart - scheduling, Bar Chart - Scheduling A pictorial chart also ...

Bar Chart - Scheduling A pictorial chart also known as the bar chart was developed by Henry L. Gantt around 1990 and is used to deal with complex activities. Out of the variou

Propose process improvements, propose process improvements, and justify you...

propose process improvements, and justify your reasons, for the improvements, to the flowchart for answering calls.

Explain rules of the irs and department of labor, Rules of the IRS and depa...

Rules of the IRS and department of labor determine which workers quailfy as indenpendent contractor?

Would this need cause you to turn down this franchise, The franchise fee is...

The franchise fee is %u201Cthe one-time payment made to become a franchisee%u201D (Hatten, 2009, p. 142). Hatten also stated that %u201Csome agreements require you to have a percen

Explain layout need to be adjusted as demand for same goods, Base on the ca...

Base on the case study: Weldon Hand Tools; how would the layout need to be adjusted as demand for this and similar products builds up?

Compute the breakeven volume, The following table shows the critical factor...

The following table shows the critical factors in a company's decision on choosing a new piece of equipment. Calculate the breakeven volume and utilization for each option and then

Define what behavioural predictions might you make, What behavioural predic...

What behavioural predictions might you make if you know that an employee had an external locus of control? If an employee had a high need for achievement? If an employee had a low

Explain are restatements of the law written, Are restatements of the law wr...

Are restatements of the law written and revised by congress and state legislatures true or false

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