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 a computer-supply mail order house has a memory chip, A computer-su...

A computer-supply mail order house has a memory chip in inventory that it sells to customers around the country. A Japanese manufacturer supplies the item using airfreight. It has

Compute sample size to confirm or not the findings, If a pilot test reveale...

If a pilot test revealed 45% perceived poor service quality, and we decide the interval range is + 10 percent with a 95% confidence level, what is the calculated sample size to con

Importance of performance measurement, Importance of performance measuremen...

Importance of performance measurement  1. Research reveals that many institutional investors are basing their decisions, in part, on a review of company's non financial perfor

I need major help, Read “Space Age Furniture Company” in Chapter 9 of your ...

Read “Space Age Furniture Company” in Chapter 9 of your text. Respond to the following and include any Materials Requirement Planning (MRP) calculations: Develop an MRP for Space

Mis, mis in decision making

mis in decision making

Explain cosmetic window dressing, Do Whole Foods Market's mission/vision an...

Do Whole Foods Market's mission/vision and the core values as presented in cases Exhibit 1 and 3 really matter? Are they "real" or just cosmetic window dressing? What evidence can

Explain salary will the inducement comprise, Existing salary for managers i...

Existing salary for managers is 45,000 euros (58,567 US DOLLARS) PLUS BONUSES. AVERAGE SALARY FOR MANAGERS IN RANGE IS 60,000 EUROS (78,090), NO BONUSES. Recommendations must inclu

Explain how many machines should be purchased, Up, up, and away is a produc...

Up, up, and away is a producer of kites and wind socks. Relevant data on a bottleneck operation in the shop for the upcoming fiscal year are given in the following table: Item Kite

How the use of strikes has increased, The use of strikes has increased in t...

The use of strikes has increased in the last decade such that the FMCS reports now show a 10% utilization rate

Explain the probable destiny of lee peterson''s company, Consider this: Lee...

Consider this: Lee Peterson has invented a new product that detects water leaks due to broken pipes and sends out an alarm similar to a smoke alarm. However, Lee has very little pe

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