Budget Variance Report

Budget Variance Report

A.    Issues

Issues can be identified based on the below budget variance reports:

Preparation of budget variance report

Houzit Pty Ltd 
Variance to Budget 
First Quarter ended Sep 2011 
 Actual ResultsBudget-1st QActual-1st Q$ Variance% VarianceF or U
 Sales3,394,2473,371,200(23,047)-1U
 – Cost Of Goods Sold1,934,7211,955,29620,5751U
 Gross Profit1,459,5261,415,904(43,622)-3U
 Gross Profit %43%42%0-2U
 Expenses     
 Accounting Fees2,5002,50000F
 Interest Expense21,12728,1507,02333U
 Bank Charges400380(20)-5F
 Depreciation42,50042,50000F
 Insurance3,3483,34800F
 Store Supplies750790405U
 Advertising200,000150,000(50,000)-25F
 Cleaning3,2563,325692U
 Repairs & Maintenance16,06816,150821U
 Rent660,127660,1270F
 Telephone2,9993,1001013U
 Electricity Expense5,3565,245(111)-2F
 Luxury Car Tax12,00012,00000F
 Fringe Benefits Tax7,0007,00000F
 Superannuation37,40437,40400F
 Wages & Salaries415,600410,500(5,100)-1F
 Payroll Tax19,74119,74100F
 Workers’ Compensation8,3128,31200F
 Total Expenses1,458,4881,410,572(47,917)-3F
 Net Profit (Before Tax)1,0385,3334,294414F
 Income Tax3111,6001,288414U
 Net Profit7273,7333,006413F
        

Debtors ageing ratio

 2009/102010/112011/12
Trade Debtors850,000975,0001,118,325
Sales14,550,10015,714,10816,971,237
Debtor Days212224

 

Figure- Debtor Days

From the above budget variance report, it is identified that there are different issues concerned with the variance of budget and actual results in the company. It is because it has a difference in the value of budget and actual results and the sales are also declined as per the budgeted value. This variance may affect the firm’s financial performance.

B.    Performance

Budget Variance Report

Financial performance

From the above analysis, it is determined that the organization is performing well at the industry level. It is because the actual net profit of Houzit in the first quarter is more as compared of budgeted net profit and included variance with the amount of $3006 (Arnaboldi et al., 2015.).

In addition to this, the gross profit rate of the firm is 42% that is more as per the retail industry gross profit rate such as 25%. During the period, Houzit is also able to produce sufficient sales and profits with the increasing trends.

Additionally, the wages and salaries have the industry average of 11% but in this part, the company has a little more with 12.2% as a sales percentage (Banerjee and Katul, 2013). The advertisement expenses also saved $50000 that increases the net profit of the company in comparison to gross profit.

Responses to performance questions

The board of Houzit provided the proper responses to the performance questions that are provided by the CEO. In which, the company has financial visibility according to the profit of the first quarter because this quarter is a seasonally slowest quarter over the year (Bititci et al., 2012).

In addition to this, the gross profit margins can be maintained as per the variance report because of the gross profit margin something like the budget. So, it can be said that the organization is able to maintain the gross profit margins.

Determination of trend of average debtor days

According to this variance report, it is identified that the financial parameter of Houzit has an increasing trend. The gross profit and sales of the company showing increasing trend so it is impacting on the cash flow.

The determination of average debtor days is also in the increasing trend in the financial years from 2009/10 to 2011/12 (Tessier and Otley, 2012). It shows that the company is providing relaxation in the credit policy where the customer can repay the credit amount on some extra days.

This may impact on the sales and the credit sales would increase. Additionally, it would impact on the cash flow where the company may face the cash issue.

C.    Recommendations

On the basis of the above situation, it can be suggested to the firm that there is a need of adoption of better policies for a reduction in the gross profit variances, sales variances and net profits variances (Bedford, 2015.).

For this, it is suggested that the firm should focus on the cost reduction strategy that would control the operational cost and also minimize the cost of reduction. At the same time, the firm should increase the sales by using the aggressive marketing for improving the financial performance.

It is also recommended to the organization that it should monitor and report on the monthly basis for a better result.

D.    Evaluation

From the above financial analysis, it is evaluated that an organization develops the budgets for properly allocating the resources and get the competitive advantages in the industry.

In addition to this, budgets are prepared to determine the flow of cash and managing the cash in the organization (Grabner and Moers, 2013). The variance analysis identifies the gap between budget and actual results so that the organization can fill the gap for improving the financial performance by adopting the best strategy.

It is also evaluated that the firm must focus on the development of competitive position by reduction in the cost of goods sold and operational costs.

References

Arnaboldi, M., Lapsley, I. and Steccolini, I., 2015. Performance management in the public sector: The ultimate challenge. Financial Accountability & Management31(1), pp.1-22.

Banerjee, T. and Katul, G.G., 2013. Logarithmic scaling in the longitudinal velocity variance explained by a spectral budget. Physics of Fluids25(12), p.125106.

Bedford, D.S., 2015. Management control systems across different modes of innovation: Implications for firm performance. Management Accounting Research28, pp.12-30.

Bititci, U., Garengo, P., Dörfler, V. and Nudurupati, S., 2012. Performance measurement: challenges for tomorrow. International journal of management reviews14(3), pp.305-327.

Grabner, I. and Moers, F., 2013. Management control as a system or a package? Conceptual and empirical issues. Accounting, Organizations and Society38(6-7), pp.407-419.

Tessier, S. and Otley, D., 2012. A conceptual development of Simons’ Levers of Control framework. Management Accounting Research23(3), pp.171-185.

 

Leave a Comment