Preparing a Cash Budget

Le famigtia Aureria provided the following information for the month of October:

a$.$ Sales are buigeted to be $$158,000.$ About $85\%$ of sales is cash; the remainder is on account.

b$.$ La Famiglia expects that, on average, $70\%$ of credit sales will be paid in the month of sale, and $28\%$ will be paid in the following month.

c$.$ Food and supplies purchases, all on account, are expected to be $$106,000.$ La Famiglia pays $25\%$ in the month of purchase and $75\%$ in the manth following purchase. average $90\%$ of their wages are paid in the month incurred and the remaining $10\%$ in the next month.

e$.$ Utities average $$5,950$ per month. Rent on the building is $$4,100$ per month.

$2.$ Insurance is paid quarterly; the next payment of $$1,500$ is due in October.

$9.$ September sales were $$181,500$ and purchases of food and supplies in September equaled $$130,000.$

h$.$ The cash balance en Octaber $1$ is $$2,14,$

nequiredt

If required, round your answers to the nearest dollar.

Catculate the cash receipts expected in October.

s$.$

Calculate the cash needed in October to pay for food purchases.

Prepare a cash budget for the month of October:

$\backslash$table$[[\backslash$table$[[$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