Question
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $ 720 $ 750
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year: |
Q1 | Q2 | Q3 | Q4 | |||||||||
Sales | $ | 720 | $ | 750 | $ | 830 | $ | 910 | ||||
a. | Accounts receivable at the beginning of the year are $310. Morning Jolt has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Negative amounts should be indicated by a minus sign.) |
Q1 | Q2 | Q3 | Q4 | |||||
Beginning receivables | $310 | $360 | $375 | $415 | ||||
Sales | 720 | 750 | 830 | 910 | ||||
Cash collections | ||||||||
Ending receivables | $360 | $375 | $415 | $455 | ||||
b. | Recalculate the cash collections with a collection period of 60 days. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places. (e.g., 32.16)) |
Q1 | Q2 | Q3 | Q4 | |||||
Beginning receivables | $310 | $480 | $500 | $553.33 | ||||
Sales | 720 | 750 | 830 | 910 | ||||
Cash collections | ||||||||
Ending receivables | $480 | $500 | $553.33 | $606.67 | ||||
c. | Recalculate the cash collections with a period of 30 days. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places. (e.g., 32.16)) |
Q1 | Q2 | Q3 | Q4 | |||||
Beginning receivables | $310 | $240 | $250 | $276.67 | ||||
Sales | 720 | 750 | 830 | 910 | ||||
Cash collections | ||||||||
Ending receivables | $240 | $250 | $276.67 | $303.33 |
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started