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 primary reason people buy, What Is The Primary Reason P...

What Is The Primary Reason People Buy And Own Major Appliance Such As Washing Machine. Is there a secondary reason as well?

Lpp, A paper mill produces two grades of paper viz., X and Y. Because of ra...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

Explain different models of organizational change, There are many different...

There are many different models of organizational change. Each has advantages and disadvantages. It is up to the organizational development specialist to match the specific model t

Leadership evaluation and leadership philosophy, Write an evaluation (500-7...

Write an evaluation (500-750 words) of the situation that addresses the following: The power bases used by the leader. The influence tactics used by the leader. The leadership sty

Explain pilot test to generate the variance estimate, If a pilot test revea...

If a pilot test revealed 45% perceived poor service quality, and we decide the interval range is + 10 percent with a 95% confidence level, what is the calculated sample size to con

How several hours of production time would you schedule, For the four basic...

For the four basic configurations that follow, assume that the market is demanding product that must be processed by both Resource X and Resource Y for Cases I, II and III. For Cas

Find average time agent work for a call center, A call center employs 1,000...

A call center employs 1,000 agents. Every month 50 employees leave the company and 50 new employees are hired. How long does the average agent work for this call center?

Explain hrm role in the international context, 1. Compare the issue(s) face...

1. Compare the issue(s) faced with the staffing approaches to one of a larger company. 2. Analyze the complexity of the HRM role in the international context. 3. Compare the

Explain vertical integration as a supply chain strategy, Locate an organiza...

Locate an organization that has used vertical integration as a supply chain strategy. Describe in detail why you believe vertical integration was/was not the appropriate strategy.

Draw a schematic layout, The flow of materials through eight departments. E...

The flow of materials through eight departments. Even though the table shows flows into and out of the different departments, assume that the direction of flow is not important. In

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