Data for an unbalanced transportation problem have been given. Balance the problem. Find an initial solution using North West Corner Rule (NWCR), the optimal solution, and the optimal solution if Georgia cannot ship to Arkansas. Place your responses in the spaces provided. All terms have their usual meaning.

solve through excel

N10 fx D E M N O Problem 3. Bob Tracker is in the frozen fruits selling busienss, He runs refrigerated trucks that take supplies from Florida, Georgia, and Alabama and delivers them to Virginia, Tennessee, and Arkansas. The unit shipment costs for various trips and the supply and demand amounts (thousands of units) are as follows: 5 B 9 10 $95 11 12 13 Note: The problem is not balanced. Balance it first! Virginia Tennessee Arkansas SUPPLY Florida $70 $90 50 Georgia $55 $75 $65 40 Alabama $60 $85 $80 60 DEMAND 30 45 60 15 What is the North-West Corner Rule solution cost (in thousands)? (Rounded whole number) ** What is the optimal transportation cost (in thousands)? (Rounded whole number) 21 If the Georgia-Arkansas shipments are forbidden, what is the optimal cost (in thousands)? (Rounded whole number) 16 22 23