Copy of Formula Spreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Name of PieceCost AU/PT/PDMark up on AU/PT/PDCost of AGMark Up on AGCost of Gem 1Mark Up on Gem 1Cost of Gem 2Mark Up on Gem 2Materials totalLabor HourlyLabor in DecimalLabor totalProfitOverheadWholesaleRetail x2 mark upRetail x2.25 mark upRetail x2.5 mark upRetail x2.75 mark upRetail x3 mark up
2
Two Tone wedding band: 3 stone$16.731.5$8.442.0$99.002.0$25.002.0$289.97$60.002.5$150.00$8.80$44.00$493$986$1,109$1,232$1,355$1,478
3
Balancing Balls - Sapphire 18ky$52.001.52.0$43.002.02.0$164.00$60.001.0$60.00$4.48$22.40$251$502$564$627$690$753
4
Arches Dangles - green sapphire brio
$50.001.52.0$16.002.02.0$107.00$60.001.0$60.00$3.34$16.70$187$374$421$468$514$561
5
Leaf Green Diamond ER$35.001.5$6.002.0$70.002.02.0$204.50$60.002.5$150.00$7.09$35.45$397$794$893$993$1,092$1,191
6
Sculputral Solitaire - sapphire1.5$12.002.0$600.001.32.0$804.00$60.003.0$180.00$19.68$98.40$1,102$2,204$2,480$2,755$3,031$3,306
7
Oval Leaves Ring$325.001.52.0$110.002.0$65.001.5$805.00$60.004.0$240.00$20.90$104.50$1,170$2,341$2,633$2,926$3,219$3,511
8
Stingray Oval Ring1.5$19.002.0$364.002.02.0$766.00$60.004.0$240.00$20.12$100.60$1,127$2,253$2,535$2,817$3,098$3,380
9
Hammered Solitaire - diamond$135.001.52.0$400.001.32.0$722.50$60.002.5$150.00$17.45$87.25$977$1,954$2,199$2,443$2,687$2,932
10
Wave RC Diamond Ring$62.001.5$12.002.0$325.001.52.0$604.50$60.002.3$138.00$14.85$74.25$832$1,663$1,871$2,079$2,287$2,495
11
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
12
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
13
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
14
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
15
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
16
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
17
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
18
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
19
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
20
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
21
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
22
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
23
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
24
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
25
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
26
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
27
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
28
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
29
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
30
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
31
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
32
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
33
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
34
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
35
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
36
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
37
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
38
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
39
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
40
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
41
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
42
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
43
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
44
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
45
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
46
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
47
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
48
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
49
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
50
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
51
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
52
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
53
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
54
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
55
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
56
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
57
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
58
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
59
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
60
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
61
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
62
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
63
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
64
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
65
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
66
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
67
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
68
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
69
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
70
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
71
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
72
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
73
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
74
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
75
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
76
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
77
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
78
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
79
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
80
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
81
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
82
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
83
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
84
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
85
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
86
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
87
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
88
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
89
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
90
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
91
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
92
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
93
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
94
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
95
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
96
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
97
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
98
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
99
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
100
1.52.02.02.0$0.00$60.00$0.00$0.00$0.00$0$0$0$0$0$0
Loading...