I will provide excel in the attachment and I did post the question on the attachment… you have to change the excel as per the question..
img_5780.jpg
img_5781.jpg
copy_of_aci_2_1_janeese_crystals.xlsx
Unformatted Attachment Preview
Janeese Crystals
Profit Anaylsis
Crystal
Profit
Cost
Necklace
Earring
Ring
Proft
$241,14
Items SoldTotal Revenue Total Profit
$95,85
%
10.448
$3.520.871,52
$2.519.430,720
28,44%
255,48
245,96
61,4
53,68
10.346
11.760
3.278.440,48
3.523.766,40
$2.643.196,080
$2.892.489,600
19,38%
17,92%
Candlestick Holder
97,53
Lamp
184,25
100,65
93,18
10.256
14.348
2.032.534,08
3.980.565,64
$1.000.267,680
$2.643.619,000
50,79%
33,59%
Vase
243,61
15,32
13.905
3.600.421,65
$3.387.397,050
5,92%
Frame
227,95
57,72
12.554
3.586.301,18
$2.861.684,300
20,21%
Ormament
182,36
68,34
14.248
3.571.973,60
$2.598.265,280
27,26%
Knicknacks
Totals
137,93
59,68
13.779 $2.722.868,19
###### ###########
$1.900.537,470
$7.370.855,56
30,20%
Lowest
98
15
10.256
$2.032.534,08
$1.000.267,68
5,92%
Highest
Average
255
202
101
64
14.348
12.650
$3.980.565,64
$3.313.082,53
$3.387.397,05
$2.490.932,06
50,79%
25,97%
…
Purchase answer to see full
attachment