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

Define the term economic order quantity, Define the term Economic Order Qua...

Define the term Economic Order Quantity. Economic Order Quantity (EOQ): A mathematical computation for a fixed quantity of inventory ordered every time which would minimi

Compute the value of the tax shield, You have a lease on an oil and gas pro...

You have a lease on an oil and gas property with 87.5% NRI that delivers your firm annual profits of $400,000 for five years, with equal production in each year (you will need to t

Productivity -numerically defined, Productivity -Numerically Defined T...

Productivity -Numerically Defined Total factor productivity (TFP) = Pt = Ot/(L+C+R+Q)  Partial factor productivity (PFP) = Ot/L or C or Ot/a combination of  inputs   Pt

List the interesting gap between consumer & service provider, 1. Look at th...

1. Look at the above table and list the interesting gaps which you observe in the 'scripts' between consumer and service provider. Answer: 1. The starting point of the servic

How measures are interpreted with operations management, Your project to ob...

Your project to obtain charitable donations is now 30 days into a planned 40-day project. The project is divided into three activities. The first activity is designed to solicit in

Compute an analysis of the volume over, Peter Belington Stereo, Inc. suppli...

Peter Belington Stereo, Inc. supplies car radios to auto manufacturers and is going to open a new plant. The company is undecided between Detroit and Dallas as the site. The fixed

OPERATION REASERCH.., #question.six operators are to be assinged with 5 job...

#question.six operators are to be assinged with 5 jobs with cost of assingment in rs given in the matrix below 1 2 3 4 5 62526 25877 78698 62345 93897 47468

Presume that as a result of hr planning, Assume that as a result of HR plan...

Assume that as a result of HR planning, a mental hospital identifies a shortage of therapists but a surplus of case workers. Discuss the actions that you would take to address the

Define cross-cultural communication, When referring to Cross-Cultural Commu...

When referring to Cross-Cultural Communication, what would be the best approach to dealing with a multicultural environment.

Explain why is forecasting important in organizations, Why is forecasting i...

Why is forecasting important in organizations, especially as related to understanding the relevant time horizon to develop a forecast against? What are some examples from industry?

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