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

Case study answer , After working for 30 years, Ramjee Somjee Dutt opted fo...

After working for 30 years, Ramjee Somjee Dutt opted for VRS and started a courier company and did very well in the first four years. He was now looking for expansion of his busine

What are the pros and cons of flexible schedules for staff, What are the pr...

What are the pros and cons of flexible schedules from an employee's perspective?

How is value of product effective on operational strategy, How is the value...

How is the value of product effective on operational strategy? Value is the cause why customers choose one rivals product over other, when an organisation can give certain uniq

Explain the risk evaluation process, Discuss and describe the risk evaluati...

Discuss and describe the risk evaluation process in a simplified approach.

Explain switch read in order to find the mac address, What part of a packet...

What part of a packet does a switch read in order to find the MAC address? a. FCS b. padding c. header d. trailer

Explain external competitive policies and techniques, 1. How might a compan...

1. How might a company's business strategy affect the internal alignment policies and techniques of its Total Compensation system? 2. How might a company's business strategy affect

Find the total book value of the assets, Alfonzo's Pizzeria purchased its b...

Alfonzo's Pizzeria purchased its building 8 years ago at a cost of $76,000. The building is currently valued at $212,000. Alfonzo's has other fixed assets that cost $58,000 and are

Explain most important consideration of pre-employment, From the case study...

From the case study, determine what ideals, obligations, and effects must be considered in using psychological tests as pre-employment screens. Decide which the most important cons

Explain reducing the project duration increases the risk, Take a position o...

Take a position on the following statement from the textbook author: "Reducing the project duration increases the risk of being late." Support your position

Solve the problem requires an excel solution, The problem requires an excel...

The problem requires an excel solution and an algebraic solution with variables: During the month of July, Pittsburgh resident Bill Fly must make four round trip flights between Pi

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