Pizza Costing
Pizza Costing
Pizza Costing
8/27/2020 16:21:53
8/27/2020 18:13:48
8/28/2020 12:43:02 139
8/28/2020 15:56:20 0
8/28/2020 15:57:35 119
8/28/2020 15:58:29
8/28/2020 16:00:06 139
8/28/2020 17:35:08 119
8/28/2020 17:35:21 119
8/28/2020 17:35:45 139
8/28/2020 18:10:28 119
8/28/2020 19:37:44
8/28/2020 19:38:16
8/28/2020 19:47:18 119
8/28/2020 19:47:37
8/28/2020 20:10:59
8/28/2020 22:09:22
8/28/2020 22:09:48
8/28/2020 22:10:32
8/28/2020 22:10:49
8/29/2020 20:23:43 119
8/29/2020 20:24:05
8/29/2020 21:08:33 119
8/30/2020 20:56:06 119
8/30/2020 20:56:44 139
8/30/2020 21:20:30
8/30/2020 21:20:56
8/30/2020 21:21:26
8/30/2020 21:21:47
8/30/2020 21:22:25 139
8/30/2020 21:23:05
8/30/2020 21:23:56
8/30/2020 21:24:52 149
8/30/2020 21:26:10 139
8/30/2020 21:26:32
8/30/2020 21:29:59 139
8/30/2020 21:30:42 119
8/30/2020 21:32:20 119
8/30/2020 21:32:31 119
8/30/2020 21:34:00
8/30/2020 21:34:18
8/30/2020 21:34:47
8/30/2020 21:36:09
8/30/2020 21:37:21
8/30/2020 21:37:55 139
8/30/2020 21:38:42 139
8/30/2020 21:39:28
8/30/2020 21:40:24
8/30/2020 21:41:16 119
8/30/2020 21:45:21 139
8/30/2020 21:45:36
8/30/2020 21:45:54 139
8/30/2020 21:46:14
8/30/2020 21:46:38
8/30/2020 21:49:54 139
8/30/2020 21:50:39
8/30/2020 21:51:27 119
8/30/2020 21:52:41
8/30/2020 21:53:07 119
8/30/2020 21:54:11 139
8/30/2020 21:54:41
8/30/2020 21:55:01
8/30/2020 21:55:39
8/30/2020 21:57:06 139
8/30/2020 21:58:12
8/30/2020 21:58:47 119 139
8/30/2020 22:03:56
8/30/2020 22:04:35
8/30/2020 22:05:21
8/30/2020 22:39:54
8/31/2020 21:43:51
8/31/2020 21:44:14
8/31/2020 21:44:27
Pizza Order [Corn n PanPizza Order [Onion n CaPizza Order [Onion n CorPizza Order [Corn n Cap
149
149
149
149
149
149
149
149
149
169
Pizza Order [Capsicum nPizza Order [Mushroom Pizza Order [Corn n ChicPizza Order [Corn n Sau
199
149
149
149
149
199
199
Pizza Order [Capsicum nPizza Order [Capsicum nPizza Order [onion n ChiPizza Order [onion n Sa
199
199 199
199
199
199
199
199
199
199
199
199
Pizza Order [Corn DelighPizza Order [Fiesty PanePizza Order [Mushroom R
Pizza Order [Corny Saus
229
179
179 179
179
179
179
179
179
179
179
179
179 179 179
179
179
179
179
179
179
Pizza Order [Chicken RulPizza Order [Chicken LoPizza Order [Veggie Feas
Pizza Order [Chic n Che
229
269
269
269
269
269
269
179
229
269
269
179 269
229
269
229
229 299
299
269
229
269 269
269
Flat Number Date
A2-2104 8/27/2020
B4-1202 8/27/2020
A2-2102 8/28/2020
B4-701 8/28/2020
A2-402 8/28/2020
B6-1602 8/28/2020
Wastage 8/28/2020
A4-1103 8/28/2020
A4-1103 8/28/2020
B5-2104 8/28/2020
wastage 8/28/2020
B6-1704 8/28/2020
B6-1704 8/28/2020
B3-304 8/28/2020
B3-304 8/28/2020
B5-501 8/28/2020
B5-501 8/28/2020
B5-501 8/28/2020
B5-2704 8/28/2020
B5-2704 8/28/2020
B3-503 8/29/2020
B3-502 8/29/2020
B5-1603 8/29/2020
B1-2002 8/30/2020
A2-2102 8/30/2020
B5-2104 8/15/2020
A2-2802 8/15/2020
B5-2502 8/15/2020
B4-701 8/15/2020
D1-2201 8/15/2020
Unknow 8/15/2020
B4-2004 8/15/2020
Unknown 8/15/2020
B5-1603 8/16/2020
B3-2403 8/16/2020
B5-2704 8/17/2020
B4-202 8/17/2020
Unknown 8/17/2020
Unknown 8/17/2020
B4-1802 8/18/2020
B4-202 8/18/2020
B5-2203 8/18/2020
B5-2104 8/19/2020
Unknown 8/20/2020
A2-2102 8/21/2020
A3-301 8/21/2020
B3-2403 8/21/2020
Unknow 8/21/2020
B5-1603 8/22/2020
A2-2102 8/22/2020
D1-2804 8/22/2020
B5-501 8/22/2020
B5-2603 8/22/2020
B4-701 8/22/2020
Unknow 8/23/2020
A3-2803 8/24/2020
B4-701 8/24/2020
A6-1603 8/25/2020
B5-501 8/25/2020
A2-2102 8/25/2020
B6-1201 8/25/2020
C3-2003 8/25/2020
A2-2802 8/25/2020
C4-2303 8/26/2020
C3-2003 8/26/2020
B4-202 8/26/2020
B4-701 8/26/2020
B4-701 8/26/2020
A3-501 8/26/2020
B4-704 8/30/2020
B5-2203 8/31/2020
B4-701 8/31/2020
B4-701 8/31/2020
Date
Data 8/15/2020 8/16/2020 8/17/2020
Count - Pizza Order [Magharita] 1 3
Count - Pizza Order [Double Cheese Magharita] 1 1
Count - Pizza Order [Corn n Mushroom] 1
Count - Pizza Order [Corn n Paneer]
Count - Pizza Order [Onion n Capsicum]
Count - Pizza Order [Onion n Corn]
Count - Pizza Order [Corn n Capsicum]
Count - Pizza Order [Capsicum n Paneer] 1
Count - Pizza Order [Mushroom n Capsicum] 1
Count - Pizza Order [Corn n Chicken]
Count - Pizza Order [Corn n Sausage]
Count - Pizza Order [Capsicum n Chicken]
Count - Pizza Order [Capsicum n sausage]
Count - Pizza Order [onion n Chicken]
Count - Pizza Order [onion n Sausage]
Count - Pizza Order [Corn Delight] 1 1
Count - Pizza Order [Fiesty Paneer] 3 1
Count - Pizza Order [Mushroom Rulz]
Count - Pizza Order [Corny Sausage]
Count - Pizza Order [Chicken Rulz]
Count - Pizza Order [Chicken Loaded] 1
Count - Pizza Order [Veggie Feast] 1 1
Count - Pizza Order [Chic n Cheese]
8/18/2020 8/19/2020 8/20/2020 8/21/2020 8/22/2020 8/23/2020
1
2 2 1
1 1 1
1
1
1
1 1
1 1 3
1 1
1 1
1 1 1 1
8/24/2020 8/25/2020 8/26/2020 8/27/2020 8/28/2020 8/29/2020
1 1 1 5 2
1 2 4
1 1 1
1 1
1 1
2 6
1 1
1 1
1 2 1
1 1
1
1 2 1
1 3 2
3
8/30/2020 8/31/2020 (empty) Total Result
1 16
1 15
1
6
1 3
1
2
2
1 3
1 9
2
6
13
4
1
1 3
1 6
2 14
1 4
Date
Data 8/15/2020 8/16/2020 8/17/2020
Sum - Pizza Order [Magharita] 139 357
Sum - Pizza Order [Double Cheese Magharita] 139 139
Sum - Pizza Order [Corn n Mushroom] 149
Sum - Pizza Order [Corn n Paneer]
Sum - Pizza Order [Onion n Capsicum]
Sum - Pizza Order [Onion n Corn]
Sum - Pizza Order [Corn n Capsicum]
Sum - Pizza Order [Capsicum n Paneer] 149
Sum - Pizza Order [Mushroom n Capsicum] 149
Sum - Pizza Order [Corn n Chicken]
Sum - Pizza Order [Corn n Sausage]
Sum - Pizza Order [Capsicum n Chicken]
Sum - Pizza Order [Capsicum n sausage]
Sum - Pizza Order [onion n Chicken]
Sum - Pizza Order [onion n Sausage]
Sum - Pizza Order [Corn Delight] 179 179
Sum - Pizza Order [Fiesty Paneer] 537 179
Sum - Pizza Order [Mushroom Rulz]
Sum - Pizza Order [Corny Sausage]
Sum - Pizza Order [Chicken Rulz]
Sum - Pizza Order [Chicken Loaded] 229
Sum - Pizza Order [Veggie Feast] 269 179
Sum - Pizza Order [Chic n Cheese]
Total 1422 497 1053
1422
8/18/2020 8/19/2020 8/20/2020 8/21/2020 8/22/2020 8/23/2020
119
278 278 139
149
149
149
179 179
179 179 537
179 179
179 229
199 199
199
398 1194
199 199
179 179
179 358 179
179 179
229
149
298
298
199 597
199
199 1791
398
1074
2327
716
229
229 637
269 1414
538 3706
269 1166
875 1235 0
Price In Stock in Stock Price Unit
Cheese 450 1.5 675 1000
Onion 25 0.5 12.5 1000
Tomato 55 2 110 1000
Capsicum 80 0.1 8 1000
Mushroom 110 400
Chicken 378 0.5 0 1000
Sausage 493 0 1000
Corn 120 1 120 1000
Paneer 375 0.2 75 1000
Maida 40 1.5 60 1000
Sugar 40 0.5 20 1000
Oregano 888.8889 0.05 44.44444 1000
Oregano Sachet 0.6 350 210 1
Chilli Sachet 0.5 350 175 1
Chilli 450 0.15 67.5
1577.444
Dough 6 1
Sauce 7 1
Electricity 10 1
Box 10 1
Marination
Price/Unit
0.45
0.025
0.055
0.08
0.275
0.378
0.493
0.12
0.375
0.04
0.04
0.888889
0.6
0.5 Tomato 110
Olive Oil 20
Onion 20
6 Oregano 10
7 Chilli flaks 5
10 Sugar 5
10 Gas 10
5 180
6
Maida 40
Atta 4
Sugar 5
Oil 5
Yeast 5
59
5.9
Cheese Onion Tomato
Margharita 60
DC Margharita 90
Corn n Mushroom 60
Corn n Paneer 60
Onion n Capsicum 60 50
Onion n Corn 60 50
Corn n Capsicum 60
Capsicum n Paneer 60
Mushroom n Capsicum 60
Corn n Chicken 60
Corn n Sausage 60
Capsicum n Chicken 60
Capsicum n sausage 60
onion n Chicken 60 50
onion n Sausage 60 50
Corn Delight 60 50
Fiesty Paneer 60
Mushroom Rulz 60 50
Corny Sausage 60 50
Chicken Rulz 60 50
Chicken Loaded 60 50
Veggie Feast 60 50
Chic n Cheese 60 50
Capsicum Mushroom Chicken Sausage Corn Paneer
20 40
40 50
25
40
25 40
25 50
25 20
65 40
110 40
25 65
25 110
65
110
25 40
25 20 50
25 20
110 40
25 65
65 110
25 20 20 50
25 20 65 20
Dough Sauce Oregano Sachet Chilli Sachet Electricity Box
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1 1
Marination
1
1
1
1
1
1
1
1
1
1
1
Cheese Onion Tomato Capsicum Mushroom
Margharita 27 0 0 0 0
DC Margharita 40.5 0 0 0 0
Corn n Mushroom 27 0 0 0 5.5
Corn n Paneer 27 0 0 0 0
Onion n Capsicum 27 1.25 0 2 0
Onion n Corn 27 1.25 0 0 0
Corn n Capsicum 27 0 0 2 0
Capsicum n Panee 27 0 0 2 0
Mushroom n Caps 27 0 0 2 5.5
Corn n Chicken 27 0 0 0 0
Corn n Sausage 27 0 0 0 0
Capsicum n Chick 27 0 0 2 0
Capsicum n sausa 27 0 0 2 0
onion n Chicken 27 1.25 0 0 0
onion n Sausage 27 1.25 0 0 0
Corn Delight 27 1.25 0 2 0
Fiesty Paneer 27 0 0 2 0
Mushroom Rulz 27 1.25 0 2 5.5
Corny Sausage 27 1.25 0 0 0
Chicken Rulz 27 1.25 0 2 0
Chicken Loaded 27 1.25 0 0 0
Veggie Feast 27 1.25 0 2 5.5
Chic n Cheese 27 1.25 0 2 5.5
Chicken Sausage Corn Paneer Dough Sauce
0 0 0 0 6 7
0 0 0 0 6 7
0 0 4.8 0 6 7
0 0 4.8 18.75 6 7
0 0 0 0 6 7
0 0 4.8 0 6 7
0 0 4.8 0 6 7
0 0 0 18.75 6 7
0 0 0 0 6 7
24.57 0 4.8 0 6 7
0 54.23 4.8 0 6 7
24.57 0 0 0 6 7
0 54.23 0 0 6 7
24.57 0 0 0 6 7
0 54.23 0 0 6 7
0 0 4.8 0 6 7
0 0 2.4 18.75 6 7
0 0 0 0 6 7
0 54.23 4.8 0 6 7
24.57 0 0 0 6 7
24.57 54.23 0 0 6 7
0 0 2.4 18.75 6 7
24.57 0 2.4 0 6 7
Oregano Sachet Chilli Sachet Electricity Box marination Total
0.6 0.5 10 10 0 61.1
0.6 0.5 10 10 0 74.6
0.6 0.5 10 10 5 76.4
0.6 0.5 10 10 5 89.65
0.6 0.5 10 10 0 64.35
0.6 0.5 10 10 0 67.15
0.6 0.5 10 10 0 67.9
0.6 0.5 10 10 5 86.85
0.6 0.5 10 10 5 73.6
0.6 0.5 10 10 5 95.47
0.6 0.5 10 10 0 120.13
0.6 0.5 10 10 5 92.67
0.6 0.5 10 10 0 117.33
0.6 0.5 10 10 5 91.92
0.6 0.5 10 10 0 116.58
0.6 0.5 10 10 0 69.15
0.6 0.5 10 10 5 89.25
0.6 0.5 10 10 5 74.85
0.6 0.5 10 10 0 121.38
0.6 0.5 10 10 5 93.92
0.6 0.5 10 10 5 146.15
0.6 0.5 10 10 5 96
0.6 0.5 10 10 5 101.82
Sale Price Profit Total Pizza sale p
t izza sale price pizza cost price
119 48.66% 16 1904 977.6
139 46.33% 15 2085 1119
149 48.72% 1 149 76.4
149 39.83% 6 894 537.9
149 56.81% 3 447 193.05
149 54.93% 0 0 0
149 54.43% 1 149 67.9
149 41.71% 2 298 173.7
149 50.60% 2 298 147.2
199 52.03% 3 597 286.41
199 39.63% 0 0 0
199 53.43% 1 199 92.67
199 41.04% 0 0 0
199 53.81% 8 1592 735.36
199 41.42% 2 398 233.16
179 61.37% 6 1074 414.9
179 50.14% 12 2148 1071
179 58.18% 4 716 299.4
229 47.00% 1 229 121.38
229 58.99% 2 458 187.84
229 36.18% 6 1374 876.9
269 64.31% 12 3228 1152
299 65.95% 3 897 305.46
19134 9069.23 10064.77
Data
Flat Number Count - Pizza Orde
Count - Pizza OrdCount - Pizza Ord
A2-2102 5
A2-2104
A2-2802
A2-402 1
A3-2803
A3-301 1
A3-501
A4-1103 2
A6-1603
B1-2002 1
B3-2403
B3-304 1
B3-502
B3-503 1
B4-1202
B4-1802
B4-2004
B4-202 2 1
B4-701 1 1
B4-704
B5-1603 3
B5-2104 1
B5-2203
B5-2502
B5-2603
B5-2704 1
B5-501 1 1
B6-1201
B6-1602
B6-1704
C3-2003
C4-2303 1
D1-2201 1
D1-2804
Unknow 1
Unknown 2 1
Wastage 1 1
(empty)
Total Result 16 15 1
Count - Pizza OrdCount - Pizza OrdCount - Pizza OrdCount - Pizza OrdCount - Pizza OrdCount - Pizza Ord
2
1
1 1
1 1
2
6 3 1 2 2
Count - Pizza OrdCount - Pizza OrdCount - Pizza OrdCount - Pizza OrdCount - Pizza Orde
Count - Pizza Ord
1
1
1 1
1 1
2
3
1
3 1 9 2
Count - Pizza OrdeCount - Pizza Orde
Count - Pizza OrdCount - Pizza OrdCount - Pizza Orde
Count - Pizza Ord
1 1
2 1 1
2 1
1
2
1
1
1
1
1 1
1
1
1 2
1
1
1 1
1 1 1
6 13 4 1 3 6
Count - Pizza OrdeCount - Pizza Order [Chic n Cheese]
7
2
2
1 4
2
1
2
2
1
2
4
2 3
1 1
1 2
1
1
1 1
1 4
3 3 13
1
1 6
3
4
1
1
7
8
1
1
3
1 1 4
1
1
1
1 5
1 7
2
0
14 4