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 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

Plant layout, what are the factors affecting plant layout

what are the factors affecting plant layout

Impact of activity of listening, How is the activity of listening impacted ...

How is the activity of listening impacted by the particular situation?

Define state licensure requirements that an organization use, Discuss state...

Discuss state licensure requirements that an organization must comply with in order to become a Medicare Advantage Plan, any exceptions to the State licensure requirement, and any

Explain worldwide the sale of alcoholic beverages is legal, Which of the fo...

Which of the following statements is true? Answer law applies to individuals only; not to groups or society as a whole the sale of marijuana is illegal worldwide the sale of alcoho

Explain the quality control implications of the major change, in a 3-4 page...

in a 3-4 page paper answer the following: Q1. Describe the quality control implications of the major changes that have taken place in food chains today compared to the past. Q2. Wh

Calculate sample mean & superimpose the frequency histogram, 1. (a) For the...

1. (a) For the measurement data presented below, draw a frequency histogram using a class width of 0.1 mm; calculate the sample means and superimpose their frequency histogram; com

Explain strategic decisions influence the power of the party, Determining t...

Determining the bargaining unit occurs before certification is obtained whereas determining the bargaining structure occurs after, but both strategic decisions influence the power

Rules related to the design of tools and equipment, Related to the  Desig...

Related to the  Design  of Tools and Equipment: 1.        The hands should  be relieved of all work  that can  done more  advantageously by a jig a  fixture  or a foot operate

Explain what is the productivity measure, A hamburger factory produces 40,0...

A hamburger factory produces 40,000 hamburgers each week. The equipment used costs $5,000 and will remain productive for 4 years. The labor cost per year is $9,500. a. What is t

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