Question

Calculator Preparing a Cash Budget d e atuha La Famiglia Perera provided the following form for the month of October Sales are budgeted to be 5151 000 About o t h e r son b. La Famiglia expects that on average 70 of credit sal a d the othed 2 Food and supplies purchases are expected to be 599.000. a a st Todowing purchase d. Most of the work is done by the owner who tvocally withdraw 56.000 month the bus payment in total to the two owns, not per person) Various parte s 57,300 per average 90% of the wages are paid in the month curred and the remaining in the e Utilities average $5.950 per month Rent on the buildings $4,100 per month Insurance paid quarterly: the next payment of $1,100 due in October 9. September sales were $181,500 and purchases of food and colles in September ad 130.000 h. The cash balance on October 1 52.147 h 56 the 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 Check My Work Previous Next > Submit Assignment for Grading E RT YU 10 OF G H си в NI M command OOR

Answer 1

cash receipts

	October
receipts from september sales	7623	181500*15% credit sales*28%paid in following month
from october sale	144205	151000*85% cash sales+ 151000*15%credit sales*70% received in same month
Total receipts	151828$	Answer 1

2.

	October
paid for september purchase	97500	130000*75%
from october purchase	24750	99000*25%
Total receipts	122250$	Answer 2

3.cash budget

		working
beginning balance	2147
cash receipts	151828
cash available	153975	2147+151828
less
payment for food	122250
owner's drw	6000
wages	7300	7300*90% of october 10% of september
utiities	5950
rent	4100
insurance	1100
total disbursement	146700
ending balance	7275$	[153975-146700]