Flint Development, Inc. has budgeted sales revenues as follows: Budgeted Sales Revenues $56,000 January February March April May June 65,000 98,000 84,000 68,000 34,000 Past experience has indicated that 80% of sales each month are on credit and that collection of credit sales occurs as follows: 60% in the month of sale, 30% in the month following the sale, and 5% in the second month following the sale. The other 5% is uncollectible. Prepare a schedule which shows expected cash receipts from sales for the months of April, May, and June. (Do not leave any answer field blank. Enter O for amounts)

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
**Flint Development, Inc. Budgeted Sales Revenues:**

| Month       | Revenue  |
|-------------|----------|
| January     | $56,000  |
| February    | $65,000  |
| March       | $98,000  |
| April       | $84,000  |
| May         | $68,000  |
| June        | $34,000  |

*Note:* Past experience has indicated that 80% of sales each month are on credit. Collection of credit sales occurs as follows: 60% in the month of sale, 30% in the month following the sale, and 5% in the second month following the sale. The remaining 5% is uncollectible.

Prepare a schedule that shows expected cash receipts from sales for the months of April, May, and June.

**Schedule: Expected Cash Receipts from Sales for the Quarter Ended June 30:**

| Sales Type     | April  | May   | June  |
|----------------|--------|-------|-------|
| **February Sales**   |        |       |       |
| Credit Sales   | $2,600 |       |       |
| **March Sales**      |        |       |       |
| Credit Sales   | $29,400 | $29,400 |  |
| **April Sales**      |        |       |       |
| Credit Sales   | $31,200 | $15,600 | $2,600 |
| Cash Sales     | $16,800 |       |       |
| **May Sales**        |        |       |       |
| Credit Sales   |        | $24,000 | $12,000 |
| Cash Sales     |        | $13,600 |       |
| **June Sales**       |        |       |       |
| Credit Sales   |        |       | $10,200 |
| Cash Sales     |        |       | $6,800 |

**Total Cash Receipts:**

| Month | Total Receipts |
|-------|----------------|
| April | $64,000        |
| May   | $67,000        |
| June  | $29,050        |

This schedule delineates the cash flow from credit and cash sales, helping to forecast the expected monthly revenue.
Transcribed Image Text:**Flint Development, Inc. Budgeted Sales Revenues:** | Month | Revenue | |-------------|----------| | January | $56,000 | | February | $65,000 | | March | $98,000 | | April | $84,000 | | May | $68,000 | | June | $34,000 | *Note:* Past experience has indicated that 80% of sales each month are on credit. Collection of credit sales occurs as follows: 60% in the month of sale, 30% in the month following the sale, and 5% in the second month following the sale. The remaining 5% is uncollectible. Prepare a schedule that shows expected cash receipts from sales for the months of April, May, and June. **Schedule: Expected Cash Receipts from Sales for the Quarter Ended June 30:** | Sales Type | April | May | June | |----------------|--------|-------|-------| | **February Sales** | | | | | Credit Sales | $2,600 | | | | **March Sales** | | | | | Credit Sales | $29,400 | $29,400 | | | **April Sales** | | | | | Credit Sales | $31,200 | $15,600 | $2,600 | | Cash Sales | $16,800 | | | | **May Sales** | | | | | Credit Sales | | $24,000 | $12,000 | | Cash Sales | | $13,600 | | | **June Sales** | | | | | Credit Sales | | | $10,200 | | Cash Sales | | | $6,800 | **Total Cash Receipts:** | Month | Total Receipts | |-------|----------------| | April | $64,000 | | May | $67,000 | | June | $29,050 | This schedule delineates the cash flow from credit and cash sales, helping to forecast the expected monthly revenue.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education