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

I need excel backup to understand a problem, Need Excel backup to understan...

Need Excel backup to understand how to answer this question. Bob White leaned back and wiped his forehead with his hand. He was the president of the home oven division of Winkley &

Explain what will her total variable cost be, Gina Fox has started her own ...

Gina Fox has started her own company, Foxy Shirts, which manufactures imprinted shirts for special occasions. Since she has just begun this operation, she rents the equipment from

Explain what percentage of parts will not meet the weight, Specifications f...

Specifications for a part for a DVD player state that the part should weigh between 24.4 and 25.4 ounces. The process that produces the parts has a mean of 24.9 ounces and a standa

Service process design, the main factors that influence the service process...

the main factors that influence the service process design.

Explain distinction between e-business and e-commerce, Why does the Baltzan...

Why does the Baltzan text draw a distinction between e-business and e-commerce? • The Baltzan text lists four challenges for Web-based e-business (pp. 103 - 104). See i

How marketing consultant brought in to help a company, Imagine you are a ma...

Imagine you are a marketing consultant brought in to help a company who has a product that is so successful they cannot keep up with customer demand. What questions would you as

Explain perspective of the target audience for webcams, What is your perspe...

What is your perspective of the target audience for webcams?

Discuss the parties have avoided violation of the franchise, Omega Computer...

Omega Computers, Incorporated is a franchisor that grants exclusive physical territories to its franchisees with retail locations, including Pete's Digital Products. Omega sells ov

Process charts - process design, Process Charts - Process Design The ...

Process Charts - Process Design The process flow chart is probably the most commonly used means of recording, and comes in several variants. Each of them uses some, or all, o

Explain the characteristics of an effective team, Question 1: Explain h...

Question 1: Explain how a leader can enhance the performance in a team? Question 2: (a) Define ‘A Team' and explain the different stages in ‘Team Development'. (b)

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