Sheet1 |
| Bears |
|
|
|
|
Jar Candles |
|
|
|
|
|
| Makes 4 bears: |
|
|
|
|
Makes (3) 6.5 oz jars |
|
|
|
|
|
| Wax p/lb |
Scent 1.5oz |
Per 4 bears |
Each bear |
|
Wax p/lb |
Scent 1oz |
Dye per block |
Cost per 3 |
Cost Each |
|
| 1.6 |
2.63 |
4.23 |
1.06 |
|
1.79 |
1.75 |
0.92 |
4.46 |
1.49 |
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| Bears Each |
Misc Each |
Times Four |
Each bear |
|
Jars (12) .64 each |
Misc |
Total (12) |
Per 3 Jars |
Cost Each |
|
| 4.99 |
6 |
43.96 |
10.99 |
|
7.68 |
12 |
19.68 |
4.92 |
1.64 |
|
| |
|
|
|
|
|
|
|
|
|
|
| Cost to make 4 Bears: |
|
|
|
|
Cost to make 3 Jar Candles: |
|
|
|
|
|
| 4 Bears/Misc |
Ingredients for 4 Bears |
Cost to make 4 Bears |
|
|
3 Jar/Misc |
Ingredients for 3 Jars |
Cost to make 3 Jars |
|
|
|
| 43.96 |
4.23 |
48.19 |
|
|
4.92 |
4.46 |
9.38 |
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
Cost to make 1 Bear: |
12.05 |
|
|
|
Cost to make 1 Jar: |
3.13 |
|
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
PRICING OPTIONS |
|
|
|
|
PRICING OPTIONS |
|
|
|
| SELL |
COST |
PROFIT |
|
|
SELL |
COST |
PROFIT |
|
|
|
| 15.99 |
12.05 |
3.94 |
|
|
3.99 |
3.13 |
0.86 |
|
|
|
| 16.99 |
12.05 |
4.9425 |
|
|
4.99 |
3.13 |
1.86 |
|
|
|
| 17.99 |
12.05 |
5.94 |
|
|
5.99 |
3.13 |
2.86 |
|
|
|
| 18.99 |
12.05 |
6.94 |
|
|
6.99 |
3.13 |
3.86 |
|
|
|
| 21.99 |
12.05 |
9.94 |
|
|
7.99 |
3.13 |
4.86 |
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
Sheet2 |
| Candy Sets |
|
|
|
|
CUT OUT CANDLES |
AND PILLAR CANDLES |
|
|
|
|
| Yield 16 Glasses |
|
|
|
|
Yield (1) 1lb 2.5inch high candle |
|
|
|
|
|
| 16 Glasses |
Each Glass |
|
|
|
Per lb |
Per oz fragrance |
Dye Block |
Misc |
Cost to make |
|
| 14.84 |
0.93 |
|
|
|
1.79 |
1.75 |
0.92 |
2 |
6.46 |
|
| |
|
|
|
|
|
|
|
|
|
|
| Misc |
Candy per Glass |
Tim/Cany per Glass |
|
|
|
|
|
|
|
|
| 1 |
2 |
3 |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| Cost per Glass: |
3.9275 |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| SELL |
COST |
PROFIT |
|
|
SELL |
COST |
PROFIT |
|
|
|
| 4.99 |
3.9275 |
1.0625 |
|
|
8.99 |
6.46 |
2.53 |
|
|
|
| 5.99 |
3.9275 |
2.0625 |
|
|
9.99 |
6.46 |
3.53 |
|
|
|
| 6.99 |
3.9275 |
3.0625 |
|
|
10.99 |
6.46 |
4.53 |
|
|
|
| 7.99 |
3.9275 |
4.0625 |
|
|
11.99 |
6.46 |
5.53 |
|
|
|
| 8.99 |
3.9275 |
5.0625 |
|
|
12.99 |
6.46 |
6.53 |
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
SELL (3) |
COST (3) |
PROFIT (3) |
|
|
|
| |
|
|
|
|
22.99 |
19.38 |
3.61 |
|
|
|
| |
|
|
|
|
23.99 |
19.38 |
4.61 |
|
|
|
| |
|
|
|
|
24.99 |
19.38 |
5.61 |
|
|
|
| |
|
|
|
|
25.99 |
19.38 |
6.61 |
|
|
|
| |
|
|
|
|
26.99 |
19.38 |
7.61 |
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
Sheet3 |
| PRICING FOR SETS |
|
1ST |
2ND |
3RD |
4TH |
5TH |
6TH |
7TH |
|
|
|
|
| SCENTED |
BEAR |
15.99 |
16.99 |
17.99 |
18.99 |
21.99 |
|
|
|
|
|
|
| +CANDY |
SET |
4.99 |
5.99 |
6.99 |
7.99 |
8.99 |
|
|
|
|
|
|
| + 2 JAR |
CANDLES |
7.99 |
9.99 |
11.99 |
13.99 |
15.99 |
|
|
|
|
|
|
| +2 CUTOUT |
/PILLAR |
17.99 |
19.99 |
21.99 |
23.99 |
25.99 |
|
|
|
|
|
|
| +3 PILLAR |
CANDLES |
22.99 |
23.99 |
24.99 |
25.99 |
26.99 |
|
|
|
|
|
|
| + 1 JAR |
CANDLE |
3.99 |
4.99 |
5.99 |
6.99 |
7.99 |
|
|
|
|
|
|
| +1 CUTOUT |
/PILLAR |
8.99 |
9.99 |
10.99 |
11.99 |
12.99 |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
1ST |
2ND |
3RD |
4TH |
5TH |
TOTAL PRICING |
AVERAGE PRICE |
SALE PRICE |
COST |
PROFIT |
|
| BEAR + CANDY |
|
20.98 |
22.98 |
24.98 |
26.98 |
30.98 |
126.9 |
25.38 |
22.99 |
15.98 |
7.01 |
|
| |
|
1ST |
2ND |
3RD |
4TH |
5TH |
TOTAL PRICING |
AVERAGE PRICE |
SALE PRICE |
COST |
PROFIT |
|
| BEAR + CANDY |
+2 JAR |
28.97 |
32.97 |
36.97 |
40.97 |
46.97 |
186.85 |
37.37 |
35.99 |
22.24 |
13.75 |
|
| |
|
1ST |
2ND |
3RD |
4TH |
5TH |
TOTAL PRICING |
AVERAGE PRICE |
SALE PRICE |
COST |
PROFIT |
|
| BEAR + CANDY |
+2 CUTOUT/ PILLAR |
38.97 |
42.97 |
46.97 |
50.97 |
56.97 |
236.85 |
47.37 |
42.99 |
28.9 |
14.09 |
|
| |
|
1ST |
2ND |
3RD |
4TH |
5TH |
TOTAL PRICING |
AVERAGE PRICE |
SALE PRICE |
COST |
PROFIT |
|
| BEAR +CANDY |
+1 JAR |
24.97 |
27.97 |
30.97 |
33.97 |
38.97 |
156.85 |
31.37 |
27.99 |
19.11 |
8.88 |
|
| |
|
1ST |
2ND |
3RD |
4TH |
5TH |
TOTAL PRICING |
AVERAGE PRICE |
SALE PRICE |
COST |
PROFIT |
|
| BEAR +CANDY |
+1 CUTOUT/ PILLAR |
29.97 |
32.97 |
35.97 |
38.97 |
43.97 |
181.85 |
36.37 |
32.99 |
22.44 |
10.55 |
|
| |
|
1ST |
2ND |
3RD |
4TH |
5TH |
TOTAL PRICING |
AVERAGE PRICE |
SALE PRICE |
COST |
PROFIT |
|
| BEAR+ CANDY |
+3 PILLAR CANDLES |
43.97 |
46.97 |
49.97 |
52.97 |
57.97 |
251.85 |
50.37 |
46.99 |
35.35 |
11.64 |
|
| ************** |
** |
1ST |
2ND |
3RD |
4TH |
5TH |
TOTAL PRICING |
AVERAGE PRICE |
SALE PRICE |
COST |
PROFIT |
|
| BEAR + 1 JAR |
NO CANDY |
19.98 |
21.98 |
23.98 |
25.98 |
29.98 |
121.9 |
24.38 |
19.99 |
15.18 |
4.81 |
|
| *************** |
** |
1ST |
2ND |
3RD |
4TH |
5TH |
TOTAL PRICING |
AVERAGE PRICE |
SALE PRICE |
COST |
PROFIT |
|
| BEAR + 2JARS |
NO CANDY |
23.98 |
26.98 |
27.98 |
32.98 |
37.98 |
149.9 |
29.98 |
23.99 |
18.31 |
5.68 |
|
| ************** |
** |
1ST |
2ND |
3RD |
4TH |
5TH |
TOTAL PRICING |
AVERAGE PRICE |
SALE PRICE |
COST |
PROFIT |
|
| BEAR +1 CUTOUT |
/PILLAR NO CANDY |
24.98 |
26.98 |
28.98 |
30.98 |
34.98 |
146.9 |
29.38 |
24.99 |
18.51 |
6.48 |
|
| *************** |
** |
1ST |
2ND |
3RD |
4TH |
5TH |
TOTAL PRICING |
AVERAGE PRICE |
SALE PRICE |
COST |
PROFIT |
|
| BEAR +2 CUTOUT |
/PILLAR NO CANDY |
33.98 |
36.98 |
39.98 |
42.98 |
47.98 |
201.9 |
40.38 |
33.98 |
24.97 |
9.01 |
|
| *************** |
** |
1ST |
2ND |
3RD |
4TH |
5TH |
TOTAL PRICING |
AVERAGE PRICE |
SALE PRICE |
COST |
PROFIT |
|
| BEAR +3CUTOUT |
/PILLAR NO CANDY |
38.98 |
40.98 |
42.98 |
44.98 |
48.98 |
216.9 |
43.38 |
38.99 |
31.43 |
7.56 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|