Do you have an excel example for teh following problem? Organisation F is a not$-$for$-$profit organisation that sources food and capture donations and distributes it to those in needs. Each month it retrieves the food donations from $10$ locations and delivers it to one of the five facilities to be processed before shipping it out to the local communities. Each facility has a limited space to store the food. Due to the differences in equipment and resources, each of these facilities has a slightly different in efficiency in storing and processing the donated food, which results in a small amount of wastage summarised in the table below: Facility $12345$ Capacity $($tonnes$)4\mathrm{.}04\mathrm{.}53\mathrm{.}83\mathrm{.}53\mathrm{.}2$ Efficiency $($per cent$)9592989697$ The cost of retrieving and transporting food primarily depends on the distance between the locations and the facilities. The following table summarises the distances between each location and each facility $($in kilometres$)$: Facility Location $1234514\mathrm{.}92\mathrm{.}07\mathrm{.}010\mathrm{.}613\mathrm{.}323\mathrm{.}43\mathrm{.}011\mathrm{.}913\mathrm{.}012\mathrm{.}632\mathrm{.}04\mathrm{.}15\mathrm{.}313\mathrm{.}412\mathrm{.}343\mathrm{.}75\mathrm{.}16\mathrm{.}411\mathrm{.}712\mathrm{.}752\mathrm{.}14\mathrm{.}43\mathrm{.}011\mathrm{.}312\mathrm{.}666\mathrm{.}07\mathrm{.}09\mathrm{.}311\mathrm{.}08\mathrm{.}776\mathrm{.}98\mathrm{.}914\mathrm{.}28\mathrm{.}98\mathrm{.}287\mathrm{.}78\mathrm{.}67\mathrm{.}410\mathrm{.}97\mathrm{.}094\mathrm{.}45\mathrm{.}99\mathrm{.}410\mathrm{.}710\mathrm{.}3104\mathrm{.}69\mathrm{.}310\mathrm{.}28\mathrm{.}611\mathrm{.}9$ Using historical data, the organisation estimates the volume of the donated food at each location in the coming month shown in the table below: Location $12345678910$ Food Volume $($tonnes$)0\mathrm{.}753\mathrm{.}402\mathrm{.}001\mathrm{.}830\mathrm{.}872\mathrm{.}601\mathrm{.}500\mathrm{.}290\mathrm{.}981\mathrm{.}64$ It will cost approximately $$141$ to transport one tonne of food for one kilometre. The management would like you to design a solution that simultaneously maximises the efficiency in processing the donated food and minimises the transportation cost. They consider maximising the efficiency in processing the donated food to be two times as important as minimising the transportation cost.