Calculating how much a business owes it's suppliers using spreadhseets.xlsx

	C	D	E	F	G
1
2	Prices
3	Suppliers	Pencil	Eraser	Sharpener
4	Supplier 1	$ 0.32	$ 1.57	$ 0.11
5	Supplier 2	$ 0.35	$ 1.54	$ 0.10
6	Supplier 3	$ 0.25	$ 1.54	$ 0.21
7	Supplier 4	$ 0.29	$ 1.24	$ 0.10
8	Supplier 5	$ 0.35	$ 1.30	$ 0.18
9	Supplier 6	$ 0.27	$ 1.42	$ 0.15
10
11	Quantity
12	Suppliers	Pencil	Eraser	Sharpener
13	Supplier 1	364	391	220
14	Supplier 2	387	245	314
15	Supplier 3	290	211	200
16	Supplier 4	340	265	330
17	Supplier 5	261	345	246
18	Supplier 6	365	232	390
19
20	Cost
21	Suppliers	Pencil	Eraser	Sharpener	Total
22	Supplier 1	$ 116.48	$ 613.87	$ 24.20	$ 754.55
23	Supplier 2	$ 135.45	$ 377.30	$ 31.40	$ 544.15
24	Supplier 3	$ 72.50	$ 324.94	$ 42.00	$ 439.44
25	Supplier 4	$ 98.60	$ 328.60	$ 33.00	$ 460.20
26	Supplier 5	$ 91.35	$ 448.50	$ 44.28	$ 584.13
27	Supplier 6	$ 98.55	$ 329.44	$ 58.50	$ 486.49
28	Total	$ 612.93	$ 2,422.65	$ 233.38	$ 3,268.96
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100