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

How a factory can produce high-quality products, Can a factory be fast, dep...

Can a factory be fast, dependable, flexible, produce high-quality products, and still provide poor service from a customer's perspective?

Explain why is forecasting important in organizations, Why is forecasting i...

Why is forecasting important in organizations, especially as related to understanding the relevant time horizon to develop a forecast against? What are some examples from industry?

Explain information systems, Write an essay of between 750-1000 words, doub...

Write an essay of between 750-1000 words, double-spaced, on the topic of information systems being leveraged to create competitive advantage for the business. Use well-known indust

Explain function of operational leadership, Create a scenario that depicts ...

Create a scenario that depicts how the first line leader should act to fulfil the purpose and function of operational leadership in his or her area

Make an aggregate plan, Prepare an aggregate plan for the coming year assum...

Prepare an aggregate plan for the coming year assuming that the sales forecast is perfect Use a spreadsheet Bradford Manufacturing in the spreadsheet an area has been designated fo

Explain what are some of the positive and negative impacts, What are some o...

What are some of the positive and negative impacts of federally mandated socioeconomic programs, goals, and quotas within the federal government contracting process?

Leaders are responsible for achieving desired results, Leaders must be held...

Leaders must be held accountable for achieving desired results. What does this mean to you?

Explain total quality improvement has changed healthcare, Analyze how total...

Analyze how total quality improvement has changed healthcare delivery on both the macro and micro levels.

Explain hospital risk pool, A hospital has contracted with an HMO to provid...

A hospital has contracted with an HMO to provide acute care inpatient services for $1,000 per day, subject to a 10 percent withhold. The proposed budget for inpatient services is b

Define the cost of equity as a check on the capm calculation, Was there som...

Was there some other way to estimate the cost of equity as a check on the CAPM calculation?

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