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 preparation and analysis of balance sheet, Explain preparation and ...

Explain preparation and analysis of balance sheet. Preparation and Analysis of Balance Sheet: Balance Sheet is one of the significant financial statements of a company provid

Explain a jet engine has ten components in series, A jet engine has ten com...

A jet engine has ten components in series. The average reliability of each component is 0.998. What is the reliability of the engine? (Round your answer to 3 decimal places, the

Explain products and convincing local customers, You are the Customer Servi...

You are the Customer Service Manager for a US manufacturer and have fielded a phone call from the Japanese Distributor of your products in Japan. She informs you that a major local

Calculate mape for each data set, DO different forecasting techniques (F1 a...

DO different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are as follows: PREDICTED DEMAN

Explain items selected from a population is called, A subset of items selec...

A subset of items selected from a population is called which of the following? Sample Statistic Census Parameter

Explain consumer products into brazil, What steps could a company take to a...

What steps could a company take to avoid making product design and marketing mistakes when introducing new consumer products into Brazil?

Explain the leadership characteristics, Provide two examples of current lea...

Provide two examples of current leaders and describe how they demonstrate their leadership characteristics. What separates these characteristics from management techniques? How eff

Explain elements of the integrated model of motivation, Analyze the four el...

Analyze the four elements of the integrated model of motivation to determine which element is the most essential to get right when motivating employees. Explain your rationale. •As

Us businesses being willing in doing business with china, Discuss your opin...

Discuss your opinion of US businesses being interested in doing business with China. What are your main concerns?

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