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

Explain estimating the mean height of a sample of seedlings, A biologist re...

A biologist reports a confidence interval of (2.0,2.4) when estimating the mean height (in centimetres) of a sample of seedlings. What is the estimated margin of error and the samp

Explain requirements of alliance membership, In what ways might the divisio...

In what ways might the divisionalized forms of most airlines lend themselves to the requirements of alliance membership? In what ways might they be compatible with the organization

Search a financial analysis report of coca-cola, Where can I find a financi...

Where can I find a financial analysis report of coca-cola for the past 5 years. I stress full financial analysis for the past 5years.

Work study, What are all the steps involved in work study?

What are all the steps involved in work study?

Find what will the productivity of the bakery, If charles lackey's utility ...

If charles lackey's utility costs remain constant at $500 per month, labor at $8 per hour, and cost of ingredients at $0.35 per loaf, but Charles does not purchase the blender sugg

World competitive merit for the manufacturing of goods, The regime in China...

The regime in China has been known to manipulate it currency creating a competitive a world competitive advantage for the manufacturing of goods. Evaluate the impact to the U.S. ma

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

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

Upper and lower control limits, Clerks at Lotsa Data Systems key in thousan...

Clerks at Lotsa Data Systems key in thousands of insurance records each day for a variety of client firms.  The process is in control but CEO Donna Lotsa wants to be sure that at

Explain what is the maximum flow for this network, Union Express has 60 ton...

Union Express has 60 tons of cargo that need to be shipped from Boston to Dallas. The shipping capacity on each of the routes Union Express planes fly each night is shown in the fo

Describe in terms of developing a project plan, In terms of developing a pr...

In terms of developing a project plan, specifically recommend how this resource could expedite that process.

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