Question#$7$

The Greens Company sales and unit prices are as follow.

Monthly sales are budgeted in units as follows: $28,000$ for October, $20,000$ for November, and $25,600$ for December.

The sales prices are $$10$ for October, $$12$ for November and $$12\mathrm{.}5$ December.

The experience has shown that $50\%$ percent of the sales of Greens Company sales are for cash.

The rest are on credit with $70\%$ of the credit sales are collected in the month of sale, $20\%$ in the month following sale, and $5\%$ in the

second month following sale.

The remainder is expected to be uncollectible.

Requirement:

i$)$ Prepare a schedule of sales for the quarter and

ii$)$ Prepare expected cash collections for the month of December.

$10$ points

Read the question above.

Read the Question, Prepare your solution & working first in MS Excel. Copy paste your workings & solution in text box.