Paramount Monthly P&L Rpt
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Download a copy of this spreadsheet to your computer by clicking on the word "File" in top left corner of this screen. Then click "Download as" in the submenu and select download format
2
3
Paramount Restaurant - Monthly Profit & Loss Report plus KPIs
4
5
INCOME
Total Company
Spicemax FactoryDistribution CtrBangalore StoreChennai StoreHyderabad StoreSecunderabad StoreVijayawada StorePune Store
6
Products Sold (Demand at Stores)3,968620775620775465713
7
Retail Markup %30.0030.0030.0030.0030.0030.00
8
Product Sales Price520520520520520520
9
Total Income$2,063,360$322,400$403,000$322,400$403,000$241,800$370,760
10
11
EXPENSE
12
Cost of Products Sold1,587,200248,000310,000248,000310,000186,000285,200
13
Facility Storage & Operating Cost376,338135,23944,35534,38328,31421,91127,26444,52640,346
14
Vehicle Operating Cost30,126
15
Total Expenses 1,963,538135,23944,355282,383338,314269,911337,264230,526325,546
16
17
MONTHLY PROFIT OR LOSS
18
Gross Profit $99,822$40,017$64,686$52,489$65,736$11,274$45,214
19
Gross Profit %4.84%12.41%16.05%16.28%16.31%4.66%12.19%
20
21
22
SUPPLY CHAIN PERFORMANCE
Total Company
Spicemax FactoryDistribution CtrBangalore StoreChennai StoreHyderabad StoreSecunderabad StoreVijayawada StorePune Store
23
**Spicy Cube: Product Cost$400
24
Beginning Inventory On-Hand2,749128412310007580506077
25
Ending Inventory On-Hand24,7821131412123100090201408510
26
Percent Change801.49%781.15%9756.10%0.00%20.00%-75.00%180.00%41.67%-87.01%
27
Avg On-Hand Inventory Amount6,2883,6341,3231,0006454977046
28
Avg On-Hand Inventory Value$2,515,027$1,453,413$529,200$400,000$25,733$21,400$38,760$28,000$18,520
29
Product Daily Demand128202520251523
30
Inventory Days of Supply 49.1250.002.572.683.884.672.01
31
32
Holding Cost due to Inventory(@25%)
$628,756.67
33
34
Net Profit-$528,934.97
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu