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

Decision making process, You have been asked to undertake a management acco...

You have been asked to undertake a management accounting review of an activity, a service or an event, which has occurred or is to occur in either your area of work or in an area o

Find annual carrying costs, Garden Variety Flower Shop uses 740 clay pots a...

Garden Variety Flower Shop uses 740 clay pots a month. The pots are purchased at $2 each. Annual carrying costs per pot are estimated to be 30 percent of cost, and ordering costs a

How to use approximation formulas for your calculation, The Northern Emerge...

The Northern Emergency Computer Support has a call center with 10 customer service representatives. Historical statistics show that the durations of customer calls are exponentiall

Explain what is the break even quantity beyond, The first process is expect...

The first process is expected to incur $280,000 of fixed cost and add $60 of variable cost for each unit produced. The second process has fixed costs of $200, 00 and adds $70 per e

Explain the benefits of list segmentation to direct marketer, What are the ...

What are the benefits of list segmentation to direct marketers?

Explain demand is approximately normal, Korner Hardware manager Emerson Jon...

Korner Hardware manager Emerson Jones is interested in determining how many nativity scenes to order for the 12-day holiday season. Past experience indicates that demand for these

Explain what the law code of hammurabi reveals, • Describe what the Law Cod...

• Describe what the Law Code of Hammurabi reveals about Babylonian culture; consider relations between men and women, slaves and freemen. • Explain whether or not you believe th

Explain quality metrics, A variety of organizational culture characteristic...

A variety of organizational culture characteristics make project success more likely. The characteristics include: A. Sufficient funding B. Feasible schedule C. Respect fo

Explain finite backward scheduling, A process capacity methodology that is ...

A process capacity methodology that is used to show how well parts being produced fit into a range specified by design limits is which of the following? a. Finite backward sche

Define conditions which exist globally that are contributing, Please answer...

Please answer both questions fully to have points awarded, Thanks! Decreasing the Incidence of CVD" Please respond to the following: 1. Propose the steps that might be taken

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