Can you help me to do this assignment? Analyze the provided restaurant financial statements. Provide a 2 paragraph minimum report on the financial strength of the restaurant and identify problems. Provide solutions based on concepts learned in class. Report your findings and upload your document.
Restaurant Client 123 Any Street St. Louis, MO 63000 December 31, 2000 OPERATING STATEMENT CURRENT PERIOD FOOD SALES 301 - Sales - Food TOTAL FOOD SALES $ FOOD COSTS 311 - Purchases - Food TOTAL FOOD COSTS 48,067.38 48,067.38 TWELVE MONTHS $ $ 34,655.79 34,655.79 YTD % $ 558,075.15 558,075.15 100.00 100.00 100.00 100.00 204,061.30 204,061.30 17,669.25 17,669.25 BEVERAGE SALES 341 - Sales - Beverages TOTAL BEVERAGE SALES CURR. % 36.76 36.76 36.57 36.57 411,558.07 411,558.07 100.00 100.00 100.00 100.00 BEVERAGE COSTS 351 - Purchases - Beverages TOTAL BEVERAGE COSTS 12,199.73 12,199.73 127,824.66 127,824.66 35.20 35.20 31.06 31.06 PRIME COST (F + B + LABOR) 57,237.44 604,063.82 69.19 62.30 ALL SALES Total Food Sales Total Beverage Sales TOTAL SALES 48,067.38 34,655.79 82,723.17 558,075.15 411,558.07 969,633.22 58.11 41.89 100.00 57.56 42.44 100.00 TOTAL COSTS OF SALES 29,868.98 331,885.96 36.11 34.23 TOTAL GROSS PROFIT 52,854.19 637,747.26 63.89 65.77 154.58 1,248.75 0.00 1,403.33 658.36 15,117.75 3,177.00 18,953.11 0.19 1.51 0.00 1.70 0.07 1.56 0.33 1.95 TOTAL INCOME 54,257.52 656,700.37 65.59 67.73 CONTROLLABLE EXPENSES Salaries & Wages Employee Benefits Direct Operating Expenses Marketing Energy & Utility Services Administrative & General Expense Repairs & Maintenance TOTAL CONTROLLABLE EXPENSES 21,947.20 5,421.26 5,191.11 6,698.18 2,248.26 6,205.73 588.88 48,300.62 232,235.55 39,942.31 48,941.28 67,888.15 33,850.14 82,030.73 9,554.25 514,442.41 26.53 6.55 6.28 8.10 2.72 7.50 0.71 58.39 23.95 4.12 5.05 7.00 3.49 8.46 0.99 53.06 142,257.96 7.20 14.67 5,297.74 72,140.69 6.40 7.44 659.16 70,117.27 0.80 7.23 TOTAL INTEREST EXPENSE 1,450.62 17,430.56 1.75 1.80 TOTAL DEPRECIATION EXPENSE 1,516.47 26,795.79 1.83 2.76 25,890.92 (2.79) 2.67 OTHER INCOME 902 - Cash Over/Short 906 - Video Game Income 907 - Insurance Claim TOTAL OTHER INCOME $ TOTAL INCOME LESS CONTROLLABLE $ TOTAL OCCUPANCY COSTS INCOME BEFORE INT, DEPR & TAX NET PROFIT or (LOSS) $ 5,956.90 $ (2,307.93) $ See Accountants' Compilation Report Restaurant Op Stmt - Food & Bev Restaurant Client 123 Any Street St. Louis, MO 63000 December 31, 2000 OPERATING STATEMENT CURRENT PERIOD SALARIES & WAGES 403 - Wages - Cook 404 - Wages - Bus/Dishwash 405 - Wages - Servers 406 - Wages - Host 409 - Wages - Bar 412 - Wages - Managers 414 - Wages - Training TOTAL SALARIES & WAGES TWELVE MONTHS CURR. % YTD % 9,838.98 1,686.55 2,287.28 914.78 2,364.20 4,267.86 587.55 21,947.20 88,309.41 22,329.82 32,646.68 16,020.88 37,830.43 32,148.89 2,949.44 232,235.55 11.89 2.04 2.76 1.11 2.86 5.16 0.71 26.53 9.11 2.30 3.37 1.65 3.90 3.32 0.30 23.95 EMPLOYEE BENEFITS 431 - FICA Tax 432 - Unemployment & City Taxes 435 - Health & W/C Insurance 439 - Medical Expense 460 - Employee Training & Education TOTAL EMPLOYEE BENEFITS 3,241.60 707.31 1,422.35 50.00 0.00 5,421.26 27,919.91 3,791.05 7,270.35 861.00 100.00 39,942.31 3.92 0.86 1.72 0.06 0.00 6.55 2.88 0.39 0.75 0.09 0.01 4.12 DIRECT OPERATING EXPENSES 509 - Contract Cleaning & Contractors 510 - Tableware, Linen, & Silverwar 511 - Kitchen Utensils 512 - Menus & Drink Lists 513 - Flowers & Decorations 514 - Cleaning, Bar & Paper Supplie 517 - Music & Entertainment 548 - Permits & Licenses 583 - Uniforms 595 - Miscellaneous TOTAL DIRECT OPERATING EXP. 513.00 1,195.69 60.00 23.40 0.00 2,808.95 249.69 0.00 0.00 340.38 5,191.11 9,650.13 7,955.23 1,243.10 485.49 77.75 17,628.26 4,001.75 2,870.24 980.96 4,048.37 48,941.28 0.62 1.45 0.07 0.03 0.00 3.40 0.30 0.00 0.00 0.41 6.28 1.00 0.82 0.13 0.05 0.01 1.82 0.41 0.30 0.10 0.42 5.05 MARKETING 533 - Comps, Coupons & Discounts 534 - Advertising TOTAL MARKETING 6,698.18 0.00 6,698.18 66,418.80 1,469.35 67,888.15 8.10 0.00 8.10 6.85 0.15 7.00 ENERGY & UTILITY SERVICE 526 - Utilities 527 - Waste Removal TOTAL ENERGY & UTILITY 1,959.79 288.47 2,248.26 30,297.20 3,552.94 33,850.14 2.37 0.35 2.72 3.12 0.37 3.49 ADMINISTRATIVE & GENERAL 612 - Postage & Delivery 616 - Officer Salaries 629 - Telephone - Restaurant 635 - Liquor Liability Insurance 645 - Other Taxes 655 - Contributions 664 - Professional Fees 666 - Office - Printing & Supplies 667 - Bank & Merchant Charges 670 - Protective Services 0.00 3,168.00 317.17 0.00 0.00 40.00 945.84 548.33 1,040.44 124.00 237.01 47,388.00 3,666.04 2,730.00 45.00 40.00 9,697.20 4,319.21 13,155.87 244.00 0.00 3.83 0.38 0.00 0.00 0.05 1.14 0.66 1.26 0.15 0.02 4.89 0.38 0.28 0.00 0.00 1.00 0.45 1.36 0.03 See Accountants' Compilation Report Restaurant Op Stmt - Food & Bev Restaurant Client 123 Any Street St. Louis, MO 63000 December 31, 2000 OPERATING STATEMENT CURRENT PERIOD 680 - Dues & Subscriptions TOTAL ADMINISTRATIVE & GEN. TWELVE MONTHS CURR. % YTD % 21.95 6,205.73 508.40 82,030.73 0.03 7.50 0.05 8.46 REPAIRS & MAINTENANCE 530 - Repairs - Buildings 531 - Repairs - Equipment TOTAL REPAIRS & MAINTENANCE 20.00 568.88 588.88 2,268.67 7,285.58 9,554.25 0.02 0.69 0.71 0.23 0.75 0.99 OCCUPANCY COSTS 720 - Rent 721 - Equipment Rental 735 - Insurance - Building\\Contents 745 - Personal Property Tax TOTAL OCCUPANCY COSTS 5,198.74 99.00 0.00 0.00 5,297.74 63,491.94 1,234.91 4,997.56 2,416.28 72,140.69 6.28 0.12 0.00 0.00 6.40 6.55 0.13 0.52 0.25 7.44 INTEREST EXPENSE 950 - Interest TOTAL INTEREST EXPENSE 1,450.62 1,450.62 17,430.56 17,430.56 1.75 1.75 1.80 1.80 DEPRECIATION 775 - Depreciation - Fixtures & Equ 776 - Amortization - Leasehold Impr 778 - Amortization TOTAL DEPRECIATION 1,200.00 5.05 311.42 1,516.47 22,984.79 67.00 3,744.00 26,795.79 1.45 0.01 0.38 1.83 2.37 0.01 0.39 2.76 See Accountants' Compilation Report Restaurant Op Stmt - Food & Bev Restaurant Client 123 Any Street St. Louis, MO 63000 December 31, 2000 OPERATING STATEMENT See Accountants' Compilation Report Restaurant Op Stmt - Food & Bev
