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

What is basic naive method, 1. The monthly sales for Telco Batteries, Inc.,...

1. The monthly sales for Telco Batteries, Inc., were as follows: Month Sales Jan 20 Feb 21 Mar 15 Apr 14 May 13 Jun 16 Jul 17 Aug 18 Sep 20 Oct 20

Explain breakeven point in dollars of sales, A firm is selling two products...

A firm is selling two products, chairs and bar stools, each at $50 per unit. Chairs have a variable cost of $25 and bar stools $20 Fixed cost for the firm is $200 a. if the sales m

Upper and lower control limits, Clerks at Lotsa Data Systems key in thousan...

Clerks at Lotsa Data Systems key in thousands of insurance records each day for a variety of client firms.  The process is in control but CEO Donna Lotsa wants to be sure that at

Value of a Loyal Customer (VLC), A manufacturer of business copier workstat...

A manufacturer of business copier workstations has a 75 percent customer retention rate. Their accounting department estimates the incremental contribution to profit and overhead

Explain why is exporting the popular initial entry method, Why is exporting...

Why is exporting the most popular initial entry method?

Sceduling for the short term, what are the advantage to finite capacity sch...

what are the advantage to finite capacity scheduling ?

Various levels of customer service in your organization, Has the philosophy...

Has the philosophy that there are different levels of customers had any material effect on the value of your organization's customer service? • Identify and explain the differen

Explain what is the average length of the place order line, Wendys opens a ...

Wendys opens a drive through with one cashier and one food preparer. Customers will first enter the "place order" line to meet the cashier and then enter the "pick up" line to get

What are the benefits of an erp system, 1. Does the JIT philosophy incorpor...

1. Does the JIT philosophy incorporate the calculation of EOQ?  2. What is the difference between MRP and ERP?  3. Why would a company implement an MRP system?  4. What ar

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