Overhead.xlsx

2019 Variable Cost

Month Type Description (ingredient only) Amount
1 Ingredient Flour 3186.38
1 Ingredient Yeast 1365.59
1 Ingredient Flavoring 4551.97
1 Packaging 1508.97
1 Catering 1123.5
2 Ingredient Flour 2893.17
2 Ingredient Yeast 1239.93
2 Ingredient Flavoring 4133.1
2 Packaging 1496.54
2 Catering 1239
3 Ingredient Flour 4260.72
3 Ingredient Yeast 1826.02
3 Ingredient Flavoring 6086.75
3 Packaging 1747.14
3 Catering 3258.5
4 Ingredient Flour 5295.53
4 Ingredient Yeast 2269.51
4 Ingredient Flavoring 7565.05
4 Packaging 2311.87
4 Catering 2709
5 Ingredient Flour 4532.76
5 Ingredient Yeast 1942.61
5 Ingredient Flavoring 6475.37
5 Packaging 2035.48
5 Catering 1624
6 Ingredient Flour 5300.31
6 Ingredient Yeast 2271.56
6 Ingredient Flavoring 7571.87
6 Packaging 2339.22
6 Catering 3416
7 Ingredient Flour 4012.94
7 Ingredient Yeast 1719.83
7 Ingredient Flavoring 5732.77
7 Packaging 1890.33
7 Catering 2103.5
8 Ingredient Flour 4026.22
8 Ingredient Yeast 1725.52
8 Ingredient Flavoring 5751.74
8 Packaging 1687
8 Catering 1960
9 Ingredient Flour 5076.29
9 Ingredient Yeast 2175.55
9 Ingredient Flavoring 7251.84
9 Packaging 2582.8
9 Catering 2940
10 Ingredient Flour 3637.47
10 Ingredient Yeast 1558.92
10 Ingredient Flavoring 5196.39
10 Packaging 1622.9
10 Catering 1571.5
11 Ingredient Flour 4351.31
11 Ingredient Yeast 1864.85
11 Ingredient Flavoring 6216.16
11 Packaging 1785.27
11 Catering 2618
12 Ingredient Flour 5767.34
12 Ingredient Yeast 2471.72
12 Ingredient Flavoring 8239.06
12 Packaging 2425.78
12 Catering 3286.5

2020 Variable Cost

Month Type Description (ingredient only) Amount
1 Ingredient Flour 3997.987
1 Ingredient Yeast 1713.423
1 Ingredient Flavoring 5711.41
1 Packaging 1846.48
1 Catering 2233
2 Ingredient Flour 3179.4105
2 Ingredient Yeast 1362.6045
2 Ingredient Flavoring 4542.015
2 Packaging 1341.21
2 Catering 2460.5
3 Ingredient Flour 5649.749
3 Ingredient Yeast 2421.321
3 Ingredient Flavoring 8071.07
3 Packaging 2651.08
3 Catering 2999.5

Fixed Cost

Type Amount
Labor 4913.33
Rent 4020
Shipping 1500