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 multiplying the cumulative error by mad, 1. as the amount of on han...

1. as the amount of on hand inventory increases, A. shortage cost increase and carrying costs increase B. Shortage cost decrease and carrying costs increase C. both shorta

Trigger changes in aspects of practice, What is a critique? Simply stated, ...

What is a critique? Simply stated, a critique is a critical analysis undertaken for some purpose. Nurses critique research for three main reasons: to improve their practice, to bro

Describe functions you would include in this sswg, As the System Safety Eng...

As the System Safety Engineer for your firm, you are writing a System Safety Working Group (SSWG) charter. List 6 individuals/functions you would include in this SSWG and the reaso

What is prime cost, What is Prime Cost? The sum of Direct Labour Cost, ...

What is Prime Cost? The sum of Direct Labour Cost, Direct Expenses and Direct Material Cost is Prime Cost.

Explain quality, Explain Quality. Quality: It is explained as fitness...

Explain Quality. Quality: It is explained as fitness of purpose. It is a relative term and is normally explained with reference to the end utilize of the product. For illustr

What are the disadvantages of the level capacity strategy, What are the dis...

What are the disadvantages of the Level capacity strategy? The disadvantages of the Level capacity strategy are as follows: a. High risk of stock obsolescence when customer

Presume the restaurant operates 360 days per year, A fast-food restaurant b...

A fast-food restaurant buys hamburger buns from a national bakery supplier. The daily usage of buns at the restaurant is normally distributed with an average of 160 and standard de

Explain well-designed teams tend to sabotage leaders, When it comes to how ...

When it comes to how a team is designed (i.e., members, communication, goals, norms, etc.) and team leadership, which of the following statements is most true based upon the studie

Explain various stressors in such an environment, Today, employers are usin...

Today, employers are using employees more and more in a matrixed environment. What does that mean? How can we contend with the various stressors in such an environment? How do we m

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