Milo Compony monufactures beoch umbrelias. The compony is preparing budgets for the third querter and ossembled the following information:

a$.$ The Marketing Deporment estimated unit soles os follows for the remainder of the year?

The selling price of the beoch umbrellos is $$12$ per unit

b$.$ All sales are on account Eased on post experience. soles are collected in the following pattern:

sex in the ronth or sald

Est in the month folidwing sald

$5$x uncallectible

Sales for June totoled $$300,000$

c$.$ The compony msintains finished goods inventories equal to $15\%$ of the following month's sales. This requirement will be met at the end of June.

d$.$ Each beach umbrella requires $4$ teet of Gilden, a moteriol thet is sometimes hard to ocquire. Therefore, the company requires ending inventory of Gilden equol to $50\%$ of the following month's production needs. The imventory of Gilden on hand at the beginning and end of the quarter will be:

June $38$

september $3?$

$72.$ eag fect

fect

e$.$ Gilden costs $$0\mathrm{.}80$ per foot. One$-$half of a month's purchases of Gilden is poid for in the month of purchase; the remainder is paid for in the following month. The occounts poyoble on July $1$ for purchoses of Gilden during June will be $$76,000.$

Required:

Celculste the estimeted soles, by month and in total, for the third quarter:

$2$ Calculate the expected cash collections, by month and in total, for the third quarter.

Celculete the estimated quentity of beach umbrellas that need to be produced in July. August, September, and October.

Calculste the quentity of Gicen $($in feet$)$ thet needs to be purchesed by month and in total, for the third querter.

Colculate the cost of the row material $($Gilden$)$ purchases by month and in totel, for the third quarter.

Celculate the expected cash cisbursements for row moteriol $($Gilden$)$ purchoses, by month and in totol, for the third quarter

Complete this question by entering vour answers in the tabs below.

Petinited $1$

Retined $2$

Recured $1$

Requnted

and $5$

Ruchents $5$

Calculde the estimets ifles, by morth and in cotal$,$ ror the thitd quarter:

$\backslash$table$[[$Budgeled fally,Suly,Auguat,September,Custer$]]$