Carmen Company sells jar candles. The sales forecast $($units$)$ for the coming months is:a$.$ Prepare a purchases budget for the quarter ending June $30.$

Note: Deductible values must be indicated with a minus sign.

$\backslash$table$[[\backslash$table$[[$Merchandise Purchases Budget $($Candles$)],[$For the Quarter Ending June $30]]],[$Budgeted unit sales,April,,,$],[$Plus: Ending inventory,,,,$],[$Less: Beginning inventory,,,,$],[$Budgeted purchases $($units$),,,,],[$Cost of merchandise $($per unit$),,,,],[$Total cost of merchandise purchases,,,,$]]$

b$.$ Prepare a cash payments budget for the quarter ending June $30.$

$\backslash$table$[[\backslash$table$[[$Budgeted Cash Payments $($Candles$)],[$For the Quarter Ending June $30]]],[,$April,May,June,Total$],[$Budgeted merchandise purchases$],[$Cash paid month of purchase $(30\%)],[$Cash paid in month following $(70\%)],[$Cash paid for merchandise purchases,,,,$]]$

$\begin{array}{cc}\text{A}\text{p}\text{r}\text{i}\text{l}& 140\\ \text{M}\text{a}\text{y}& 170\\ \text{J}\text{u}\text{n}\text{e}& 230\\ \text{J}\text{u}\text{l}\text{y}& 170\\ \text{A}\text{u}\text{g}\text{u}\text{s}\text{t}& 200\end{array}$

Each candle costs $$13.$ The ending inventory policy is $40\%$ of next month's sales needs. April $1$ inventory will be as expected under the policy. Carmen pays for purchases $30\%$ in the month of purchase and $70\%$ the following month. Accounts payable on April $1$ is $$3,060.$

Required:

a$.$ Prepare a purchases budget for the quarter ending June $30.$

Note: Deductible values must be indicated with a minus sign.

$\backslash$table$[[\backslash$table$[[$Merchandise Purchases Budget $($Candles$)],[$For the Quarter Ending June $30]]],[,$April,May,June,Total$],[$Budgeted unit sales$],[$Plus: Ending inventory$],[$Less: Beginning inventory$],[$Budgeted purchases $($units$)],[$Cost of merchandise $($per unit$)],[$Total cost of merchandise purchases,,,,$]]$Carmen Company sells jar candles. The sales forecast $($units$)$ for the coming months is:

April $140$

May $170$

June $230$

July $170$

August $200$

Each candle costs $$13.$ The ending inventory policy is $40\%$ of next month's sales needs. April $1$ inventory will be as expected under the policy. Carmen pays for purchases $30\%$ in the month of purchase and $70\%$ the following month. Accounts payable on April $1$ is $$3,060.$

Required:

Prepare a purchases budget for the quarter ending June $30.$

Note: Deductible values must be indicated with a minus sign.

Prepare a cash payments budget for the quarter ending June $30.$