$5.)$ Build out Product Budget $1$ points

$-$ Step $1$: Use the numbers already created in your Sales Budget for Production Budget

$-$ Step $2$: Second, decide how much ending inventory does your Manufacturing Company desire to have on hand at the end of the period? what $\backslash \%$ percentage of inventory available at the end of the month based off next month's sales should be available for sale? Build the production needed for each product $1,2$ and $3,$ what is your desired ending inventory for each product should be different

Product $1$

Budget unit sales

Add: Desired Units ending finished goods

Total Needed

Less Units of beginning finished goods

Required Production in units

Product $2$ Production Budget

Product $2$

Budget unit sales

Add: Desired Units ending finished goods

April

May

June

June

April

May

ne

Quarter

Quarter

Quarter

Total Needed

Less Units of beginning

finished goods

Required Production in units

Product $3$ Production Budget

Product $1$

April

May

June

Quarter

Budget unit sales

Add: Desired Units ending

finished goods

Total Needed

Less Units of beginning

finished goods

Required Production in units

$6.)$ Why is depreciation expense considered a non$-$cash impact or referred to as a noncash expense? $(.25$ point$)4.)$ Building and Creating Budgets: Now it is time to build out Budgets for your Manufacturing Company that you created in

Instructions, Sales Budget and Cash Collections Budget $($you might need separate paper$)$

$-$ Step $1$: List the Name and Sales price $\backslash$$ of each of the $3(.25$ point$)$

Chair $(\backslash$$$250)$ Table $(\backslash$$$500)$ Beds $(\backslash$$$750)$

$-$ Step $2$: List the Estimated Forecasted Monthly Sales volume using EXCEL Graph $(.75$ point$)$ Create an excel sheetJanua ryFebrua ryMar chApr ilJun eJul Augu y stSeptem berOctob erNovemb erDecembe rProd uct $1$Prod uct $2$

$-$ Step $3$: What do you estimate to be the cash collections to be each month from sales? April May June $(\mathrm{.}5)$Product $1$ in Sales Dollars $\backslash$$Product $2$ in Sales Dollars $\backslash$$Product $3$ in Sales Dollars $\backslash$$ $-($for example, $20\backslash \%$ cash collect in month of sale and $70\backslash \%$ in the second month, $8\backslash \%$ third month make$-$up your own split, and option to allocate $2\backslash \%$ or $5\backslash \%$ to uncollectible

Cash Collection Budget based on total Sales $\backslash$$ $(\mathrm{.}75$ point$)$ Quarter $2$February Sales $\backslash$$$\backslash$$

$\backslash (\backslash$begin$\{$array$\}\{$lllll$\}\backslash$text $\{$ May Sales $\backslash$$$\backslash$$ $\}$ & $0$ & $5639$ & $19736\mathrm{.}5$ & $25375\mathrm{.}5\backslash$end$\{$array$\}\backslash )$

Total Cash

Collections

$5.)$ Build out Product Budget $1$ points

$-$ Step $1$: Use the numbers already created in your Sales Budget for Production Budget

$-$ Step $2$: Second, decide how much ending inventory does your Manufacturing Company desire to have on hand at the end of the period? what $\backslash \%$ percentage of inventory available at the end of the month based off next month's sales should be available for sale? Build the production needed for each product $1,2$ and $3,$ what is your desired ending inventory for each product should be different

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

Product $1$ & April May June Quarter

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

Budget unit sales

Add: Desired Units ending finished goods

Total Needed

Less Units of beginning finished goods

Required Production in units

Product $2$ Production Budget

Budget unit sales

Add: Desired Unit