
Concept explainers
Schedule of Cash Collections of
Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows:
October | $133,000 |
November | 166,000 |
December | 243,000 |
The Accounts Receivable balance on September 30 was $89,000.
Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar.
Office World Inc. |
Schedule of Collections from Sales |
For the Three Months Ending December 31 |
October | November | December | |
Receipts from cash sales: | |||
Cash sales | |||
September sales on account | |||
Collected in October | |||
October sales on account | |||
Collected in October | |||
Collected in Noember | |||
November sales on account: | |||
Collected in November |
Collected in December | |||
December sales on account: | |||
Collected in December | |||
Total cash receipts |

PARTICULARS | OCTOBER | NOVEMBER | DECEMBER |
Receipts from cash sales: | |||
Cash sales |
$133000 * 25% = $33250 |
$166000 * 25% = $41500 |
$243000 * 25% = $60750 |
September sales on account | $89000 | ||
Collected in October | $71200 | ||
October sales on account |
$133000 * 75% = $99750 |
|
|
Collected in October |
$99750 *20% = $19950 |
|
|
Collected in November |
$99750 * 80% = $79800 |
|
|
November sales on account: |
$166000 * 75% =$124500 |
|
|
Collected in November |
$124500 *20% = $24900 |
Collected in December |
= $124500 * 80% = $99600 |
||
December sales on account: |
$243000 * 75% = $182250 |
||
Collected in December |
$182250 * 20% = $36450 |
||
Total cash receipts |
$124450 (OCTOBER MONTH CASH COLLECTION) |
$146200 (NOVEMBER MONTH CASH COLLECTION) |
$196800 (DECEMBER MONTH CASH COLLECTION) |
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps

- Jasper Company has 56% of its sales on credit and 44% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $523,000 for April, $533,000 for May, and $558,000 for June. Total sales for March are $305,700. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Cash sales JASPER COMPANY Schedule of Cash Receipts from Sales April May Collections of prior period sales Total cash receipts S S $ $ $ $ Junearrow_forward5 At Lyman Company, past experience reveals that 10% of sales are for cash and the remaining 90% are on credit. Lyman Company expects to collect 30% of its credit sales in the month of sale, 50% in the month following sale, and 18% in the second month following sale. Which ONE of the following is part of the cash collections expected to be made in January? O Cash sales from the preceding December O Cash collections of credit sales from the preceding December O Cash collections of credit sales from the preceding September O Cash sales from the preceding Novemberarrow_forwardA company is preparing its cash buget for the month of May. Below is A/R information: Actual credit sale for March $130,000 Actual credit sale for April $160,000 Estimated credit sales for May $210,000 Estimated collections in the month of sale 25% Estimated collections in the first month after the month of sale 60% Estimated collections in the second month after the month of sale 10% Estimated provision of bad debts (made in month of sale) 5% ** Firm writes off all UNCOLLECTIBLE account receievables at the end of second month after the month of sale. Required: For the month of May, calculate the following: 1. Estimated cash receipts from account recievable collections. 2. The gross amount of A/R at the end of the month (after appropriate write off of uncollectiable amounts). 3. The net amount of A/R at the end of the month 4. Recalculate the requirement 1 & 2 under the assumption that estimated collections in the month of sale equal 60% and in the first…arrow_forward
- Schedule of Cash Collections of Accounts Receivable Bark & Purr Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $160,000 June 230,000 July 350,000 All sales are on account. 53 percent of sales are expected to be collected in the month of the sale, 37% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for May, June, and July. May June July May sales on account: Collected in May $fill in the blank 1 Collected in June $fill in the blank 2 Collected in July $fill in the blank 3 June sales on account: Collected in June fill in the blank 4 Collected in July fill in the blank 5 July sales on account: Collected in July fill in the blank 6 Total cash collected $fill in the blank 7 $fill in the blank 8 $fill in the…arrow_forwardJasper Company has 56% of its sales on credit and 44% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $520,000 for April, $530,000 for May, and $555,000 for June. Total sales for March are $292,100. Prepare a schedule of cash receipts from sales for April, May, and June Sales Cash receipts from Cash sales Accounts payable Total cash receipts JASPER COMPANY Schedule of Cash Receipts from Sales April 520,000 May 530,000 June 555,000arrow_forwardRefer to the picture pleasearrow_forward
- Jasper Company has 56% of its sales on credit and 44% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $516,000 for April, $526,000 for May, and $551,000 for June. Total sales for March are $299,000. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Total cash receipts JASPER COMPANY Schedule of Cash Receipts from Sales April May 516,000 526,000 June 551,000arrow_forwardPlease do not give solution in image format thankuarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education





