Stewart Electronics sells tablets. Its sales budget for the nine months ended September $30$ follows:

$($Click the icon to view the budget.$)$

$($Click the icon to view additional information.$)$

Requirement

Prepare a cost of goods sold $,$ inventory, and purchases budget for each of the first three quarters of the year. Compute cost of goods sold for the entire nine$-$month period. $($Round amounts to the nearest whole dollar.$)$

Stewart Electronics

Cost of Goods Sold, Inventory, and Purchases Budget

For the Nine Months Ended September $30$

$\backslash$table$[[$Cost of goods sold,Quarter Ended,$\backslash$table$[[$Nine$-$Month$],[$Total$]]],[$Mar $31,$Jun $30,$Sep $30],[,,,],[$Plus: Desired ending inventory,,,$k+4,],[$Total inventory required,,,,$],[$Less: Beginning inventory,,$=,13712,],[$Purchases$,,,=,]]$

Data table

$\backslash$table$[[,$For th$,\backslash$table$[[$Stewar$],[$Sale$],[$e Nine Mont$]],\backslash$table$[[$Electronics$],[$s Budget$],[$s Ended Sept$]],$nber $30,],[,,,$uarter Ended,,$],[,,$Mar $31,$Jun $30,$Sep $30,\backslash$table$[[$Nine$-$Month$],[$Total$]]],[$Cash sales, $30\%,.$$$,39,000$$$,54,000$$$,46,500$$$,139,500],[$Credits sales, $70\%,,91,000,126,000,108,500,325,500],[$Total sales, $100\%,$$$,130,000$$$,180,000$$$,155,000$$$,465,000]]$