Please complete this excel table for me$!!5$ Aanamptiona:

$6.$ Soles volume incremes $500$ units each euarter, inchudies $01$ of the rest prar

$7$ Liding inventory is $20$ K of nest euarter's budgeted sales

Unit cont h $45\%$ of sales pice

$9$ Salaries are $25\%$ of sales

$10$ Commisvioms are $5\%$ of sales

$11$ Benelis aet $29\%$ of salaries

$12$ Sopplies are $1$ $h of sales

$13$ Wi thet expernes are the same amonat each quarier

$14$ interect erepemes are $15$ of Sales

$15$ Mobme lases are $20\%$ of earnings before tams

$16$ flemt his $$90,000$ per quarter

$17$ Unities are $$5,000$ per quarter

$18$

Depereciation is $$70$ p$09$ per querter

$19$

$20$

$21$

$22$

$\backslash$table$[[54$as tydets,Q$1,62,43,$Q$4,$Tatal$],[$falme twits,$15,809,,,,15,000],[$Fike per unit,$250,360,29,200,125],[$Tetal sales,$1,750\mathrm{.}000,,$cdots,$,1,175,000]]$

Purthases Budget

Units fold

$15,000$

$15\mathrm{.}000$

Budget

Sowarer

$29$ Purchases Budget

Urits Sold

$\backslash$table$[[15,000,,-,,15,000],[15,000,,,,17.],[15,000,,,,],[1,000,,,,3,000],[12,000,,,,12,000]]$

Revenue

Sales

$3,750,000$

Cent of Goodr fold

$1,1437,500$

$\backslash$table$[[3,50,000$