Hoosier Inc. sells basketballs. The following is the trial balance for Hoosier Inc. as of $9/30/2023.$

Budgeted sales for October total $$160,000,$ consisting of $$40,000$ cash and $$120,000$ on credit.

The company expects sales to increase by $12\%$ each month.

The mix of cash $v.$ credit sales is not expected to change from month to month.

HALF of the credit sales are collected in the following month. The remaining sales are collected $2$ months later.

$$25,000$ of the AR at $\frac{9}{30}$ was collected in October, the remaining amount was collected in November.

Prepare a sales budget and schedule of cash receipts for October, November, and December.

$\backslash$table$[[$Sales Budget:,October,November,December,Total,$],[$Cash Sales$],[$Credit Sales$],[$Total$],[,,,,,],[$Cash Receipts,October,November,December,Total,$],[$Cash Sales,$$40,000,,,,],[$Credit Sales,$25,000,,,,],[$Total$,,,,372,176,],[$What is total revenue for the fourth quarter $($Q$4)?],[$What is the accounts receivable balance at $\frac{12}{31}\frac{?}{2023}?$