Question
Answered step-by-step

Review and analyse the data from Tree Top's March Quarterly Roster...

Review and analyse the data from Tree Top's March Quarterly Roster and provide SIX changes/suggestions that you believe would help to reduce labour costs, increase the overall profit without affecting the quality of the product or service.

 (Your answers must be in line with acceptable industry work practices)

Image transcription text

184 - AHAH (2).png 114% LE 45 . . . REDBRICK RESORT - TREE TOP RESAURANT & BAR QUARTERLY BUDGET Previous & Current Year 20 0720xx Period / Month Actual March Quarter Actual March Quarter Budget March Quarter | Budget Variance Actual Previous Year 20xx Current Year 20xx Percentage of Revenue Current Year 20xx v Budget Current Year Total F&B Sales Trend Comparison Between Previous Year 20xx Food Sales and Current Year 20xx March Quarters Actual $ Bar Sales 892,308 976,924 $ % 1,000,000 231,680 (23,076) Bar Snacks 25,040 -2.31% 461,840 64.75% 84,616 119,231 (36,800) -7.97 28.17% 9.48% Minus GST 257,693 50,000 193,360 83.46% Total Sales Revenue 113,020 150,878 7,693 3.08% 155,622 17.08% 138,462 ,508,779 -3.05% 10.00% Cost of Goods Sold 1,130,199 116.13% 1,556,218 (47,439) -3.05% 37,858 33.50% Food Purchases 378,580 33.50% Beverage Purchases 263,462 320,000 Bar Snack Purchases 80,870 312,000 16,500 8,000 2.56% 25,500 21.21% 56,538 41,483 21.46% TOTAL PURCHASE (COGS) 84,530 (000'6) -7.17% 7.72% 35,630 44,06% 85,815 78,950 Operational Expenses: 21,030 5,580 7.07% 16,450 4,580 0.89 5.60% 43,047 34.53% 103.77% RENT 135,215 35.05% LIVE ENTERTAINMENT 36,000 41,000 WATER 1,630 41,000 1,835 0.00 2.72% 5,000 ENERGY 1,720 1,624 1,780 212 13.03% 0.12% 13.89% 205 12.60% GARBAGE 13,900 14,250 1,820 14,400 TISO -2.20%% 0.12% RECYLCING 4,880 4,910 -1.04% 60 0.94% 3.49% 5,260 350 2.52% GAS 1,690 1,830 (350) 6.65% 0.33% 30 INSURANCE 14,200 1,780 So 2.81% 14,600 0.12% 0.61% 14,400 (200) -1.37% 140 8.28% PRINTING 2,400 2,800 0.95% 200 LAUNDRY 240 2,800 0.00% 1.41% 270 280 0.19% 400 16.67% KITCHEN CONTROLLABLES 1,680 1,825 (10) -3.57% 0.02% 1,875 (so) 30 -2.67% 0.12% 12.50% UNIFORM 1,200 1,350 1,500 145 1,235 1,485 (150) 8.63% LIECENCE / PERMITS -10.00% 0.09% 1,500 (15) 1.00%% 150 12.50% REPAIR/ MAINTENANCE 1,400 1,500 0.10% 1,500 250 20.24% PHONE/INTERNET/ IT SUPPORT 3,158 3,350 0.00% 0.10% PEST CONTROL 1,200 3,000 1,500 350 100 11.67% 0.22% 7.14% 1.500 192 SECURITY 1,200 6.08% 1,240 0.00% 1,240 0.10% 300 MARKETING 2,400 2,600 0.00% 0.08% 25.00% 2,400 2.600 40 3.33% POS FEE 2,500 D.00% 200 BANK MERCHANT FEES 1.6% 1,462 2,500 0.00% 8.33% 1,525 1,700 0.17% 100 8.550 -10.29% 4.17%% MISC - OTHER 7,436 (175) 11,545 (2,995) 0.10% -25.94% 63 LEGAL 4,690 4.34% 5,985 0.57% 1,114 1,400 7,360 1,375) -18.68 14.98% RECURUITMENT 1,553 1,600 0.40% 13,200 13,200 (47) -2.94% 1,295 0.10% 27.61% TOTAL OPERATIONAL EXPENSES 20,721 13,500 (200) 10.93% 31,338 -1.48% 153 0.88% FRONT OF HOUSE LABOUR 36,484 (5,145) -3.77% 100 8.70% 0.76% BACK OF HOUSE LABOUR 62,308 89,833 0,618 99,615 (9,782) 8.80% Labour Cost 200,308 237,083 -3.26% 62,615 248,615 19.21% 26,917 (11,532) -4.64% 7.526 10.49% Superannuateon 9.5% $48,231 43,948 21,314) 15.71% 4.92% 36,776 18.36% Workers compensation 3.5% 50,057 52,082 54,301 -3.89% 13.90% 17,730 (2,025) Annual Leave 17.5% 20,194 21,011 3.32% (817) 6,109 Payroll Tax 5.5% 88,649 00,970 -3.89% 13.90% 05,055 (4,084) 1.34% 2,464 27,861 31,734 6.69% 13.90% TOTAL LABOUR COST 3.89% 640,803 33,017 729,872 (1,284) -3.89 12,322 TOTAL REVENUE 2.10% 13.90% 759,396 (29,524) 13.90% TOTAL F&B COGS 1,130,199 -3.89 3,873 ,508,779 48.37% 89,069 13.90% TOTAL OPERATIONAL EXPENSES 385,815 1,556,218 521,030 (47,439) -3.05% 516,450 100.00% 4.580 TOTAL LABOUR COST 31,338 0.89% 378,580 34.53% 33.50% 20,721 35,215 35.05% NET PROFIT 640,803 136,484 (5,145) 29,872 -3.77% 8.70% 759,396 10,618 17,140) 126,539 (29,524) 143,889 -3.89% 48.37% 8.80% (17,350) -12.06% 89,069 8.39% 143,679 13.90% -838.28% O 9 24 C 320 ~ 9 (1 3. F4 03:18 2021/11/27

... Show more

Image transcription text

1:A - #HIRE (1).png 138% 14 2 45 . . . Tree Top Restaurant and Bar Wages and Salaries March Quarter Current Year 20x Jan Feb Mar Apr May 18 Nov Total Front of house staff costs 262,308 289,833 299,615 0 851,75 Back of house staff costs 200,308 237,083 248,615 0 0 0 0 0 686,00 Total staff costs 462,615 526,916 0 0 1,537,76 Executive chef 7,500 7,500 7,500 22,500 Sous chefs 18,750 18,750 18,750 56,250 Chef de Partie 41,333 41,333 41,333 124,000 Demi chef F/T 25,333 25,333 25,333 76,000 Demi chef casual 28,000 56,000 63,000 147,000 Commi chef 35,000 40,000 40,000 115,000 Aprentice chef 12.891 12,891 12,891 38,673 Kitchen hand F/T 12,000 12,000 12,000 36,000 Kitchen hand casual 19,500 19,500 26,000 boooooooooooooooo 65,000 Restaurant manager 7,083 7,083 7,083 21,250 Restaurant supervisor 31,000 31,000 31,000 93,000 Wait staff F/T 39,891 39,891 39,89 119,673 Wait staff casual 80.000 106,667 13,333 300,000 Bar manager 5,833 5,833 5,833 17,500 Bar supervisor 20,667 20,667 20,667 62,000 Bar person F/T 25,333 25,333 25,333 76,000 Bar person casual 52,500 52,500 56,000 161,000 Number of employees 1495 15 Avg Gross Salary 1560 160 1554 #DIV/O! #DIV/O! #DIV/O! #DIV/01 NDIV/O! #DIV/O! #DIV/0! #DIV/O! #DIV/O! #DIV/O! Average er of en Staff list Jan Feb Apr May Jun Jul Aug Sep Oct Nov Salary Executive chef 90,000 Sous chefs 75,000 Chef de Partie 62,000 Demi chef F/T 38,000 Demi chef casual 42,000 Commi chef 30,000 Aprentice chef 25,782 Kitchen hand F/T 24,000 Kitchen hand casual 26,000 Restaurant manager 85,000 Restaurant supervisor 62,000 Wait staff F/T 39,891 Wait staff casual 40,000 Bar manager 70,000 Bar supervisor 62,000 Bar person F/T 38,000 Bar person casual 42,000 O 24'C BEHE A D @() ' * 3. F 4 03:18 2021/11/27

... Show more

Answer & Explanation
Verified Solved by verified expert
Rated Helpful

Fusce dui lectus, con

s a molestie consequat, u

rem ipsum dolor sit amet, con

ia pulvinar tortor n

lestie conseq

s a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia

Unlock full access to Course Hero

Explore over 16 million step-by-step answers from our library

Subscribe to view answer
Step-by-step explanation

Fusce dui lectus, con

m risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue ve

ce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec faci

gue

s a molestie consequat, u

iscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lore

gue

rem ipsum dolor sit amet, con

ur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar torto

gue

ia pulvinar tortor n

et, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, d

gue

lestie conseq

, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam ris

gue

dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus effici

Student reviews
67% (3 ratings)
Easy to follow
Clear formatting

"thanks!"