Q$1(7$ Marks$)$: X Company's sales budget for the second quarter is given below:

Budgeted sales $($all on account$).$

April

$\frac{\text{M}\text{a}\text{y}}{\text{\$}500,000}$

$\frac{\text{J}\text{u}\text{n}\text{e}}{\text{\$}200,000}$

Total

$\frac{\text{T}\text{o}\text{t}\text{a}\text{l}}{\text{\$}1\mathrm{.}000\mathrm{.}000}$

From past experience, the company has learned that $20\%$ of a month's sales are collected in the month of sale, and the remaining $80\%$ are collected in the month following sale. March sales totaled $$260,000.$

Required: Prepare a schedule of expected cash collections from sales for the second quarter by month and in total.