X-Tel budgets sales of $65,000 for April, $120,000 for May, and $80,000 for June. Sales are 40% cash and 60% on credit. All credit sales are collected in the month following the sale. Total sales for March were $11,000. Prepare a schedule of cash receipts from sales for April, May, and June Sales Cash receipts from: X-TEL Schedule of Cash Receipts from Sales April May June $ 65,000 $ 120,000 $ 80,000 Total cash receipts $ 0 $ 0 $ 0

X-Tel budgets sales of $65,000 for April, $120,000 for May, and $80,000 for June. Sales are 40% cash and 60% on credit. All credit sales are collected in the month following the sale. Total sales for March were $11,000. Prepare a schedule of cash receipts from sales for April, May, and June Sales Cash receipts from: X-TEL Schedule of Cash Receipts from Sales April May June $ 65,000 $ 120,000 $ 80,000 Total cash receipts $ 0 $ 0 $ 0

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?
Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?
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?
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?
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?
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 $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
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 $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 $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