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.
$
Feedback
Correct
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 in October (85% of 153000) | 130,050 |
Credit Sales collection of October Sales | 16,065 |
Credit Sales collection of September Sales | 7,623 |
Total receipts | 153,738 |
october credit sales = 153000 x 15% = 22950
Credit sales collection of october sales = 22950 x 70%
Credit sales collection of Sep sales = Credit sales = 181500 x 15% = 27225 and cash collect on oct = 27225x28% = 7623
2.
Cash Payment to Purchase | |
25% of october month | 25,250 |
75% of september month | 97,500 |
Total cash needed | 122,750 |
122750 needed for payment regarding purchase.
3
La Famigia Pizzeria | |
Cash Budget | |
For the month of october | |
Beginning Balance | 2,147 |
Total Receipts | 153,738 |
Cash Available | 155,885 |
Less : Payments to food and supplies | 122,750 |
Less : Owners Draw | 6,000 |
Less : Workers Wages | 7,300 |
Less : Utility | 5,950 |
Less : Rent | 4,100 |
Less : Insurance | 1,600 |
Total Disbursment | 147,700 |
Ending Balance | 8,185 |
Workers wages will be 7300. Becuase monthly 7300. 90% of october and 10% of Septmber month will receive in October
Ending balance = Available cash - total disbursement