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

Depict an aon diagram of the project, The following is a table of activitie...

The following is a table of activities associated with a project at Bill Figg Enterprises, their durations and what activities each must precede- Activity Duration (weeks) Prece

What are the three sequential operations, A manufacturing process consists ...

A manufacturing process consists of three sequential operations. At maximum capacity operation A can output 125 units per hour, Operation B can output 120 units per hour, and Opera

Explain what are the privacy requirements under hipaa, What are the privacy...

What are the privacy requirements under HIPAA? Explain why confidentiality of health information has been a controversial public policy issue. Give a real world example. How can he

Quantitative layout analysis, Quantitative Layout Analysis Once a layo...

Quantitative Layout Analysis Once a layout is prepared, before accepting it should be evaluated quantitatively and compared with other alternative layouts to have a better lay

Explain main reasons businesses safe guard the environment, What are the ma...

What are the main reasons businesses don't conserve natural resources or safe guard the environment?

How to exceeded these requirements, Please solve the following constraint t...

Please solve the following constraint then graph: -0.30x + 0.70y ? 0 Show ALL work as to how you got to your conclusion. I will give the highest rating to the person who I fe

Explain dual chains of command can create more problems, Some people argue ...

Some people argue that the matrix structure should be adopted only as a last resort because the dual chains of command can create more problems than they solve. Discuss. Do you agr

Forecasting, The cafeteria supervisor at CarWash is interested in developin...

The cafeteria supervisor at CarWash is interested in developing a forecast model for the number of meals to be prepared each day. The following daily data from the cafeteria’s regi

Describe katie''s liability, Katie is a 17-year-old (a minor) who graduated...

Katie is a 17-year-old (a minor) who graduated from high school two months ago. In August, she started attending a university 150 miles from home and has contracted to rent an apar

Explain can you provide examples of voluntary boundaries, Can you provide e...

Can you provide examples of voluntary boundaries, core practices, and mandated boundaries in various industries? Why do the boundaries you identify fit within each category?

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