Orchard Company has forecast sales to be $129,000 in February, $144,000 in March, $150,000 in April, and $141,000 in May. The average cost of goods sold is 70% of sales. All sales are made on credit, and sales are collected 70% in the month of sale and 30% in the month following. What is the budgeted Accounts Receivable balance on May 31? 6:42 PM

Orchard Company has forecast sales to be $129,000 in February, $144,000 in March, $150,000 in April, and $141,000 in May. The average cost of goods sold is 70% of sales. All sales are made on credit, and sales are collected 70% in the month of sale and 30% in the month following. What is the budgeted Accounts Receivable balance on May 31? 6:42 PM

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 9PA: Fitbands estimated sales are: What are the balances in accounts receivable for January, February,...

See similar textbooks

Similar questions

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?
Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?
Last year, Tobys Hats had net sales of 45,000,000 and cost of goods sold of 29,000,000. Tobys had the following balances: Refer to the information for Tobys on the previous page. Required: Note: Round answers to one decimal place. 1. Calculate the average accounts receivable. 2. Calculate the accounts receivable turnover ratio. 3. Calculate the accounts receivable turnover in days.
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?
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?
Millennial Manufacturing has net credit sales for 2018 in the amount of $1,433,630, beginning accounts receivable balance of $585,900, and an ending accounts receivable balance of $621,450. Compute the accounts receivable turnover ratio and the number of days sales in receivables ratio for 2018 (round answers to two decimal places). What do the outcomes tell a potential investor about Millennial Manufacturing if industry average is 2.6 times and number of days sales ratio is 180 days?
Jasper Company has sales on account and for cash. Speclfically, 63% of Its sales are on account and 37% are for cash. Credit sales are collected In full in the month following the sale. The compay forecasts sales of $526.000 for April, $536.,000 for May, and $561,000 for June. The beginning balance of Accounts Recetvable Is S291.600 on Aprll 1. Prepare a schedule of budgeted cash recelpts for Aprl, May, and June.
As of January 1, 2021, NUBD Co. had an accounts receivable of P500,000. The sales for January, February, and March were as follows: P1,200,000, P1,400,000, and P1,600,000, respectively. Of each month’s sales, 80% is on account. 60% of account sales is collected in the month of sale, with remaining 40% collected in the following month. What is the accounts receivable balance as of March 31, 2021? A. P720,000 B. P480,000 C. P587,200 D. P512,000
ABC, Incorporated, has a beginning receivables balance on January 1st of $620. Sales for January through April are $380, $410, $490 and $510, respectively. The accounts receivable period is 60 days. How much did the firm collect in the month of March? Assume 365 days per year.
As of January 1 of the current year, Grayson Company had accounts receivable of $40,000. The sales for January, February, and March were $120,000, $140,000, and $150,000, respectively. Of each month's sales, 20% are for cash. Of the remaining 80% (the credit sales), 60% are collected in the month of sale, with the remaining 40% collected in the following month. What is the total cash collected (both from accounts receivable and for cash sales) in the month of January?
As of January 1 of the current year, Phyllis Company had accounts receivable of $50,000. The sales for January, February, and March were $120,000, $140,000, and $160,000, respectively. 20% of each month's sales are for cash. Of the remaining 80% (the credit sales), 60% are collected in the month of sale, with the remaining 40% collected in the following month. What is the total cash collected (both from accounts receivable and for cash sales) in the month of March? a.$153,600 b.$146,800 c.$142,800 d.$138,000
Sweetens Cove, Incorporated, has weekly credit sales of $69400 and the average collection period is 23 days. What is the average accounts receivable figure?