Oranges are grown, picked, and then stored in warehouses in Koforidua, Cape Coast, and Sunyani. These warehouses supply oranges to markets in Accra, Kumasi, Tamale, and Takoradi. The table below shows the shipping costs per truckload $($in thousands of Ghana Cedis$)$ of oranges from a warehouse to a demand centre. The maximum available supply is $200$ truckloads for each of the three warehouses, whereas the demand is $170,150,80,$ and $130$ truckloads for Accra, Kumasi, Tamale, and Takoradi respectively. Because of an agreement between distributors, shipments are prohibited from Sunyani to Takoradi.

Shipping cost per truckload $($in Ghc$1000)$

To

From

Accra

Kumasi

Tamale

Takoradi

Koforidua

$9$

$14$

$12$

$17$

Cape Coast

$11$

$10$

$6$

$10$

Sunyani

$12$

$8$

$15$

$7$

Formulate the above problem with a linear programming model and solve using Excel Solver to answer the following questions.

$1.$ The total cost of transportation after obtaining the optimal solution is Ghc Blank $1.$ Fill in the blank, read surrounding text.

$.$

$2.$ The truckloads of oranges to be transported from Koforidua to Accra is Blank $2.$ Fill in the blank, read surrounding text.

$.$

$3.$ The truckloads of oranges to be transported from Cape Coast to Accra is Blank $3.$ Fill in the blank, read surrounding text.

$.$

$4.$ The cost of transporting a truckload of oranges from Koforidua to Takoradi should be reduced from Ghc$17$ to Ghc Blank $4.$ Fill in the blank, read surrounding text.

in order to transport oranges from Koforidua to Takoradi.

$5.$ The cost of transporting a truckload of oranges from Sunyani to Accra should be reduced from Ghc$12$ to Ghc Blank $5.$ Fill in the blank, read surrounding text.

in order to transport oranges from Sunyani to Accra.

$6.$ If supply from the warehouse at Cape Coast were to increases by $8$ more truckloads, the total transportation cost will decrease by Ghc Blank $6.$ Fill in the blank, read surrounding text.

$.$

$7.$ Let $1,2,$ and $3$ represent the warehouses in Koforidua, Cape Coast, and Sunyani respectively. The warehouses with surplus oranges left are Blank $7.$ Fill in the blank, read surrounding text.

and Blank $8.$ Fill in the blank, read surrounding text.

$,$ with a surplus of Blank $9.$ Fill in the blank, read surrounding text.

and Blank $10.$ Fill in the blank, read surrounding text.

truckloads respectively.

$8.$ Let $1,2,3,$ and $4$ represent Accra, Kumasi, Tamale, and Takoradi respectively. Suppose demand at Accra were to increase by additional $100$ oranges, whereas everything else remain the same. Resolve the problem again and answer the following questions.

$9.$ The total cost of transportation after obtaining the optimal solution based on question $8$ is Ghc Blank $11.$ Fill in the blank, read surrounding text.

$.$

$10.$ The demand centres with some unfulfilled demand are Blank $12.$ Fill in the blank, read surrounding text.

and Blank $13.$ Fill in the blank, read surrounding text.

$,$ with an unfulfilled number of truckloads of oranges of Blank $14.$ Fill in the blank, read surrounding text.

and