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 draw a graph illustrating the crossover point, Stan's company is co...

Stan's company is considering producing a gear assembly that it now purchases from Sal Company. Salt company charges 4 per unit with a minimum order of 3000 units. Stan estimates t

Explain what is the amortization schedule, 30 year mortgage at 10 percent i...

30 year mortgage at 10 percent interest rate. Loan amount $300000. 1. What is the amortization schedule for the 1st year (12moonths) 2. What is the remaining balance of the 29years

Explain minimization and maximization problems using lp, What are the simil...

What are the similarities and differences between minimization and maximization problems using LP

How marketing consultant brought in to help a company, Imagine you are a ma...

Imagine you are a marketing consultant brought in to help a company who has a product that is so successful they cannot keep up with customer demand. What questions would you as

Explain draw the project network using aon, Task time estimates for a produ...

Task time estimates for a production line setup project at Robert Klassens Ontario factory are as follows: Activity Time (in hours) Immediate Predecessors A 6.0 B 7.2 C 5.0 A D 6.0

Explain stakeholder analysis, Stakeholder analysis is important in risk ass...

Stakeholder analysis is important in risk assessments for most activities is not important in risk assessments for most activities is usually undertaken at the end of the planning

Explain the variable cost to produce each unit, Assume a fixed cost for a p...

Assume a fixed cost for a process of $120,000. The variable cost to produce each unit of product is $35, and the selling price for the finished product is $50. Which of the followi

Explain functions and objectives of trade unions, Explain functions and obj...

Explain functions and objectives of trade unions. Functions and Objectives of Trade Unions: The functions of trade unions are: (i) The provision of friendly services which

Explain transnational model, Q1. Is changing the organization's domain a fe...

Q1. Is changing the organization's domain a feasible strategy for coping with a threatening environment? Can you think of an organization in the recent news that has changed its do

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