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 best time for performance appraisal, Is there one best time for per...

Is there one best time for performance appraisal? Explain

Explain investment triple itself, At what rate of interest, compounded annu...

At what rate of interest, compounded annually, will an investment triple itself in (a) 8 years ? (b) 10 years? (c) 12 years?

What kinds of goals will donna likely make, Donna Hamilton is excited to op...

Donna Hamilton is excited to open her own restaurant, the Westminster Inn. Although Donna has worked as a chef and even managed a number of restaurants during her career, she is co

Innovation and learning perspective - performance measures, Innovation and ...

Innovation and Learning Perspective - Performance Measures In this perspective, the company emphasises the design and application of business management initiatives that foste

Determine a pareto analysis of the errors, 1. Construct and inerpret ...

1. Construct and inerpret a control chart for the packing slip data. 2. Construct a Pareto analysis of the errors. 3. What information might a separate char

Explain the specification of lead time, Explain the specification of lead t...

Explain the specification of lead time. Lead Time has: (i) Time to place the order and to process the enquiries. (ii) Time to send the order to the supplier. (iii) Ti

Answer the this question as I found on the google search, Ask questioAn ups...

Ask questioAn upscale home fixture supplier has four locations. Each location manages its ordering independently. The specialized lighting fixture sells for $300 and sales are on a

Introduction to the operations function, Introduction to the Operations Fun...

Introduction to the Operations Function Firstly, consider the economy where gross domestic product (GDP) has been subdivided into its major divisions which are agriculture, ma

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