budget assumption

$55,000$ per month up to June $2024.$ There is a projected increase of $10\%$ for the remaining six months.

The price is $$460$ per unit

Collection

cash sales $50\%$

Sales on account $50\%$ collected has follows:

$10\%$ in the month of sale

$50\%$ in the month following sale

$35\%$ two months following sale

The accounts receivable balance for December $2023$ is broken down has follows:

$$60,000$ balance from November $2023$ paid in full January $2024,340,000$ from December $2023$ payable in $200,000$ January $2024$ and $140,000$ February $2024$

Create the schedule of expected cash collection for the months January to December