Emerald Service anticipates the following sales revenue over a five$-$month period:

$($Click the icon to view the sales data.$)$

The company's sales are $30\%$ cash and $70\%$ credit.

Its collection history indicates that credit sales are collected as follows:

$($Click the icon to view the collections data.$)$

How much cash will be collected in January? In February? In March? For the quarter in total?

Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. $($Round your answers to the nearest whole dollar.$)$

Emerald Service

Cash Collections Budget

For the Months of January through March

$\backslash$table$[[*,$January,February,March,Quarter$],[$Cash sales$],[$Collection of credit sales:$],[20\%$ Month of sale$],[40\%$ Month after$],[30\%$ Two months after$],[$Total cash collections,,,,$]]$

Data table

More info

$20\%$ in the month of the sale

$40\%$ in the month after the sale

$30\%$ two months after the sale

$10\%$ are never collected