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

Capacity planning and controlling, #theories and techniques can help if app...

#theories and techniques can help if applies properly.

How to compare forecasts with the original data, Develop a forecast for yea...

Develop a forecast for years 2 through 12 using exponential smoothing with ƒÑƒn= .4 and a forecast for year 1 of 6. Plot your new forecast on a graph with the actual data and the n

Explain how does safety management address fatigue issues, Fatigue is a maj...

Fatigue is a major safety concern in the aviation industry. How does safety management address fatigue issues yet accomplish the job without incurring more costs in the company. We

Explain what types of strategy should including in the plan, Imagine you ar...

Imagine you are creating a marketing plan for a company that will sell kites. As you consider the marketing program, what types of strategy should you consider including in the pla

Explain primarily used to help design products, Which of the following is p...

Which of the following is primarily used to help design products that will connect product attributes with customer desires?

Explain implementation of a transnational strategy, What do you see as the ...

What do you see as the main organizational problems that are likely to be associated with implementation of a transnational strategy? Explain

Find the average total setup cost and shortage cost, A manufacturer uses a ...

A manufacturer uses a purchase part who's demand over any time period of length t (in years) can assume to be normally distributed with mean 200t and variance 400t. The part cost $

Explain your approach to tracking a project, Describe your approach to trac...

Describe your approach to tracking a project. What kinds of issues would you focus on if you were a project manager? Why?

What kind of transmission path does a fixed wireless signal, What type of t...

What type of transmission path does a fixed wireless signal require?

Explain permissive actions act, Why do unions emphasize the need for cohesi...

Why do unions emphasize the need for cohesiveness? So they can issue calls for "solidarity" to members during periods of threat Because group members tend to behave different

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