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 is production levelling related to 5s, How is production levell...

How is production levelling related to 5S and Value Stream Mapping?

Question 2, Exercise 2: Use of a Grid Analysis (Weighted Scoring Model) to ...

Exercise 2: Use of a Grid Analysis (Weighted Scoring Model) to Help Make the North American Plant Location Decision for the RX 330 This exercise illustrates how when deciding among

Explain perspective of the target audience for webcams, What is your perspe...

What is your perspective of the target audience for webcams?

Hospitality industry , Can I have a process strategy matrix , which has 5...

Can I have a process strategy matrix , which has 5 key performance objectives, people processes, technology and information in one of the accor chain hotel?

Explain what suggestions do you have for improving program, Go to skillsoft...

Go to skillsoft.com, the website for Skill soft, a company that specializes in providing e-learning solutions. Move the cursor over Info Center, then over Demos. Click on Business

Describe how many bags per run are optimal, A chemical firm produces sodium...

A chemical firm produces sodium bisulfate in 100-pound bags. Demand for this product is 20 tons per day. The capacity for producing the product is 50 tons per day. Setup costs $100

[email protected], Modelling – meaning and process, Certainty and uncertainty...

Modelling – meaning and process, Certainty and uncertainty in models, importance of understanding data before modelling , modelling with spreadsheet in simple decision situations.

What do you think joe thomas must do about this matter?, What do you think ...

What do you think Joe Thomas should do about this matter?

Explain course wrap-up, "Course Wrap-Up" Please respond to the following: I...

"Course Wrap-Up" Please respond to the following: Identify three concepts from your graduate course work that you found to be of significant value and explain how you plan to apply

Production control function, Production control Function 1. Dispatchi...

Production control Function 1. Dispatching : Dispatching may be  defined as setting  production activities in motion through  the  release  of orders ( work order shop order)

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