Cash Budget and Report Analysis
Introduction
For this piece of assignment, a cash budget will be made for Doomy Corporation for the second quarter of the year. For this budget, all the sales figures for the second quarter and some of the expenditure have been given. Hence, to prepare a cash budget, the sales figure given will be used and some calculations will be worked out in order to fully prepare an outstanding budget for Doomy Corporation the following information will be used efficiently.
“Doomy Corporation, a rapidly expanding specialist photocopier manufacturer, is in the process of formulating plans for next year. The director of marketing has completed his sales budget and is confident that sales estimates will be met or exceeded. The following budgeted sales figures show the growth expected and will provide the planning basis for other corporate departments”.
Sales figures of (April £2 200 000, May £2 500 000 and June £2 800 000)
The rest of the budget was calculated from the information below:
Doomy Corporation has experienced an excellent record in debtors’ (accounts receivable) collection and expects this trend to continue. 60% of billings are collected in the month after the sale and 40% in the second month after the sale. The purchase of raw materials is Doomy’s largest expenditure; the cost of these items equals 50% of sales. 60% of the raw materials are received and paid in the month they are purchased and 40% are paid in the second month of purchase. Hourly wages depend on sales volume and are equal to 20% of the current month’s sales. General and administrative expenses are budgeted to be £2 640 000 for the year. Salaries £480 000, Promotion £660 000, Property taxes £240 000, Insurance £360 000, Utilities£300 000 and Depreciation £600 000.
Corporation tax payments are made by Doomy in the first month of each quarter based on the profit for the prior quarter. Doomy’s tax rate is 40%. Doomy’s taxable profit for the first quarter is projected to be £612 000. Equipment and
For this piece of assignment, a cash budget will be made for Doomy Corporation for the second quarter of the year. For this budget, all the sales figures for the second quarter and some of the expenditure have been given. Hence, to prepare a cash budget, the sales figure given will be used and some calculations will be worked out in order to fully prepare an outstanding budget for Doomy Corporation the following information will be used efficiently.
“Doomy Corporation, a rapidly expanding specialist photocopier manufacturer, is in the process of formulating plans for next year. The director of marketing has completed his sales budget and is confident that sales estimates will be met or exceeded. The following budgeted sales figures show the growth expected and will provide the planning basis for other corporate departments”.
Sales figures of (April £2 200 000, May £2 500 000 and June £2 800 000)
The rest of the budget was calculated from the information below:
Doomy Corporation has experienced an excellent record in debtors’ (accounts receivable) collection and expects this trend to continue. 60% of billings are collected in the month after the sale and 40% in the second month after the sale. The purchase of raw materials is Doomy’s largest expenditure; the cost of these items equals 50% of sales. 60% of the raw materials are received and paid in the month they are purchased and 40% are paid in the second month of purchase. Hourly wages depend on sales volume and are equal to 20% of the current month’s sales. General and administrative expenses are budgeted to be £2 640 000 for the year. Salaries £480 000, Promotion £660 000, Property taxes £240 000, Insurance £360 000, Utilities£300 000 and Depreciation £600 000.
Corporation tax payments are made by Doomy in the first month of each quarter based on the profit for the prior quarter. Doomy’s tax rate is 40%. Doomy’s taxable profit for the first quarter is projected to be £612 000. Equipment and
References: Abrams, J. H. (1982) the limitations of budgeting analysis (abstract) the government accounts journal (e-version) Arlington spring 1982. Vol. 31, iss, 1 pg 31, 7 pgs IMF (2001), Government Finance Statistics Manual 2001 (GFSM 2001), International Monetary Fund, Washington DC. Doh, J. C. (1971). The planning-programming-budgeting systems in three federal agencies. Manchester, NH: Irvington . E. J. Mclaney (1991) business finance for decision makers, mixed decisions chapter 4. Pg 314 http://www.accountingformanagement.com/cash_budget.htm David L. Fraley (1998) Financial Decision-making: Peter Atrill and Eddie McLaney, "Accounting and Finance for Non-Specialists" (Prentice Hall 1997) Leopold Bernstein and John Wild, "Analysis of Financial Statements" (McGraw-Hill 2000)