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

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

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

YZ company is preparing its cash budget for the first quarter of the year. It has $10,000 in cash at the beginning of the period. Cash collections from customers for the quarter are budgeted at $28,000. Cash ayment during the quarter for inventory purchases are budgeted at $25,000. The desired cash balance at the end of the quarter is $8,000. Other operating expenses for the quarter are budgeted at $20.000, whic ncludes $3.000 depreciation. Cash expenses are paid in the month incurred. How much borrowing will the company need during the quarter? Select one: O a. None of the given answers O b. $18,000 O c $4,000 O d. $15,000 O e. $12,000
Ross Corporation makes all sales on account. The June 30th balance sheet balance in its accounts receivable is $400,000, of which $240,000 pertain to sales that were made during June. Budgeted sales for July are $1,250,000. Ross collects 70% of sales in the month of sale; 20% in the following month; and the final 10% in the second month after the sale. What are Ross's budgeted collections for July? Select one: a. $800,000. b. $939,000. c. $1,083,000. d. $915,000.
Getty Company expects sales for the first three months of next year to be $205,000, $240,000 and $280,000, respectively. Getty expects 30 percent of its sales to be cash and the remainder to be credit sales. The credit sales will be collected as follows: 10 percent in the month of the sale and 90 percent in the following month. Compute a schedule of Getty's cash receipts for the months of February and March. Budgeted cash receipts February March
Nestee controller for Mactan Relaters has assembled the following data to assist in the preparation of a cash budget for the third quarter of 2021: Sales- May $100,000 ;June $120,000; July $90,000 ; August $100,000 September $135,000; October $110,000 Each month, 30% of sales are for cash and 70% ore on credit. The collection pattern for credit sales is 20% in the month of sale, 50% in the following month, and 30% in the second month following the sale. Each month the ending inventory exactly equals 50% of the cost of next month's sales. The markup on goods is 25% of cost. Inventory purchases are paid in the month following the purchase. Monthly expenses are as follows: Salaries and wages $10,000; Depreciation $4,000; Utlites $1,000; Other $1,700. Property taxes of $15,000 are due and payable on July 15,2021. Advertising fees of $6,000 must be paid on August 20,2021. A lease on a new storage facility is scheduled to begin on September 2, 2021.Monthly payments are $5,000. The…
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
Floss Company has $13,000 in cash on hand on January 1 and has collected the following budget data. Assume Floss has cash payments for selling and administrative expenses including salaries of $66,000 plus commissions of 2% of sales, all paid in the month of sale. The company requires a minimum cash balance of $11,000. Prepare a cash budget for January and February. Will Floss need to borrow cash by the end of February? Beginning bye preparing the cash budget for January, then the cash budget for February. (Complete all input fields. Enter a “0” for any zero balances. )
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%.)
The following information is available for Zetrov Company. a. The cash budget for March shows an ending bank loan of $17,000 and an ending cash balance of $70,500. b. The sales budget for March indicates sales of $134,000. Accounts receivable are expected to be 60% of the current-month sales. c. The merchandise purchases budget indicates that $90,400 in merchandise will be purchased on account in March. Purchases on account are paid 100% in the month following the purchase. Ending inventory for March is predicted to be 740 units at a cost of $35 each. d. The budgeted income statement for March shows net income of $49,400. Depreciation expense of $2,400 and $27,400 in income tax expense were used in computing net income for March. Accrued taxes will be paid in April. e. The balance sheet for February shows equipment of $82,600 with accumulated depreciation of $31,400, common stock of $32,000, and ending retained earnings of $9,400. There are no changes budgeted in the equipment or…
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.