$5.$ Calculating Cash Collections The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year:

Sales

Q$1$

$$750$

Q$2$

$$810$

Q$3$

$$890$

Q$4$

$$980$

a$.$ Accounts receivable at the beginning of the year are $$335.$ The company has a $45-$day collection period. Calculate cash collections in each of the four quarters by completing the following:

$01$

$02$

$03$

Q$4$

Beginning receivables

Sales

Cash collections

Ending receivables

b Rework part $($a$)$ assuming a collection period of $60$ days.

c Rework part $($a$)$ assuming a collection period of $30$ days.

use excel to solve this please