A DE Miles Country Club Statement of Activities Period Ending w/CCX For your 2020 Cape The Al Line Car To F88 River Line 1 2 (2) Explain Variance of Yellow Highlighted Lineers This Month 2019 5650 000 | 200 000 850.000 This Month 2020 5800 500 186 500 787,000 4 5 6 7 8 REVENUE Food & Beverage Beverage Sales Subtotal Unspent Food Minimum Set Up Charges Room Charges Audio/Visual/Other Subtotal 15.000 50 000 13 000 10.000 14 500 49000 13 500 1.500 78.500 Total Food & Beverage Revenue 938.000 865,500 10 11 12 13 14 15 16 17 18 19 20 21 COST of SALES Food Purchases Beverage. Purchases Employee Comp Meal Credits Total Cost of Sales 350.000 56 000 -70 000 336.000 56.000 46.500 Gross Profit On F&B Sales 602.000 561.000 24 25 26 27 28 Cost Of Labor Wages Taxes Employee Benefits Employee Meals Total Cost Of Labor 315.000 27500 | 6 000 70.000 418.500 250.000 27500 12 000 46.500 336.000 31 32 34 35 Departmental Expenses Training Managers DSS Supplies - Departmental Supplies . China, Silver & Glassware R&M-Equipment R&M. Service Contracts Bark Fees & Charges Licenses & Permits Printing Linen & Laundry Uniforms. Departmental Ulities - Electric Cable Water Gas Waste Total Departmental Expenses 2.948 12 250 16 200 10 076 4 875 324 1.490 1,565 25 307 4 474 11 880 92.389 2.730 11 343 15 000 9 329 4 514 300 1380 1.449 24 358 4 143 11.000 85.545 37 39 40 41 42 43 44 Income Before Fixed Charges 91.111 139.455 46 47 48 49 50 51 52 Fixed Charges Interest On Loans Insurance Leases Depreciation and Amortization Total Fixed Charges 32 000 2 500 24 000 59.000 32.000 2.500 24.000 59.000 Results of Operations 32.111 80.455 54 55 Other Activities Dining Assessment Investment Income Total Other Activities 50.000 11 844 61.844 5.000 2.500 7.500 57 58 59 Change In Unrestricted Net Assets a. Question - 1 Based on the information provide, please answer the following questions: In the F&B P&L Compare worksheet do the following: Compute the calculations in column H based on its heading Do the same for columns I and J b. What is the Cost Of Food % to two decimal points? Compute and place answer in cell C8 on this page c. What is the cost so sales % (COS)? Compute and place answer in cell C11 d. If the Membership dues of this club is $1,000,000, what is the likely amount of its labor cost in dollars and why? Answer in the highlighted area below: e. The club's Current Assets total $100,000, its Inventory $25,000 and it Current liabilities total $75,000 Answer in the shaded areas below: What is the clubs Current Ratio? What is the club's Quick Ratio? 8. Using the data in F&B P&L worksheet, what is the club's Operating Efficiency Ratio? For year 2020 Compute The Of Al Line Hems Compared To F88 Revenue (line 123 Vince 2 decimals) Explain Va This Month 2019 $650,000 200.000 850,000 This Month 2020 $600 500 166.500 787.000 15.000 50.000 13.000 10.000 38.000 14 500 49.000 13.500 1.500 78.500 938,000 865.500 350.000 56.000 -70.000 336,000 295.000 56.000 45.500 304.500 602.000 561.000 315.000 27.500 6.000 70.000 418,500 250.000 27500 12.000 46.500 336.000 Statement of Activities Period Ending xxxXXXXX Line 1 REVENUE 2 Food & Beverage 3 Beverage Sales 4 Subtotal 5 6 Unspent Food Minimum 7 Set Up Charges 8 Room Charges 9 Audio/Visual/Other 10 Subtotal 11 12 Total Food & Beverage Revenue 13 14 COST of SALES 15 Food - Purchases 16 Beverage - Purchases 17 Employee/Comp Meal Credits 18 Total Cost of Sales 19 20 Gross Profit On F&B Sales 21 22 Cost Of Labor 23 Wages 24 Taxes 25 Employee Benefits 26 Employee Meals 27 Total Cost Of Labor 28 29 Departmental Expenses 30 Training - Managers D&S 31 Supplies - Departmental 32 Supplies - China, Silver & Glassware 33 R&M - Equipment 34 R&M - Service Contracts 35 Bank Fees & Charges 36 Licenses & Permits 37 Printing 38 Linen & Laundry 39 Uniforms - Departmental 40 Utilities - Electric, Cable, Water, Gas, Waste 41 Total Departmental Expenses 42 43 Income Before Fixed Charges 44 45 Fixed Charges 46 Interest On Loans 47 Insurance 48 Lenses 49 Depreciation and Amortization 50 Total Fixed Charges 51 52 Results of Operations 53 54 Other Activities 55 Dining Assessment 56 Investment Income 57 Total Other Activities 58 59 Change In Unrestricted Not Assets 2.730 11.343 15.000 9.329 4.514 300 2.948 12.250 16.200 10,076 4.875 324 1.490 1.565 26 307 4 474 11 880 92.389 1.449 24.358 4,143 11.000 85.545 91,111 139.455 500 32.000 2.500 24.000 59.000 500 32.000 2.500 24.000 59.000 32.111 30.455 50.000 11.3441 61,844 5.000 2.500 7,500 $93.955 $87-9551