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

Location analysis, explain the series of steps involved and various factor...

explain the series of steps involved and various factor effecting location decion?

Find which city provides the lowest overall costs, Kelly Trucking, Inc., is...

Kelly Trucking, Inc., is planning a new warehouse to serve the western United States. Denver, Santa Fe, and Salt Lake City are under consideration. For each location, annual fixed

Depict a fishbone chart showing reasons, Consider the everyday task of gett...

Consider the everyday task of getting to work on time or arriving at your first class on time in the morning. Draw a fishbone chart showing reasons why you might arrive late in the

Hidden markov models, Hidden Markov Models: We discussed an example of...

Hidden Markov Models: We discussed an example of determining the most probable state path with the Viterbi algorithm. We also discussed in the class how to calculate the margi

Illustrate the examples of the inventory control systems, Illustrate the ex...

Illustrate the examples of the inventory control systems? Examples of inventory control systems Reorder level systems: When the current stock level decreased below a

Define performance appraisal, Define performance appraisal. Performanc...

Define performance appraisal. Performance Appraisal:   It is a systematic and impartial assessment of an employee's performance on the job, along with a view to discovering ho

Depict a project network that includes all the activities, Operations and S...

Operations and Supply Chain Management : CELL PHONE DESIGN PROJECT 1. Draw a project network that includes all the activities 2. Calculate the start and finish times for each

External factors - factor affecting productivity improvement, External Fact...

External Factors - Factors Affecting Productivity Improvement As was previously stated, the organisation has no direct control over external factors, be they government policy

What is business process re-engineering, What is Business process re-engine...

What is Business process re-engineering? Business process re-engineering (BPR): The basic redesign of existing business processes to attain enhancements in critical areas

Explain the term organisation structure, Explain the term organisation stru...

Explain the term organisation structure. It is the systematic arrangement of the people doing work for the organisation so as to achieve predecided goals.  This structure is

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