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

Draw a p-chart based on the questionnaire results, You are the newly appoin...

You are the newly appointed assistant administrator at a local hospital, and your first project is to investigate the quality of the patient meals put out by the food-service depar

Define a person stole a car from a car rental agency, A person stole a car ...

A person stole a car from a car rental agency. The police spotted the car and gave chase. The thief hit another car, seriously injuring that driver. The person who stole the car fl

Describe some possible strategic initiatives that sigma, Suggest some possi...

Suggest some possible strategic initiatives that Sigma could pursue to continue its growth.

Determine the standard time, An 8 hours work measurement  study  in a plant...

An 8 hours work measurement  study  in a plant reveals the following : Units  produced= 320 nos. Idle  time = 15%  performance rating-= 120% . allowances  = 12% of normal  time. De

Forcasting, what are types of forcasting?

what are types of forcasting?

Explain creating diverse teams is a challenge, Creating diverse teams is a ...

Creating diverse teams is a challenge. All of the following are important steps to include in a plan for bringing diversity to a team, except: a. The organization should publicly c

Assignment, What do you understand by “line balancing”? What happens if bal...

What do you understand by “line balancing”? What happens if balance doesn’t exist?

Depict a sequence diagram, Hertford Post Office Situation: Hertford has a t...

Hertford Post Office Situation: Hertford has a typical small town post office that sells stamps, rents post office boxes, and delivers mail to postal customers. a. Identify possibl

Explain what leadership style dominates at novo nordisk, A wide array of le...

A wide array of leadership perspectives and theories. In order to synthesize the information, it is best to look at a real-life situation and analyze the leadership styles. Case 14

Devise a regression equation or predict the profitability, Consider the tab...

Consider the table below. This time, the historical profitability of eight locations is listed in the table. Devise a regression equation and predict the profitability of a new sit

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