9) Western Company expects the following credit sales for the first five months of the year: January, $43,000; February, $58,000; March, $48,000; April, $54,000, May $58,000. Experience has shown that payment for the credit sales is received as follows: 60% in the month of sale, 25% in the first month after sale, 10% in the second month after sale, and the remainder is uncollectible. How much cash can Western Company expect to collect in March as a result of credit sales (current and past)? A) $28,800. B) $42,600. C) $48,000. D) $47,600. E) $41,100.

9) Western Company expects the following credit sales for the first five months of the year: January, $43,000; February, $58,000; March, $48,000; April, $54,000, May $58,000. Experience has shown that payment for the credit sales is received as follows: 60% in the month of sale, 25% in the first month after sale, 10% in the second month after sale, and the remainder is uncollectible. How much cash can Western Company expect to collect in March as a result of credit sales (current and past)? A) $28,800. B) $42,600. C) $48,000. D) $47,600. E) $41,100.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 14EA: Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is...

See similar textbooks

Similar questions

Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?
NuParts, Inc., has estimated quarterly sales for next year, starting with Quarter 1, of $15,900, $16,800, $17,500, and $16,400. Purchases are equal to 67 percent of the following quarter's sales and the accounts payable period is 60 days. Assume 30 days in each month. How much will the firm owe its suppliers at the end of Quarter 3? $7,066.67 $7,506.67 $7,816.67 $6,933.33 $7,325.33
Wigmore, Incorporated, has estimated sales of $20,200, $21,825, $20,170, and $21,900 for each quarter next year, respectively. The accounts receivable period is 75 days. What is the expected accounts receivable balance at the end of the second quarter? Assume each month has 30 days. Multiple Choice $3,637.50 $16,833.33 $18.187.50 $16.808.33 $3,361.67
Beech's managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August, September, and October will be $280,000, $300,000, $290,000, and $310,000, respectively. 2. 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. 3. Each month's ending inventory must equal 25% of the cost of next month's sales. The cost of goods sold is 75% 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. 4. Monthly selling and administrative expenses are always $52,000. Each month $5,000 of this total amount is depreciation expense and the remaining $47,000 relates to expenses that are paid in the month they are incurred. 5. The…
The management of Sheffield Industries estimates that credit sales for August, September, October, and November will be $525,000, $705,000, $880,000, and $465,000, respectively. Experience has shown that collections are made as follows: In month of sale 25% In first month after sale 60% In second month after sale 10% Determine the collections from customers in October and November
Excel Berhad manufactures one product line – the Nexus. Sales of Nexus over thenext few months are planned as follows:1. Demand: July 180,000 units, August 200,000 units, September 240,000 units,October 180,000 units. The selling price for each Nexus is RM5. 2. Debtor receipts: Credit customers (receivables) are expected to pay as follows: 70%during the month of sale and 28% during the following month.The remaining credit customers are expected to go bad (that is, to be uncollectable).Credit customers who pay in the month of sale are entitled to deduct a 2 per centdiscount from the invoice price. 3. Finished goods inventories: Inventories of finished goods are expected to be 50,000units at 1 July. The business’s policy is that, in future, the inventories at the end ofeach month should equal 20 percent of the following month’s planned salesrequirements. 4. Raw materials inventories: Inventories of raw materials is expected to be 50,000 kgon 1 July. The business’s policy is that, in…
Excel Berhad manufactures one product line – the Nexus. Sales of Nexus over thenext few months are planned as follows:1. Demand: July 180,000 units, August 200,000 units, September 240,000 units,October 180,000 units. The selling price for each Nexus is RM5. 2. Debtor receipts: Credit customers (receivables) are expected to pay as follows: 70%during the month of sale and 28% during the following month.The remaining credit customers are expected to go bad (that is, to be uncollectable).Credit customers who pay in the month of sale are entitled to deduct a 2 per centdiscount from the invoice price. 3. Finished goods inventories: Inventories of finished goods are expected to be 50,000units at 1 July. The business’s policy is that, in future, the inventories at the end ofeach month should equal 20 percent of the following month’s planned salesrequirements. 4. Raw materials inventories: Inventories of raw materials is expected to be 50,000 kgon 1 July. The business’s policy is that, in…
Excel Berhad manufactures one product line – the Nexus. Sales of Nexus over thenext few months are planned as follows:1. Demand: July 180,000 units, August 200,000 units, September 240,000 units,October 180,000 units. The selling price for each Nexus is RM5. 2. Debtor receipts: Credit customers (receivables) are expected to pay as follows: 70%during the month of sale and 28% during the following month.The remaining credit customers are expected to go bad (that is, to be uncollectable).Credit customers who pay in the month of sale are entitled to deduct a 2 per centdiscount from the invoice price. 3. Finished goods inventories: Inventories of finished goods are expected to be 50,000units at 1 July. The business’s policy is that, in future, the inventories at the end ofeach month should equal 20 percent of the following month’s planned salesrequirements. 4. Raw materials inventories: Inventories of raw materials is expected to be 50,000 kgon 1 July. The business’s policy is that, in…
The management of Marigold Industries estimates that credit sales for August, September, October, and November will be $550,000, $735,000, $885,000, and $480,000, respectively. Experience has shown that collections are made as follows: In month of sale 25% In first month after sale 60% In second month after sale 10% Determine the collections from customers in October and November
Assume receivables of $20,000 at the start of the January are all collected during the month; if sales for January and February are $400,000 and $300,000 respectively; the company typically receives payment from 20% of its customers within the same month, 60% the following month, and the remaining 20% by the end of the second following month, how much would accounts receivable be at the end of February?
Graham Potato Company has projected sales of $16,200 in September, $18,500 in October, $26,200 in November, and $22,200 in December. Of the company's sales, 25 percent are paid for by cash and 75 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December. Also assume Graham's cash payments for November and December are $22,000 and $14,500, respectively. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. Sales Credit sales Cash sales One month after sale Two months after sale Total cash receipts Graham Potato Company Cash Receipts Schedule September October November $ $ December 6,550 $ 19,650 6,550 $ $ 22,200 16,650 5,550 5,550
Graham Potato Company has projected sales of $11,400 in September, $14,500 in October, $21,400 in November, and $17,400 in December. Of the company's sales, 30 percent are paid for by cash and 70 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December. Also assume Graham’s cash payments for November and December are $18,000 and $10,500, respectively. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. b. Prepare a cash budget with borrowing needed or repayments for November and December. (Negative amounts should be indicated by a minus sign. Assume the November beginning loan balance is $0.)