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.) | Amount in $ | ||
Cash sales of October | 137,700 | (162,000 x 85% ) | |
Credit Sales collection of October | 17,010 | ( 162,000 x 15% x 70% ) | |
Credit Sales collection of September | 7,623 | (181,500 x 15% x 28% ) | |
Cash receipts expected in October | 162,333 | ||
2.) | Amount in $ | ||
Cash payment for food & supplies of october | 25,750 | (103,000 x 25% ) | |
Cash payment for food & supplies of September | 97,500 | (130,000 x 75% ) | |
Cash needed in October to pay for food purchases | 123,250 | ||
3.) | La Famiglia Pizzeria | ||
Cash budget | |||
For the month of October | Amount in $ | ||
Beginning balance | 2,147 | ||
Cash receipts | 162,333 | ||
Cash available | 164,480 | ||
Less: | |||
Payments for food and supplies purchases | 123,250 | ||
Owners' draw | 6,000 | ||
Workers' wages ( 7,300 x 90% ) + ( 7,300 x 10% ) | 7,300 | ||
Utilities | 5,950 | ||
Rent | 4,100 | ||
Insurance | 1,100 | ||
Total disbursements | 147,700 | ||
Ending balance | 16,780 | ||