A Jx D E G H Chapter 18- Dropbox 5.4 Enable Editi Problem 2: Calculating Cash Collections The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year: Sales Q1 $820 Q2 Q3 Q4 $850 $930 $1,010 Accounts Receivable at the beginning of the year are $345. a) Calculate cash collections in each quarter if the collection period is 45 days. b) Calculate cash collections in each quarter if the collection period is 60 days. c) Calculate cash collections in each quarter if the collection period is 30 days. Use the Template Provided Below to Create Your Solution - Pay close attention to the formul Input Area: Beginning A/R a. Collection period b. Collection period c. Collection period Sales Q1 22 Q2 Q3 Q4