Spreadsheet Basics Course

	B	C	D	E	F	G	H	I
1
2	2011 Sales
3
4
5	Customer ID	Month	Product ID	Units	Revenue per Unit	Total Revenue	Cost per Unit	Total Cost

6	A38	Jan, 2011	Z12	19	$32.10
7	A38	Jan, 2011	X09	21	$36.64
8	B28	Feb, 2011	X09	19	$36.64
9	D32	Feb, 2011	Z12	21	$32.10
10	F32	Feb, 2011	Z12	21	$32.10
11	D32	Mar, 2011	Y18	23	$33.25
12	D32	Apr, 2011	Y18	18	$33.25
13	A38	May, 2011	Y18	21	$33.25
14	A38	May, 2011	X09	15	$36.64
15	C29	Jun, 2011	X09	26	$36.64
16	D32	Jun, 2011	X09	25	$36.64
17	F32	Jul, 2011	X09	19	$36.64
18	A38	Aug, 2011	X09	19	$36.64
19	D32	Aug, 2011	Y18	16	$33.25
20	C29	Aug, 2011	Y18	17	$33.25
21	F32	Sep, 2011	Z12	19	$32.10
22	D32	Sep, 2011	X09	21	$36.64
23	F32	Sep, 2011	Y18	22	$33.25
24	B28	Sep, 2011	X09	16	$36.64
25	A38	Oct, 2011	X09	22	$36.64
26	F32	Oct, 2011	X09	16	$36.64
27	F32	Oct, 2011	Z12	16	$32.10
28	D32	Oct, 2011	X09	19	$36.64
29	E44	Nov, 2011	X09	25	$36.64
30	A38	Nov, 2011	X09	24	$36.64
31	D32	Nov, 2011	X09	19	$36.64
32	A38	Dec, 2011	X09	22	$36.64
33
34					Total:
35					Profit:
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