handcruser

	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	sku	Description	Vendor Cost	Standard Cost	Catalog	20% Discount		GMP	Comp Price	Savings	Individual Item GMP Floor	Desired Average GMP	Line Item Count	Total Adjustment	Diff	Diff%	% Adjustment	New GMP	New Price	New Savings
2	111-1111	Product a	$99.00	$100.98	$156.75	$125.40		19.5%	$135.14	$9.74	21.0%	25.0%	24	14.2%	0.0%	0.0%	0.0%	19.5%	$125.40	$9.74
3	111-1111	Product a	$20.00	$30.46	$49.75	$39.80		23.5%	$40.79	$0.99					0.0%	0.0%	0.0%	23.5%	$39.80	$0.99
4	111-1111	Product a	$26.88	$30.91	$47.75	$38.20		19.1%	$40.96	$2.76					0.0%	0.0%	0.0%	19.1%	$38.20	$2.76
5	111-1111	Product a	$268.05	$273.41	$415.75	$342.85	CPM	20.3%	$348.49	$5.64					0.0%	0.0%	0.0%	20.3%	$342.85	$5.64
6	111-1111	Product a	$36.02	$36.74	$56.75	$45.40		19.1%	$46.32	$0.92					0.0%	0.0%	0.0%	19.1%	$45.40	$0.92
7	111-1111	Product a	$24.54	$25.03	$39.95	$31.96		21.7%	$32.72	$0.76					0.0%	0.0%	0.0%	21.7%	$31.96	$0.76
8	111-1111	Product a	$11.05	$11.27	$41.95	$17.95	CPM	37.2%	$29.40	$11.45					12.2%	12.4%	1.8%	35.5%	$17.46	$11.94
9	111-1111	Product a	$16.31	$17.65	$33.45	$25.95	CPM	32.0%	$31.27	$5.32					7.0%	7.1%	1.0%	31.0%	$25.57	$5.70
10	111-1111	Product a	$4.09	$4.48	$10.95	$8.45	CPM	47.0%	$8.92	$0.47					22.0%	22.2%	3.2%	43.8%	$7.98	$0.94
11	111-1111	Product a	$10.25	$17.88	$46.95	$21.95	Best	18.5%	$17.84	-$4.11					0.0%	0.0%	0.0%	18.5%	$21.95	-$4.11
12	111-1111	Product a	$1.55	$1.93	$11.95	$6.95	CPM	72.2%	$9.17	$2.22					47.2%	47.8%	6.8%	65.5%	$5.59	$3.58
13	111-1111	Product a	$14.17	$15.78	$29.25	$23.40		32.6%	$28.04	$4.64					7.6%	7.7%	1.1%	31.5%	$23.03	$5.01
14	111-1111	Product a	$17.40	$17.75	$29.95	$23.96		25.9%	$26.77	$2.81					0.9%	0.9%	0.1%	25.8%	$23.92	$2.85
15	111-1111	Product a	$88.00	$89.76	$132.95	$105.75	CPM	15.1%	$106.18	$0.43					0.0%	0.0%	0.0%	15.1%	$105.75	$0.43
16	111-1111	Product a	$104.20	$106.28	$157.25	$124.75	CPM	14.8%	$125.73	$0.98					0.0%	0.0%	0.0%	14.8%	$124.75	$0.98
17	111-1111	Product a	$104.20	$106.28	$157.25	$124.75	CPM	14.8%	$125.73	$0.98					0.0%	0.0%	0.0%	14.8%	$124.75	$0.98
18	111-1111	Product a	$18.07	$21.93	$47.75	$28.95	Best	24.2%	$25.07	-$3.88					0.0%	0.0%	0.0%	24.2%	$28.95	-$3.88
19	111-1111	Product a	$25.50	$28.49	$80.75	$38.05	CPM	25.1%	$38.24	$0.19					0.1%	0.1%	0.0%	25.1%	$38.04	$0.20
20	111-1111	Product a	$29.94	$30.54	$48.95	$39.16		22.0%	$42.42	$3.26					0.0%	0.0%	0.0%	22.0%	$39.16	$3.26
21	111-1111	Product a	$49.50	$50.49	$77.45	$61.96		18.5%	$69.95	$7.99					0.0%	0.0%	0.0%	18.5%	$61.96	$7.99
22	111-1111	Product a	$94.69	$99.42	$149.95	$119.96		17.1%	$125.37	$5.41					0.0%	0.0%	0.0%	17.1%	$119.96	$5.41
23	111-1111	Product a	$11.30	$12.20	$19.95	$15.96		23.6%	$16.99	$1.03					0.0%	0.0%	0.0%	23.6%	$15.96	$1.03
24	111-1111	Product a	$11.30	$12.20	$19.95	$15.96		23.6%	$16.99	$1.03					0.0%	0.0%	0.0%	23.6%	$15.96	$1.03
25	111-1111	Product a	$14.50	$15.66	$26.75	$21.40		26.8%	$22.77	$1.37					1.8%	1.8%	0.3%	26.6%	$21.32	$1.45
26						$1,448.87		25.6%	$1,511.27	$62.40								25.0%	$1,445.67	$65.60
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