Forecast Sales Account:

April $2024$ $$2,756,000$

May $3,223,000$

June $3,381,000$

July $3,129,000$

August $2,982,000$

september $3,087,000$

October $3,157,000$

November $3,219,000$

December $3,281,000$

Jan $2025$ $ $3,343,000$

February $3,288,000$

March $3,145,000$

Forecast collection schedule: In month of sale $62\%.$ In $1$st month after sale $22\%.$ In $2$nd month after sale $12\%.$ Uncollectible $4\%$

Prepare the following detailed schedule:

a$.$ The amounts to be collected in the month of December $2024?$

b$.$ The expected cash collections that are forecasted to be completed in the third $(3$rd$)$ quater of $2024.$ include all details of the monthly amounts to be collected in each of the three months during the period along with the total amount collected in the quarter?

c$.$ What is the total net accounts receivable as at the beginning of third$(3$rd$)$ quarter of $2024?($Hint: you have already calculated iit in part b$)$

d$.$ What is the total dollar$($$$)$ amount of bad debt in the third$(3$rd$)$ quarter of $2024?$