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

Define what rrmc should do to counter its image, Describe what RRMC should ...

Describe what RRMC should do to counter its image problem in the community because of its decision to close the Women's Pavilion.

Explain what is the most that should be paid for forecast, Nick has plans t...

Nick has plans to open some pizza restaurants, but he is not sure how many to open. He has prepared a payoff table to help analyze the situation. States of Nature Alternatives Good

Calculate discount on acquisition, Westside Printing Limited was incorporat...

Westside Printing Limited was incorporated on 1 July 200A to take over the existing business of Bob's Printing. Net assets (other than cash) were taken over at fair value. The tota

Explain what capability would an organization have, What capability would a...

What capability would an organization have to have to not need forecasts?

Explain risks to a broad generic business strategy, What are some drawbacks...

What are some drawbacks and risks to a broad generic business strategy? To a focused strategy?

Define importance of training and education, Define importance of Training ...

Define importance of Training and Education. Importance of Training and Education: Training and education bring employees to a standard whether they can carry out industrial

Explain the current yield on alaska power company bonds, Alaska Power Compa...

Alaska Power Company issued $1,000 bonds that have an annual coupon rate of 7.5%. The present market value of the bonds is $1,125. If the bonds have 15 years remaining until maturi

Explain low level coding in mrp indicates, Q 1 Low level coding in MRP indi...

Q 1 Low level coding in MRP indicates the exact status of each item managed by the system in "real time." Q 2 Which of the following is considered a secondary report in an MRP s

Examples of productivity measures, Examples of Productivity Measures  ...

Examples of Productivity Measures  Sales ($)/labour costs ($)  Sales ($)/pay ($)  Total value of sales (billed) ($)/labour costs($) + investment ($)  Sales/salespeopl

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