Assume the following budgeted information for a merchandising company: Budgeted sales (all on credit) for November, December, and January are $254,000, $224,000, and $215,000, respectively. ● • Cash collections of credit sales are expected to be 70% in the month of sale and 30% in the month following the sale. • The cost of goods sold is always 65% of sales. • Each month's ending inventory equals 15% of next month's cost of goods sold. • 40% of each month's merchandise purchases are paid in the current month and the remainder is paid in the following month. • Monthly selling and administrative expenses that are paid in cash in the month incurred total $28,000. Monthly depreciation expense is $27,500. The expected cash collections from customers in December are:

Assume the following budgeted information for a merchandising company: Budgeted sales (all on credit) for November, December, and January are $254,000, $224,000, and $215,000, respectively. ● • Cash collections of credit sales are expected to be 70% in the month of sale and 30% in the month following the sale. • The cost of goods sold is always 65% of sales. • Each month's ending inventory equals 15% of next month's cost of goods sold. • 40% of each month's merchandise purchases are paid in the current month and the remainder is paid in the following month. • Monthly selling and administrative expenses that are paid in cash in the month incurred total $28,000. Monthly depreciation expense is $27,500. The expected cash collections from customers in December are:

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

Atlanta Industries sales budget shows quarterly sales for the next year as follows: Quarter 1–10,000; Quarter 2–8,000; Quarter 3–12,000; Quarter 4–14,000. Company policy is to have a target finished-goods inventory at the end of each quarter equal to 20% of the next quarter’s sales. Budgeted production for the second quarter of next year would be:
The Lowville Company has budgeted the following data for November: • Sales of $1,728,300, all in cash. • A cash balance on November 1 of $72,000. • Cash disbursements (other than interest) during November of $1,740,000. • A minimum cash balance of $90,000 at the end of each month. The company has 2% open line of credit for $100,000. All borrowing will take place at the beginning of the month. The November interest will be paid in cash when repayment is made. The excess (deficiency) of cash available over disbursements for November will be: A. $(11,700) B. $ (29,700) C. $60,300 D. $72,000 1. 2. The amount of cash needed to be borrowed on November 1 to cover all cash disbursements and to obtain the desired November 30 cash balance is: A. $11,700 B. $18,000 C. $29,700 D. $30,000 The minimum cash balance the Lowville Company should have in order to make both repayment and interest payment in December should be closest to: A. $18,060 B. $29,800 C. $90,600 D. $119,800
Assume the following budgeted information for a merchandising company: Budgeted sales (all on credit) for November, December, and January are $241,000, $211,000, and $202,000, respectively. Cash collections of credit sales are expected to be 75% in the month of sale and 25% in the month following the sale. The cost of goods sold is always 65% of sales. Each month’s ending inventory equals 20% of next month’s cost of goods sold. 40% of each month’s merchandise purchases are paid in the current month and the remainder is paid in the following month. Monthly selling and administrative expenses that are paid in cash in the month incurred total $21,500. Monthly depreciation expense is $21,000. The expected cash collections from customers in December are:
ABC Company's actual unit sales in the current year for January, February, and March were 16,500, 13,500, and 19,500 units, respectively. Current year selling price is $20. An analysis of general economic trends and specific initiatives at ABC forecasts increases for the coming budget year: sales volume by 10% and sales price by 5%. Required: Prepare ABC Company's budgeted unit sales and total sales volume for the first quarter of the coming year. Current sales (units) Budgeted volume increase Budgeted sales (units) Budgeted selling price Budgeted total sales January $ 0 % February $ 0 % $ March 0 % $ Total 0 %
The budgeted sales of Kelley, SA for the given months are as follows: Cash Sales Credit Sales April $38,000 $256,000 May $54,000 $250,000 June $36,000 $192,000 July $33,000 $190,000 August $35,000 $287,000 To prepare a cash budget, the company needs to determine the expected cash collections each month, and has provided the following additional information: The Accounts Receivable balance on April 1 was $82,015. Of this amount, $57,015 represented uncollected March sales and $25,000 represented uncollected February sales. Collections on Credit sales: 65% in month of sale 30% in month following sale 5% in second month following sale Part 1: What should the April cash collected be? $BLANK Part 2: For August 1, what is budgeted Accounts Receivable? (76,100, 100,300, 109,950, 144950, OR 79,700)
Daybook Inc. collects 30% of its sales on account in the month of the sale and 70% in the month following the sale. If sales on account are budgeted to be $105,000 for September and $116,000 for October, what are the budgeted cash receipts from sales on account for October?$fill in the blank 1
Corporation has projected sales in units for the third quarter of the coming year as follows: July 60,000 August September 50,000 80,000 All units are sold on account for $18 each. Cash collections from sales are budgeted at 75% in the month of sale, and 25% in the month following the month of sale. June sales were $1,500,000 Required: 1. Prepare a schedule for the third quarter, showing budgeted cash receipts for Ehrlich Corporation. 2. What are budgeted accounts receivable?
C2
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 $42,000 and $74,000, respectively. The company expects to collect 35% of its credit sales in the month of the sale and the remaining 65% in the following month. What amount of cash collections from credit sales would the company include in its cash budget for the second month?
Folgerty Enterprises prepared the following sales budget: Month Budgeted Sales March $6,000 April $13,000 May $12,000 June $14,000 The expected gross profit rate is 30% and the inventory at the end of February was $10,000. Desired finished goods inventory levels at the end of the month are 20% of the next month's cost of goods sold. What is the desired beginning finished goods inventory on June 1 (in dollars)? Select one: a. $1,960 b. $840 c. $1,680 d. $9,800 e. $1,860
Elordi Engineers Corp. has the following budgeted sales data (in dollars): June July August September Credit Sales 290,000 300,000 260,000 310,000 Cash Sales 70,000 70,000 70,000 70,000 The regular pattern of collection of credit sales is 30% in the month of sale, 60% in the month following sale, and the remainder in the second month following the month of sale. There are no bad debts. What would the budgeted cash receipts during September be? Round your answer to the nearest whole number.
I need the working solution for the cash balance at the beginning month. Cash Budget 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 Sales $130,000 $156,000 $205,000 Manufacturing costs 55,000 67,000 74,000 Selling and administrative expenses 46,000 47,000 78,000 Capital expenditures _ _ 49,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…