Please answer all parts and show your steps!

Gem Service anticipates the following sales revenue over a five-month period EEB (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 1 (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 For the Months of January through March January February March Quarter More Info Cash sales Collection of credit sales 20% Month of sale 40% Month after 25% Two months after 20% in the month of the sale 40% in the month after the sale 25% two months after the sale 15% are never collected Total cash collections Data Table Print Done November December January February March