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 the average safety capacity, An assembly line normally operates two ...

An assembly line normally operates two shifts a day, five days per week. The planned capacity of the assembly line is 380 units/shift. Determine the average safety capacity if 700

Describe double exponential smoothing, The Cardinal Electronics Company mus...

The Cardinal Electronics Company must project the sales of cellular phones for the next year (called year 2). The number of cell phones sold by Cardinal Electronics in each of the

Find range of annual volume, A firm plans to begin production of a new smal...

A firm plans to begin production of a new small appliance. The manager must decide whether to purchase the motors for the appliance from a vendor at $7 each or to produce them in-h

Find revenue growth and overall financial performance, What actions do you ...

What actions do you think management at Sam's Club should take to boost revenue growth and overall financial performance? What actions do you think management at BJ's Wholesale sho

Explain expects to perform the modifications to vehicles, Honda Motor Compa...

Honda Motor Company has discovered a problem in the exhaust system of one of its automobile lines and has voluntarily agreed to make the necessary modifications to conform with gov

Explain the affidavit, Which section of the project charter signed by spons...

Which section of the project charter signed by sponsor, project manager and core team members typically describes decision authority and the expected commitment for each of these k

Define goal is to develop a strong talent management program, The goal is t...

The goal is to develop a strong talent management program globally to develop and retain talent that you have been losing to competitors. Discuss the strategies that you might use

Explain efects in the accounts receivable department, Category- 1) Invoi...

Category- 1) Invoice Amount does not agree with check amount 2) Invoice not on record 3) No formal invoice issued 4) Check (payment) not recieved on time 5) Check no

What additional annual cost is the shop incurring by staying, Garden Variet...

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

Explain business-level strategy, "Business-Level Strategy" Please respond t...

"Business-Level Strategy" Please respond to the following: • From the first e-Activity, assess your satisfaction with the company you researched and make recommendations about h

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