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 the upper or lower control limits for a mean chart, The overall ave...

The overall average on a process you are attempting to monitor is 50 units. the process standard deviation is 1.72. Determine the upper and lower control limits for a mean chart, i

Define skills needed in order to succeed as systems analyst, Discuss the ty...

Discuss the types of skills needed in order to succeed as a systems analyst

Describe two methods for allocating costs, Explain two methods for allocati...

Explain two methods for allocating costs. Justify why you selected them and how you would make the most use of them in cost analysis. No copying and pasting or will not be ra

Time study - process design, Time Study - Process Design Time study by...

Time Study - Process Design Time study by stopwatch or micro-motion analysis is the original method of work measurement devised by Taylor and his followers, and is still routi

Identify the feasible region for the set of constraints, Identify the feasi...

Identify the feasible region for the following set of constraints: 3A - 2B ? 0 2A - 1b ? 200 1A ? 150 A, B >=0 This will need to include graphing or I will not ra

Describe project should be clearly explained, The "ends" of the project sho...

The "ends" of the project should be clearly explained, measured, and communicated, prior to the "means" being decided

Describe management of telecommuters, All of the following are negative abo...

All of the following are negative about telecommunication except/1. Technical difficult with computer linkage/2.islotion from co-worker/3.decrease identification with work team/4.m

Problem on abc analysis of inventory, Problem on ABC Analysis of Inventory:...

Problem on ABC Analysis of Inventory: The ABC Analysis of Inventory divides inventory into three classes: Class A - high annual dollar volume Class B - medium annual doll

Explain about the supply chain management according to kilty, Q. Explain ab...

Q. Explain about the Supply chain management according to Kilty? According to Kilty supply chain management: It involves the movement of products, services, and information

Explain generalized or specialized approach to work, To be a true strategi...

To be a true strategic partner, does HR need to take on a more generalized or specialized approach to work? Why?

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