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 for october | |
Cash sales ( 164000 * 85 % ) | 139400 |
Collection from credit sales | |
October ( 164000 * 15 % * 70 % ) | 17220 |
September ( 181500 * 15 % * 28 % ) | 7623 |
164243 | |
2. cash needed to pay for food purchases in october | |
October ( 110000 * 25 % ) | 27500 |
September ( 130000 * 75 % ) | 97500 |
125000 | |
La famiglia Pizzeria | |
Cash budget | |
Beginning balance | 2147 |
Cash receipts | 164243 |
Cash available | 166390 |
Less: | |
Payments for food and supplies purchases | 125000 |
Owners' draw | 6000 |
Workers' wages ( 7300 * 10 % + 7300 * 90 % ) | 7300 |
Utilities | 5950 |
Rent | 4100 |
Insurance | 1500 |
Total disbursements | 149850 |
Ending balance | 16540 |
Get Answers For Free
Most questions answered within 1 hours.