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

Distinguish among a general benefit and a specific benefit, Distinguish bet...

Distinguish between a general benefit and a specific benefit. Why do customers respond positively to specific benefits?

Layout s problems, what are the problems of layouts like: functional , line...

what are the problems of layouts like: functional , line layout in production & operation mangement subject

Explain the various ways hr supports managers, 1) Discuss the various ways ...

1) Discuss the various ways HR supports managers. 2) Discuss the difference between the focus on Affirmative Action and the focus on equality. 3) Discuss two of the protected class

Explain legal and ethical behaviour in marketing, Describe the difference b...

Describe the difference between legal and ethical behaviour in marketing. Give an example of each as it pertains to marketing

Write the facultyids of faculty who are not qualified, Using the following ...

Using the following tables (primary keys are underlined), write the expressions that follow in SQL. STUDENT (StudentID, StudentName) FACULTY(FacultyID, FacultyName) COURSE(CourseID

Describe why is it vital to pay more attention to firms roe, Explain why is...

Explain why is it important to pay more attention to the firm's ROE if you are the firm's shareholder (investor) and explain how to use the DuPont equation to see how the ROE can b

Explain fixed order interval system, How much gravy should be ordered using...

How much gravy should be ordered using a fixed order interval system? Order is being placed on Thursday and the fiscal week begins on Thursday and ends on Wednesday. Service level

Moving average in local organic food market, Weekly sales of 10-grain bread...

Weekly sales of 10-grain bread at the local organic food market are in the table below. Based on this data, forecast Week 9 using a five-week moving average. Week Sales 1

Explain sexual assault prevention and response, What impact do you think th...

What impact do you think that the DODs new Sexual Assault Prevention and Response (SAPR) program will have on the culture and the historic problems of sexual assault/harassment and

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