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 | $ |
1) | Cash receipts | |||||||
Cash Sales october | (152000*85%) | 129200 | ||||||
Credit sales oct | (152000*15%*70%) | 15960 | ||||||
Credit sales sept | (181,500*15%*28%) | 7623 | ||||||
Total Cash receipts expected in October | 152783 | answer | ||||||
2) | Cash need in oct to pay for food purchases | |||||||
oct purchase | (117000*25%) | 29250 | ||||||
Sept purchase | (130,000*75%) | 97500 | ||||||
Cash need in oct to pay for food purchases | 126750 | answer | ||||||
3) | Cash Budget | |||||||
Beginning balance | 2,147 | |||||||
Cash receipts | 152783 | |||||||
Cash available | 154,930 | |||||||
less: | ||||||||
payment for food and supplies purchase | 126750 | |||||||
owenr's draw | 6,000 | |||||||
worker's wages | 7,300 | |||||||
utilities | 5,950 | |||||||
Rent | 4,100 | |||||||
insurance | 1,200 | |||||||
Total disbursements | 151300 | |||||||
Ending balance | 3,630 | |||||||