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 controlling stock levels of all the products at tep, Using Pareto a...

Using Pareto analysis, categorize the products into Classes A, B, C, based on usage value. Would this approach be useful for categorizing and controlling stock levels of all the pr

Explain cosmetic window dressing, Do Whole Foods Market's mission/vision an...

Do Whole Foods Market's mission/vision and the core values as presented in cases Exhibit 1 and 3 really matter? Are they "real" or just cosmetic window dressing? What evidence can

Explain the nature of leadership and relate leadership, A: Describe the nat...

A: Describe the nature of leadership and relate leadership to management. B: what are the distinctions between management and lead?

Explain level production and chase production strategies, Henderson Furnitu...

Henderson Furniture sells reproductions of 18th century furniture. For a particular table, the following information is valid. Month | Demand Jan 81 Feb 89 Mar 100 Apr 130 May 97 J

Relationship management principles, What are the optional issues that a net...

What are the optional issues that a network member must address in order to manage the network effectively? How can the manager manage these operational issues and integrate them w

Cheapest car rental rents cars why getting loses, Cheapest Car Rental rents...

Cheapest Car Rental rents cars at the Chicago airport. The car rental market consists of two segments: the short term segment, which rents for an average of .5 weeks, and the mediu

Explain what will be the company''s return on equity, Midwest packaging's R...

Midwest packaging's ROE last year was only 3%, but its management has developed a new operating plan that calls for a debt-to-asset ratio of 60%, which will result in annual intere

Explain what is the minimum number of workstations, An assembly line with a...

An assembly line with a number of tasks is to be balanced. The sum of the task times is 62 minutes. The line will operate for 6 hours per day. What is the minimum number of worksta

Explain damage and restrict water access, Please explain how you would hand...

Please explain how you would handle the following question: An environmental impact statement confirms that you are within your legal rights to build a hotel property in a scenic a

Travael chart, I want some project about travel chart.

I want some project about travel chart.

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