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 organizational culture regarding staffing decisions, What is the re...

What is the relationship between the business strategy and an entity's organizational culture regarding staffing decisions? Is it possible to strengthen one without the other?

Explain the effectiveness of southwest airlines, "Southwest Airlines" Pleas...

"Southwest Airlines" Please respond to the following: • Evaluate the effectiveness of Southwest Airlines execution of its low-cost / low-price / no-frills strategy to the busine

Define how each it project supports bill''s umuc pizza, Explain how each IT...

Explain how each IT project listed above specifically improves and/or supports Bill's UMUC Pizza business

Procedure of production control, Procedure of Production Control 1. C...

Procedure of Production Control 1. Control  of activities : It  involves  the  release of manufacturing  orders, setting  plans  in motion  at assigned times  by means of  d

Generate a table that includes all of the key elements, Create a table that...

Create a table that includes all of the key elements that you think an organization must focus on to promote change

Explain setup cost is independent of order size, 1. A stock out occurs when...

1. A stock out occurs when an item that is typically stocked is not available to satisfy a demand the moment it occurs. 2. A backorder occurs when a customer order cannot be fil

Exactly how must sustainability be best defined, Exactly how should "sustai...

Exactly how should "sustainability" be best defined when making it part of a gold statement or performance objective for a business or organization?

Compute a tracking signal or determine whether the forecast, The following ...

The following are monthly actual and forecast demand levels for May thur December for units of a products manufactured by the N. tamimi Pharmaceutical Company Month Actual deman

Define the functional flexibility workforce, Define the functional flexibil...

Define the functional flexibility workforce. Functional flexibility (task flexibility or multi-skilled employees) associates breaking down traditional occupational restricti

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