Formulate problem then solve please using excel solver

Keynote File Edit Insert Slide Format Arrange View Play Share Window Help 6) 37% O Mon 9:53 PM Q CamScanner 11).mp4 Screen Shot 2021-10...6.56 AM 100% + Transportation Problem T Chart Text Shape v 24 View Zoom Add Slide Play Keynote Live Table Media Comment Collaborate Format Animate Document Slide Layout Screen Shot 2021-10...6.26 PM 18 Blank Change Master 19 Transportation Problem: Example #1 Acme Block Company has orders for 80 tons of concrete blocks at three suburban locations as follows: Northwood -- 25 tons, Westwood -- 45 tons, Eastwood -- 10 tons. Acme has two plants, each of which can produce 50 tons per week. Delivery cost per ton from each plant to each suburban location is shown in the table. Screen Shot 2021-10...6.29 AM Appearance Title Body Slide Number 20 Background Screen Shot 2021-10....29 AM 1 21 Edit Master Slide Northwood 24 30 Westwood 30 Plant 1 Plant 2 Eastwood 40 42 22 40 23 How should end of week shipments be made to fill the above orders? BUS 190 - Xu (Cissy) Yang Slide19 24 43,095 22 A CC