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 the importance of correctly stating the objective, Explain the imp...

Explain the importance of correctly stating the objective function and constraints in linear optimization problems. Provide a few examples of the problems that could result if the

Explain the elements of an organizations environment, Describe the elements...

Describe the elements of an organization's external environment. Why is it important to understand the external environment?

Explain cost management processes, Cost management processes are involved i...

Cost management processes are involved in estimating, budgeting and controlling costs so that the project can be completed within the approved budget.

Explain employee types, After an all-night study session the day before the...

After an all-night study session the day before their last final exam, four first-year MBA students decide to stop for some much-needed coffee at the campus Starbucks. They arrive

Line balancing of product layouts, Line Balancing of Product Layouts ...

Line Balancing of Product Layouts A major consideration in the design of product layouts is that of bottlenecks; just as the strength of a chain is determined by its weakest

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 what values of q and r is carmins boutique currently, Carmin's Bout...

Carmin's Boutique sells a large number of black dress shirts. The shirts, which bear the store label, are shipped from a manufacturer in Paris. Carmin's purchasing department manag

Explain what is the logic in the least squares method, What is the logic in...

What is the logic in the least squares method of linear regression analysis?

Compute the total annual cost, A local nursery, Greens, uses 2184 bags of p...

A local nursery, Greens, uses 2184 bags of plant food annually. Greens works 52 weeks per year. It costs $8 to place an order for plant food. The annual holding cost rate is $2 per

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