I need to have solver solution The City's Department of Transportation (on its own and as a client to the Department of Design and Construction) uses about 400,000 tons of asphalt each year to repave streets There are eight asphalt plants located in and around New York City, one of which is owned by the City and staffed by City employees Each plant's capacity (the maximum it can produce) along with the price for which it is willing to sell asphalt to the City (the cost to the City at the plant) are listed in Table 1 Since the specific streets that will be paved are all over a borough, the Department uses a central point to determine distance from the plants to job sites It costs $0 15 per ton per mile to truck asphalt from a plant to a job site Distances from each plant to the Borough centers are displayed in table 2 Use these distances as they are to calculate the transportation costs Table 3 displays the amount of asphalt each borough expects to need in the next year How much should it take from each plant The City can buy from as many plants as it wants Would it make sense for the City to expand its own plant How much would it be willing to invest in that expansion Assume it can expand without limit and produce at the same cost Using the same information that we used to solve the original Cost of Asphalt problem, answer the questions below with the following new information It has been estimated that the cost of expanding the Hamilton Avenue Plant beyond its current 100,000 ton capacity would cost $8 per ton of expansion That is, if the City decided to expand the capacity of the plant by 10,000 tons to 110,000, it would incur a cost of $80,000 (Assume that is an amortized cost estimate and that cost could be added directly to the total cost function ) 1 How much capacity would it add in that expansion Assume it can expand without limit and produce at the same cost 2 How much new capacity would the City add if the cost was $5 per ton Z now much new capacity would we city add li tie cost was Dy per won Table 1 Table 3 Plant Capacity ( yr) Cost at Silo ( ton) Borough Requirements (Tons per Year Needed) Grace Asphalt 80,000 $29 70 Manhattan 65,000 Tully Construction 75,000 $28 40 Bronx 55,000 Van Bro Materials 100,000 $26 95 Brooklyn 85,000 Nigro Corp 60,000 $27 32 Queens 125,000 Yonkers Contractors 75,000 $28 01 Staten Island 70,000 New York Paving 60,000 $29 50 Sopranos Inc 65,000 $30 25 Hamilton Ave (City Owned) 100,000 $19 85 Table 2 Plant Manhattan Bronx Brooklyn Queens Staten Island Grace 8 5 6 2 10 5 2 1 14 8 Tully 8 3 7 1 9 9 1 8 13 9 Van Bro 12 1 19 4 7 3 16 2 2 7 Nigro 11 6 5 9 14 9 10 3 22 5 Yonkers 10 9 5 2 13 7 12 1 23 6 New York 8 4 6 6 9 7 1 5 13 1 Sopranos 6 8 13 1 4 2 8 2 9 1 Hamilton 5 5 12 4 5 4 9 3 10 1

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 22, 2024

I need to have solver solution The City's Department of Transportation (on its own and as a client to the Department of Design and Construction)

I need to have solver solution

The City's Department of Transportation (on its own and as a client to the Department of Design and Construction) uses about 400,000 tons of asphalt each year to repave streets. There are eight asphalt plants located in and around New York City, one of which is owned by the City and staffed by City employees. Each plant's capacity (the maximum it can produce) along with the price for which it is willing to sell asphalt to the City (the cost to the City at the plant) are listed in Table 1.

Since the specific streets that will be paved are all over a borough, the Department uses a central point to determine distance from the plants to job sites. It costs $0.15 per ton per mile to truck asphalt from a plant to a job site. Distances from each plant to the Borough centers are displayed in table 2. Use these distances as they are to calculate the transportation costs. Table 3 displays the amount of asphalt each borough expects to need in the next year.

How much should it take from each plant? The City can buy from as many plants as it wants.
Would it make sense for the City to expand its own plant? How much would it be willing to invest in that expansion? Assume it can expand without limit and produce at the same cost.
Using the same information that we used to solve the original Cost of Asphalt problem, answer the questions below with the following new information: It has been estimated that the cost of expanding the Hamilton Avenue Plant beyond its current 100,000-ton capacity would cost $8 per ton of expansion. That is, if the City decided to expand the capacity of the plant by 10,000 tons to 110,000, it would incur a cost of $80,000. (Assume that is an amortized cost estimate and that cost could be added directly to the total cost function.)

1.How much capacity would it add in that expansion? Assume it can expand without limit and produce at the same cost.

2.How much new capacity would the City add if the cost was $5 per ton?

Z. now much new capacity would we city add li tie cost was Dy per won! Table 1 Table 3 Plant Capacity (/yr) Cost at Silo (/ton) Borough Requirements (Tons per Year Needed) Grace Asphalt 80,000 $29.70 Manhattan 65,000 Tully Construction 75,000 $28.40 Bronx 55,000 Van Bro Materials 100,000 $26.95 Brooklyn 85,000 Nigro Corp 60,000 $27.32 Queens 125,000 Yonkers Contractors 75,000 $28.01 Staten Island 70,000 New York Paving 60,000 $29.50 Sopranos Inc 65,000 $30.25 Hamilton Ave (City Owned) 100,000 $19.85 Table 2 Plant Manhattan Bronx Brooklyn Queens Staten Island Grace 8.5 6.2 10.5 2. 1 14.8 Tully 8.3 7.1 9.9 1.8 13.9 Van Bro 12.1 19.4 7.3 16.2 2.7 Nigro 11.6 5.9 14.9 10.3 22.5 Yonkers 10.9 5.2 13.7 12.1 23.6 New York 8.4 6.6 9.7 1.5 13.1 Sopranos 6.8 13.1 4.2 8.2 9.1 Hamilton 5.5 12.4 5.4 9.3 10.1