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

Need supply and chain term paper, I am in need of a couple of suggestions f...

I am in need of a couple of suggestions for a Supply and Chain term paper. I was thinking about "Money" Any help will be highly appreciate it.

Operation planning and scheduling system, Operation Planning and Scheduling...

Operation Planning and Scheduling System Operation planning g and scheduling system concern the volume and timing of the outputs utilizations of the operations capacity and the

How to formulate a linear programming model, George Johnson recently inheri...

George Johnson recently inherited a large sum of money; he wants to use a portion of this money to set up a trust fund for his two children. The trust fund has two investment optio

Resource utilisation & work in progress in organisation, What effect does y...

What effect does your organisation's facility layout have on the following (where appropriate): inter-process movement; health & safety; congestion; resource utilisation; work-in-p

Explain the legal environment of hrm includes eeo, The Legal environment of...

The Legal environment of HRM includes EEO, Affirmative Action, and Americans with Disabilities Act. Discuss each explaining significance.

Describe the history of welfare reform, Discuss the history of welfare refo...

Discuss the history of welfare reform. Discuss some of the historical aspects and your opinion about how these changes were implemented and whether or not the changes were effectiv

Business management, Six Operators are to be assigned to five jobs with the...

Six Operators are to be assigned to five jobs with the cost of assignment in Rs. given 10 marks in the matrix below. Determine the optimal assignment. Which operator will have no a

Problem, a firm isconsidering replacement of a machien, whoes cost price is...

a firm isconsidering replacement of a machien, whoes cost price is rs 12200 and scrap value is rs 200 the running cost is rupee given below year running cost 1 200 2 50

Explain which of the following is not a production activity, Which of the f...

Which of the following is not a production activity report generated by MRP? a. Planning report b. Exception report c. Planned-order schedules d. Performance contro

Activity sampling - process design, Activity Sampling - Process Design ...

Activity Sampling - Process Design This is a method of finding the percentage occurrence of a certain activity by statistical sampling and random observation. It is used when

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