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

Compute the shape yield percentage, You punch multiple parts from a sheet o...

You punch multiple parts from a sheet of Aluminium. The sheet is a 1728 square-inches rectangle and you get 18 parts that are 70 square-inches each. The machine is old so you inclu

Design an appropriate control chart, This assignment requires you to look i...

This assignment requires you to look in some detail at one quality issue arising in your organisation. Some of the exercises in Units 4 and 5 have already suggested that you consid

Explain what are best practices of college, What are Best Practices of coll...

What are Best Practices of college/university communications to students

Formulate the subsequent problems, Formulate the following problems:B.7; B....

Formulate the following problems:B.7; B.8; B.10; B.11 and B.17. Do not solve

Explain what problems does diversity present, Individual diversity is an im...

Individual diversity is an important concept in organizational behaviour. People can be described by a number of categories that are both inherent (e.g., age, race, gender, ethnici

Explain industries is most likely to use database marketing, Which of the f...

Which of the following industries is most likely to use database marketing? a. A supermarket chain b. A school system c. A local restaurant d. A p

Types of operations systems - variations in demand, Types of Operations Sys...

Types of Operations Systems - Variations in Demand Make-to-order versus make-for-stock  Particularly in production systems, a key decision must be made as to whether o

Depict a forecast on a graph with the actual data, Develop a forecast for y...

Develop a forecast for years 2 through 12 using exponential smoothing with %u03B1 = .4 and a forecast for year 1 of 6. Plot your new forecast on a graph with the actual data and th

Determine that the trade offs of operation system is correct, Determine tha...

Determine that the Trade offs of operations systems is correct You may wish to ponder this trade-offs for a moment and ask the question: is this correct? Consider an organisat

Explain what is the role of safety stock in an mrp system, 1) Discuss the m...

1) Discuss the meaning of MRP such as planned order release and scheduled order receipts? 2) Many practitioners currently update MRP weekly or biweekly. Would it be more valuabl

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