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

The? company's sales are 40% cash and 60% credit.

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

25% in the month of the sale

50% in the month after the sale

15% two months after the sale

10% are never collected

Data Table

	November	December	January	February	March
Sales revenue. . . . . . . .	$16,100	$10,400	$15,600	$12,400	$14,400

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

Jewel Service

Cash Collections Budget

For the Months of January through March

	Jan	Feb	March	Total
cash sales
collection of credit sales
25% month of sale
50% month after
15% 2 months after
Total cash collections

Cash sales

Collection of credit sales:

25% Month of sale

50% Month after

15% Two months after

Total cash collections