The LaGrange Corporation had the following budgeted sales for the first half of the current year Cash Sales $ 50,000 $ 55,000 January February March April May June Collections on sales: 50% in month of sale The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Multiple Choice O 30% in month following sale 20% in second month following sale The accounts receivable balance on January 1 of the current year was $81,000, of which $50,000 represents uncollected December sales and $31,000 represents uncollected November sales. What is the budgeted accounts receivable balance on May 31? O $95,200 $221,400 $ 51,000 $ 46,000 $ 56,000 $ 80,000 $100,000 Credit Sales $ 150,000 $ 170,000 $126,200 $ 130,000 $ 131,000 $ 200,000 $ 250,000

The LaGrange Corporation had the following budgeted sales for the first half of the current year Cash Sales $ 50,000 $ 55,000 January February March April May June Collections on sales: 50% in month of sale The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Multiple Choice O 30% in month following sale 20% in second month following sale The accounts receivable balance on January 1 of the current year was $81,000, of which $50,000 represents uncollected December sales and $31,000 represents uncollected November sales. What is the budgeted accounts receivable balance on May 31? O $95,200 $221,400 $ 51,000 $ 46,000 $ 56,000 $ 80,000 $100,000 Credit Sales $ 150,000 $ 170,000 $126,200 $ 130,000 $ 131,000 $ 200,000 $ 250,000

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

Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January February March $ 519,000 409,000 476,000 $ 459,200 349,200 532,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Beginning cash balance Add: Cash receipts Total cash available Less: Cash payments for Interest on loan…
Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects credit sales of $40,000 and $77,000, respectively. The company expects to collect 30% of its credit sales in the month of the sale and the remaining 70% in the following month. What is the expected cash collections from credit sales during the first month?
The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: October September October November $125,000 $154,000 $201,000 53,000 66,000 72,000 76,000 48,000 44,000 46,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 $6,000 of the estimated monthly manufacturing costs. The annual Insurance premium is paid in January, and the annual property taxes are paid in December. 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. Sales Manufacturing costs Selling and administrative expenses Capital expenditures Current assets as of September 1 include…
The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: Line Item Description Sales September October November $103,000 $122,000 $166,000 Manufacturing costs 43,000 52,000 60,000 Selling and administrative expenses Capital expenditures 36,000 37,000 63,000 40,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 $10,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. 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…
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. January February⚫ March Cash Receipts Cash payments $ 521,000 408,000 457,000 $ 467,800 354,800 522,000 Kayak requires a minimum cash balance of $50,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $50,000 is used to repay loans at month-end. The company has a cash balance of $50,000 and a loan balance of $100,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)
Treasure 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.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale 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 do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Done
Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects cash sales of $34,000 and $50,000, respectively. It also expects credit sales of $60,000 and $70,000, respectively. The companyvexpects to collect 60% of its credit sales in the month of the sale, 35% in the following month, and 5% is deemed uncollectible. What amount of cash collections would appear in the company's cash budget for the first month
The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November $89,000 $109,000 $146,000 37,000 47,000 31,000 33,000 Sales Manufacturing costs Selling and administrative expenses Capital expenditures 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 $7,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. 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 September 1 include cash of $34,000, marketable…
The following information is available to assist you in preparing a company's cash budget. a. The cash balance on July 1 is $41,000. b. Actual sales for May and June and expected sales for July are as follows: May $ 68,400 $ 87,400 $ 95,800 $ 415,000 $ 614,000 $ 692,000 June July Cash sales Sales on account Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected In the second month following sale. The remaining 2% is uncollectible. C. Purchases of inventory will total $376,000 for July. Thirty percent of a month's Inventory purchases are paid during the month of purchase. The accounts payable remaining from June's inventory purchases total $174,500, all of which will be paid in July. d. Selling and administrative expenses are budgeted at $452,000 for July. Of this amount, $63,500 is for depreciation. e. A new web server for the Marketing Department costing $86,500 will be…
The 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 $132,000 $164,000 $210,000 Manufacturing costs 55,000 71,000 76,000 Selling and administrative expenses 38,000 44,000 46,000 Capital expenditures _ _ 111,000 The company expects to sell about 12% of its merchandise for cash. Of sales on account, 65% 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 $8,000 of the estimated monthly manufacturing costs. The annual insurance 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…
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 526,000 $ 472,800 February 412,000 358,800 March 459,000 528,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.
Getty Company expects sales for the first three months of next year to be $205,000, $270,000 and $300,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. February March Budgeted cash receipts