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

Describe what is the basic problem causing this conflict, You are the plant...

You are the plant manager at Acme Plastics. You are running two shifts, a day shift and an evening shift. Before the day shift leaves each day, the workers must get an adequate sup

Explain project lacking a time-phrase baseline, Create a worst-case scenari...

Create a worst-case scenario for a project lacking a time-phrase baseline. Also discuss if you were ever in such a situation, the outcomes of the situation and what you learned. Th

Explain a set of circumstances consider disciplinary action, Describe a set...

Describe a set of circumstances under which you might legitimately consider disciplinary action for a chronic complainer.

Explain current design strategy, In what ways does an airline alliance refl...

In what ways does an airline alliance reflect each of the four dominate themes of current design strategy?

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

Determine that the trade offs of operation system is correct, Determine tha...

Determine that the Trade offs of operations systems is correct You may wish to ponder this trade-offs for a moment and ask the question: is this correct? Consider an organisat

Explain the job performed by engineers, 1. What are some of the major diffe...

1. What are some of the major differences between the job performed by engineers and the job performed by engineer managers?

Discuss what responsibility businesses towards environment, Environment Ple...

Environment Please respond to the following: •From the video, take a position on the ethical aspects of the logging industry on the local economies and the environment in the North

Explain create a rfp for a bpo in a factious organization, Create a RFP for...

Create a RFP for a BPO in a factious organization and explain why you would use different parts. Defend you choices to the executive team tasked with the outsourcing project.

Compute the probability that a type1 customer arrives, Consider a queuing s...

Consider a queuing system with 2 types of customers. Type 1 customers arrive according to a Poisson process with a mean rate of 5 per hour. Type 2 customers arrive according to a P

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