this is done on a excel speadsheet. i need help setting it up.

3) You are a major exporter based in Nicaragua, who is trying to introduce the Pitaya fruit (they are delicious) to the US market in LA and Boston (demand in each city is provided in the table below). You can ship from the west coast of Nicaragua and have access to three seaports in the United States (San Diego, Trenton, and Lewiston), and can transfer the fruit to trains and trucks from the seaport to reach their final destination. Given the length and storage technologies, some percentage of the fruit is spoiled on each leg of the journey and the costs vary by route (information provided below). a. (8 points) In Excel, please draw the transshipment network and make sure to label cach node and are with the appropriate information. b. (15 points) Please set up and solve this transportation problem that meets demand while minimizing costs. Make sure to label you objective function, constraints, and decision/choice variables. Starting Location Percent spoiled Cost per ton Seaport West Coast Nicaragua San Diego 5% $0.67 West Coast Nicaragua Trenton 12% $0.52 West Coast Nicaragua Lewiston 13% $0.78 US Seaport San Diego San Diego Trenton Trenton Lewiston Lewiston Destination Percent spoiled Cost per ton LA 1% $0.61 Boston 3% $2.52 LA 6% $2.57 Boston 1% $1.47 LA 6% S1.52 Boston 7% $1.78 Destination Tons Demanded LA 6,000 Starting Tons Location Supplied West Cost Nicaragua 11,000 Note: Only ship enough to meet demand Boston 4.000