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 what is the annual number of orders, Office Supreme, Inc., a local ...

Office Supreme, Inc., a local retailer of office supplies, faces demand for one of its inventory items at a constant rate of 240,000 units per year. It costs Office Supreme $38 to

Explain coca cola''s change in sales policy, How would you respond to Coca ...

How would you respond to Coca Cola's change in sales policy? How would you ensure Pepsi's board that this response will allow you to remain competitive and profitable?

Inventory, What is ABC analysis in inventory control? Discuss its advantage...

What is ABC analysis in inventory control? Discuss its advantages/disadvantages

Explain how can product development costs be minimized by, How can product ...

How can product development costs be minimized by entering the market late

Operations function - transformation processes and planning, Operations Fun...

Operations Function - Transformation Processes and Planning The operations function is concerned with the design of transformation processes, planning their use, and organisin

How to do selection of a database management system, Identify and describe ...

Identify and describe three criteria that should be used to evaluate the selection of a database management system. Describe how an organization should use each criterion to evalua

Explain what is te annual carrying cost, Uick cheif cookers sell at an aver...

Uick cheif cookers sell at an average [ace of 12500 per month. Each cooker costs the company $100. The annual carrying cost for each cooker is 10%. Each Each or

Explain the forecasted demand for fudge, The forecasted demand for fudge fo...

The forecasted demand for fudge for the next four months is 140, 160, 90 and 70 pounds. A) What is the recommended production rate if a level strategy is adopted with no back order

., The following process is designed to handle 120 customers a day. The cus...

The following process is designed to handle 120 customers a day. The customer is “processed” through each of the two operations, A and B, in sequence form. The average rate of each

List any three business areas in the umuc pizza shops, List three business ...

List three business areas and/or processes used in the UMUC Pizza shops that could be supported by an IT solution.

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