Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale 20     Percent paid in the month after the sale 55     Percent paid in the second month after the sale 23     To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April $228,000   May 297,600   June 312,000   July 288,000   August 360,000   Required: 1.  Prepare a schedule of cash receipts for July. Be sure to enter percentages as whole numbers.

Current Attempt in Progress Swifty Industries expects credit sales for January, February, and March to be $176,000, $208,000, and $240,000, respectively. It is expected that 75% of the sales will be collected in the month of sale, and 25% will be collected in the following month. Compute cash collections from customers for each month. Credit Sales January February March $ January Collections from Customers February March

Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart 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 $127,000 November 159,000 December 232,000 The Accounts Receivable balance on September 30 was $85,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. OfficeMart Inc.Schedule of Cash Collections from SalesFor the Three Months Ending December 31   October November December Receipts from cash sales:       Cash sales $fill in the blank 1 $fill in the blank 2 $fill in the blank 3 September sales on account:…

The table contains the Sales estimates for the next year. Sales are collected as follows:In the month of Sales: 43%In the next month: 23%After 2 months: 14%After 3 months: remainder is collected What is the cash collection for November? Month Sales $ Month Sales $ Jan         28,555 July         36,215 Feb         21,027 Aug         19,907 Mar         19,907 Sep         28,555 Apr         36,215 Oct         19,907 May         28,555 Nov         21,027 June         21,027 Dec         36,215

5 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 November

A 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…

Center Company makes collections on sales according to the following schedule: 30% in the month of sale 60% in the month following sale 8% in the second month following sale The following sales are expected: Expected Sales January $117,000 February $152,000 March $132,000 Cash collections in March should be budgeted to be: Multiple Choice $130,800. $133.200. $140.160. $132,000.

X-Tel budgets sales of $55,000 for April, $110,000 for May, and $70,000 for June. Sales are 50% cash and 50% on credit. All credit sales are collected in the month following the sale. Total sales for March were $13,000. Prepare a schedule of cash receipts from sales for April, May, and June Sales Cash receipts from: Total cash receipts X-TEL Schedule of Cash Receipts from Sales April $ $ 55,000 $ 0 $ May 110,000 $ 0 $ June 70,000 0

Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects credit sales of $45,000 and $65,000, respectively. The company expects to collect 30% of its credit sales in the month of the sale and the remaining 70% in the following month. What is the expected cash collections from credit sales during the first month? Multiple Choice   $13,500   $31,500   $25,500   $49,000