Boston Company developed the following budgeted data for the month of June:

a. The June 1^st cash balance is $34,700.

b. Cash sales in June are $75,000.

c. Credit sales for June are expected to be $40,000.Credit sales for May were $60,000 and for

April were $50,000.70% of credit sales are collected in the month of sale, 20% are collected in

the month following the sale, and the remaining 10% are collected in the second month following

the sale.

d. Purchases for May were $100,000 and for June are $80,000.25% of purchases are paid in the

month of purchase and the remaining 75% in the month following the purchase.

e. June salaries are $35,400, utilities are $14,200, and depreciation on the building and equipment

is $20,000.

Required:

Create a cash budget for the month of June 2018.