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

Marketing manager needs to know the marketing research cost, The marketing ...

The marketing manager needs to know the cost of the research project before approving it. During which stage of the marketing research process would such a consideration most likel

Explain formulate and solve a linear optimization model, Klein Industries m...

Klein Industries manufactures three air compressors: small, medium, and large, which have unit profits of $20.50, $34, and $42 respectively. The monthly projected sales of small ar

Depict a decision tree for problem, A manager is trying to decide whether t...

A manager is trying to decide whether to build a small medium, or large facility. Demand can be low, average, or high, with the estimated probabilities being 0.25, 0.40, and 0.35,

Explain must decide between two different forecasting tech, An analyst must...

An analyst must decide between two different forecasting techniques for weekly sales of roller blades: a linear trend equation and the naive approach. The linear trend equation is

MATERIAL REQUIREMENT PLANNING, Ask question #Minimum 100COMPONENTS OF MATER...

Ask question #Minimum 100COMPONENTS OF MATERIAL REQUIREMENT PLANNING words accepted#

Explain shipping alternative would you recommend, A manager must make a dec...

A manager must make a decision on shipping. There are two shippers, A and B. Both offer a two-day rate: A for $536 and B for $525. In addition, A offers a three-day rate of $464 an

Explain interpret the meaning of the p-value in this problem, Initially, th...

Initially, the mean turnaround time for a stress test was 68 hours. After incorporating changes into the stress-test process, the quality improvement team collected a sample of 50

Define globalization of health care good or bad for patients, Is the global...

Is the globalization of health care good or bad for patients? Who might benefit from the globalization of health care? Who might lose?

Visual basic 2010 problems, Are the practice questions at the end of the ch...

Are the practice questions at the end of the chapters in starting out with Visual Basic 2010 5th edition a good representation of the questions in the Test Bank?

Explain what is the horizon value, Current and projected cash flows for Ran...

Current and projected cash flows for Randell Global Operatons are shown below. Growth is expected to be constant after 2012, and the weighted average cost of capital is 11%. What i

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