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

Define what changes in dividends will affect the stock price, AirJet Best P...

AirJet Best Parts, Inc. is concerned regarding recent changes in its stock prices for the company and would like to determine the stock prices for key competitors. Key competitors

Explain traditionally non-user input environment, To what extent should end...

To what extent should end users be involved in the design of a database? How have our ideas of agile development environments affected this traditionally non-user input environment

Define the relationships among the four functions of manage, Explain the re...

Explain the relationships among the four functions of management? Please dont copy paste from google.

Define what would the average inventory be for this lot size, A chemical fi...

A chemical firm produces sodium bisulfate in 100-pound bags. Demand for this product is 20 tons per day. The capacity for producing the product is 50 tons per day. Setup costs $100

Explain multifactor productivity, The following table shows data on the ave...

The following table shows data on the average number of customers processed by several bank service units each day. The hourly wage rate is $15, the overhead rate is 1.0 times labo

States the numerical flexibility workforce, States the numerical flexibilit...

States the numerical flexibility workforce? Numerical flexibility allows a firm to adjust quickly to changing levels of demand through increasing or decreasing the number of

Describe harley davidson has excess capacity, Harley Davidson sells motorcy...

Harley Davidson sells motorcycle X and Y. Motorcycle X sells for $10,000, has variable cost (labour and material) of $2,000, and requires 10 hours of use of machinery to produce. M

Location analysis, explain the series of steps involved and various factor...

explain the series of steps involved and various factor effecting location decion?

Explain optimization technique and a heuristic to solve, What is the differ...

What is the difference between using an exact optimization technique and a heuristic to solve a problem?

Explain challenges has the european union consortium faced, Describe what c...

Describe what challenges has the European Union Consortium faced in the last 2-3 years

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