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

Testing the optimality, Step 1 : It is observed that cost of transportation...

Step 1 : It is observed that cost of transportation is to Rs. 144. Step 2: Testing the Optimality : After obtaining the initial basic feasible solution the next step is to test

Explain social media in checking references, I will need at least one page ...

I will need at least one page with cites and references; (use of social media in checking references)

Describe the role of ethics and social responsibility, Explain the role of ...

Explain the role of ethics and social responsibility in developing a strategic plan, considering stakeholder needs. Explain how your ethical perspective has evolved throughout t

Explain what is the optimal opder quantity for coffee, A special coffeehous...

A special coffeehouse sells Colombian coffee at a fairly steady reat of 30 pounds per month. The beans are purchased from a local supplier for $3.20 per pound. The coffeehouse esti

Explain important terms of the factories act 1948, Explain important Terms ...

Explain important Terms of the factories act 1948. Important Terms of act: (a) Factory:  A place wherein ten or more persons are working and wherein a manufacturin

Explain the term marketing, Explain the term Marketing. Marketing:  A...

Explain the term Marketing. Marketing:  All organisations are occupied in producing products or services meant for utilize/consumption by people at large. Wants and needs are

Compute the bias and mad for each set of forecasts, Given the series of dem...

Given the series of demand data below Period: 1 2 3 4 5 6 7 8 9 10 Demand: 43 31 52 44 23 48 40 39 30 40 Calculated forecasts for periods 7 through 11 using moving average

Determine the full study sample size, 1. An element of work has been measur...

1. An element of work has been measured 6 times, with the following results (units of 0.01 minutes): 18, 20, 19, 21, 19, 22. What should be the full-study sample size?  Answer:

What is benchmark for future comparison, Cunningham Performance Auto, Inc.,...

Cunningham Performance Auto, Inc., modifies 375 autos per year. The manager, Peter Cunningham, is interested in obtaining a measure of overall performance. He has asked you to prov

Three requirements that met when designing jobs, 1. What are the three requ...

1. What are the three requirements which must simultaneously be met when designing jobs?   Answer: Technical, economic and behavioural feasibility.

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