UC calculations, January 2017
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
Weightkg0.7780.6380.6980.7640.5780.5560.7080.794UC pizzas22.36%
2
Price$$16.00$13.00$16.00$15.00$11.00$15.00$15.00$15.00
3
Cost$$3.74$3.08$3.85$3.87$2.18$2.73$3.09$3.49
4
%23.38%23.69%24.06%25.82%19.85%18.21%20.60%23.27%
5
Margin$$12.26$9.92$12.15$11.13$8.82$12.27$11.91$11.51
6
Ingredients06.01.16SupremePepperoniThe MeatsChickenClubMargheritaChicken BBQHawaiianVeggieSalesUC realLCFixed (rent, insurance, bills) *higher volume would result in more breaksEBITDAAv pizza price # of pizzasGrowth
8
Pepperonikg$12.900.040$0.520.080$1.030.040$0.520.000$0.000.000$0.000.000$0.000.000$0.000.000$0.00$30,000.0026%$10,800.00$6,000.00$5,400.00$14.502,068.00
9
Italian Sausageskg$14.150.040$0.570.000$0.000.040$0.570.000$0.000.000$0.000.000$0.000.000$0.000.000$0.00$30,000.0040%$10,800.00$6,000.00$1,200.00$8.903,370.0063.00%
10
Hamkg$12.970.000$0.000.000$0.000.040$0.520.000$0.000.000$0.000.000$0.000.040$0.520.000$0.00$36,000.0040%25.00%$7,000.00$5,600.00$8.904,044.9495,6%
11
Baconkg$10.030.020$0.200.000$0.000.020$0.200.020$0.200.000$0.000.020$0.200.000$0.000.000$0.00$50,000.0040%25.00%$7,000.00$10,500.00$8.905,618.00172.00%187 pizzas a day
12
Grilled Chickenkg$10.720.000$0.000.000$0.000.000$0.000.050$0.540.000$0.000.050$0.540.000$0.000.000$0.00Looks similar to Domino's numbers if marketing and royalty are included in UC
13
Mushrooms kg$4.970.040$0.200.000$0.000.000$0.000.000$0.000.000$0.000.000$0.000.000$0.000.040$0.20The biggest concern is kitchen productivity. Domino's has 3 ovens and 5 people only making pizzas during the rush
14
Green Pepperskg$2.870.040$0.110.000$0.000.000$0.000.000$0.000.000$0.000.000$0.000.000$0.000.040$0.11But we might assume that we have less sides, so all the sales would come from pizzas ---- higher LC
15
Red Onionskg$2.850.020$0.060.000$0.000.000$0.000.020$0.060.000$0.000.020$0.060.000$0.000.020$0.06
16
Black Oliveskg$1.990.020$0.040.000$0.000.000$0.000.000$0.000.000$0.000.000$0.000.000$0.000.020$0.04
17
Pineapplekg$4.760.000$0.000.000$0.000.000$0.000.000$0.000.000$0.000.000$0.000.110$0.520.000$0.00
18
Cherry Tomatoeskg$6.770.000$0.000.0000.0000.020$0.140.020$0.140.000$0.000.000$0.000.020$0.14
19
Parsleykg$10.200.000$0.000.0000.0000.007$0.070.000$0.000.000$0.000.000$0.000.007$0.07
20
Mozzarellakg$7.980.110$0.880.110$0.880.110$0.880.110$0.880.110$0.880.110$0.880.110$0.880.110$0.88
21
Parmesankg$10.780.010$0.110.010$0.110.010$0.110.010$0.110.010$0.110.010$0.110.010$0.110.010$0.11
22
Riccotakg$6.810.000$0.000.0000.0000.180$1.230.000$0.000.000$0.000.000$0.000.180$1.23
23
Waterkg$0.270.127$0.030.127$0.030.127$0.030.127$0.030.127$0.030.127$0.030.127$0.030.127$0.03
24
Yeastkg$6.290.001$0.010.001$0.010.001$0.010.001$0.010.001$0.010.001$0.010.001$0.010.001$0.01
25
High-gluten flourkg$1.100.205$0.220.205$0.220.205$0.220.205$0.220.205$0.220.205$0.220.205$0.220.205$0.22
26
Saltkg$0.320.004$0.000.004$0.000.004$0.000.004$0.000.004$0.000.004$0.000.004$0.000.004$0.00
27
Olive oilkg$2.360.003$0.010.003$0.010.003$0.010.003$0.010.003$0.010.003$0.010.003$0.010.003$0.01
28
Garlickg$3.320.000$0.000.000$0.000.000$0.000.007$0.020.000$0.000.000$0.000.000$0.000.007$0.02
29
Black Pepperkg$15.940.001$0.020.001$0.020.001$0.020.001$0.020.001$0.020.000$0.000.001$0.020.001$0.02
30
Crushed Tomatoeskg$1.600.090$0.140.090$0.140.090$0.140.000$0.000.090$0.140.000$0.000.090$0.140.000$0.00
31
Dried oreganokg$19.980.001$0.020.001$0.020.001$0.020.000$0.000.001$0.020.000$0.000.001$0.020.000$0.00
32
Basilkg$37.210.007$0.260.007$0.260.007$0.260.000$0.000.007$0.260.007$0.260.007$0.260.000$0.00
33
BBQ saucekg$6.890.000$0.000.000$0.000.000$0.000.000$0.000.000$0.000.010$0.070.000$0.000.000$0.00
34
Packaging
35
Boxunit$0.301.000$0.301.000$0.301.000$0.301.000$0.301.000$0.301.000$0.301.000$0.301.000$0.30
36
Quality controlunit$0.051.000$0.051.000$0.051.000$0.051.000$0.051.000$0.051.000$0.051.000$0.051.000$0.05
37
38
39
40
41
42
43
44
45
Loading...
 
 
 
Итог
Unit cost composite
Copy of Unit cost composite
Unit cost simple
ID продуктов
Бланк заказа Аллиагтор