Question

Question I (35 %) Here are some important figures from the budget of Scarlet Inc., for the second quarter of 2019 June May April 378,400 €314,500 336,900 Credit sales 180,300 152,400 134,100 Credit purchases Cash disbursements 62,300 67,600 48,910 Wages, taxes, and expenses 11,320 11,320 11,320 Interest 79,900 122,000 0 Equipment purchases Additional information: The company predicts that 5 percent of its credit sales will never be collected, 35 percent of its sales will be collected in the month of the sale, and the remaining 60 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2019, credit sales were 211,500 and credit purchases were 145,200 Cash balance at 1 April 2019 is 121,000. nstructions Using all the above information, complete the following cash budget. (25%)

Please as fast as possible I only need the numbers for this table

Answer 1

SCHEDULE OF CASH COLLECTIONS FROM CUSTOMERS
	APRIL	MAY	JUNE
Current Month sales	336900*35%= 117915	314500*35%=110075	378400*35%=132440
Past month sales	211500*60%= 126900	336900*60%= 202140	314500*60%= 188700
Total cash collections from receipts	244815	312215	321140

	April	May	June
Beginning cash balance	121000	80485	62980
cash receipts
cash collection from credit sales	244815	312215	321140
Total cash available	365815	392700	384120
cash disbursement
Purchase	145200	134100	152400
Wages,taxes and expenses	48910	62300	67600
Interest	11320	11320	11320
Equipment purchase	79900	122000	0
Total cash disbursement	(285330)	(329720)	(231320)
Ending cash balance	80485	62980	152800