In: Accounting
Preparing a Cash Budget
La Famiglia Pizzeria provided the following information for the month of October:
Required:
If required, round your answers to the nearest dollar.
1. Calculate the cash receipts expected in
October.
$
2. Calculate the cash needed in October to pay
for food purchases.
$
3. Prepare a cash budget for the month of October.
La Famiglia Pizzeria | |
Cash budget | |
For the month of October | |
Beginning balance | $ |
Cash receipts | |
Cash available | $ |
Less: | |
Payments for food and supplies purchases | $ |
Owners' draw | |
Workers' wages | |
Utilities | |
Rent | |
Insurance | |
Total disbursements | $ |
Ending balance | $ |
SOLUTION
1. Schedule of cash receipts-
September | October | |
Expected sales | 181,500 | 154,000 |
Cash sales | 85% | 85% |
Cash sales in dollar (A) | 154,275 | 130,900 |
Credit sales | 27,225 | 23,100 |
Collection of September Credit sales (27,225*28%) (B) | 7,623 | |
Collection of October Credit sales (23,100*70%) (C) | 16,170 | |
Total collection in October (A+B+C) | 154,693 |
2. Schedule of cash payment-
September | October | |
Expected purchases | 130,000 | 113,000 |
Cash purchase | 25% | 25% |
Cash purchase in dollars | 32,500 | 28,250 |
Credit purchases | 97,500 | 84,750 |
Payment from September month purchase | 97,500 | |
Total payments in October | 125,750 |
3. Cash budget-
Particulars | Amount ($) | Amount ($) |
Beginning balance | 2,147 | |
Cash receipts | 154,693 | |
Cash available (A) | 156,840 | |
Less: Cash disbursements: | ||
Payments for food and supplies purchases | 125,750 | |
Owners' draw | 6,000 | |
Workers' wages | 7,300 | |
Utilities | 5,950 | |
Rent | 4,100 | |
Insurance | 1,500 | |
Total disbursements (B) | 150,600 | |
Ending balance (A-B) | 6,240 |