SALES AND PROFIT BUDGET REPORT
Houzit Ptd Ltd
END OF YEAR JULY 30,2012
PROFIT BUDGET 2011/2012 Quarter 1 Quarter 2 Quarter 3 Quarter 4
Revenue
Sales $15,714,108.00 $3,142,822.00 $3,771,386.00 $4,085,668.00 $4,74,232.00
Bathroom Fit. $4,714,232.40 $942,846.60 $1,131,415.00 $1,225,700.40 $1,414,269.60
Bedroom Fit. $3,928,527.00 $785,705.50 $942,846.50 $1,021,417.00 $1,178,558.00
Mirrors $2,357,116.20 $471,423.30 $565,707.90 $612,850.20 $707,134.80
Décor. Items $1,571,410.80 $314,282.20 $377,13.60 $408,566.80 $471,423.20
Lighting Fixtures $3142821.60 $628,564.40 $754,277.20 $817,133.60 $942,846.40
Cost of Goods Sold $8,799,900.00 $1,759,980.00 $2,111,976.00 $2,287,974.00 $2,639,970.00
Gross Profit $6914208.00 $1,382,842.00 $1,659,410.00 $1,797,694.00 $2,074,262.00
…show more content…
It is working efficiently within its resources and does not require any additional funds from outside resources for its operations. The company has a good plan to pay off its debt by applying the company’s profits to repay the long term debt, which will lower the company’s incidental expenses relating to it.
b. Will we be able to maintain our gross profit margins in the predicted downturn?
Yes, the company will be able to maintain its steady gross profit rate by maintaining its set budget and operating within the limits of its resources.
c. Determine a trend of the average debtor days and the impact to the cash flow of Houzit.
The average debtor days according to the company’s aged debtors is 73, which means it takes a long time for company to receive its payment for the goods and services provided. It will eventually influence the company’s cash flow statement.
D. RECOMMENDATIONS:
Keep the sales price at its current amount and continue to maintain an average cost of sales turnover within its industry’s benchmark limit.
In order to lower the company’s expenditure and the rate of high payroll tax, worker’s compensation and superannuation which is directly proportional to its expense account, the company must ensure that the wages and salaries and expenditures of the company are within the industry’s benchmark
…show more content…
So the company must encourage debtors to pay promptly by providing an incentive for early payment of debts.
According to the rent expense turnover, the company is paying a higher amount than it can cover with its operations. So, a new contract should and agreement must be created and the property owner must settle the rent expense paid by the company.
In the future budget plan, the expected sales must be calculated within the reasonable margin based on previous performance of the company. To ensure that the projected budget will be close to the actual performance of the company; inflation and the season must be considered as
For example interest rates, the cost of raw materials including fuel, the number of sales or orders that we make and in turn all of these rely on other factors. The best therefore that can be done when developing a budget is to look at all the factors that are likely to affect the budget and decide how to take account of each one. If there is a previous budget (last year or last month) then it is sensible to look at how this has been achieved or not as the case may be, and what factors affected the outcome. If we are looking at monthly budgets it might be a better comparison to look at the same month twelve months ago as well as the previous months. The more factors we take into consideration when estimating a budget, the more accurate our budget will be.
While it is true that Ms. Forthright had always exceeded her budgeted sales, the extent to which she diverts away from the managers projections does not necessarily means that she is violating honesty and integrity. Her decision on what her budgeted sales for the year is highly relevant to the data available to her. Her projections tends to lie between the field manager and the marketing manager’s predictions, which can be reasonable because in the past years, the field manager’s projections tend to be over what the actual sales of the year will be.
3. Explain two methods that can be used in order to identify realistic estimations when developing a budget. [2.2]
As indicated by the scenario it seems that the decision problem is a matter if the accounting systems annual conference that is previously scheduled to occur on September 13-16,2005 should be canceled, due to the fact Hurricane Katrina has occurred and demolished building and homes leaving them in ruin in the city of New Orleans, Louisiana. The primary issue thus becomes does the board or committee moves the conference to a future date or have conference at another location that would thus incur higher costs for hotel for patrons of the conference in addition to it would be a price increase for flights that were already scheduled to New
* Our company’s sales forecast has been based on performance from previous years along with market circumstances. We are looking at the future of the business objectively which we then can evaluate past to
As a first step in the budget process, sales forecasting allows for other budgets to be planned on sales activities. Purchases and production, for example, depend on the forecasted sales and subsequent inventory levels to be managed. The operating expenses are then budgeted as a result of the sales budget and expected costs of purchasing and production (materials, labor, manufacturing) as a measure of Cost of Good's Sold.
The central challenge that budget developers encounter is predicting what the future holds for the internal business and external factors. Reading the future is something that can never be done with perfect precision. The fast pace of technological change, the complexities of global competition and world events make developing effective budgets both more difficult and more important.
The company’s debt ratios are 54.5% in 1988, 58.69% in 1989, 62.7% in 1990, and 67.37% in 1991. What this means is that the company is increasing its financial risk by taking on more leverage. The company has been taking an extensive amount of purchasing over the past couple of years, which could be the reason as to why net income has not grown much beyond several thousands of dollars. One could argue that the company is trying to expand its inventory to help accumulate future sales. But another problem is that the company’s
Also, according to its leverage ratios, the company’s debts are not only very high, but are also increasing. Its decreasing TIE ratio indicates that its capability to pay interests is decreasing. The company’s efficiency ratios indicate that despite the fact that its fixed assets are increasingly being utilized to generate sales during the years 1990-1991 as indicated by its increasing fixed asset turnover ratio, the decreasing total assets turnover indicate that overall the company’s total assets are not efficiently being put to use. Thus, as a whole its asset management is becoming less efficient. Last but not the least, based on its profitability ratios, the company’s ability to make profit is decreasing.
The Gross profit margin stays relatively constant at around 36 %. However, there is a slight rise from 2000 to 2004.
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.
1. Currently, the collection period of Oracle is at 137 days which is higher than the industry average of 62 days. The company must reduce credit terms implementing tighter credit control activities
Planning system weaknesses: To begin with, fundamental assumptions, such as new plants, inventory carryovers, packaging trends, etc., which are used for initial sales forecast, are entirely made by corporate headquarters. However, the divisional managers assume full responsibility for the estimates they submitted to the corporate head office. As a result, they have to make efforts to increase the overall accuracy of forecast and avoid making changes in subsequent reviews of the budget. Moreover, each product line uses the same forecasting method. It is ineffective for the company to make accurate budget since factors affecting each product line are different, such as industry trends, customer preferences and so on. Lastly, instead of plant managers, the district sale managers raise the sales budgets. However, the plant managers are held accountable for this budgeted profit number, which is connected with their performance and is not controlled by them.
Budget and budgetary control practices are undeniably indispensable as organizations routinely go about their business activities and operations. These organizations are constantly on the alert on how actual levels of performance agree with planned or budgeted performance. A budget expresses a plan in monetary terms. It is prepared and approved prior to a particular budgeted period and explicitly may show the income, expenditure and the capital to be employed by organizations in achieving their goals and objectives.
Many businesses expect employees to achieve budget targets as part of their overall performance. While the specifics requirements of each employee differ with the position and nature of the company, it is common for employees to be expected to sell a certain number of items, control costs versus a budgeted amount or reduce waste compared with a benchmark. A potential downfall of using budget information for performance evaluation is that employees may be so concerned with making budget targets that they may do so at the cost of other parts of the business.