please only do the blank bottom, and explain how you did it. I included the top to help give context I only need the second questions!

Rovniak Reeds, a manufacturer of saxophone, oboe, and clarinet reeds, has projected sales to be $894,000 in October, $956,000 in November, $1,045,000 in December, and $936,000 in January. Rovniak's sales are 30% cash and 70% credit. The company's collection history indicates that credit sales are collected as follows: 20% in the month of the sale 65% in the month after the sale 12% two months after the sale 3% are never collected Requirements 1. Prepare a sales budget for all four months, showing the breakdown between cash and credit sales. 2. Prepare a cash collection budget for December and January. Round all answers up to the nearest dollar. Cash sales S 288,200 $ 286,800 S 313,500 $ 280,800 625.800 669.200 Credit sales 731,500 655,200 894,000 $ 956,000 S 1,045,000 $ 936,000 Total sales Requirement 2. Prepare a cash collection budget for December and January. Round all answers up to the nearest dollar. Rovniak Reeds Budgeted Cash Collections from Customers For the Months of December and January December January Cash sales $ 313,500 $ 280,800 Collection of credit sales: 20% of current month credit sales 146,300 131,040 65% of prior month credit sales 12% of credit sales two months ago Total collection of credit sales Total cash collections