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

Location, what are the globalization and geoghacical dispersion of operatio...

what are the globalization and geoghacical dispersion of operation

Logistics, Ask question #Minimum 100 words acceptedTopic 2: Logistics Logi...

Ask question #Minimum 100 words acceptedTopic 2: Logistics Logistics is the management of the flow of goods, information and other resources, including energy and people, between

Why must you begin a case analysis with a financial analys, Why should you ...

Why should you begin a case analysis with a financial analysis? When are other approaches appropriate?

Explain manager of a production department, Suppose that you are the manage...

Suppose that you are the manager of a production department that uses 400 boxes of rivets per year. The supplier quotes you a price of $8.50 per box for an order size of 199 boxes

Operations and Maintenance document, Hello, I need some help for O & M doc...

Hello, I need some help for O & M doc. So I am looking for a template or How and what to be included in the doc for a public facing Azure Website built using Drupal 8. Thanks

Explain the rop that will provide a risk of stockout, Given this informatio...

Given this information: Expected demand during lead time = 300 units Standard deviation of lead time demand = 30 units Determine each of the following, assuming that lead time dema

Capacity planning, outsourcing as external source of capacity

outsourcing as external source of capacity

Find range of annual volume, A firm plans to begin production of a new smal...

A firm plans to begin production of a new small appliance. The manager must decide whether to purchase the motors for the appliance from a vendor at $7 each or to produce them in-h

Point rating method, Point  Rating Method In  selecting  a site  of l...

Point  Rating Method In  selecting  a site  of location companies  have several  objectives, but  not  all are  of equal  importance. The relative weight a company assigns to

Explain how to negotiate for more compensation, Describe how to negotiate f...

Describe how to negotiate for more compensation. Explain why one must be assertive to earn what he or she deserves. Relate four things not to do when asking for a raise. How much c

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