Chapter 09 - Profit Planning and Activity-Based Budgeting
9-20
Deduct: Total disbursements................................ $9,785,000 $ 9,385,000 $10,725,000
Cash balance .......................................................... $ 115,000 $ 1,615,000 $ 2,605,000
Cash borrowed ....................................................... 385,000
Cash repaid (385,000)
Ending balance ...................................................... $ 500,000 $ 1,230,000 $ 2,605,000
a
60% of sales in first month after sale; 40% of sales in second month after sale.
b
See next page.
c
30% of current month sales.
d
(Total, less property taxes and depreciation) divided by 12.
e
40% × $3,200,000.
PROBLEM 9-36 (CONTINUED)
b
Accounts payable:
Total* Percentage February March April May June
Cost of goods sold:
February .... $4,000,000 .30 $1,200,000
March ........ 3,600,000 .70 2,520,000
March ........ 3,600,000 .30 $1,080,000
April ........... 4,600,000 .70 3,220,000
April ........... 4,600,000 .30 $1,380,000
May ............ 5,000,000 .70 3,500,000
May ............ 5,000,000 .30 $1,500,000
June ........... 5,600,000 .70 3,920,000
$3,720,000 $4,300,000 $4,880,000 $5,420,000
Payments:
February .... $3,720,000 .25 $ 930,000
March ........ 4,300,000 .75 3,225,000
March ........ 4,300,000 .25 $1,075,000
April ........... 4,880,000 .75 3,660,000
April ........... 4,880,000 .25 $1,220,000
May ............ 5,420,000 .75 4,065,000
$ 0 $ 0 $4,155,000 $4,735,000 $5,285,000
*For cost of goods sold, this amount is equal to 40% of sales. For payments, this amount is
equal to the cost of goods sold.
2. Cash budgeting is important for Alpha-Tech because as sales grow, so will
expenditures for inputs. Since these expenditures generally precede cash receipts,
the company must plan for possible financing to cover the gap between payments