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

Describe what is the chocolate raw material safety stock, Christian runs a ...

Christian runs a small chocolate shop. He manages his chocolate raw material using a periodic review system. Daily demand has a mean of 100 pounds and standard deviation of 10 poun

Explain mission and vision statement, What is the difference between a miss...

What is the difference between a mission and vision statement. Discuss why mission statements are important in performance improvement and why a solid mission statement (describing

Explain successful personal selling philosophy, According to the Strategic/...

According to the Strategic/Consultative Selling Model, what are the three prescriptions for developing a successful personal selling philosophy?

How reduce the safety stock, The annual demand for a product is 15,600 unit...

The annual demand for a product is 15,600 units. The weekly demand is 300 units with a standard deviation of 90 units. The cost to place an order is $31.20, and the time from order

Describe limitations of the relational model, Write a 200- to 350- word sho...

Write a 200- to 350- word short-answer response to the following: • Identify and describe three limitations of the relational model and recommend strategies to overcome these li

How you would address project management situation, MBTI and Keirsey Temper...

MBTI and Keirsey Temperament Sorter Describe the challenges you foresee in using the MBTI instrument or Keirsey Temperament Sorter in a project management situation and how you wo

What are the primary external organizational considerations, Do you think t...

Do you think these primary external organizational considerations are the same across all industries, or do different industries (like manufacturing vs. health care) have different

Succession planning and workforce plan evaluation, Succession Planning and ...

Succession Planning and Workforce Plan Evaluation Develop a succession plan that addresses internal labour needs in the medium to long term, utilising succession planning princ

Explain the concept of globalization many businesses operate, Based on the ...

Based on the concept of globalization, many businesses operate and compete in a global environment. Describe the additional factors that affect/impact global supply chains.

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