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

Find revenue from its recently won government contract, Buckeye Manufacturi...

Buckeye Manufacturing expects to generate additional revenue from its recently won government contract. Buckeye forecasts that the revenue will be $40 million in the first year, bu

Explain manual order management system, Mr. McNeely currently batches order...

Mr. McNeely currently batches orders for processing under the manual order management system. The orders are batched for daily processing. If Mr. McNeely opts to implement a Web-ba

Explain best decision based on an expected monetary value, The product desi...

The product design group of Flores Electrick Supplies, Inc., has determined that it needs to design a new series of switches. It must decide on one of three design strategies. The

Explain activity immediate predecessor normal time, The Scott Corey account...

The Scott Corey accounting firm is installing a new computer system, and several things must be done to make sure the system works properly. The following table provides informatio

Explain planning of the project, You have been appointed as a project manag...

You have been appointed as a project manager for a high dollar project for the private sector and you have been asked by your boss to identify the stakeholder groups and the indivi

Basic stages, basic stages of Operation Management

basic stages of Operation Management

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

Explain deviance and a moderate level of cohesiveness, Why is it important ...

Why is it important for groups and teams to have a balance of conformity and deviance and a moderate level of cohesiveness?

Explain a recruitment process, Describe a recruitment process that would pr...

Describe a recruitment process that would provide a pool of pre-qualified candidates for the seven open trainer positions.

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