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 organizational strategy is analyze organizations, Organizational St...

Organizational Strategy is Critically evaluate information from core business functions to enhance organizational knowledge, how would you assess your mastery of this competency?

How much hours of production time would you schedule for x, Plans are being...

Plans are being made to produce a product that requires 40 minutes on Resource X and 30 minutes on resource Y. Assume that there is only one of each of these resources, and that ma

Requirements from an operations perspective of competing, Question 1: A...

Question 1: A hotel has decided to focus more strongly on customer service and has just conducted a customer survey. Unfortunately, the results show that many customers are dis

What is the objective under jit and time-based competition, _____ is the ob...

_____ is the objective under JIT and time-based competition. WIP reduction Material velocity Lead-time reduction Decreasing material wait time

Explain analysis of the social, Perform an analysis of the social / demogra...

Perform an analysis of the social / demographic, technological, economic, environmental / geographic, and political/legal / governmental segments to understand the general environm

Forcasting, what are types of forcasting?

what are types of forcasting?

Explain what is cube per order index policy, What is Cube per order index p...

What is Cube per order index policy, and state any real life application to this warehouse policy.

Explain calculated values in descending order on the same, Create a procedu...

Create a procedure in VBA to do the following actions: -Create a linear series of numbers starting at 1 (e.g. 1, 2, 3,) -Display a Message Box asking if you'd like to calculate ano

Analyse the cost - benefits and resources , Undertake Systems based analysi...

Undertake Systems based analysis, including: i. Developing a systems based diagnosis of the ‘situation'; ii. Analyse one or more processes which are considered to be problem

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