Explanation of Sales Budget For Hampton Freeze Inc
Explanation of Sales Budget For Hampton Freeze Inc
Explanation of Sales Budget For Hampton Freeze Inc
Sales Budget
For the Year Ended December 31, 2003
Quarter
1 2 3 4 Year
70% 30%
1 2 3 4 Year
Budgeted sales (see sales budget) 10,000 30,000 40,000 20,000 100,000
Add desired ending inventory of finished goods* 6,000 8,000 4,000 3,000 3,000
*Twenty percent of the next quarters sales. The ending inventory of 3,000 cases is assumed
**The beginning inventory in each quarter is the same as the prior quarter's ending inventory
Pay particular attention to the year column to the right of the production budget in
the example. In some cases (e.g., budgeted sales, total needs, and required
production), the amount listed for the year is the sum of the quarterly amounts for
the item. In other cases (e.g., desired inventory of finished goods and beginning
inventory of finished goods), the amount listed for the year is not simply the sum of
the quarterly amounts. From the standpoint of the entire year, the beginning
inventory of finished goods is the same as the beginning inventory of finished goods
for the first quarter--it is not the sum of the beginning inventories of the finished
goods for all quarters. Similarly, from the standpoint of the entire year, the ending
inventory of finished goods is the same as the ending inventory of finished goods for
the fourth quarter--it is not the sum of the ending inventories of finished goods for
all four quarters.
Quarter
Add receipts:
Collections from customers See sales budget 230,000 480,000 740,000 520,000 1,970,000
Less disbursements:
Financing:
**The interest payment relate only to the the principle being repaid at the time it is
repaid. For example, the interest in quarter 3 relates only to the interest due on the
$100,000 principle being repaid from quarter 1 borrowing:
The cash budget is prepared one quarter at a time, starting with the first quarter.
Management began the cash budget by entering the beginning balance of cash for
the first quarter of $42,500--a number that is given above. Receipts--in this case,
just the $230,000 in cash collection from customers--are added to the beginning
balance to arrive at the total cash available of $272,500. Since the total
disbursements are $352,500 and the total cash available is only $272,500, there is
short fall of $80,000. Since management would like to have a beginning cash
balance of at lease $40,000 for the second quarter, the company would need to
borrow $120,000.
The second quarter of cash budget is handled similarly. Note that the ending cash
balance of the first quarter is brought forward as the beginning cash balance for the
second quarter. Also note that additional borrowing is required in the second quarter
because of the continued cash shortfall.
In third quarter, the cash flow situation improves dramatically and the excess of cash
available over disbursement is $148,000. This makes it possible for the company to
repay part of its loan from the bank, which now totals $180,000. How much can be
repaid? The total amount of the principle and interest that can be repaid is
determined as follows:
Total maximum feasible loan payments at the end of the third quarter
Excess of cash available over disbursement $148,000
Less desired ending cash balance 40,000
-------------
Maximum feasible principle and interest payment $108,000
======
The next step--figuring out the exact amount of loan payment--is tricky since
interest must be paid on the principle amount that is repaid. In this example, the
principle amount that is repaid must be less than $108,000, so we know that we
would be paying of part of the loan that was taken out at the beginning of the first
quarter. Since the repayment would be made at the end of the third quarter, interest
would have accrued for three quarters. So the interest owed would be 3/4 of 10% or
7.5%. Either a trial and error or an algebraic approach will lead to the conclusion
that the maximum principle repayment that can be made is $100,000. The interest
payment would be 7.5% of this amount, or $7,500--making the total payment
$107,500.
In the fourth quarter, all of the loan and accumulated interest are paid off. If all
loans are not repaid at the end of the year and budgeted financial statements are
prepared, then interest must be accrued on the unpaid loans. This interest will not
appear on the cash budget (since it has not yet been paid), but it will appear as
interest expense on the budgeted income statement and as a liability on the
budgeted balance sheet.
As with the production budget and raw materials budget, the amounts under the
year column in the cash budget are not always the sum of the amounts for the four
quarters. In particular, the beginning cash balance for the year is the same as the
beginning cash balance for the first quarter and the ending cash balance for the year
is the same as the ending cash balance for the fourth quarter.
Quarters
Year 4 3 2 1
40,400 7,600 14,400 12,800 5,600 (Budgeted direct labor hours (see direct labor budget
$4.00 $4.00 $4.00 $4.00 $4.00 Variable overhead rate
$344,000 $76,000 $103,200 $96,800 $68,000 Cash disbursement for manufacturing overhead
------------
At Hampton Freeze the manufacturing overhead is spread into variable and fixed
components. The variable component is $4 per direct labor-hour and the fixed
component is $60,600 per quarter. Because the variable component of the
manufacturing overhead depends on direct labor, the first line in the manufacturing
overhead budget consists of the budgeted direct labor hours from the direct labor
budget (see direct labor budget). The budgeted direct labor hours in each quarter
are multiplied by the variable rate to determine the variable component of the
manufacturing overhead. For example, the the variable manufacturing overhead for
the first quarter is $22,400 (5,600 direct labor hours × $4.00 per direct labor-hour).
This is added to the fixed manufacturing overhead for the quarter to determine the
total manufacturing overhead for the quarter. The total manufacturing overhead for
the first quarter is $83,000 ($22,400 + $60,600).
A few words about fixed costs and the budgeting process are in order. In most cases,
fixed costs are the costs of supplying capacity to do things like make products,
process purchase orders, handle customer calls, and so on. The amount of capacity
that will be required depends on the expected level of activity for the period. If the
expected level of activity is greater than the company's current capacity, then fixed
costs may have to be increased. Or, if the expected level of activity is appreciably
below the company's current capacity, then it may be desirable to decrease fixed
costs if that is possible. However once the level of fixed cost has been determined in
the budget, the costs really are fixed. The time to adjust fixed costs is during the
budgeting process. To determine the appropriate level of fixed costs at budget time,
an activity based costing system may be very helpful. It can help answer questions
like, "How many clerks will we need to hire to process the anticipated the number of
purchase orders next year?" For simplicity, we assume in all of the budgeting
examples that appropriate fixed costs has already been determined for the budget
with the aid of activity based costing system or some other method.
The last line in the manufacturing overhead budget for Hampton Freeze Inc. shows
that its budgeted cash disbursement for manufacturing overhead. Since, some of
the overhead costs are not cash outflows, the total budgeted manufacturing
overhead costs must be adjusted to determine the cash disbursements for
manufacturing overhead. At Hampton Freeze, the only significant non-cash
manufacturing overhead cost is depreciation, which is $15,00 per quarter. These
non-cash depreciation charges are deducted from the total budgeted manufacturing
overhead to determine the expected cash disbursements. Hampton Freeze Inc. pays
all overhead costs involving the cash disbursements in the quarter incurred. Note
that the company's predetermined overhead rate for the year will be $10 per direct
labor hour, which is determined by dividing the total budgeted manufacturing
overhead for the year by the total budgeted direct labor hours for the year.
1 2 3 4 Year
Required production in cases (see production budget page) 14,000 32,000 36,000 19,000 101,000
1 Add desired ending inventory of raw material 48,000 54,000 28,500 22,500 22,500
Less beginning inventory of raw materials 21,000 48,000 54,000 28,500 21,000
50% 50%
1 Ten percent of the next quarter's needs. For example, the second-quarter production needs are 480,000 pounds. Therefore, the
desired ending inventory for the first quarter would be 10% 480,000 pounds = 48,000 pounds. The ending inventory of 22,500
pounds for the quarter is assumed
2 Cash payments for the last year's fourth-quarter materials purchases.
3 $47,500 × 50%; $47,500 × 50%.
4 $97,200 × 50%; $97,200 × 50%.
5 $102,900 × 50%; $102,900 × 50%.
6 $55,800 × 50%. Unpaid fourth quarter's purchases appear as accounts payable on the company's end of year balance sheet
The only raw materials include in this budget is high fructose sugar, which is the
major ingredient in popsicles (finished goods of Hampton Freeze Inc.) other than
water. The remaining raw materials are relatively insignificant and are included in
variable manufacturing overhead. As with finished goods, management would like to
maintain some minimum inventories of raw materials as cushion. In this case,
management would like to maintain ending inventories of sugar equal to 10% of the
following quarter's production needs.
The first line in the direct materials budget contains the required production for each
quarter, which is taken directly from the production budget (see production budget
page). Looking at the first quarter, since the schedule of production budget calls for
the production of 14,000 cases of popsicles (finished goods of Hampton Freeze Inc.)
and each case requires 15 pounds of sugar, the total production needs are for
210,000 pounds of sugar (14,000 cases × 15 pounds per case). In addition,
management wants to have ending inventories of 48,000 pounds of sugar, which is
10% of the following quarter's needs of 480,000 pounds. Consequently the total
needs are for 258,000 pounds (210,000 pounds for the current quarter's production
plus 48,000 pounds for the desired ending inventory). However, since the company
already has 21,000 pounds in beginning inventory, only 237,000 pounds of sugar
(258,000 pounds – 21,000 pounds) will need to be purchased. Finally, the cost of the
materials purchases is determined by multiplying the amount of raw materials to be
purchased by the cost per unit of the raw materials. In this case, since 237,000
pounds of sugar will have to be purchased during the first quarter and sugar costs
$0.20 per pound, the total cost will be $47,400 (237,000 pounds × $0.20 per
pound).
As with the production budget, the amounts listed under the year column are not
always just the sum of the quarterly amounts. The desired ending inventory of raw
materials for the year is the same as the desired ending inventory of raw materials
for the fourth quarter. Likewise the beginning inventory of the raw materials for the
year is the same as the beginning inventory of raw materials for the first quarter.
1 2 3 4 Year
Budgeted sales in cases (see sales budget) 10,000 30,000 40,000 20,000 100,000
Variable selling and administrative expenses per case $1.80 $1.80 $1.80 1.80 $1.80
----------- ----------- ----------- ----------- -----------
Budgeted variable expense $ 18,000 $54,000 $72,000 $36,000 $180,000
====== ====== ====== ====== ======
Like the manufacturing overhead budget the selling and administrative expense
budget is divided into variable and fixed cost components. In the above example the
variable selling and administrative expense is $1.80 per case. Consequently,
budgeted sales in cases for each quarter are entered at the top of the schedule.
These data are taken from the sales budget (see sales budget). The budgeted
variable selling and administrative expenses are determined by multiplying the
budgeted sales in cases by the variable selling and administrative expense per case.
For example, the budgeted variable selling and administrative expense for the first
quarter is $18,000 (10,000 cases × $1.80 per case). The fixed selling and
administrative expenses (all given data) are then added to the variable selling and
administrative expenses to arrive at the total budgeted selling and administrative
expenses. Finally, to determine the cash disbursement for selling and administrative
items, total budgeted selling and administrative expense is adjusted by adding back
non-cash selling and administrative expenses (in this case, just depreciation).
--------------
Less selling and administrative expenses Selling and administrative expense budget 577,800
--------------
--------------
======
-------------
--------------
--------------
=======
Liabilities and Stockholders' Equity
Current liabilities:
Accounts payable (raw materials) 8 $27,000
Stockholders' equity:
Common stock, no par 9 $175,000
--------------
--------------
=======
-------------
-------------
-------------
-------------
-------------
=======
1. The ending cash balance, as projected by the cash budget on cash budget
page.
2. Thirty percent of fourth quarter sales, from sales budget ($400,000 × 30% =
$120,000)
3. From direct materials budget, ending raw materials inventory will be 22,500
pounds. This material costs $0.20 per pound. Therefore, the ending inventory
in dollars will be 22,500 pounds × $0.20 = $4,500.
4. From ending finished goods inventory budget.
5. From December 2008 balance sheet (no change).
6. The December 2008 balance sheet indicated a balance of $700,000. During
2009, $130,000 of additional equipment will be purchased (see cash budget),
bringing the December 31, 2009, balance to $830,000.
7. The December 31, 2008 balance sheet indicated a balance of $292,000.
During 2009, $100,000 depreciation will be taken ($60,000 from
manufacturing overhead budget, and $40,000 selling and administrative
expense budget), bringing the December 2009, balance to $392,000.
8. One half of the fourth quarter raw materials purchase, from direct materials
budget.
9. From the December 2008 balance sheet (no change).
---------
======
-----------
======
For Hampton Freeze Inc. the absorption costing unit product cost is $13 per case of
popsicles (finished goods of Hampton Freeze Inc.)--costing of $3 of direct materials,
$6 of direct labor, and $4 of manufacturing overhead. The manufacturing overhead
is applied to units of product on the basis of direct labor-hours at the rate of $10 per
direct labor-hour. The budgeted carrying cost of the expected inventory is $39,000.