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

Short-term and long-term liabilities, In addition to the car lease, Leonard...

In addition to the car lease, Leonard and Rose each have a VISA card with an interest rate of 18.25% p.a. They currently have a balance of $1,205 and made payments of $3,537 in 201

Describe difference between two population means, If a manager wishes to de...

If a manager wishes to develop a confidence interval estimate for estimating the difference between two population means, an increase in the size of the samples used will result in

Explain the amount of time covered by the basic mrp, The amount of time cov...

The amount of time covered by the basic MRP record is called the _____. time bucket new horizon time horizon planning horizon

Explain crafting executive strategy, 1. What evidence do you find in this c...

1. What evidence do you find in this case, either explicitly or implicitly, that indicates that Whole Foods Market has a mission, core values, or is practicing decision-making that

Explain how globalization is affecting the political, Discuss how globaliza...

Discuss how globalization is affecting the political, legal, and economic forces impacting todays business environment?

Simplex method , Q3. Solve the following Linear Programming Problem using S...

Q3. Solve the following Linear Programming Problem using Simple method. Maximize Z= 3x1 + 2X2 Subject to the constraints: X1+ X2 4 X1+ X2 2 X1, X2 0

Describe in light of accounting scandals, One of the most influential piece...

One of the most influential pieces of legislation was the Sarbanes-Oxley Act of 2002. This act greatly increased the transparency of financial disclosure in light of accounting sca

Forecasting, managerial decision modeling with spreadsheets 2nd Canadian ed...

managerial decision modeling with spreadsheets 2nd Canadian edition end of chapter 12 solution

Explain traditional inventory models, The information technology department...

The information technology department of State University buys paper for its copier machine frequently. The office manager would like to determine the best quantity to order each

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