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

Define the term management, Define the term Management.  Ans:  "Mana...

Define the term Management.  Ans:  "Management is the accomplishment of results by the efforts of many people"  - LAWRENCE APPLEY   "Management is the art of getting

What are the qualities you believe are important in a leader, Name three qu...

Name three qualities you believe are important in a leader. Elaborate on each of those qualities. Do you think a leader today has to be more aware of their ethical behaviours than

Describe how hr evolved throughout this process, HR has moved from an admin...

HR has moved from an administrative function to a transformational function. This change is based on automating HR functions through an HRIS system. Explain how HR evolved througho

Explain statutory law, Statutory law is: Answer a law enacted by a legislat...

Statutory law is: Answer a law enacted by a legislative body also known as the fundamental law of the nation a form of common law the separation of powers at the federal level all

Calculate the mean absolute deviation, Since May of 2005, the purchase mana...

Since May of 2005, the purchase manager at a department store has been using a 4-period moving average to forecast sales in upcoming months. Sales data for the months of January th

Explain observation setting be natural or contrived, What are Best Practice...

What are Best Practices of college/university communications to students? Concerning this research project, what primary data would you suggest and by what methods should be used t

Describe alabama electric for a claim, Fred Flowers works for Alabama Elect...

Fred Flowers works for Alabama Electric and is a resident of the State of Florida. Following a series of storms in the Northeast, Alabama Electric sent Fred to Virginia as part of

Explain increase retention of employees, If you became the new manager at r...

If you became the new manager at restaurant with high employee turnover, what actions would you take to increase retention of employees?

Explain annual holding and order costs, Item Cost - $7.00 Order Cost - $283...

Item Cost - $7.00 Order Cost - $283.00 Annual Hold - 32% of item cost Annual Demand - 22,100 Average Demand - 442 per week Standard deviation of weekly demand 20 per week lead time

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