I need help with the attached question.

1.Saunders Railway Company handles large coal shipments.On April 13^th, the company had empty coal cars at the following locations in the quantities indicated:

Morgantownsupply of cars:35

Youngstownsupply of cars:60

Pittsburghsupply of cars:25

By April 16^th the following towns need coal cars delivered:

Coal Valleydemand for cars:30

Coaltowndemand for cars:45

Coal Junctiondemand for cars:25

Coalsburgdemand for cars:20

Using the mileage table below.Build an LP in Solver to minimize the number of miles traveled by coal cars to meet the required demand.What is the optimal solution?

Answer each of the following four problems and bring the completed take-home portion to the Final Exam on 8 May. Each problem is worth 15 points. Be sure to show enough information to fully grade your answer! 1. Saunders Railway Company handles large coal shipments. On April 13th, the company had empty coal cars at the following locations in the quantities indicated: Morgantown supply of cars: 35 Youngstown supply of cars: 60 Pittsburgh supply of cars: 25 By April 16th the following towns need coal cars delivered: Coal Valley demand for cars: 30 Coaltown demand for cars: 45 CoalJunction demand for cars: 25 Coalsburg demand forcars: 20 Using the mileage table below. Build an LP in Solver to minimize the number of miles traveled by coal cars to meet the required demand. What is the optimal solution? Coal From/To Coal Valley Junction Coalsburg Morgantown \" 70 .3!- Youngstown 20 10 Pittsburgh 100 -_