please answer for all 4 columns down (january, february, and march)

Gem Service anticipates the following sales revenue over a five-month period: Click the icon to view the sales data.) The company's sales are 40% cash and 60% 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) Gem Service Cash Collections Budget More info For the Months of January through March January 25% in the month of the sale 50% in the month after the sale Collection of credit sales 20% two months after the sale 25% Month of sale 50% Month after 5% are never collected 20% Two months after Total cash collections Print Done Cash sales Data table November December 16,100 $ 10,000 January February $ 15,400 $ 12,600 March $ 14,400 Sales revenue Vil Check