(Cash budget) The accountant for Georgia Pizza prepared the following cash budget for the third quarter of 2000. When the owner was reviewing it, he was eating a deep dish pizza loaded with extra cheese. Some of the topping inadvertently spilled onto the page and smeared the figures. Complete the missing numbers on the cash budget, assuming that the accountant has projected a minimum cash balance at the start of each month of $2,500. All borrowings, repayments, and investments are made in even $500 amounts.
|
July |
August |
September |
Total |
|
|
Beginning cash balance |
$ 4,500 |
$ ? |
$ ? |
$ ? |
|
Cash receipts |
8,200 |
10,100 |
? |
? |
|
Total cash available |
$ ? |
$13,000 |
$19,500 |
$39,400 |
|
Cash disbursements: |
||||
|
Payments on account |
$ ? |
$ 3,900 |
$ 5,700 |
$ ? |
|
Wages expense |
5,000 |
? |
6,100 |
17,200 |
|
Overhead costs |
4,000 |
4,600 |
? |
13,000 |
|
Total disbursements |
$10,300 |
$ ? |
$16,200 |
$ ? |
|
Cash excess (deficiency) |
$ ? |
$ ? |
$ ? |
$ ? |
|
Minimum cash balance |
(2,500) |
(2,500) |
? |
? |
|
Cash available (needed) |
$ ? |
$ (4,100) |
$ ? |
$ (4,200) |
|
Financing: |
||||
|
Borrowings (repayments) |
$ 500 |
$ ? |
$ (500) |
$ ? |
|
Acquire (sell) investments |
0 |
0 |
? |
? |
|
Receive (pay) interest |
0 |
0 |
? |
(50) |
|
Ending cash balance |
$ 2,900 |
$ ? |
$ ? |
$ 2,750 |