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 efects in the accounts receivable department, Category- 1) Invoi...

Category- 1) Invoice Amount does not agree with check amount 2) Invoice not on record 3) No formal invoice issued 4) Check (payment) not recieved on time 5) Check no

Explain store marketing, Please answer this question: You work in the suppl...

Please answer this question: You work in the supply chain department for a consumer goods company. You have recently expanded globally shipping goods to a nation where it is custom

Relationship among analysis and planning and implementation, Analyze the re...

Analyze the relationship between analysis, planning, implementation, and control. Provide an example of a product or service that flows through this relationship. Break down the pr

Difference between performance and productivity measurement, 1. Explain the...

1. Explain the link between productivity and quality?  2. Who do van Biema and Greenwald (1997) and Drucker (1991) suggest are responsible for the slow growth in service sector

Explain brand equity, What is your understanding of the term: Brand Equity?...

What is your understanding of the term: Brand Equity? How do marketers develop brand equity for their products/services relative to competition? Provide an example of a brand/produ

MBA, A paper mill produces two grades of paper viz., X and Y. Because of ra...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

Explain identify the basic control issues at unilever, Identify the basic c...

Identify the basic control issues at Unilever from all three levels? How do you think the control function should be organized and managed at Unilever?

Which charts is used to monitor the total number of defects, Which of the f...

Which of the following charts is used to monitor the total number of defects per unit when a constant subgroup size is employed? s-chart c-chart p-chart u-chart

Explain what forecast is the most accurate, Data collected on the monthly d...

Data collected on the monthly demand for lawn mower at Azaka Gaarden Supply are shown in the following table Period Demand for lawn mower January 10 February 12 March 18 April 16 M

Describe how to do in excel, Can you show how to do in excel? Bowman Bui...

Can you show how to do in excel? Bowman Builders manufactures steel storage sheds for commercial use, Joe Bowman, president of Bowman Builders, is contemplating producing sheds

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