Transportation Problems

A total of 5481 boxes of face masks are in stock across 9 branches of a medical product are supplying company, A, B, C, D, E, F, G, H, J, with the number of boxes in stock as shown in Table 4.

Table 4

Branches	A	B	C	D	E	F	G	H	I
Number of boxes in stock	234	543	754	877	456	236	876	563	942

In combating the spread of COVID-19, 9 Grocery stores, R, S, T, U, V, W, X, Y, Z, ordered in boxes of face masks from that 9 branches. The number of boxes ordered are as shown in Table 5.

Table 5

Grocery stores	R	S	T	U	V	W	X	Y	Z
Number of boxes ordered	500	600	300	700	590	800	300	200	400

The delivery expenses (in $) for each one box of face masks from a branch to a grocery stores are as shown in table 6.

Table 6

	R	S	T	U	V	W	X	Y	Z
A	0.14	0.2	0.32	0.32	0.54	0.44	0.55	0.340	0.65
B	0.35	0.32	0.21	0.19	0.51	0.33	0.32	0.45	0.54
C	0.16	0.14	0.11	0.16	0.48	0.21	0.22	0.54	0.2
D	0.23	0.18	0.22	0.14	0.43	0.34	0.16	0.56	0.1
E	0.45	0.23	0.33	0.16	0.19	0.4	0.11	0.65	0.4
F	0.67	0.76	0.4	0.3	0.21	0.32	0.34	0.32	0.55
G	0.56	0.87	0.67	0.22	0.11	0.19	0.5	0.1	0.56
H	0.76	0.65	0.7	0.6	0.17	0.14	0.3	0.06	0.43
I	0.77	0.88	0.99	0.65	0.23	0.17	0.21	0.08	0.32

By using [Solver], determine the ways of delivering all the face masks ordered from the 9 branches to the 9 grocery stores, where the total expenses on delivery is minimized. Attach one(1) screenshot from Microsoft Excel/LibreOffice Calc alongside with your answers.