Water Sport Inc. manufactures a small personal water tube used for children learning to swim. Management is now preparing detalled budgets for the third quarter, July through September, and has ascembled the following Information to assist

a$.$ The Marketing Department has estimated sales as follows for the remainder of the year $($number of water tubes$)$:

$\backslash$table$[[$July$,7,100,$October,$3,500],[$August$,5,680,$Noverber,$3,100],[$Septerber$,4,680,$Deconber,$2,600]]$

The selling price of the wster tubes is $$60.$

b$.$ All sales are on account. Based on past expertence, sales are expected to be collected in the followng pattern:

$56$ in the month of sile

$45$x In the month following fale St uncollectible

The beginning accounts receivable balance $($excluding uncolectble a mountsy on July i will be $$163\mathrm{.}000.$

c$.$ The company maintains finkhed goods inventoris equal to $20$ s of the following months sales. The inventoy of finished goces on July $1$ will be $1,420$ units.

d$.$ Each water tube requires $3$ klograms of synthete polylsoprene rubber compound, To preventshotsges, the company would ike production heeds. The Inventory of synthetic rubber compound on hsind on Hy I wil se $4080$ wiograme. $513,200$ on fuly $1$

Required:

Prepres sales budget, by month snd in tots. for the third quater. Show you budget in boh unte of weter tubee and col are. Aleo prepsre a schedule of expected cash colfectons, by month snd in tots, for the thire quster:

$\backslash$table$[[8$alec budget$],[,$July,Auguet,epptomber,cuartor$],[$Butseded sther $($with$)],[,,,,1x^2$