The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year:QI$ 210Sales02$ 270Beginning receivablesSalesCash collectionsEnding receivablesQ3$ 330a. Accounts receivable at the beginning of the year are $480. The company has a 45-day collection period. Calculate cashcollections in each of the four quarters by completing the following:Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.Beginning receivablesSalesCash collectionsEnding receivablesQ1210Q104$480210Q2Q2270b. Accounts receivable at the beginning of the year are $480. The company has a 60-day collection period. Calculate cashcollections in each of the four quarters by completing the following:Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.270Q3Q3330330DrairQ4Q448048021.10 H c. Accounts receivable at the beginning of the year are $480. The company has a 30-day collection period. Calculate cashcollections in each of the four quarters by completing the following:Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.Beginning receivablesSalesCash collectionsEnding receivablesQ1210Q2270Q3330Q4480www

Unmanaged accounts receivable can cause missed or delayed revenue, which lowers a business's…

Answered: The Morning Jolt Coffee Company has…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter21: Cash Budgeting (cashbud)

Section: Chapter Questions

Problem 5R: The following four suggestions have been made to improve the company’s cash position. Evaluate the...

See similar textbooks

Similar questions

Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year: Sales Q1 $ 750 Beginning receivables Sales Cash collections Ending receivables Q2 $ 810 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: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables S Beginning receivables Sales Cash collections Ending receivables S Q1 S 03 $ 890 Q1 335 750 Q1 04 $ 980 b. Accounts receivable at the beginning of the year are $335. The company has a 60-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. 335 750 Q2 335 750 Q2 810 Q2 810 Q3 810 Q3…
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year: Sales Q1 $ 540 Q2 $ 570 Q3 Q4 $ 630 $ 780 a. Accounts receivable at the beginning of the year are $300. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables Q1 540 Q2 570 Q3 630 Q4 780 b. Accounts receivable at the beginning of the year are $300. The company has a 60-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables Q1 540 Q2 570 Q3 630 Q4 780 c. Accounts receivable at the beginning of the year are $300. The company…
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year: 01 Sales $ 330 Q2 $ 390 Beginning receivables Sales Cash collections Ending receivables a. Accounts receivable at the beginning of the year are $360. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables Q3 $ 450 Show Transcribed Text Beginning receivables Sales Cash collections Ending receivables Q1 Q1 Q1 330 04 $ 600 330 b. Accounts receivable at the beginning of the year are $360. The company has a 60-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. 330 Q2 Q2 Q2 390 390 390…
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year. 04 $480 Sales 01 $ 210 02 $ 270 a. Accounts receivable at the beginning of the year are $480. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables $ Beginning receivables S Sales Cash collections Ending receivables 03 $ 330 Beginning receivables Sales Cash collections Ending receivables Q1 S Q1 480 210 585 105 $ 01 Answer is complete and correct. 480 210 $ 00 480 210 Q2 105 $ 270 b. Accounts receivable at the beginning of the year are $480. The company has a 60-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the…
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year 01 02 04 Sales # 330 $390 a. Accounts receivable at the beginning of the year are $360. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables 03 $450 Beginning receivables Sales Cash collections Ending receivables S Beginning receivables Sales Cash collections Ending receivables 01 01 300 330 01 330 b. Accounts receivable at the beginning of the year are $360. The company has a 60-day collection period Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e-g.. 32. 02 330 02 390 Q² 390 03 350 03 450 03 c. Accounts…
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $ 750 $ 810 $ 890 $ 980 Accounts receivable at the beginning of the year are $335. The company has a 45-day collection period. a. Calculate cash collections in each of the four quarters by completing the following: Q1 Q2 Q3 Q4 Beginning receivables Sales 750.00 810.00 890.00 980.00 Cash collections Ending receivables
Sheridan Company provided the following information for the month of October: Beginning cash balance=$34700 Cash receipts=459600 Cas disbursements=486000 Sheridan's policy is to keep a minimum end-of-the-month cash balance of $29300. How much will Sheridan need to borrow during October? $21000 $26400 $8300 $0
Here is a forecast of sales by National Bromide for the first 4 months of 2019 (figures in thousands of dollars): Month: 1 21 3\ 4 Cash sales 32 41 35 31 Sales on credit 185 205 175 155 On average, 60% of credit sales are paid for in the current month, 20% in the next month, and the remainder in the month after that. What are the expected cash collections in months 3 and 4? (Enter your answers in whole dollars not in thousands of dollars.) Expected Cash Collections Month 3 Month 4 < Prev 3 of 8 Next search
Here is a forecast of sales by National Bromide for the first 4 months of 2022 (figures in thousands of dollars): Month: 1 2 3 4 Cash sales 34 43 37 33 Sales on credit 195 215 185 165 On average, 60% of credit sales are paid for in the current month, 20% in the next month, and the remainder in the month after that. What are the expected cash collections in months 3 and 4? Note: Enter your answers in whole dollars not in thousands of dollars.
Here is a forecast of sales by National Bromide for the first 4 months of 2022 (figures in thousands of dollars): Month: Cash sales Sales on credit 1 2 3 4 27 36 30 26 160 180 150 130 On average, 50% of credit sales are paid for in the current month, 30% in the next month, and the remainder in the month after that. What are the expected cash collections in months 3 and 4? Note: Enter your answers in whole dollars not in thousands of dollars. Month 3 Month 4 Expected Cash Collections
Here is a forecast of sales by National Bromide for the first 4 months of 2019 (figures in thousands of dollars): Month: 1 2 3 4 Cash sales 30 39 33 29 Sales on credit 175 195 165 145 On average, 60% of credit sales are paid for in the current month, 20% in the next month, and the remainder in the month after that. What are the expected cash collections in months 3 and 4? (Enter your answers in whole dollars not in thousands of dollars.) Expected Cash collections Months 3 ______________ Months 4 ______________

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

SEE MORE TEXTBOOKS