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 the precedence relationships and the estimated times, A project con...

A project consists of activities A, B, C, D, E, F, and G. The precedence relationships and the estimated times to complete each activity are given below: Activity Preceding Activit

Explain cost-reimbursement contracts for the government, Find an example of...

Find an example of a project in which one of these two types was used in a real federal contract. These two types refers to contrast fixed-price and cost-reimbursement contracts fo

Develop a hypothesis test that can be used to what, According to a study, t...

According to a study, the mean price of a gallon of unleaded gasoline in the United States is 4.15. a sample of 25 Chicago area gas station shows the mean price of 4.95. the standa

Explain process-improvement efforts, Until the start of the 1980s, most U.S...

Until the start of the 1980s, most U.S. companies focused on maintaining quality levels by utilizing which of the following practices? Process-improvement efforts Design-qual

I want help with writing an rcode to analyze an experiment, I need help wit...

I need help with writing an rcode to analyze an experiment for a two way layout without replication. There are two factors each with 3 levels.

What factors are likely cause faults in valuing google stock, The managemen...

The management and Directors of Google have stated that there is no plan for Google to ever pay dividends. Yet, the stock trades at a very high price in dollar terms (around $490 p

Explain fatigue and delay, a. You are chartered to set a time standard for ...

a. You are chartered to set a time standard for a worker assembling 96 piece jigsaw puzzles. The following times have been collected from five different operators with one observat

Explain city water supply system, The network in figure below shows the pip...

The network in figure below shows the pipeline transportation system for treated water from the treatment plant (node 1) to a city water supply system (node 14). The arc capacities

Operations Management: Sustainability and Supply Chain Manag, I have seven...

I have seven homework question that I''m trying to complete. How much will it cost

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