hi?

Right now, I need report detailing the issues, variances, performance, recommendations and evaluations identified from the financial information for Houzit Pty Ltd.

Houzit Pty Ltd Variance to Budget xxx Quarter ended mmm-yyy Actual results Sales less cost of goods sold Gross profitet sales Gross profit % Expenses Accountant fees Loan repayment Advertising Bank charges Interest expense Electricity Expense Depreciation Telephone Store supplies Cleaning Rent & rates Repairs & maintenance Fringe benefits Tax Insurance Superannuation Wages&Salaries Luxury Car Tax Payroll Tax Workers' Compensation Total expenses Net profit /Before Tax/ Income tax NET PROFIT Assumptions: All figures are GST inclusive. Budget Qx Actual Qx $3,360,640.99 $1,881,959.00 $1,478,681.99 44% $3,371,200 $1,955,296 $1,415,904 42% $2,500.00 $0.00 $200,000.00 $400.00 $21,127.00 $5,356.00 $42,500.00 $2,999.36 $749.84 $3,256.45 $660,127.00 $16,068.00 $7,000.00 $3,347.50 $37,404.00 $415,600.00 $8,040.95 $19,741.00 $8,312.00 $1,454,529.10 $24,152.89 $7,245.87 $16,907.02 $2,500 $0 $150,000 $380 $28,150 $5,245 $42,500 $3,100 $790 $3,325 $660,127 $16,150 $7,000 $3,348 $37,404 $410,500 $12,000 $19,741 $8,312 ### $5,332.00 $1,599.60 $3,732.40 Variance $ $10,559.01 $73,337.00 -$62,777.99 -2% $0.00 $0.00 $0.00 -$50,000.00 -$20.00 $7,023.00 -$111.00 $0.00 $100.64 $40.16 $68.55 $0.00 $82.00 $0.00 $0.50 $0.00 -$5,100.00 $3,959.05 $0.00 $0.00 -$43,957.10 -$18,820.89 -$5,646.27 -$13,174.62 Favorable Unfavorable yy Variance % F or U 0.31% Favorable 3.90% Unfavorable -4.25% Unfavorable -4.55% Unfavorable 0.00% -25.00% Favorable -5.00% Favorable 33.24% -2.07% Favorable 0.00% 3.36% Unfavorable 5.36% Unfavorable 2.11% Unfavorable 0.00% 0.51% Unfavorable 0.00% 0.01% 0.00% -1.23% Favorable 49.24% Unfavorable 0.00% 0.00% -3.02% Favorable -77.92% Unfavorable -77.92% -77.92% Unfavorable Debtor ageing ratio template Trade Debtors Sales Deptor days 2009/10 2010/11 Growth 2011/12 $850,000 $975,000 15% $1,118,382 $14,550,100 $15,714,108 8% $16,803,205 21 23 24 21.3 Profit & Loss for [Houzit Pty LTD] as at [2011/2012] PROFIT & LOSS Q1 $0 Sales $3,371,200 less cost of goods sold $1,955,296 More... Gross profitet sales Gross profit % $1,415,904 42% Expenses Accountant fees $2,500 Loan repayment $0 Advertising Bank charges Interest expense Electricity Expense Depreciation Telephone Store supplies Cleaning Rent & rates Repairs & maintenance Fringe benefits Tax Insurance Superannuation Wages&Salaries Luxury Car Tax Payroll Tax Workers' Compensation Total expenses Net profit /Before Tax/ Income tax NET PROFIT Assumptions: All figures are GST inclusive. $150,000 $380 $28,150 $5,245 $42,500 $3,100 $790 $3,325 $660,127 $16,150 $7,000 $3,348 $37,404 $410,500 $12,000 $19,741 $8,312 $1,410,572 $5,332 $1,600 $3,732 011/2012]