Business plan

Sheet 2 - Table 1-1

	YES' Hotels
	Income Statement (F&B Revenue)
	As of December 31, 2013 and 2014
	F&B Revenue	2013	2014	$ change	% change
	Dining Room	$201,600	$221,900	$20,300	10.07%
	Coffee Shop	$195,900	$201,700	$5,800	2.96%
	Banquets	$261,200	$241,100	($20,100)	-7.70%
	Room Service	$81,700	$82,600	$900	1.10%
	Bar	$111,200	$121,800	$10,600	9.53%
	Total Revenues:	$851,600	$869,100	$17,500	2.05%

&"Helvetica,Regular"&12&K000000&P

Sheet 3

She’s
Income Statement for the Months Ended June 30 and July 31, 2014
	June	July	$ change	% change
Revenues:
Food	$ 890,000	$ 927,000	37,000	4.16%
Beverage	$ 220,000	$ 201,100	(18,900)	(8.59%)
Others	$ 28,100	$ 26,150	(1,950)	(6.94%)
Total Revenues	$ 1,138,100	$ 1,154,250	16,150	1.42%
Cost of Sales:
Food	$ 320,400	$ 358,700	38,300	11.95%
Beverage	$ 48,400	$ 48,000	(400)	(0.83%)
Others	$ 15,455	$ 15,010	(445)	(2.88%)
Total Cost of Sales	$ 384,255	$ 421,710	37,455	9.75%
Gross Profit:
Food	$ 569,600	$ 568,300	(1,300)	(0.23%)
Beverage	$ 171,600	$ 153,100	(18,500)	(10.78%)
Others	$ 12,645	$ 11,140	(1,505)	(11.90%)
Total Gross Profit	$ 753,845	$ 732,540	(21,305)	(2.83%)
Operating Expenses:
Salaries and Wages	$ 352,811	$ 353,000	189	0.05%
Employee Benefits	$ 105,843	$ 105,900	57	0.05%
Direct Operating Expenses	$ 68,286	$ 69,578	1,292	1.89%
Marketing	$ 39,834	$ 35,000	(4,834)	(12.14%)
Utilities	$ 44,386	$ 45,900	1,514	3.41%
Administration and General	$ 28,453	$ 28,453	0	0.00%
Repairs and Maintenance	$ 25,038	$ 15,040	(9,998)	(39.93%)
Music and Entertainment	$ 31,867	$ 32,045	178	0.56%
Total Operating Expenses	$ 696,518	$ 684,916	(11,602)	(1.67%)
Operating Income	$ 57,327	$ 47,624	(9,703)	(16.93%)
Other Expenses:
Rent	$ 8,000	$ 8,000	0	0.00%
Depreciation	$ 20,470	$ 20,470	0	0.00%
Interest	$ 4,500	$ 2,250	(2,250)	(50.00%)
Total Other Expenses	$ 32,970	$ 30,720	(2,250)	(6.82%)
Income Before Income Taxes	$ 24,357	$ 16,904	(7,453)	(30.60%)

&"Helvetica,Regular"&12&K000000&P

Sheet1