Total April $300, 000 May $500, 000 June Budgeted sales (all on account) $200, 000 $1,000,000 From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?

Total April $300, 000 May $500, 000 June Budgeted sales (all on account) $200, 000 $1,000,000 From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

XYZ Corp has the following sales budget: $195,550 $185,950 Sales budget They collect 60% of sales in the month of the sale, 20% in the first month after the sale, 15% in the second month after the sale, and 5% goes uncollected. What are the cash collections from sales in March? $206,050 January $205,000 $210,000 February $194,000 March $210,000
None
Center Company makes collections on sales according to the following schedule: 40% in the month of sale 50% in the month following sale 7% in the second month following sale The following sales are expected: Expected Sales January $ 106,000 February $ 142,000 March $ 125,000 Cash collections in March should be budgeted to be: $126,330. $128,420. $121,000. $125,000.
Aztec Company sells its product for $180 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) . 4,000 $ 720,000 May (actual) 2,000 360,000 June (budgeted) . 6,000 1,080,000 July (budgeted) 5,000 900,000 August (budgeted) . 3,800 684,000 All sales are on credit. Recent experience shows that 20% of credit sales is collected in the month of the sale, 50% in the month after the sale, 28% in the second month after the sale, and 2% proves to be uncollectible. The product’s purchase price is $110 per unit. 60% of purchases made in a month is paid in that month and the other 40% is paid in the next month. The company has a policy to maintain an ending monthly inventory of 20% of the next month’s unit sales plus a safety stock of 100 units. The April 30 and May 31 actual inventory levels are consistent with this policy. Selling and administrative expenses for the year are $1,320,000 and are paid evenly throughout the year in cash. The company’s minimum cash balance at…
Dec. Year Jan. Year 2 Feb. Year 2 Mar. Year 2 1 (Actual) $70,000 $20,000 (Budgeted) $165,000 $ 40,000 (Budgeted) $ 120,000 $ 22,000 (Budgeted) Credit sales $150,000 Cash sales $ 35,000 Based on the company's collection history, 42% of credit sales are collected in month of sale, and the remainder is collected in the following month. Cash collections in January from December credit sales would be: Multiple Choice $40,600. $45,500. $62,000. $60,200.
None
2. Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,620,000 Quarter 2 5,610,000 Quarter 3 1,190,000 Quarter 4 7,840,000 In Shalimar’s 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 $5,640,000 and for the fourth quarter of the current year are $7,320,000. Required: Question Content Area 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year $fill in the blank 0b62a1fb700f07d_1 $fill in the blank…
do not give solution in image
Cash budgetThe controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $86.000 $90,000 $95,000 Manufacturing costs 34,000 39,000 44,000 Selling and administrative expenses 15,000 16,000 22,000 Capital expenditures ___ __ 80,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $3,500 of the estimated monthly manufacturing costs. The annualinsurance premium is paid in September, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of May 1…
The BRS Corporation makes collections on sales according to the following schedule: 40% in month of sale 55% in month following sale 5% in second month following sale The following sales have been budgeted: April May June Sales $110,000 $120,000 $110,000 Budgeted cash collections in June would be: Multiple Choice $115,500 $110,000 $110,550 $112,000
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month Sales Revenue Month Sales Revenue $300,000 March 245,000 April $200,000 155,000 January February All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of sale. Operating expenses total $40,000 per month and are paid during the month incurred. The cash balance on February 1 is estimated to be $30,000. Prepare monthly cash budgets for February, March, and April. Use negative signs only with beginning and ending cash balances, when appropriate. Do not use negative signs with disbursement answers. Wilson's Retail Company Cash Budgets February, March, and April February March Cash balance, beginning $ Total Cash receipts Cash available Total disbursements Cash balance, ending…
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,690,000 Quarter 2 5,410,000 Quarter 3 4,890,000 Quarter 4 7,920,000 In Shalimar's 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 $5,160,000 and for the fourth quarter of the current year are $7,430,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. Quarter Cash Sales Credit Sales 3, current year $_______ $______ 4, current year ________ _______ 1, next year _______ _______ 2,…