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

Computed marginal profit for various costing profiles, An HMO requests your...

An HMO requests your hospital services for its obstetrics division. It offers to pay your hospital $2,000 for a vaginal delivery without complications (DRG 373). You look at the St

Explain why organizations need correct performance metrics, Discuss why org...

Discuss why organizations need to have the correct performance metrics to drive quality. Think of examples in the news and their outcomes.

Explain assessment of the quality of the decision, Watch the video, how to ...

Watch the video, how to perform a SWOT Analysis, and then conduct a SWOT analysis using the Starbucks' Global Quest 2006: Is the Best Yet to Come? Case provided in the Course Mater

Causes of poor lighting, 1. Flickering tubes: This condition which may b...

1. Flickering tubes: This condition which may be due to defective conditions or by tube which has reached its working life, creates eyestrain. 2. A. Misadjusted Refle

Create a perceptual map for a particular product, Which of the following da...

Which of the following data are collected from consumers to develop a perceptual map for a particular product? A listing of all prospective brands and products Managerial jud

Explain overall impression of the candidate, Does a condidate's use of a so...

Does a condidate's use of a song you like (or dislike) affect your overall impression of the candidate?

Explain project manager is normally directly accountable, The project manag...

The project manager is normally directly accountable for the project result, schedule and budget.

Define materials requirements planning, Describe a consequence of not proce...

Describe a consequence of not processing MRP (Materials Requirements Planning) records in a timely fashion.

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

Cellular manufacturing, Hi, How to design a cell layout after forming the p...

Hi, How to design a cell layout after forming the part families and machine routing sequence. Is there any algorithm/heuristics/ mathematical models available to do it ? Please hel

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