problem #2 graph and show using excel

The container ships sent from the San Francisco pier need to be carefully balanced in order to sail correctly to the markets beyond the Pacific Ocean. Usually, these ships have three storage places: back, center, and front, each of them with different weight and volume capacities. The back can carry up to 2,000 tons or 100,000m3 of products. The center can carry up to 3,000 tons or 135,000m3. The front can carry up to 1,500 tons or 30,000m3. A particular ship is going to be loaded with three particular products (i.e., cars, computers, and home appliances). There are 4,000 tons of cars, 6,000 tons of computers, and 2,000 tons of homeappliances ready to be shipped. Each ton of car occupies 50m3, while each ton of computers occupies 60m3, and each ton of home appliances occupies 25m3 of volume. It costs $600 to transport each ton of car, but the ship charges $1,400 per ton to the car producer. Similarly, it costs $1,000 to transport a ton of computers, while the producer is charged with $1,600 per ton. Finally, transporting a ton of home appliances costs $750, and the ship charges $1,200 per ton transported to the producer. To ensure a quick delivery without any complications in the ocean, the [weight/weight capacity] ratio must be the same for all the storage places. Please do the following (credit is assigned at the end of each bullet): Similarly, it costs $1,000 to transport a ton of computers, while the producer is charged with $1,600 per ton. Finally, transporting a ton of home appliances costs $750, and the ship charges $1,200 per ton transported to the producer. To ensure a quick delivery without any complications in the ocean, the [weight/weight capacity] ratio must be the same for all the storage places. Please do the following (credit is assigned at the end of each bullet): 1. Formulate a mathematical model for this problem utilizing the six-step process discussed in class (40 points). 2. Solve the problem by using Excel ( 20 points)