Please show me how to solve this cash budget, showing me the format and explanation.

Consider the budgeted income statement for Big_Z for the month ended 30 June 2018 below:-

$$

Sales290,000

Less: Cost of Goods Sold

Inventory, 31 May 201850,000

Purchases192,000

Available for sale242,000

Inventory, 30 June 201840,000

202,000

Gross profit88,000

Less: Operating expenses

Wages36,000

Utilities5,000

Advertising 10,000

Depreciation1,000

Office expenses4,000

Insurance and property taxes3,00059,000

Operating profit29,000

=====

Additional information:

The cash balance on 31 May 2018 $15,000.

Sales proceeds are collected as follows: 80% the month of sale; 10% the second month; and 10% the third month.

Accounts receivable are $44,000 on 31 May 2018 consisting of $20,000 from April 2018 sales and $24,000 from May 2018 sales.

Accounts payable on 31 May 2018 are $145,000.

Big_Z pays 25% of purchases during the month of purchase and the remainder during the following month.

All operating expenses requiring cash are paid during the month of recognition, except that insurance and property taxes are paid annually in December for the forthcoming year.