Purchases Budget in Units and Dollars

Budgeted sales of The Music Shop for the first six months of $2010$ are as follows:

$\backslash$table$[[$Month$,$Unit Sales,Month,Unit Sales$],[$January$,130,000,$April,$200,000],[$February$,170,000,$May,$180,000],[$March$,190,000,$June,$250,000]]$

Beginning inventory for $2010$ is $40,000$ units. The budgeted inventory at the end of a month is $40$ percent of units to be sold the following month. Purchase price per unit is $$6.$

Prepare a purchases budget in units and dollars for each month, January through May.

$\backslash$table$[[,,\backslash$table$[[$The Musi$],[$Purchases$],[$January $-$ M$]],\backslash$table$[[$Shop$],[$Budget$],[$ay$,2010]],,],[,$January,February,March,April,May$],[$Purchase units:,$122,000,166,000,190,000,190,000,198,000],[$Purchase dollars:,$366,000,498,000,570,000,570,000,594,000]]$