please include the formulated table so I can see the formula used.

1. The ProExpert Company is producing highchairs in its three production facilities and ships the highchairs to four distribution centers. Production facilities 1, 2, and 3 produce 12, 17, and 11 shipments per month, respectively. Each distribution center needs to receive 10 shipments per month. The distance from each plant to the respective distributing centers is given below: Distance Distribution Center 1 2 3 4 1 800 miles 1,300 miles 400 miles 700 miles Plant 2 | 1,100 miles 1,400 miles 600 miles 1,000 miles 3 600 miles 1,200 miles 800 miles 900 miles The freight cost for each shipment is $100 plus 50 cents per mile. Formulate this problem as a transportation problem by constructing the appropriate parameter table. How much should be shipped from each plant to each of the distribution centers to minimize the total shipping cost? Solve the question using both Excel solver and pyomo