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

View the sales data.

View additional information.

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.$)$

Garnet Service

Cash Collections Budget

For the Months of January through March

Cash sales

Collection of credit sales:

$20\%$ Month of sale

$40\%$ Month after

$35\%$ Two months after

otal cash collections

$\backslash$table$[[$January$,$February$],[$$$,6,160,],[,1,848,],[,2,400,],[,3,423,],[$$$,13,831,]]$

Additional information

The company's sales are $40\%$ cash and $60\%$ credit. Its collection history indicates that credit sales are collected as follows:

$20\%$ in the month of the sale

$40\%$ in the month after the sale

$35\%$ two months after the sale

$5\%$ are never collected

Sales data

$\backslash$table$[[,,$November,,ecember,,January,,ebruary,,March$],[$Sales revenue,dotsdots.$$,16,300,$$$,10,000,$$$,15,400,$$$,13,000,$$$,14,000]]$