Concept explainers
Berry expects total sales of $359,000 in January and $405,000 in February. Assume that Berry’s sales are collected as follows:
80% in the month of the sale
10% in the month after the sale
6% two months after the sales
4% never collected
November sales totaled $350,000, and December sales were $325,000. Prepare a schedule of cash receipts from customers for January and February. Round answers to the nearest dollar.
Want to see the full answer?
Check out a sample textbook solutionChapter 22 Solutions
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Additional Business Textbook Solutions
Fundamentals Of Financial Accounting
Cost Accounting (15th Edition)
Fundamentals of Financial Accounting
Advanced Financial Accounting
Horngren's Financial & Managerial Accounting, The Financial Chapters (6th Edition)
Financial Accounting (12th Edition) (What's New in Accounting)
- Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?arrow_forwardEarthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?arrow_forwardMy Aunts Closet Store collects 60% of its accounts receivable in the month of sale and 35% in the month after the sale. Given the following sales, how much cash will be collected in March?arrow_forward
- Nonnas Re-Appliance Store collects 55% of its accounts receivable in the month of sale and 40% in the month after the sale. Given the following sales, how much cash will be collected in February?arrow_forwardCash collections for Wax On Candles found that 60% of sales were collected in the month of the sale, 30% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in January and February?arrow_forwardWells Company reports the following sales forecast: September, $55,000; October, $66,000; and November, $80,000. All sales are on account. Collections of credit sales are received as follows: 25% in the month of sale, 60% in the first month after sale, and 10% in the second month after sale. 5% of all credit sales are written off as uncollectible. Prepare a schedule of cash receipts for November.arrow_forward
- The Palos Company expects sales for June, July, and August of $48,000, $54,000, and $44,000, respectively. Experience suggests that 40% of sales are for cash and 60% are on credit. The company collects 50% of its credit sales in the month following sale, 45% in the second month following sale, and 5% are not collected. What are the company's expected cash receipts for August from its current and past sales?arrow_forwardMarcel Company projects the following sales for the first three months of the year: $13,500 in January; $12,200 in February, and $10,500 in March. The company expects 60% of the sales to be cash and the remainder on account Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Read the requirements. Requirements 1. Prepare a schedule of cash receipts for Marcel for January, February, and March. What is the balance in Accounts Receivable on March 31? 2. Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale, 30% in the month following the sale, and 10% in the second month following the sale. What is the balance in Accounts Receivable on March 31? Ouruary CASH SHIVJ Print March-Cash sales February-Credit sales, collection of February sales in February February-Credit sales, collection of February sales…arrow_forwardFrom past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, another 75% are collected in the month following sale, and the remaining 5% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $270,000, and March sales totaled $300,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?arrow_forward
- Graham Company projects the following sales for the first three months of the year: $10,600 in January: $14,600 in February; and $16,300 in March. The company expects 80% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Read the requirements. Requirement 1. Prepare a schedule of cash receipts for Graham for January, February, and March. What is the balance in Accounts Receivable on March 31? (If an input field is not used, leave the input field empty. Do not enter a zero.) Cash Receipts from Customers Total sales Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credit sales, collection of February sales in…arrow_forwardMountaineers expects total sales of $702,500 for January and $351,000 for February. Assume that Mountaineers's sales are collected as follows: November sales totaled $398,000, and December sales were $407,000. Prepare a schedule of cash receipts from customers for January and February. Round answers to the nearest dollar. (If an input field is not used in the table leave the input field empty, do nothing enter a zero.)arrow_forwardJane MacDonald, Carroll Financial Analyst, prepared the following sales and cash disbursement estimates for the February-June period of this year. Month Sales Cash Disbursements February 500 400 March 600 300 April 400 600 May 200 500 June 200 200 MacDonald indicates that 30% of sales have been, historically, in cash. 70% of credit sales are collected one month after the sale, and the remaining 30% are collected two months after the sale. The company wants to keep a minimum final balance in its $ 25 cash account. Balances in excess of this amount will be invested in short-term government securities (marketable securities), while any deficits will be financed through short-term bank borrowing (payable securities). The cash balance initially on April 1 is $ 115. Prepare cash budgets for April, May, and June. How much, if any, of the maximum funding would Carroll require to meet its obligations within this three-month period?…arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning