Kingston budgets total sales for June and July of $440,000 and $398,000, respectively. Cash sales are 65% of total sales. Of the credit sales, 20% are collected in the month of sale, 65% 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 $ 440,000 398,000 Credit Sales As of July 31 Percent Uncollected Amount Uncollected

Kingston budgets total sales for June and July of $440,000 and $398,000, respectively. Cash sales are 65% of total sales. Of the credit sales, 20% are collected in the month of sale, 65% 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 $ 440,000 398,000 Credit Sales As of July 31 Percent Uncollected 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

Oivas Corporation is preparing its cash budget for September. The budgeted beginning cash balance is $46,000. Budgeted cash seceipts total $160,000 and budgeted cash disbursements total $152,000. The desired ending cash balance is $70,000. The company can borrow up to $120,000 at any time from a local bank, with interest not due until the following month. What is the amount required to borrow in order to have the desired ending cash balance? Oa $15,000 Ob $10,000 Oc $26,000 Od $16,000
Bridgeport Inc. has budgeted sales for the second quarter of $340,000 for April; $505,000 for May; and $670,000 for June. Normally, 20% are cash sales and 80% of sales are on account. As well, 30% of the sales on account are normally collected during the month of sale, 50% in the following month, and 20% in the second month following sale. The accounts receivable balance as of April 1 is $250,000.Prepare the schedule of cash collections for the second quarter by month and in total. (Round intermediate calculations and final answers to 0 decimal places, e.g. 15 or 15%.)
Prepare a master budget for the three-month period ending June 30 that includes a schedule of expected cash collections, by month and in total.
Bramble Company expects to have a cash balance of $43,200 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $81,600, February $144,000. Payments for direct materials: January $48,000, February $72,000. Direct labor: January $28,800, February $43,200. Wages are paid in the month they are incurred. Manufacturing overhead: January $20,160, February $24,000. These costs include depreciation of $1,440 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $14,400, February $19,200. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $11.520 in cash. Bramble Company has a line of credit at a local bank that enables it to borrow up to $24,000. The company wants to maintain a minimum monthly cash balance of $19,200. Prepare a cash budget for January and February.
Big Wheel, Inc., collects 25% of its sales on account in the month of the sale and 75% in the month following the sale. Sales on account are budgeted to be $22,500 for March and $74,100 for April. What are the budgeted cash receipts from sales on account for April?$
Maraa Company's budget includes the following credit sales for the current year: August, $25,000; September, $36,000; October, $30,000; November, $32,000. Experience has shown that payment for the credit sales is received as follows: 15% in the month of sale, 60% in the first month after sale, 20% in the second month after sale, and 5% is uncollectible. How much cash can Marra expect to collect in October as a result of current and past credit sales? Group of answer choices 1)$19,700. 2)$30,000. 3)$31,100. 4)$28,500. 5)$33,900.
ABC Company’s budgeted sales for June, July, and August are 13,200, 17,200, and 15,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 3% in the second month following the sale. Required: Prepare an analysis of cash receipts from sales for ABC Company for August.
Jasper Company has sales on account and for cash. Specifically, 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 company forecasts sales of $525,000 for April, $535,000 for May, and $560,000 for June. The beginning balance of Accounts Receivable is $302,000 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. April May June Cash sales 37% Sales on account 63% Total sales JASPER COMPANY Schedule of Cash Receipts For April, May, and June April May June Cash receipts from: Cash sales Collection of accounts receivable Total budgeted cash receipts
Big Wheel, Inc. collects 25% of its sales on account in the month of the sale and 75% in the month following the sale. Sales on account are budgeted to be $17,100 for March and $40,800 for April. What are the budgeted cash receipts from sales on account for April?
The following is the sales budget for Yellowhead Inc. for the first quarter of 2021: Sales January $200,000 February $220,000 March $243,000 Credit sales are collected as follows: 65% in the month of the sale, 20% in the month after the sale, and 15% in the second month after the sale. The accounts receivable balance at the end of the previous quarter was $84,000 ($54,000 of which was uncollected December sales). a. Calculate the sales for November. (Omit "$" sign in your response.) November sales b. Calculate the sales for December. (Round the final answer to 2 decimal places. Omit "$" sign in your response.) December sales $ c. Calculate the cash collections from sales for each month from January through March. (Do not round intermediate calculations. Round the final answers to 2 decimal places. Omit "$" sign in your response.) January February March Cash collections $ $ $
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 $237,000, $308,000, and $422,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 October from accounts receivable are estimated to be a.$172,480 b.$205,660 c.$246,792 d.$139,300
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…