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 how can healthcare service providers avoid claims, Part I: Avoid cl...

Part I: Avoid claims rejections A payer may delay or deny payment because of inaccurate or missing information in a submitted claim. Many contracts require payment within a spec

Explain homogenous group, In a diverse team, a "fault-line" refers to: a. C...

In a diverse team, a "fault-line" refers to: a. Cases in which a team tends to find fault or blame in the other team members rather than their own behaviour b. Cases in which group

Explain build the pilot project and then make a decision, Dan Reid, chief e...

Dan Reid, chief engineer at New Hampshire Chemical, Inc., has to decide whether to build a new state-of-art processing facility. If the new facility works, the company y could real

Which is a group of products that are closely related, A _____ is a group o...

A _____ is a group of products that are closely related because they satisfy a class of needs, are used together, are sold to the same customer group, are distributed through the s

Compute a simple exponential smoothing forecast, The actual demand of the p...

The actual demand of the patients at Omaha Emergency Medical clinic for the first six weeks of the year are as follows: week Actual # of patients 1 65 2 62 3 70 4 48 5 63 6

Structural adjustment - factor affecting productivity, Structural Adjustmen...

Structural Adjustments - Factors Affecting Productivity Improvement Structural adjustment relates to the composition of society, the industries in which people work, fashions

Look to shareholders - financial perspective, Look to Shareholders - Financ...

Look to Shareholders - Financial Perspective  In this perspective, the company identifies individual function contribute to the accomplishment of its overall mission and strat

Answer, the desired daily output for an assembly line is 360 units.this ass...

the desired daily output for an assembly line is 360 units.this assembly line will operate 450 minutes per day

Presume the restaurant operates 360 days per year, A fast-food restaurant b...

A fast-food restaurant buys hamburger buns from a national bakery supplier. The daily usage of buns at the restaurant is normally distributed with an average of 160 and standard de

Describe what is the total cost of a package, The Fido Dog Food Company wis...

The Fido Dog Food Company wishes to introduce a new brand of dog biscuits (composed of chicken and liver-flavoured biscuits) that meets certain nutritional requirements. The liver-

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