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 production budget, Explain production budget. A production bu...

Explain production budget. A production budget may be made by production manager in consultation along with his assistants after obtaining the sales Budget. A production budg

Explain integrated forecasting and inventory control system, Herman Hahn is...

Herman Hahn is attempting to set up an integrated forecasting and inventory control system for his hardware store, Hahn's Hardware. When Herman indicates that outdoor lights are a

Could you please explain which values i need to calculate, Regarding the tr...

Regarding the trash bag case (Essentials of Business Statistics, chapter 7 exercise 50), I am not sure where the 1.9991 comes from. I tired computing the standard normal distrib

Explain appellate jurisdication, Stan Garner resides in illinois and promot...

Stan Garner resides in illinois and promotes boxing matches for Supersports, INC. an Illinois corporation. Garner created the conect of "ages" promotion- a three fight series of bo

Explain forecast week 7 using a six-week moving average, Weekly sales of ry...

Weekly sales of rye bread at the corner store are shown below. Using this data, forecast Week 7 using a six-week moving average. Week Sales 1 415 2 389 3 420 4 382 5

Define what is the sample value of the test statistic, 1. The average laten...

1. The average lateness for one of the top airline companies is 10 minutes. The Standard Deviation of the lateness measure is calculated as 3. An airplane arrived 8.5 minutes after

Explain companys competitive advantage, Which is most important for a compa...

Which is most important for a companys competitive advantage: internal consistency or market competitiveness?

Describe what is lean six sigma, What is Lean Six Sigma, please explain and...

What is Lean Six Sigma, please explain and give examples, thanks

Line balancing of product layouts, Line Balancing of Product Layouts ...

Line Balancing of Product Layouts A major consideration in the design of product layouts is that of bottlenecks; just as the strength of a chain is determined by its weakest

How to find the order quantity, The supplier is reliable and maintains a co...

The supplier is reliable and maintains a constant lead time of 5 days. The cost of placing an order is $10 and the cost of holding inventory is $0.50 per unit per year. There are n

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