Answer and steps to the question below

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

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

$\backslash$begin$\{$tabular$\}\{$lr$\}$

& Unit Sales $\backslash \backslash$

April & $88,000\backslash \backslash$

May & $90,000\backslash \backslash$

June & $128,000\backslash \backslash$

July & $99,000$

$\backslash$end$\{$tabular$\}$

The company wants its ending inventory levels to equal $15\backslash \%$ of the following month's unit sales. The inventory at the end of March $13,200$ units.

Required:

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

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$c$|\}\{$Down Under Products, Limited$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$c$|\}\{$Production Budget$\}\backslash \backslash$

$\backslash$hline & April & May & June & Quarter $\backslash \backslash$

$\backslash$hline Budgeted unit sales & & & & $\backslash \backslash$

$\backslash$hline P & & & & $\backslash \backslash$

$\backslash$hline Total needs & $0$ & $0$ & $0$ & $0\backslash \backslash$

$\backslash$hline $-$ & & & & $\backslash \backslash$

$\backslash$hline Required production in units & $0$ & $0$ & $0$ & $0\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$