Kingston budgets total sales for June and July of $500,000 and $328,000, respectively. Cash sales are 70% of total sales. Of the credit sales, 25% are collected in the month of sale, 60% are collected during the first month after the sale, and the remaining 15% are collected in the second month after the sale. Determine the amount of accounts receivable reported on the company's budgeted balance sheet as of July 31. Hint: Determine the percent of June and July sales that are uncollected at July 31. Sales month June July Total Total Sales $ Credit Sales 500,000 $ 328,000 375,000 246,000 As of July 31 Percent Uncollected 60% 15% Amount Uncollected

Kingston budgets total sales for June and July of $500,000 and $328,000, respectively. Cash sales are 70% of total sales. Of the credit sales, 25% are collected in the month of sale, 60% are collected during the first month after the sale, and the remaining 15% are collected in the second month after the sale. Determine the amount of accounts receivable reported on the company's budgeted balance sheet as of July 31. Hint: Determine the percent of June and July sales that are uncollected at July 31. Sales month June July Total Total Sales $ Credit Sales 500,000 $ 328,000 375,000 246,000 As of July 31 Percent Uncollected 60% 15% Amount Uncollected

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

Use the following Information to prepare the July cash budget for Acco Company. Ignore the "Loan activity" section of the budget a. Beginning cash balance on July 1: $72,000. b. Budgeted cash receipts from sales: 25% is collected in the month of sale, 50% In the next month, and 25% in the second month after sale. Sales amounts are May (actual), $1,830,000; June (actual), $1,490,000; and July (budgeted), $1,600,000. c. Budgeted cash payments on merchandise purchases: 80% in the month of purchase and 20% in the month following purchase. Purchase amounts are June (actual), $560,000; and July (budgeted), $730,000. d. Budgeted cash payments for salaries in July: $180,000. e. Budgeted cash payments for sales commissions for July: $110,000. f. Budgeted cash payment for Income taxes In July: $100,000. g. Budgeted cash payment for loan Interest in July: $5,500. Complete this question by entering your answers in the tabs below. Calculation Cash Budget Prepare the July cash budget for Acco…
Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business-September, October, and November-are $241,000, $314,000, and $415,000, respectively. The company expects to sell 30% of its merchandise for cash. Of sales on account, 80% are expected to be collected in the month of the sale and 20% in the month following the sale. The cash collections expected in November from accounts receivable are projected to be: C a. $331,632 Ob. $232,400 O c. $188,440 Od. $276,360
Papst Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable (based on sales made to customers on open account): Actual credit sales for March $ 135,000 Actual credit sales for April $ 167,000 Estimated credit sales for May $ 222,000 Estimated collections in the month of sale 25% Estimated collections in the first month after the month of sale 60% Estimated collections in the second month after the month of sale 10% Estimated provision for bad debts (made in the month of sale) 5% The firm writes off all uncollectible accounts at the end of the second month after the month of sale. Determine for Papst Company for the month of May: The estimated cash receipts from accounts receivable collections. The gross amount of accounts receivable at the end of the month after appropriate write-off of uncollectible accounts. The net amount of accounts receivable at the end of the month. Recalculate…
The following is the sales budget for Lemonis, Incorporated, for the first quarter of 2021: January February March Sales budget $198,000 $218,000 $241,000 Credit sales are collected as follows: 55 percent in the month of the sale. 30 percent in the month after the sale. 15 percent in the second month after the sale. The accounts receivable balance at the end of the previous quarter was $82,000 ($52,000 of which was uncollected December sales). a. Calculate the sales for November. (Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Calculate the sales for December. (Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. Calculate the cash collections from sales for each month from January through March. (Do not round Intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) a. November sales b. December sales c. January cash collections c. February cash collections c.…
Kingston budgets total sales for June and July of $520,000 and $488,000, respectively. Cash sales are 70% of total sales. Of the credit sales, 15% are collected in the month of sale, 60% are collected during the first month after the sale, and the remaining 25% are collected in the second month after the sale. Determine the amount of accounts receivable reported on the company's budgeted balance sheet as of July 31. Hint: Determine the percent of June and July sales that are uncollected at July 31. Sales month June July Total Total Sales $ 520,000 488,000 Credit Sales As of July 31 Percent Uncollected Amount Uncollected
The treasurer of U Co. has accumulated the budget information presented in the table for the months of March and April pertaining to cash payments. Forty percent of the merchandise costs are expected to be paid in the month they are incurred and the remaining sixty percent in the following month. All of the operating expenses are paid for by cash in the month they are incurred. The accounts payable balance on March 1 is $60,000. What is the amount to include in the Cash Budget for the month of March for the Merchandise Costs (which does include the beginning balance from February)? MARCH APRIL Merchandise costs $120,000 $132,000 Operating expenses 100,000 110,000
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech’s managers have made the following additional assumptions and estimates: Estimated sales for July, August, September, and October will be $410,000, $430,000, $420,000, and $440,000, respectively. All sales are on credit and all credit sales are collected. Each month’s credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. Each month’s ending inventory must equal 30% of the cost of next month’s sales. The cost of goods sold is 70% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July. Monthly selling and administrative expenses are…
Emerald Service anticipates the following sales revenue over a five-month period Its collection history indicates that credit sales are collected as follows E (Click the icon to view the sales data ) The company's sales are 40% cash and 60% credit O (Click the icon to view the collections data) How much cash will be collected in January? In February? In March? For the quarter in total? Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole dollar) Emerald Service Cash Collections Budget For the Months of January through March January Cash sales 6,080 Collection of credit sales 25% Month of sale 2,280 50% Month after 15% Two months after Total cash collections
The Ellis Company has budgeted its activity for September according to the following information: Sales are budgeted at $392,000 and all sales are for cash. All purchases of merchandise inventory are for cash. Merchandise inventory was $150,000 on August 31 and the planned merchandise inventory on September 30 is $140,000. All merchandise is sold at 40% above cost. The selling and administrative expenses are budgeted at $92,000 for the month. All of these expenses are paid for in cash except for depreciation of $12,000. The budgeted net income for September is?
ABC Company's budgeted sales for June, July, and August are 14,200, 18,200, and 16,200 units respectively. The selling price for each unit is $15. Based on past experience, ABC expects that 40% of a month's sales will be collected in the month of sale, 55% in the following month, and 2% in the second month following the sale. Required: Prepare an analysis of cash receipts from sales for ABC Company for August. Budgeted sales units Unit selling price Budgeted sales revenue August collections: Current month's sales. Prior month's sales. Second prior month's sales. Total collections June July August
McFarland Company makes 70 percent of its sales in cash. Credit sales are collected as follows: 70 percent in the month of sale and 30 percent in the month following the sale. McFarland's budgeted sales for upcoming months follow: $ 24,200 42,000 40,000 38,000 June July August September Required: Compute McFarland's expected cash receipts for August Budgeted Cash Receipts
The following information is provided to assist in the preparation of the Cash Budget for Ding Ltd. for May 2020. The cash balance at 1 May 2020 is $30,000. Budgeted Sales ($) Budgeted Purchases ($) April 170,000 64,000 May 140,000 68,000 All sales are on cash basis and will be collected in the same month the sale is made. All purchases are made on credit and payments are made as follows: 60% of purchases are paid for in the month of purchase. 40% of purchases are paid for in the month following the purchase. The business plans to take out a small business loan of $50,000 at the end of May 2020 and will be repaying it back in July 2020. Selling and administrative expenses each month are $45,000. The selling and administrative expenses include monthly depreciation expense of $6,000. Sales commission is 15% of the total monthly sales, and paid to the staff at the end of every month. Equipment costing $35,000 is expected to be bought in May and paid in…