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 handheld computer or a tablet computer, Which would you rather have...

Which would you rather have - a handheld computer or a tablet computer? Why?

States gross national product, States Gross National Product (GNP) Gr...

States Gross National Product (GNP) Gross Domestic Product (GDP) adjusted for foreign earnings.

Explain what are the two possible outcomes if this is done, It is generally...

It is generally not appropriate to apply control charts to the same data that were used to derive the mean and limits. Why? What are the two possible outcomes if this is done, how

Describe key issues and concerns, As area sales manager for a company manuf...

As area sales manager for a company manufacturing and marketing outboard engines, you have been assigned the responsibility of conducting a research study to estimate the sales pot

I want to make-to-stock master production schedule, I need instructions for...

I need instructions for completing a make-to-stock master production schedule

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 both or either of burglary and felony murder, Doug enters Jane%u201...

Doug enters Jane%u2019s residence through an unlocked window that he lifts open at midnight, intending to steal her first edition copy of Sense & Sensibility, which he knows was re

Determine the optimal selling price, A manufacturer sells 150 tables a mont...

A manufacturer sells 150 tables a month at the price of $200 each. For each $1 decrease in price, he can sell 25 more tables. Each table costs $125 to make. (a) The demand (pric

Explain procedure of job evaluation, Explain procedure of job evaluation. ...

Explain procedure of job evaluation. Procedure of Job Evaluation:   The procedure for job evaluation is as specified below: (i)  Know the jobs to evaluate. (ii) Selec

Explain importance of team preparation, • Prepare a 3 to 5 page paper discu...

• Prepare a 3 to 5 page paper discussing what conclusions you can reach on the importance of team preparation and member selection to the "Define" stage, and eventual success of Si

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