Question

Insert Mi Duyexlsx - Protected Page Layout PROTECTED VIEW Formulas Data Be careful--files from the Internet can contain viruses. Unless you need to Review View H H9 --NM Income Statement D Percent 3 Sales 4 Food 5 Beverage 6 Total Sales 7 Cost of Sales 8 Food Cost 9 Beverage Cost 10 Cost of Goods Sold 11 Gross Profit Dollars 1,013,600 386,400 1,400,000 72.4% 27.6% 100.0% 331,447 85,394 416,841 32.7% 22.1% 29.8% 70.2% 12 403,200 96,600 499,800 916,641 28.8% 6.996 35.7 65.5% 13 Labour 14 Salaries & Wages 15 Employee Benefits 16 Total Labour Costs 17 Prime Cost 18 Controllable Expenses 19 Direct Operating Expenses 20 Music & Entertainment 21 Marketing 22 Utilities 23 General & Administrative 24 Repairs & Maintenance 25 Total Controllable Expenses 26 Income Before Fixed Costs 27 28 Fixed Costs 29 Occupancy Costs 30 Interest 31 Depreciation 32 Total Fixed Costs 33 Earnings Before Interest and Tax (EBIT) 70,000 11,200 32,200 63,000 37,800 7,000 5.0% 0.8% 2.3% 4.5% 2.2% 0.5 15.8% 18.7% 221,200 262.159 140,000 65,000 21,000 10.0% 4.6% 1.5% 16.1% 266 226.000 for your info

Answer 1

Vancover Treats
Income Statement
				Budget with Decrease
Sales	Dollars		Percent	Management Goals	Dollars
Food	$ 1,013,600		72.4%	67.0%	$ 937,250
Beverage	$    386,400		27.6%	32.0%	$ 447,642
Total Sales		$ 1,400,000	100.0%	decline 11.2%		$ 1,398,880
Cost of Sales
Food Cost	$    331,447		32.7%	32.0%	$ 299,920
Beverage Cost	$     85,394		22.1%	20.0%	$   89,528
Cost of Goods Sold		$    416,841	29.8%	27.8%		$    389,448
Gross Profit		$    983,159	70.2%	72.2%		$ 1,009,432
Labour
Salaries & wages	$    403,200		28.8%	28.8%	$ 402,877
Employee Benefits	$     96,600		6.9%	6.9%	$   96,523
Total Labour Costs		$    499,800	35.7%	35.7%		$    499,400
Prime Cost		$    916,641	65.5%	63.5%		$    888,848
Controllable Expense
Direct Operating Expenses	$     70,000		5.0%	5.0%	$   70,000
Music & Entertainment	$     11,200		0.8%	0.8%	$   11,200
Marketing	$     32,200		2.3%	2.3%	$   32,200
Utilities	$     63,000		4.5%	4.5%	$   63,000
General & Administrative	$     37,800		2.7%	2.7%	$   37,800
Repairs & Maintenance	$       7,000		0.5%	0.5%	$    7,000
Total Controllable Expenses		$    221,200	15.8%	15.8%		$    221,200
Income Before Fixed Costs		$    262,159	18.7%	20.6%		$    288,832
Fixed Costs
Occupancy Costs	$    140,000		10.0%	10.0%	$ 140,000
Interest	$     65,000		4.6%	4.6%	$   65,000
Depreciation	$     21,000		1.5%	1.5%	$   21,000
Total Fixed Costs		$    226,000	16.1%	16.2%		$    226,000
Earning Befor Interest and Tax (EBIT)		$     36,159	2.6%	4.5%		$     62,832
Vancover Treats
Income Statement
				Budget with Increase
Sales	Dollars		Percent	Management Goals	Dollars
Food	$ 1,013,600		72.4%	71.0%	$ 994,355
Beverage	$    386,400		27.6%	29.0%	$ 406,145
Total Sales		$ 1,400,000	100.0%	Grow 5%		$ 1,400,500
Cost of Sales
Food Cost	$    331,447		32.7%	32.0%	$ 318,194
Beverage Cost	$     85,394		22.1%	20.0%	$   81,229
Cost of Goods Sold		$    416,841	29.8%	28.5%		$    399,423
Gross Profit		$    983,159	70.2%	71.5%		$ 1,001,077
Labour
Salaries & wages	$    403,200		28.8%	28.8%	$ 403,344
Employee Benefits	$     96,600		6.9%	6.9%	$   96,635
Total Labour Costs		$    499,800	35.7%	35.7%		$    499,979
Prime Cost		$    916,641	65.5%	64.2%		$    899,401
Controllable Expense
Direct Operating Expenses	$     70,000		5.0%	5.0%	$   70,000
Music & Entertainment	$     11,200		0.8%	0.8%	$   11,200
Marketing	$     32,200		2.3%	2.3%	$   32,200
Utilities	$     63,000		4.5%	4.5%	$   63,000
General & Administrative	$     37,800		2.7%	2.7%	$   37,800
Repairs & Maintenance	$       7,000		0.5%	0.5%	$    7,000
Total Controllable Expenses		$    221,200	15.8%	15.8%		$    221,200
Income Before Fixed Costs		$    262,159	18.7%	20.0%		$    279,899
Fixed Costs
Occupancy Costs	$    140,000		10.0%	10.0%	$ 140,000
Interest	$     65,000		4.6%	4.6%	$   65,000
Depreciation	$     21,000		1.5%	1.5%	$   21,000
Total Fixed Costs		$    226,000	16.1%	16.1%		$    226,000
Earning Befor Interest and Tax (EBIT)		$     36,159	2.6%	3.8%		$     53,899