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 the industry life cycle affect business strategy, How does the indu...

How does the industry life cycle affect business strategy? Detail your answer based on each stage: introduction, growth, maturity, and decline. (Please provide example(s) were appl

Explain make-or-buy in decision, Consider the make-or- buy in decision. Giv...

Consider the make-or- buy in decision. Give three examples of situations in which a business should make, rather than buy. Give three examples of situations in which a business sho

I have some charts that i need help to put it in excel, I have soem charts ...

I have soem charts that were done i word how do I gt them to you for someone to put in excel for me

Expected effectiveness of plan, Expected effectiveness of plan: Ramon ...

Expected effectiveness of plan: Ramon Martinez is the general manager of Classic Inn, a local mid-priced hotelwith 100 rooms. His job objectives include providing resourceful

Explain what is the role and impact of hr practices, What is the role and i...

What is the role and impact of HR practices domestically and internationally when globalization forces the organization to seek expansion overseas?

Impact of product life cycle on operation strategy, Question 1: Describ...

Question 1: Describe the impact of product or service life cycle on operation strategy - Impact of each Stage (Introduction, development, growth, maturity, decline) - Descri

Define challenges of managers providing accurate feedback, Assess the chall...

Assess the challenges of managers providing accurate, timely, and effective feedback to employees. Recommend how managers can overcome any two of the challenges you identified.

How performing the necessary paperwork, Annual demand for number 2 pencils ...

Annual demand for number 2 pencils at the campus store is normally distributed with mean 1,000 and standard deviation 250. The store purchases the pencils for 6 cents each and sell

Hard, Ask quesThe Delicious Apple Company has orchards in Red City, Golden,...

Ask quesThe Delicious Apple Company has orchards in Red City, Golden, and Macville Estimated amounts of apples to be available from the three orchards are the following: Red City

Briefly analyze two opportunities, Thoroughly research and analyze two oppo...

Thoroughly research and analyze two opportunities and two major threats that united airlines is facing

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