ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Points
Percent Contribution to Vendor Excel Project
2
21
Merge and center Cells G2 & G3 ; H2 & H3
3
22
Create borders around cells in columns G & H
4
23
Input formula in C205 to calculate total sales
5
24
Input formula in D4 to calculate percent contribution to total; utilize an absolute sign ($) in your formula to keep C205 constant
6
25
Format cell D4 to be a percent and 2 places to the right of the decimal
7
6
Auto-fill this formula down to the rest of the rows (stores)
8
27
Input a formula in E4 to calculate the dollar amount of inventory at this store utilizing a total inventory for the vendor found in cell E205 ($1,859,415). Utilize an absolute sign for cell E205.
9
8
Auto-fill this formula down to the rest of the rows (stores)
10
29
Input formulas to calculate "Should have inventory" utilize absolute sign in formula as appropriate
11
210
Input formula for over/under
12
11
Auto-fill the these two formulas to remaining rows
13
212
Format dollars of analysis to be whole # 's and currency (no decimals)
14
213
Data Sort based upon over/under inventory
15
314
Highlight top 6 stores in need of more inventory in green (highlight all of the info in the row)
16
315
Highlight bottom 6 stores that are over in inventory In yellow (highlight all of the info in the row)
17
216
Hide (do not delete) rows of remaining stores in-between top and bottom stores
18
217
Save completed file as yourlastname_yourfirstname_ PercentContributionByStore and upload to Canvas
19
30
20
21
Reminders:
22
Project must be completed in Excel (not Google Sheets, not Numbers) and must be saved and submitted as an Excel file (not as a link to a drive or file share)
23
Students must do their own work. Any file sharing of this assignment is academic misconduct.
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