please do question 9.11 only

if you can properly fill in the excel i will thumbs up.

342 CHAPTER 9. TRANSPORTATION, ASSIGNMENT. AND NETWORK MODELS plant capacities, and daily project requirements are By Monday, April 16, the following towns will need provided in the table on this page the numbers of coal cars listed: Formulate this as a linear program to determine the least-cost way to meet the requirements. Solve TOWN DEMAND FOR CARS using any computer software Coal Valley 30 9.9 Hardrock Concrete's owner has decided to increase Cealtown 45 the capacity at his smallest plant (see Problem 9,8). Coal Junction Instead of producing 30 loads of concrete per day at plant 3, that plant's capacity has been doubled to Cealsburg 60 loads. Does this change the schedule developed Using a railway city-to-city distance chart the dis previously? patcher constructs a mileage table for the preceding 8.9-10 The Saussy Lumber Company ships pine flooring to towns. The result is shown in the table on this page three building supply houses from its mills in Pine- Minimizing total miles over which cars are moved ville. Oak Ridge, and Mapletown. Determine the to new locations, compute the best shipment of coal best transportation schedule for the data given in the cars table on this page 8:9-12 An air-conditioning manufacturer produces room 8:9-11 The Krampf Lines Railway Company specializes air conditioners at plants in Houston, Phoenix, and in coal handling. On Friday, April 13, Krampf had Memphis. These are sent to regional distributors in empty cars at the following towns in the quantities Dallas, Atlanta, and Demer. The shipping costs vary. indicated and the company would like to find the least-cost way to meet the demands at each of the distribution TOWN SUPPLY OF CARS centers, Dallas needs to receive 800 air condition Morgantown 35 ees per month. Atlanta needs 600, and Denver needs 200, Houston has 850 air conditioners available cach Youngstown 60 month Phoenix has 650, and Memphis has 300. The Pittsburgh shipping cost per unit from Houston to Dallas is $8. Table for Problem 9-8 TO FROM PROJECT A PROJECT PROJECTC CAPACITY PLANTI $10 $4 S11 70 PLANT 2 $12 SS S8 SO PLANT 3 59 S7 $6 30 REQUIREMENTS 40 50 60 Table for Problem 9-10 TO FROM PANEVILLE OAK RIDGE MAPLETOWN SUPPLY-HOUSE DEMAND SUPPLY SUPPLY SUPPLY MILL HOUSE 1 HOUSE 2 HOUSE 3 CAPACITY (TONS 53 53 S2 S4 $2 53 40 S3 S2 S3 30 30 30 35 Table for Problem 9-11 TO FROM COAL VALLEY COALTOWN COAL JUNCTION COALSBURG MORGANTOWN SO 30 60 70 YOUNGSTOWN 20 80 10 90 PITTSBURGH 100 40 80 30 X1 X12 X13 1 x22 X23 X1 X2 33 Decision Variables 5. Objective Function Coefficient 6 Constraints LHS BHS Ole 10 11 12 11 DIC CE O IS 16 17