Scribd Logo
Upload

Welcome to Scribd!

  • 28 views

    Sales Expected To Increase by 8%

    Uploaded by

    WiSeVirGo
    Sales were slightly under budget by 0.1% for the first quarter. Cost of goods sold was 1% over budget, resulting in gross profit being 3% under budget and gross profit percentage 1% lower than expected. Expenses were mixed with interest expenses 33% over budget but bank charges 5% under budget. Overall, results were slightly under budget for the quarter.

    Copyright:

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

    Sales Expected To Increase by 8%

    Uploaded by

    WiSeVirGo
    28 views11 pages
    Sales were slightly under budget by 0.1% for the first quarter. Cost of goods sold was 1% over budget, resulting in gross profit being 3% under budget and gross profit percentage 1% lower than expected. Expenses were mixed with interest expenses 33% over budget but bank charges 5% under budget. Overall, results were slightly under budget for the quarter.

    Original Title

    check

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Sales were slightly under budget by 0.1% for the first quarter. Cost of goods sold was 1% over budget, resulting in gross profit being 3% under budget and gross profit percentage 1% lower than expected. Expenses were mixed with interest expenses 33% over budget but bank charges 5% under budget. Overall, results were slightly under budget for the quarter.

    Copyright:

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

    Sales Expected To Increase by 8%

    Uploaded by

    WiSeVirGo
    Sales were slightly under budget by 0.1% for the first quarter. Cost of goods sold was 1% over budget, resulting in gross profit being 3% under budget and gross profit percentage 1% lower than expected. Expenses were mixed with interest expenses 33% over budget but bank charges 5% under budget. Overall, results were slightly under budget for the quarter.

    Copyright:

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

    Sales 2011/12 Qtr1

    Budget Total Budget 20%


    Sales expected to increase by 8%

    Total Sales 15714108 3394247.328


    16971236.64

    Bathroom Fitting 30% 5091370.992 1018274.1984

    Bedroom Fitting 25% 4242809.16 848561.832

    Mirrors 15% 2545685.496 509137.0992

    Decorative Items 10% 1697123.664 339424.7328

    Lighting Fixtures 20% 3394247.328 678849.4656

    Total Budget 20% 24% 26% 30%


    0.20000003 0.24000000509 0.25999999491 0.29999997455
    15714108 3142822 3771386 4085668 4714232
    Qtr2 Qtr3 Qtr4
    24% 26% 30%
    2008 2009 2010

    4073096.7936 4412521.5264 5091370.992 12474336 13472315 14550100


    Sales

    1221929.0381 1323756.4579 1527411.2976


    0.08000257 0.0799999852

    1018274.1984 1103130.3816 1272842.748


    COGS 7409773 8002555
    610964.51904 661878.22896 763705.6488 0.0800000216

    407309.67936 441252.15264 509137.0992 GP


    6062542 6547545

    814619.35872 882504.30528 1018274.1984


    GP margin 0.45000002 0.45

    3500
    18700

    15200
    2011

    15714108

    0.08

    8799900
    0.0996363

    6914208

    0.44000003

    3605
    19261

    15656
    Profit Budget 2011/12 Qtr1 Qtr2
    Revenue 20% 24%
    Sales 16971236.64 3394247.328 4073096.7936
    Cost Of Goods Sold 9673604.8848 1934720.977 2321665.172352
    Gross Profit 7297631.7552 1459526.351 1751431.621248
    Gross Profit % 43% 43% 43% 43%

    Expenses
    accounting Fees 10000 2500 2500
    Interest Expenses 84508 21127 21127
    Bank Charges 1600 400 400
    Depreciation 170000 42500 42500
    Insurance 13390 3347.5 3347.5
    Store Supplies Increase by 4% 3749.2 749.84 899.808
    Advertising 350000 200000 50000
    Cleaning 16282.24 3256.448 3907.7376
    Repairs & Maintenance 64272 16068 16068
    Rent 2640508 660127 609348
    Telephone 14996.8 2999.36 3599.232
    Electricity Expense 26780 5356 6427.2
    Luxury Car Tax 12000 12000
    Fringe Benefits Tax 28000 7000 7000
    Superannuation 187020 37404 44884.8
    Wages & Salaries 2078000 415600 498720
    Payroll Tax 98705 19741 23689.2

    Workers' Compensation 41560 8312 9974.4

    Total Expenses 5841371.24 1458488.148 1344392.8776


    Net Profit (Before Tax) 1456260.5152 1038.20304 407038.743648
    Income Tax@30% 436878.15456 311.460912 122111.6230944
    Net Profit 1019382.3606 726.742128 284927.1205536
    Qtr3 Qtr4
    26% 30%
    4412521.5264 5091370.992
    2515137.27 2902081.4654
    1897384.2564 2189289.5266
    43% 43%

    2500 2500
    21127 21127
    400 400
    42500 42500
    3347.5 3347.5
    974.792 1124.76
    50000 50000
    4233.3824 4884.672
    16068 16068
    660127 761685
    3899.168 4499.04
    6962.8 8034

    7000 7000
    48625.2 56106
    540280 623400
    25663.3 29611.5

    10805.6 12468

    1444513.7424 1644755.472
    452870.51395 544534.05456
    135861.15419 163360.21637
    317009.35977 381173.83819
    Cash Flow Analysis GST 2011/12 Qtr1 Qtr2
    Sales percentage 20% 24%
    GST Collected 16971236.64 1697123.664 339424.7328 407309.67936
    Less GST Paid
    COGS 967360.48848 193472.097696 232166.51724
    Accounting Fee 1000 250 250
    Insurance 1339 334.75 334.75
    store supplies 374.92 74.984 89.9808
    advertsing 35000 20000 5000
    cleaning 1628.224 325.6448 390.77376
    repairs and maintenance 6427.2 1606.8 1606.8
    rent 264050.8 66012.7 60934.8
    telephone 1499.68 299.936 359.9232
    electricity expense 2678 535.6 642.72
    Luxury car tax 9747

    GST Paid 1291105.31248 282912.512496 301776.264995


    GST Payable 406018.35152 56512.220304 105533.414365
    Cash Flow Analysis
    Qtr3 Qtr4 2011/12
    GST
    26% 30% Sales percentage
    441252.153 509137.0992 GST Collected 16971236.64 1697124
    Less GST Paid
    251513.727 290208.14654 9673605
    250 250 Accounting Fee 10000
    334.75 334.75 Insurance 13390
    97.4792 112.476 store supplies 3749.2
    5000 5000 advertsing 350000
    423.33824 488.4672 cleaning 16282.24
    1606.8 1606.8 repairs and maintenance 64272
    66012.7 76168.5 rent 2640508
    389.9168 449.904 telephone 14996.8
    696.28 803.4 electricity expense 26780
    9747

    326324.9912 385169.443744
    114927.1614 123967.655456
    Qtr1 Qtr2 Qtr3 Qtr4

    1934721 2321665 2515137 2902081


    2500 2500 2500 2500
    3347.5 3347.5 3347.5 3347.5
    749.84 899.808 974.792 1124.76
    200000 50000 50000 50000
    3256.448 3907.738 4233.382 4884.672
    16068 16068 16068 16068
    660127 609348 660127 761685
    2999.36 3599.232 3899.168 4499.04
    5356 6427.2 6962.8 8034
    Aged Debtors Budget Total Qtr1

    Sales 16971236.64 3394247.328


    % Debtors Sales 20%
    Total Debtors 678849.4656
    Current
    30 Days 10% 67884.94656
    60 Days 5% 33942.47328
    90 Days 1% 6788.494656
    Qtr2 Qtr3 Qtr4

    4073096.7936 4412521.5264 5091370.992


    20% 20% 20%
    814619.35872 882504.30528 1018274.1984

    81461.935872 88250.430528 101827.41984


    40730.967936 44125.215264 50913.70992
    8146.1935872 8825.0430528 10182.741984
    Houzit Pty Ltd
    Variance to Budget
    First Quarter ended 30 September 2011

    $ %
    Actual Results Budget-Q1 Actual Q1 F or U
    Variance Variance

    Sales 3,394,247 3,371,200 ### 0% U


    - Cost of Goods
    1,934,721 1,955,296 20,575 1% U
    Sold
    Gross Profit 1,459,526 1,415,904 -43,622 -3% U
    Gross Profit % 43% 42% 0% -1% U
    Expenses
    - Accounting Fees 2,500 2,500 0 0% -
    - Interest Expense 21,127 28,150 7,023 33% U
    - Bank Charges 400 380 -20 -5% F
    - Depreciation 42,500 42,500 0 0% -
    - Insurance 3,348 3,348 0 0% -
    - Store Supplies 750 790 40 5% U
    - Advertising 200,000 150,000 -50,000 -25% F
    - Cleaning 3,256 3,325 69 -2% U
    - Repairs &
    16,068 16,150 82 1% U
    Maintenance
    - Rent 660,127 660,127 0 0% -
    - Telephone 2,997 3,100 101 3% U
    - Electricity
    5,356 5,245 -111 -2% F
    Expense
    - Luxury Car Tax 12,000 12,000 0 0% -
    - Fringe Benefits
    7,000 7,000 0 0% -
    Tax
    - Superannuation 37,404 37,404 0 0% -
    - Wages & Salaries 415,600 410,500 -5,100 -1% F
    - Payroll Tax 19,741 19,741 0 0% -
    - Workers
    8,312 8,312 0 0% -
    Compensation
    Total Expenses 1,458,488 1,410,572 -47,917 -3% F
    Net Profit (Before
    1,038 5,333 4,294 414% F
    Tax)
    Income Tax 311 1,600 1,288 414% U
    Net Profit 7,27 3,733 3,006 414% F

    You might also like