Exercise $8-2($Algo$)$ Production Budget $[$LO$8-3]$

Down Under Products' sales budget for the next four months is as follows:

$\backslash$table$[[,],[$April$,$Unit Sales$],[$May$,68,000],[$June$,80,000],[$July$,108,000],[,89,000]]$

The company wants its ending inventory levels to equal $10\%$ of the following month's unit sales. The inventory at the end of March was $6,800$ units.

Required:

Prepare a production budget, by month and in total, for the second quarter.

$\backslash$table$[[\backslash$table$[[$Down Under Products, Limited$],[$Production Budget$]]],[$Budgeted unit sales,April,May,June,Quarter$],[,,,,],[$Total needs$],[,0,0,0,0],[$Required production in units,,,,$],[,0,0,0,0]]$