Find forecasted sales for week first, 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.


Mumbai

Chennai

Lucknow

Delhi

Kolkata

OP Bal

120

350

270

250

350

Safety Stock

60

125

150

100

200

Min Ord Qty

80

200

200

100

300

Lead time Wk

1

2

3

2

3

Transit





300

Sales Forecast






Wk 1

50

100

150

50

100

Wk 2

35

75

100

75

150

Wk 3

55

125

150

80

200

Wk 4

65

100

200

55

135

Wk 5

80

200

300

75

125

Wk 6

125

150

200

80

165

Wk 7

50

100

100

90

200

 


Related Discussions:- Find forecasted sales for week first

Explain formal partnership agreement, Suppose a partnership is set up and o...

Suppose a partnership is set up and operated without a formal partnership agreement. What problems might arise?

Describe identified the problem and a technology solution, At this point of...

At this point of the project, you have identified the problem and a technology solution for the business. Now, you want the business to accept the idea. Using your text, the pre

Explain even though efforts to restrict employees'', Discuss the following ...

Discuss the following statement: Even though efforts to restrict employees' free speech at work may be permissible, such efforts raise troubling questions affecting individual righ

Explain democracy of goods, The concept of the "democracy of goods" means w...

The concept of the "democracy of goods" means what? 1. Fill in the blanks: By Mistake, someone left spaces unfilled in the status report below. a. Please complete the report

Explain that they receive the training they need, The Chief Projects Office...

The Chief Projects Officer (CPO) is responsible for the individuals working on a project in all of the following way EXCEPT: A. That they perform project activities according to

, What happens if balance doesn’t exis

What happens if balance doesn’t exist

Describe costco''s inventory before it is sold, The following table shows f...

The following table shows financial data for Costco and wal mart: CostcoInventories: $3,643Sales (net): $48106COGS: $41651 Wal Mart:Inventories: $29447Sales (net): $286103COG

Explain multifactor productivity, The following table shows data on the ave...

The following table shows data on the average number of customers processed by several bank service units each day. The hourly wage rate is $15, the overhead rate is 1.0 times labo

Explain what type of discharge of the contract, Mary has a City Credit Card...

Mary has a City Credit Card (CCC) and has run up a $13,000 debt. She calls the company and explains that she can't pay the full amount, but will be willing to pay $10,000 if they w

Explain evolution of the supply chain concept, What is the relationship bet...

What is the relationship between the growth in worldwide competition and the evolution of the supply chain concept?

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