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

What was jimmy efficiency, 1) Jimmy runs a business in his basement that sp...

1) Jimmy runs a business in his basement that spin aligns and marks golf balls with logos for tournaments. The automated machine goes through three serial steps; the first step tak

Strategy and standards approaches to reviewing software, Strategy and Stand...

Strategy and Standards Please respond to the following: •Discuss the factors that should be considered when developing a consistent IM / IT strategy. Explain your rationale. •Analy

Explain what is the hourly production rate, An assembly line currently has ...

An assembly line currently has five workstations and the time required for each is shown below. 1: 48 seconds, 2: 38 seconds, 3: 44 seconds, 4: 56 seconds, 5: 42 seconds what is th

Determine the optimal quantity , Suppose you are overseeing the purchasing ...

Suppose you are overseeing the purchasing of a certain commodity for the following year. The demand for this item is estimated to be 20,000 units/year, and steady throughout. Every

Explain what are the four main reasons for holding inventory, 1. What facto...

1. What factors enter into the choice of a value for the smoothing constant in exponential smoothing? 2. Name at least 3 competitive advantages of concurrent engineering? 3.

Depict the project network using aon, Task time estimates for a production ...

Task time estimates for a production line setup project at Robert Klassens Ontario factory are as follows: Activity Time (in hours) Immediate Predecessors A 6.0 B 7.2 C 5.0 A D 6.0

Define management information system and its scope, Normal 0 fa...

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Moving average in local organic food market, Weekly sales of 10-grain bread...

Weekly sales of 10-grain bread at the local organic food market are in the table below. Based on this data, forecast Week 9 using a five-week moving average. Week Sales 1

Scope of production and operation management , Scope of Production and Oper...

Scope of Production and Operation Management Production management mainly associated with the factory management as the problem of production crept with the development of facto

Find what is the stock worth today, Investor G. Loeb owns a 5-year, $1000 b...

Investor G. Loeb owns a 5-year, $1000 bond with a 5% coupon. If the yield to maturity on similar bonds is currently 10%, what is Mr. Loeb's bond worth today? A security analyst

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