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 straight-line depreciation, The expected average rate of return for...

The expected average rate of return for a proposed investment of $500,000 in a fixed asset with a useful life of four years, straight-line depreciation, no residual value, and an e

Explain which if any of the resources are over allocated, 1. Which if any o...

1. Which if any of the resources are over allocated? 2. Assume that the project is time constrained and try to resolve any over allocation problems by levelling slack. What happ

Explain the size and timing of planned-order, A firm that produces wood shu...

A firm that produces wood shutters and bookcases has received two orders for shutters: one for 100 shutters and one for 150 shutters. The 100-unit order is due at the start of week

Location analysis, explain the series of steps involved and various factor...

explain the series of steps involved and various factor effecting location decion?

Calculate the regression equation, The I-10 carpet outlet wants to develop ...

The I-10 carpet outlet wants to develop a means to forecast its sales. The store manager believes that the stores sales are directly related to the number of new housing starts in

Explain challenges has the european union consortium faced, Describe what c...

Describe what challenges has the European Union Consortium faced in the last 2-3 years

Rules related to the arrangement of the work place, Related to the arrangem...

Related to the arrangement of the work place: 1.       There  should  be a definite and fixed place  for all tool sand material. 2.        Tools  materials and controls sho

Describe what you understand by supply chain management, Question : (a)...

Question : (a) Describe what you understand by supply chain management. (b) An important decision facing most purchasing managers is whether to source each individual produc

Explain penalty for theft is immediate termination, Your company terminated...

Your company terminated an employee for stealing a ladder. The employee filed a grievance with the union. The union argues that the employee had verbal permission from the temporar

Describe different leadership theories, This week you learned about a numbe...

This week you learned about a number of different leadership theories. Choose two of today's leaders listed below and research on their leadership styles: • Richard Branson •

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