PLEASE PROVIDE EXCEL FUNCTIONS!!

\begin{tabular}{l} 1 \\ 1 \\ \hline \end{tabular} The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year. 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. b. Rework part (a) assuming a collection period of 60 days.c. Rework part (a) assuming a collection period of 30 days. 2 c. Rework part (a) assuming a collection period of 30 days. (Use cells A6 to E11 from the given information to complete this question.) Output Area: 45-day collection period