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

Introduction of operations strategy, Introduction of Operations Strategy ...

Introduction of Operations Strategy The term strategy, given in the Collins English Dictionary is, 'the art or science of the planning and conduct of a war; generalship; a lon

Calculate the average rate of installation of carpet, Carpet city recorded ...

Carpet city recorded the following data on carpet instalations over th past week. Use the data to calculate the average rate (in yards per hour) at which carpet can be installed

Find annual sales is thousands of bottles, Problem 3-5 A cosmetics manufact...

Problem 3-5 A cosmetics manufacturer's marketing department has developed a linear trend equation that can be used to predict annual sales of its popular Hand & Foot Cream. Ft = 80

Explain activity immediate predecessor normal time, The Scott Corey account...

The Scott Corey accounting firm is installing a new computer system, and several things must be done to make sure the system works properly. The following table provides informatio

Explain primary causes of information management, Analyze the primary cause...

Analyze the primary causes of information management / information technology project failures and recommend at least three (3) best practices that could be adopted by any organiza

Objectivise and benefits of work study, Objectivise and Benefits of Work St...

Objectivise and Benefits of Work Study Objectivise of Work Study a)Provide more and improved physical means to motivate the workers. b)Improve the basic process by resear

., 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

What is an operation setback chart, An operation setback chart _____. is...

An operation setback chart _____. is based on lead times that typically include move and queue times and indicates a schedule for when to make a part. is a schedule for when

Describe the problems of homelessness, Explain the problems of homelessness...

Explain the problems of homelessness based upon the developmental, situational, and human needs perspectives, what make a person become homeless, when they are well educated and no

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