This example looks at predicting the cash outflows in the cost of goods sold category in order to prepare a cash flow budget. A cash outflow falls under this category if it is for the purchase of inventory items resold to your customers or for inventory items used to manufacture an end product.
Scott Derby owns a store called the "Top Hat." His store specializes in selling - you guessed it - hats! Scott purchases all his hats from special hat suppliers and resells them to his customers.
Scott is preparing a cash flow budget for the first six months of 2010, and needs to predict his cost of goods sold to complete the budget. To determine his cash outflows for the budget, Scott will use the sales and cost of goods sold information listed on his tax returns from the previous four years. Using this information allows Scott to determine the percentage relationship between sales and the cost of goods sold.
The following chart summarizes the information from his tax returns, and shows the cost of goods sold percentages for the previous four years:
| |
A |
B |
C |
| Tax Return Year |
Sales |
Cost of
Goods Sold |
Cost of Goods
Sold Percentage
C = (B/A) |
| 2009 |
$410,970 |
$245,226 |
59.67% |
| 2008 |
408,024 |
245,345 |
60.13% |
| 2007 |
396,108 |
232,793 |
58.77% |
| 2006 |
389,566 |
238,453 |
61.21% |
From the information listed above, Scott has determined that his cost of goods sold has been averaging about 59.95 percent of his total sales over the last four years. Scott will use this percentage to predict his cash outflows for the six month cash flow budget he is preparing for 2010. In his budget he will assume that his cash outflows for the cost of goods sold will continue to average about 59.95 percent of his forecasted sales. The following chart summarizes his budgeted cash outflows for the cost of goods sold.
| |
A |
B |
C |
| Month |
Forecasted
Sales |
Cost of Goods
Sold Percentage |
Projected
Cost of
Goods Sold
C = (A x B) |
| January |
$35,000 |
59.95% |
$20,983 |
| February |
32,500 |
59.95% |
19,484 |
| March |
32,000 |
59.95% |
19,184 |
| April |
31,000 |
59.95% |
18,585 |
| May |
36,000 |
59.95% |
21,582 |
| June |
37,300 |
59.95% |
22,361 |