Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    Complete Spreadsheet 1

    Uploaded by

    asusv86204

    Copyright:

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

    Complete Spreadsheet 1

    Uploaded by

    asusv86204
    4 views5 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
    4 views5 pages

    Complete Spreadsheet 1

    Uploaded by

    asusv86204

    Copyright:

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

    King Edward VII College Pty Ltd

    ABN 012 444 555

    Income Certificate III in International Trade $ 75,000.00


    Certificate IV in International Trade $ 125,000.00
    Diploma of International Trade $ 150,000.00
    Total $ -

    Expenditure Accounting fees $ 12,000.00


    Advertising fees $ 10,000.00
    Computer software $ 1,000.00
    Electricity $ 1,500.00
    Insurance $ 4,800.00
    Internet $ 1,300.00
    Office supplies $ 2,700.00
    Printing $ 2,200.00
    Rent $ 60,000.00
    Repairs and maintenance $ 3,200.00
    Salaries $ 195,000.00
    Superannuation expenses $ 20,000.00
    Telephone $ 2,500.00
    Travel $ 2,100.00
    Total $ 318,300.00

    Profit Budget figure $ 31,700.00


    King Edward VII College Pty Ltd
    ABN 012 444 555

    Annual budget
    Income Certificate III in International Trade $ 75,000.00

    Certificate IV in International Trade $ 125,000.00

    Diploma of International Trade $ 150,000.00

    Total $350,000.00

    Expenditure Accounting fees $ 12,000.00

    Advertising fees $ 10,000.00

    Computer software $ 1,000.00

    Electricity $ 1,500.00

    Insurance $ 4,800.00

    Internet $ 1,300.00

    Office supplies $ 2,700.00

    Printing $ 2,200.00

    Rent $ 60,000.00

    Repairs and maintenance $ 3,200.00

    Salaries $ 195,000.00

    Superannuation expenses $ 20,000.00

    Telephone $ 2,500.00

    Travel $ 2,100.00

    Total $318,300.00

    Profit Budget figure $236,730.00


    Projected values Total annual budget-total expenditure for three months
    $318,300.00 - 81,75.00 = $236,730.00

    Total monthly budget-total expenditure for three months


    166,396.00 - $81,570.00 = $84,826.00
    Actual monthly figures and variations to budget
    Monthly budget JUL AUG SEP Totals
    $ 6,250.00 $ 9,000.00 $ 7,500.00 $10,500.00 $108,250.00
    difference
    $ 10,146.67 $12,500.00 $20,000.00 $16,000.00
    difference $183,646.00
    $ 150,000 $21,000.00 $30,000.00 $33,000.00
    difference $384,000.00
    $166,396.00
    difference

    $ 1,000.00 $ 4,000.00 $ 2,000.00 $ -


    difference
    $ 833.33 $ 1,000.00 $ 1,500.00 $ 1,000.00
    difference
    $ 83.33 $ 500.00 $ - $ -
    difference
    $ 125.00 $ 300.00 $ 300.00 $ 250.00
    difference
    $ 400.00 $ 400.00 $ 400.00 $ 400.00
    difference
    $ 108.33 $ 150.00 $ 200.00 $ 150.00
    difference
    $ 225.00 $ 200.00 $ 400.00 $ 250.00
    difference
    $ 183.33 $ 270.00 $ 300.00 $ 150.00
    difference
    $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00
    difference
    $ 266.67 $ 400.00 $ 300.00 $ 700.00
    difference
    $ 16,250.00 $13,000.00 $13,000.00 $13,000.00
    difference
    $ 1666.67 $ 1,500.00 $ 1,500.00 $ -
    difference
    $ 208.33 $ 4,500.00 $ 500.00 $ 550.00
    difference
    $ 175.00 $ - $ 3,000.00 $ 500.00
    difference
    $26,524.99
    difference

    $84,826.00 $31,220.00 $28,400.00 $21,950.00


    difference

    You might also like