Paramount Monthly P&L Rpt

	A	B	C	D	E	F	G	H	I	J
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 Factory	Distribution Ctr	Bangalore Store	Chennai Store	Hyderabad Store	Secunderabad Store	Vijayawada Store	Pune Store
6	Products Sold (Demand at Stores)	3,968			620	775	620	775	465	713
7	** Retail Markup %				30.00	30.00	30.00	30.00	30.00	30.00
8	Product Sales Price				520	520	520	520	520	520
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 Sold	1,587,200			248,000	310,000	248,000	310,000	186,000	285,200
13	Facility Storage & Operating Cost	376,338	135,239	44,355	34,383	28,314	21,911	27,264	44,526	40,346
14	Vehicle Operating Cost	34,808	1,357	33,452
15	Total Expenses	1,998,347	136,595	77,807	282,383	338,314	269,911	337,264	230,526	325,546
16
17	MONTHLY PROFIT OR LOSS
18	Gross Profit	$65,013			$40,017	$64,686	$52,489	$65,736	$11,274	$45,214
19	Gross Profit %	3.15%			12.41%	16.05%	16.28%	16.31%	4.66%	12.19%
20
21
22	SUPPLY CHAIN PERFORMANCE	Total Company	Spicemax Factory	Distribution Ctr	Bangalore Store	Chennai Store	Hyderabad Store	Secunderabad Store	Vijayawada Store	Pune Store
23	** Spicy Cube: Product Cost	$400
24	Beginning Inventory On-Hand	2,749	1284	123	1000	75	80	50	60	77
25	Ending Inventory On-Hand	24,782	11314	12123	1000	90	20	140	85	10
26	Percent Change	801.49%	781.15%	9756.10%	0.00%	20.00%	-75.00%	180.00%	41.67%	-87.01%
27	Avg On-Hand Inventory Amount	6,288	3,634	1,323	1,000	64	54	97	70	46
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 Demand	128			20	25	20	25	15	23
30	Inventory Days of Supply	49.12			50.00	2.57	2.68	3.88	4.67	2.01
31	Vehicle Carbon Footprint (Kg)	32,236
32
33	Holding Cost due to Inventory(@25%)	$628,756.67
34
35	Net Profit	-$563,743.37
36
37	** Accept default numbers for Product Markup and Product Price, or enter other numbers manually in cells outlined in orange.
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