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

a. The June 1st 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:

Prepare a cash budget for the month of June 2018.