General Comments
In covering budgeting, it is important not to get “bogged down” in the computations of
budgeted amounts. With this in mind, the chapter is focused from the outset on the importance of
planning and controlling cash flows from operations. There are, of course, an unlimited number
of potential computations; it is not possible to illustrate them all. Therefore, we usually illustrate
only one or two of the “basic” types of budgeting computations. Exercises 1 thru 9 are intended
for this purpose. Case 1 provides an opportunity for students to confront the interrelationships
among budgeted financial statements free from an excessive computational burden. We highly
recommend reviewing this case in class.
We also emphasize that in a large organization, the number of specific schedules and
budgets comprising the master budget requires the use of a computerized systemin the budgeting
process. The system is programmed with the “cost formulas” and the interrelationships among
budgeted amounts. Once this task is completed, the system can almost instantly develop every
element of the budget from forecast sales data. In addition, the budgeting software can be used to
assess the expected impact of changes in sales, production costs, or any of the other variables
upon which the budget is based. The original development of budgeting software is a formidable
task. Once this software has been developed, however, the time-consuming “number crunching”
aspects of budgeting are eliminated. Also, this software may be used for many years, requiring
only minor adjustments to cost formulas and interrelationships among the budgeted amounts.
Many companies now use packaged budgeting software that may be a part of a larger accounting
or enterprise resource planning (ERP) system.
An aside There is no more dramatic case of a profit rich–cash poor company than W. T. Grant,
Inc. in the years leading up to its liquidation in 1976. In each of the nine years prior to declaring
bankruptcy, the company reported positive net income. However, it experienced negative cash
flows from operations as it continued to invest in unsalable inventory and uncollectible
receivables. The history of this failed corporation is an object lesson in the importance of
budgeting cash flows. This is a great opportunity to emphasize to students the importance of
comparing a company’s reported net income with cash flows in order to better assess financial
health and predict future results.
Supplemental Exercises
Group Exercise
As a group, select an established manufacturing company. Prepare an estimated quarterly
sales forecast for the coming year. Next, prepare a production budget that includes direct
materials, direct labor, and manufacturing overhead. These budgets should be prepared in Excel.
Prepare a summary of your results in a PowerPoint presentation. Explain any assumptions used
in creating the budget and also discuss internal and external factors that may impact the actual
results during the year.