ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
IngredientStorePrice of PackageVolume/Weight of PackageVolume/Weight of Ingredient Used% of Package UsedCost Per Ingredient UsedCake Totals
2
(One Whole Package)(One Whole Package — Try to use same units as E)(Try to use same units as D. For help, *see link to conversion chart in column J.)(**See important notes in column J.)DO NOT EDIT OR DELETE ANY CELLS IN THIS COLUMN! (***See notes/troubleshooting in column J for more info.)If at any time the functions or formats stop working, or if you accidentally delete a function, please refer to the functions/equations/formats page of the document in the tabs (underlined in yellow) near the bottom of the page.
3
White Box Cake MixGiant Eagle$1.291 box 6 box 0.00%$0.00Total Cost of Ingredients — Do NOT edit/delete J4 (the cell below)
4
King Arthur AP FlourCostco$5.9912 lb (192 oz)6 cups (25.5 oz)0.00%$0.00$68.70
5
White SugarCostco$4.9910 lb (160 oz)6 cups (42 oz)0.00%$0.00
6
Sour CreamCostco$3.993 lb3 lb100.00%$3.99Total Cost of Work Time:
7
Vegetable OilGiant Eagle$1.9916 oz (32 tbsp)12 tbsp37.00%$0.74Multiply your desired hourly rate by the number of hours you'll bake/decorate and enter it below (in cell J8). If you charge $20/hour and work time is 3 hours, type "60" in J8.
8
Pastuerized Egg WhitesGiant Eagle$2.9916 oz 32 oz200.00%$5.98$60.00
9
Vanilla Bean PasteLocal Store$23.504 oz1 oz25.00%$5.88
10
Pure Vanilla ExtractCostco$15.9916 oz4 oz25.00%$4.00Additional Charges:
11
ButterCostco$8.498 cups (4 packs of 4 sticks)8 cups100.00%$8.49If you wish to charge any additional costs to the client, type the amount in below (in cell J12). For example: delivery, cake stand rental, overhead for equipment etc. If no extra charge, type "0".
12
10x SugarCostco$4.297 lb8 lb114.00%$4.89$5.00
13
Heavy Whipping CreamGiant Eagle$7.991 QT (4 cups)1.4 cups35.00%$2.80
14
Satin Ice FondantLocal Store$3.99-5 packages500.00%$19.95Total Cake Cost — Do NOT edit/delete J15 (the cell below)
15
Cupcake LinersGiant Eagle$2.99100150150.00%$4.49$133.70
16
Cake Board & BoxLocal Store $5.00--100.00%$5.00
17
Whole Milk (Gallon)Walmart$4.211 gallon (128 oz)1 cup (8 oz)6.25%$0.26* Volume/Ounce/Gram Weight Chart:
18
Light Brown SugarWalmart$2.832 lb (4.5 cups)2 cups44%$1.25https://www.kingarthurbaking.com/learn/ingredient-weight-chart
19
Example$1.00100.00%$1.00
20
$0.00** How To Calculate/Estimate % of Package Used & NOTES:
21
$0.00You can estimate large amounts. For example:
22
$0.00•All of 1 package is 100% •2 packages is 200%
23
$0.00•Half of a package is 50%. •Quarter of a package is 25%
24
$0.00If you want to calculate precise percentages, divide the volume/weight used (E) by the volume/weight of the full package (D). HOWEVER:
25
$0.00Units MUST be the same to divide. (Ounces divided by ounces, cups by cups, etc.. NOT cups divided by ounces...) For example:
26
$0.00•6 boxes used divided by 1 box full package equals 6, which is 600%.
27
$0.00•6 cups of flour is approx 25.5 oz according to above chart. 25.5 oz divided by full package of flour (mine was 192 oz) is .13 which is 13%.
28
$0.00Remember, to convert an integer or decimal to percent, move the "point" to the right by two spaces. For example, .25 (one-quarter) becomes 25% and 1.5 (one and a half) is 150%.
29
$0.00If the "%" symbol doesn't automatically populate in column F, click on the cell in question and then click the % button in the menu (to the right of the font.) THE % SYMBOL IS NECESSARY TO ACCURATELY CALCULATE FINAL COST.
30
$0.00
31
$0.00*** Troubleshooting Cost Calculation in Column G
32
$0.00•DO NOT edit or delete any cells in column G, otherwise you risk deleting the function.
33
$0.00•To adjust the figure in column G, adjust the figures in columns C, and/or F.
34
$0.00•To remove a figure from column G, delete the percentage from F, or change F to 0.
35
$0.00•If the cost does not automatically calculate in column G, double check that the function is showing in the function (fx) bar above the cells by clicking on the cell in question. If the fx bar is blank after clicking on the cell, type in the following function (what is in between the quotation marks) without any spaces: " =C#*F# " (replace the "#" symbol with the number of the row in which you're calculating cost.) Essentially, you tell excel to multiply (*) a cell from C with a cell from F. If the figure in C19 is $1, and it's multiplied by F19 (100%), the result is $1.
36
$0.00
37
$0.00If at any time the functions or formats stop working, or if you accidentally delete a function,
38
$0.00please refer to the functions/equations/formats page of the document in the tabs, below.
39
$0.00
40
$0.00Contact lexis@lexisrose.com with any questions about use of the Cake Cost Calculator.
41
$0.00For personal use only—not to be reproduced, altered, or edited for selling purposes.
42
$0.00Lexisrose.com is not responsible for any miscalculations or mistakes resulting allegedly from use of this template. This is provided as a helpful ESTIMATION resource only, and should always be reviewed for any user or technical errors.
43
$0.00
44
$0.00https://lexisrose.com/home-bakers-guide-pricing-cakes-free-calculator/
45
$0.00
46
$0.00
47
$0.00
48
$0.00
49
$0.00
50
$0.00
51
$0.00
52
$0.00
53
$0.00
54
$0.00
55
$0.00
56
$0.00
57
$0.00
58
$0.00
59
$0.00
60
$0.00
61
$0.00
62
$0.00
63
$0.00
64
$0.00
65
$0.00
66
$0.00
67
$0.00
68
$0.00
69
$0.00
70
$0.00
71
$0.00
72
$0.00
73
$0.00
74
$0.00
75
$0.00
76
$0.00
77
$0.00
78
$0.00
79
$0.00
80
$0.00
81
$0.00
82
$0.00
83
$0.00
84
$0.00
85
$0.00
86
$0.00
87
$0.00
88
$0.00
89
$0.00
90
$0.00
91
$0.00
92
$0.00
93
$0.00
94
$0.00
95
$0.00
96
$0.00
97
$0.00
98
$0.00
99
$0.00
100
$0.00