P&L
ENHANCE COLLEGE
Quarterly Profit & Loss Statement
Period Jul20 to Sep20
Jul-20 Aug-20 Sep-20 Qtr Total Budget Variance
Trading Days 26 27 26 79 79 0
Lunch
Covers 1,859 1,825 2,045 5,729 5,800 -71
Food Revenue 22,866 21,446 25,970 70,282 74,000 -3,718
Beverage Revenue 6,507 5,859 7,668 20,034 21,000 -966
Total Lunch Revenue 29,372 33,639 90,316 95,000 -4,684
Dinne
Covers 1,453 1,316 1,352 4,122 -78
Food Revenue 21,292 18,283 21,483 61,058 63,500 -2,442
Beverage Revenue 7,601 6,450 5,543 19,594 21,000 -1,406
Total Dinner Revenue 28,894 24,732 27,026 80,652 84,500 -3,848
Total Food Revenue 44,158 39,729 47,454 131,340 137,500 -6,160
Total Beverage Revenue 14,108 12,309 13,212 39,628 42,000 -2,372
Art Income 350 100 450 900 750 150
Other Income 356 475 645 1,476 926 550
Total Revenue 58,972 52,612 173,344 181,176 -7,832
Cost of Food 11,702 26.5% 9,932 25.0% 12,670 26.7% 34,304 26.1% 34,375 25.0% -71 -1.1%
Cost of Beverage 4,021 28.5% 3,446 28.0% 3,831 29.0% 11,298 28.5% 11,760 28.0% -462 -0.5%
Cost of art sales 175 50.0% 50 50.0% 225 50.0% 450 50.0% 375 50.0% 75 0.0%
Cost of other income 164 46.0% 228 48.0% 284 44.0% 676 45.8% 324 35.0% 351 -10.8%
Total Cost of Sales 16,061 13,657 26.0% 17,010 27.5% 46,728 27.0% 46,834 25.9% -106 -1.1%
Expenses
Merchant fees 118 105 124 347 300 47
Depreciation 0 0 0 0 0 0
Linen 166 157 170 493 500 -7
Contract cleaning 500 500 500 1,500 1,500 0
Advertising 1,100 0 0 1,100 750 350
Repairs & Maintenance 0 385 0 385 0 385
Printing Materials 0 0 250 250 200 50
Rent (incl Utilities) 2,450 2,450 2,450 7,350 7,350 0
Superannuation 2,377 2,469 2,758 7,603 8013 -410
Salaries & Wages 25,023 42% 25,986 49% 29,027 80,037 46% 84,350 47% -4,313
Other employer expenses 0 250 0 250 0 250
Total Expenses 31,734 54% 32,302 61% 35,278 57% 99,314 57% 102,963 57% -3,649
Profit/(Loss) 11,176 19.0% 6,654 12.6% 9,471 15.3% 15.7% 31,379 17.3% -4,077
Employees (Hours)
F/T Chef 171 178 171 519.8
Casual Chef 78 81 78 237.0
Shift Leade
Manager 171 178 171 519.8
Floor Staff (Casual) 520 540 702 1,762.0
Average Customer Spend
Lunch 15.80 16.45 15.76 16.38 -0.61
Dinner 19.88 18.79 19.99 19.57 -0.55
Covers per labour hour 3.22 3.03 3.24
Balance Sheet
ENHANCE COLLEGE
Balance Sheet
Assets
Cu
ent Assets
Petty Cash 100
Float 500
Cash at Bank 66,443
Inventory 15,650
Accounts Receivable 1,000
Total cu
ent assets
Long term assets
Equipment 55,000
Total long term assets 55,000
Total Assets 138,693
Liabilities
Cu
ent Liabilities
Accounts Payable
GST Collected 16,879
GST Paid -5,360
Superannuation 7,603
PAYG Payable 3,250
Total cu
ent assets 36,391
Long term liabilities
Bank loan 25,000
Total long term liabilities 25,000
Total Liabilities 61,391
Owners equity
Owners Equity 0
Owners Capital 50,000
Retained Earnings
Control -0
Trial Balance
ENHANCE COLLEGE
Trial Balance
as at 30 September 2020
Account DR CR
101 Petty Cash 100
102 Float 500
103 Cash at Bank 66,443
104 Inventory 15,650
105 Accounts Receivable 1,000
106 Equipment
201 Accounts Payable 14,018
202 GST Collected 16,879
203 GST Paid 5360
204 Superannuation 7,603
205 PAYG Payable 3,250
206 Bank loan 25,000
301 Owners Equity
302 Owners Capital 50,000
401 Food revenue
402 Beverage revenue 39,628
403 Art income 900
404 Other income 1,476
501 Cost of Food 34,304
502 Cost of Beverage 11,298
503 Cost of art sales 450
504 Cost of other income 676
601 Merchant fees 347
602 Depreciation
603 Linen 493
604 Contract cleaning 1,500
605 Advertising 1,100
606 Repairs & Maintenance 385
607 Printing Materials 250
608 Rent (incl Utilities) 7,350
609 Superannuation 7,603
610 Salaries & Wages
611 Other employer expenses 250
701 Interest 0
XXXXXXXXXX XXXXXXXXXX
Control -0.00
Journal entry
Date Code Account Name Debit Credit
9/30/20
501 Cost of Food
104 Inventory 12,670
Cost of food for Sep20
Date Code Account Name Debit Credit
9/30/20
Cost of Beverage 3,831
104 Inventory
Cost of Beverage for Sep20
P&L
ENHANCE COLLEGE
Quarterly Profit & Loss Statement
Period Jul20 to Sep20
Jul-20 Aug-20 Sep-20 Qtr Total Budget Variance
Trading Days 26 27 26 79 79 0
Lunch
Covers 1,859 1,825 2,045 5,729 5,800 -71
Food Revenue 22,866 21,446 25,970 70,282 74,000 -3,718
Beverage Revenue 6,507 5,859 7,668 20,034 21,000 -966
Total Lunch Revenue 29,372 33,639 90,316 95,000 -4,684
Dinne
Covers 1,453 1,316 1,352 4,122 -78
Food Revenue 21,292 18,283 21,483 61,058 63,500 -2,442
Beverage Revenue 7,601 6,450 5,543 19,594 21,000 -1,406
Total Dinner Revenue 28,894 24,732 27,026 80,652 84,500 -3,848
Total Food Revenue 44,158 39,729 47,454 131,340 137,500 -6,160
Total Beverage Revenue 14,108 12,309 13,212 39,628 42,000 -2,372
Art Income 350 100 450 900 750 150
Other Income 356 475 645 1,476 926 550
Total Revenue 58,972 52,612 173,344 181,176 -7,832
Cost of Food 11,702 26.5% 9,932 25.0% 12,670 26.7% 34,304 26.1% 34,375 25.0% -71 -1.1%
Cost of Beverage 4,021 28.5% 3,446 28.0% 3,831 29.0% 11,298 28.5% 11,760 28.0% -462 -0.5%
Cost of art sales 175 50.0% 50 50.0% 225 50.0% 450 50.0% 375 50.0% 75 0.0%
Cost of other income 164 46.0% 228 48.0% 284 44.0% 676 45.8% 324 35.0% 351 -10.8%
Total Cost of Sales 16,061 13,657 26.0% 17,010 27.5% 46,728 27.0% 46,834 25.9% -106 -1.1%
Expenses
Merchant fees 118 105 124 347 300 47
Depreciation 0 0 0 0 0 0
Linen 166 157 170 493 500 -7
Contract cleaning 500 500 500 1,500 1,500 0
Advertising 1,100 0 0 1,100 750 350
Repairs & Maintenance 0 385 0 385 0 385
Printing Materials 0 0 250 250 200 50
Rent (incl Utilities) 2,450 2,450 2,450 7,350 7,350 0
Superannuation 2,377 2,469 2,758 7,603 8013 -410
Salaries & Wages 25,023 42% 25,986 49% 29,027 80,037 46% 84,350 47% -4,313
Other employer expenses 0 250 0 250 0 250
Total Expenses 31,734 54% 32,302 61% 35,278 57% 99,314 57% 102,963 57% -3,649
Profit/(Loss) 11,176 19.0% 6,654 12.6% 9,471 15.3% 15.7% 31,379 17.3% -4,077
Employees (Hours)
F/T Chef 171 178 171 519.8
Casual Chef 78 81 78 237.0
Shift Leade
Manager 171 178 171 519.8
Floor Staff (Casual) 520 540 702 1,762.0
Average Customer Spend
Lunch 15.80 16.45 15.76 16.38 -0.61
Dinner 19.88 18.79 19.99 19.57 -0.55
Covers per labour hour 3.22 3.03 3.24
Balance Sheet
ENHANCE COLLEGE
Balance Sheet
Assets
Cu
ent Assets
Petty Cash 100
Float 500
Cash at Bank 66,443
Inventory 15,650
Accounts Receivable 1,000
Total cu
ent assets
Long term assets
Equipment 55,000
Total long term assets 55,000
Total Assets 138,693
Liabilities
Cu
ent Liabilities
Accounts Payable
GST Collected 16,879
GST Paid -5,360
Superannuation 7,603
PAYG Payable 3,250
Total cu
ent assets 36,391
Long term liabilities
Bank loan 25,000
Total long term liabilities 25,000
Total Liabilities 61,391
Owners equity
Owners Equity 0
Owners Capital 50,000
Retained Earnings
Control -0
Trial Balance
ENHANCE COLLEGE
Trial Balance
as at 30 September 2020
Account DR CR
101 Petty Cash 100
102 Float 500
103 Cash at Bank 66,443
104 Inventory 15,650
105 Accounts Receivable 1,000
106 Equipment
201 Accounts Payable 14,018
202 GST Collected 16,879
203 GST Paid 5360
204 Superannuation 7,603
205 PAYG Payable 3,250
206 Bank loan 25,000
301 Owners Equity
302 Owners Capital 50,000
401 Food revenue
402 Beverage revenue 39,628
403 Art income 900
404 Other income 1,476
501 Cost of Food 34,304
502 Cost of Beverage 11,298
503 Cost of art sales 450
504 Cost of other income 676
601 Merchant fees 347
602 Depreciation
603 Linen 493
604 Contract cleaning 1,500
605 Advertising 1,100
606 Repairs & Maintenance 385
607 Printing Materials 250
608 Rent (incl Utilities) 7,350
609 Superannuation 7,603
610 Salaries & Wages
611 Other employer expenses 250
701 Interest 0
XXXXXXXXXX XXXXXXXXXX
Control -0.00
Journal entry
Date Code Account Name Debit Credit
9/30/20
501 Cost of Food
104 Inventory 12,670
Cost of food for Sep20
Date Code Account Name Debit Credit
9/30/20
Cost of Beverage 3,831
104 Inventory
Cost of Beverage for Sep20