Scribd Logo
Upload

Welcome to Scribd!

  • 13 views

    20XY-07 Monthly Budget Variance Report - July

    Uploaded by

    emmalainevinas

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    20XY-07 Monthly Budget Variance Report - July

    Uploaded by

    emmalainevinas
    13 views2 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    13 views2 pages

    20XY-07 Monthly Budget Variance Report - July

    Uploaded by

    emmalainevinas

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 2

    Monthly Budget Variance Rep

    for the month ended 31 Ju

    July 20XY 1st Quarter Results


    Revenue
    Budget Actual Variance Budget Actual Variance
    Total Room Nights Available 1,674 1,674 - 4,968 1,674 (3,294)
    Rooms Occupied 1,172 1,245 73 3,478 1,245 (2,233)
    Occupancy Rate 70% 74% 4% 70% 74%
    Room Revenue 309,126 327,782 18,656 917,407 327,782 (589,625)
    Restaurant Revenue 243,815 266,700 22,885 723,580 266,700 (456,880)
    Functions Revenue 40,208 48,253 8,045 120,625 48,253 (72,372)
    Total Revenues 593,150 642,735 49,585 1,761,612 642,735 (1,118,877)
    [42] [42] [42]

    [42]
    Cost of Sales
    Cost of Sales Rate to revenue 40% 41% 1% 40% 41% 1%
    Cost of Sales Food & Beverage 113,609 129,131 15,521 337,682 129,131 - 208,551
    Food (Fonly) 73,846 83,935 10,089 219,493 83,935 - 135,558
    Beverages - Soft Beverages 7,377 8,587 1,210 21,893 8,587 - 13,306
    Beverages - Liqour 1,054 1,356 302 3,128 1,356 - 1,772
    Beverages - Beer 10,222 11,751 1,529 30,337 11,751 - 18,586
    Beverages - Wine 12,225 14,011 1,786 36,280 14,011 - 22,269
    Bar Consumables 8,993 10,395 1,402 26,689 10,395 - 16,294
    Total Cost of Sales 113,717 130,035 16,318 337,820 130,035 (207,786)

    NET INCOME 479,433 512,700 33,268 1,423,792 512,700 (911,092)


    [42] [42] [42]

    [42]
    Expenses
    Rooms Related Expenses
    Commissions 3,091 3,278 187 9,174 3,278 (5,896)
    Laundry, Linen & Guest Supplies 9,892 10,489 597 29,357 10,489 (18,868)
    OPERA Cloud PMS system - - - - - -
    Food & Beverage Expenses
    Cleaning 1,200 1,200 - 3,600 1,200 (2,400)
    Miscellanous kitchen supplies 1,000 100 (900) 3,000 100 (2,900)
    Equipment Hire 5,000 5,000 - 15,000 5,000 (10,000)
    Equipment Maintenance Contracts 2,000 2,000 - 6,000 2,000 (4,000)
    Employee Related Expenses
    Salaries and wages 203,000 202,188 (812) 609,000 202,188 (406,812)
    Superannuation Gaurantee 20,300 20,219 (81) 60,900 20,219 (40,681)
    Uniforms 9,500 9,122 (378) 28,500 9,122 (19,378)
    Training & Development 6,000 5,622 (378) 18,000 5,622 (12,378)
    Other employee related expenses 2,500 1,225 (1,275) 7,500 1,225 (6,275)
    General Expenses
    Administration 15,000 12,110 (2,890) 45,000 12,110 (32,890)
    Accounting Fees - - - 10,000 - (10,000)
    Sales & Marketing 1,546 1,639 93 4,588 1,639 (2,949)
    Software 1,500 1,500 - 4,500 1,500 (3,000)
    Utilities 9,600 10,200 600 28,800 10,200 (18,600)
    Web hosting and domains 100 50 (50) 300 50 (250)
    Music and Entertainment 500 560 60 1,500 560 (940)
    External ICT Support 5,000 5,000 - 15,000 5,000 (10,000)
    Maintenance and repairs 15,715 12,300 (3,415) 47,145 12,300 (34,845)
    Insurance 2,500 2,500 - 7,500 2,500 (5,000)
    Interest expense 3,200 1,175 (2,025) 9,600 1,175 (8,425)
    Office supplies 2,000 2,000 - 6,000 2,000 (4,000)
    Telephone & Internet 2,500 2,030 (470) 7,500 2,030 (5,470)
    Printing & Stationery 1,500 1,443 (57) 4,500 1,443 (3,057)
    Other Expenses 17,460 16,778 (682) 52,380 16,778
    Total Expenses 341,604 329,727 (11,877) 1,034,344 329,727 (669,015)

    Net Income 137,829 182,973 45,144 389,448 182,973 (242,077)

    You might also like