QS $20-29$A $($Algo$)$ Merchandising: Merchandise purchases budget LO P$4$

Lexi Company budgets unit sales of $1,170,000$ in April, $1,240,000$ in May, $310,000$ in June, and $1,450,000$ in July. Beginning inventory on April $1$ is $468,000$ units, and the company wants to have $40\%$ of next month$$s unit sales in inventory at the end of each month. The merchandise cost per unit is $$0\mathrm{.}50.$ Prepare a merchandise purchases budget for the months of April, May, and June.