An appliance store owns two warehouses and has three major regional stores. Supply, demand, and transportation costs

Question:

An appliance store owns two warehouses and has three major regional stores. Supply, demand, and transportation costs for refrigerators are provided in the following table:
Warehouse
Store A B C Supply
1 6 8 5 80
2 12 3 7 40
Demand 20 50 50
a. Set up the transportation tableau.
b. Find an optimal solution using Excel.