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. C. Rework part (a) assuming a collection period of 30 days. Input Area: Beginning A/R Collection period Collection period Collection period $335 45 60 30 Q1 $750 Q2 Q3 $890 04 Sales $810 $980 (Use cells A6 to E11 from the given information to complete this question.) Output Area: 45-day collection period Q1 Q2 Q3 Q4 Beginning receivables Sales Cash collections Ending receivables 60-day collection period Beginning receivables Sales Cash collections Ending receivables 30-day collection period Beginning receivables Sales Cash collections Ending receivables