X-Tel budgets sales of $80,000 for April, $116,000 for May, and $56,000 for June. Sales are 60% cash and 40% on credit. All credit sales are collected in the month following the sale. Total sales for March were $12,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 May June $ 80,000 $ 116,000 $ 56,000

X-Tel budgets sales of $80,000 for April, $116,000 for May, and $56,000 for June. Sales are 60% cash and 40% on credit. All credit sales are collected in the month following the sale. Total sales for March were $12,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 May June $ 80,000 $ 116,000 $ 56,000

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

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?
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?
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?
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?
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?
Cash 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?
Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment schedule for January using this data: in December through February, it purchased $22,000, $25,000, and $23,000 respectively.
Jasper Company has 62% of its sales on credit and 38% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $527,000 for April, $537,000 for May, and $562,000 for June. Total sales for March are $296,400. 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 527,000 537,000 June 562,000
Jasper Company has 57% of its sales on credit and 43% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $524,000 for April, $534,000 for May, and $559,000 for June. Total sales for March are $307,500. 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 524,000 ***** 534,000 June 559,000
Jasper Company has 62% of its sales on credit and 38% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $522,000 for April, $532,000 for May, and $557,000 for June. Total sales for March are $304,900. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Accounts receivable Total cash receipts JASPER COMPANY Schedule of Cash Receipts from Sales April 522,000 May 532,000 June 557,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
Jasper Company has 57% of its sales on credit and 43% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $518,000 for April, $528,000 for May, and $553,000 for June. Total sales for March are $293,600. Prepare a schedule of cash receipts from sales for April, May, and June. JASPER COMPANY Schedule of Cash Receipts from Sales April May June Sales 518,000 528,000 553,000 Cash receipts from: Total cash receipts