ASSIGNMEMT 9 Pabodya.xlsx

	A	B	C	D	E	F	G	H	I	J
1	A (Item)	B (Description)	C (Original Price)	D (25% Discount)	E (Our Cost)	F (50% Markup)	G (Customer Cost)	H (Customer Cost w/ Tax)	I (Amount Sold)	J (Profit)
2	Item 1	Hair Clip	13.5	3.375	10.125	5.0625	15.1875	16.09875	10	50.625
3	Item 2	Hair Band	8	2	6	3	9	9.54	15	45
4	Item 3	Hair Brush	22	5.5	16.5	8.25	24.75	26.235	5	41.25
5	Item 4	Hair Spray	15	3.75	11.25	5.625	16.875	17.8875	20	112.5
6	Item 5	Hair Gel	10	2.5	7.5	3.75	11.25	11.925	12	45
7	Item 6	Hair Dye	18	4.5	13.5	6.75	20.25	21.465	8	54
8	Item 7	Hair Pins	5	1.25	3.75	1.875	5.625	5.9625	30	56.25
9	Item 8	Hair Ties	7.5	1.875	5.625	2.8125	8.4375	8.94375	25	70.3125
10	Item 9	Hair Comb	11	2.75	8.25	4.125	12.375	13.1175	18	74.25
11	Item 10	Hair Serum	25	6.25	18.75	9.375	28.125	29.8125	3	28.125
12	Item 11	Hair Wax	14	3.5	10.5	5.25	15.75	16.695	14	73.5
13	Item 12	Hair Mask	20	5	15	7.5	22.5	23.85	6	45
14	Item 13	Hair Oil	9	2.25	6.75	3.375	10.125	10.7325	22	74.25
15	Item 14	Hair Mousse	12.5	3.125	9.375	4.6875	14.0625	14.90625	16	75
16	Item 15	Hair Powder	6	1.5	4.5	2.25	6.75	7.155	28	63
17	Item 16	Hair Spray (Travel)	8.5	2.125	6.375	3.1875	9.5625	10.13625	21	66.9375
18	Item 17	Hair Gel (Travel)	5.5	1.375	4.125	2.0625	6.1875	6.55875	26	53.625
19	Item 18	Hair Perfume	16	4	12	6	18	19.08	9	54
20	Item 19	Hair Extensions	30	7.5	22.5	11.25	33.75	35.775	2	22.5
21	Item 20	Hair Detangler	13	3.25	9.75	4.875	14.625	15.4925	11	53.625
22	Totals
23
24
25
26
27
28
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