On average, it takes 3 months before Oriole Corp. fully completes the collection cycle for its credit sales. All sales are made on account, with 20% of customers paying in the month of sale, 40% paying the month after sale, and 35% paying their balance 2 months after the sale; the remaining 5% is considered uncollectible. Given Oriole's budgeted sales for the 4 months leading up to quarter-end, as shown below, determine the company's collectible (or net) A/R balance on September 30. June Budgeted sales $48,500 July $48,000 A/R balance on September 30 $ August $53,800 September $76,600

On average, it takes 3 months before Oriole Corp. fully completes the collection cycle for its credit sales. All sales are made on account, with 20% of customers paying in the month of sale, 40% paying the month after sale, and 35% paying their balance 2 months after the sale; the remaining 5% is considered uncollectible. Given Oriole's budgeted sales for the 4 months leading up to quarter-end, as shown below, determine the company's collectible (or net) A/R balance on September 30. June Budgeted sales $48,500 July $48,000 A/R balance on September 30 $ August $53,800 September $76,600

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 14EB: Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is...

See similar textbooks

Similar questions

Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.
A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000
All Temps has a policy of always paying within the discount period, and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 80% of its payments are made in the month of purchase and 20% are made the following month. The direct materials budget provides for purchases of $23,812 in February, $23,127 in March, $21,836 in April, and $28,173 in May.What is the balance in accounts payable for April 30, and May 31?
Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
Earthies 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?
Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
The sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one-fourth in the West region. The budgeted selling price is 25 per unit. The desired ending inventory on June 30 is 2,000 units, and the expected beginning inventory on June 1 is 3,000 units. Prepare the following: a. A sales budget for June. b. A production budget for June.
The company has found that, on average, about 25 percent of its credit sales are collected during the month when the sale is made, and the remaining 75 percent of credit sales are collected during the month following the sale. As a result, the company uses these figures for budgeting. The company estimates its purchases at 60 percent of next month's sales, and payments for those purchases are budgeted to lag the purchases by one month. In addition, a tax payment of Sh.105,000 is due on January 15, and Sh.40,000 in dividends will be declared in January and paid in March. Also, the company has ordered a Sh.75,000 piece of equipment. Delivery is scheduled for early January, and payment will be due in February.The company’s projected cash balance at the beginning of January is Sh.100,000, and the company desires to maintain a balance of Sh.100,000 at the end of each month. Prepare a cash budget for Atlas Products, Company, for the first quarter of 2014, based on the following…
The company pays for its purchases within 10 days of purchase, so assume that one-third of the purchases of any month are due and paid for in the following month. The cost of the merchandise purchased is $10 per case. At the end of each month, it is desired to have an inventory equal in units to 75% of the following month's sales in units. Exclusive of bad debts, total budgeted selling and general administrative expenses for the fiscal year are estimated at$80,600, of which $19,000 is fixed expense (which includes a $5,200 annual depreciation charge). this is incurred fixed expenses uniformly throughout the year. The balance of the selling and general administrative expenses varies with sales. Expenses are paid as incurredRequirementl.
Maraa Company's budget includes the following credit sales for the current year: August, $25,000; September, $36,000; October, $30,000; November, $32,000. Experience has shown that payment for the credit sales is received as follows: 15% in the month of sale, 60% in the first month after sale, 20% in the second month after sale, and 5% is uncollectible. How much cash can Marra expect to collect in October as a result of current and past credit sales? Group of answer choices 1)$19,700. 2)$30,000. 3)$31,100. 4)$28,500. 5)$33,900.
Dax, Inc., collects its accounts receivable as follows: 30% in the month ofsale, 60% in the next month, and 8% in the second month after the sale; 2%are uncollectible. Budgeted sales for the next four months are March, $16,000; April, $22,000; May, $19,000; and June, $23,000. Budgeted collections forJune area. $20,060.b. $20,380.c. $21,260.d. $21,380.
Justin Company's budget includes the following credit sales for the current year: September, $42,000; October, $53,000; November, $47,000; December, $49,000. Credit sales are collected as follows: 10% in the month of sale, 65% in the first month after sale, 23% in the second month after sale, and 2% is uncollectible. How much cash can Justin expect to collect in November as a result of current and past credit sales? Multiple Choice $47,000. $51,610. $37,410. $48,810. $46,210.