Coyote Loco, Incorporated, a distributor of salsa, has the following historical collection pattern for its credit sales. 60 percent collected in the month of sale. 20 percent collected in the first month after sale. 15 percent collected in the second month after sale. 4 percent collected in the third month after sale. 1 percent uncollectible. The sales on account have been budgeted for the last seven months as follows: $ 129,000 156,500 181,500 June July August September October November December 213,000 238,000 263,000 225,500 Required: 1. Compute the estimated total cash collections during October from credit sales. 2. Compute the estimated total cash collections during the fourth quarter from sales made on account during the fourth quarter. 1. Total cash collections 2. Total cash collections

Coyote Loco, Incorporated, a distributor of salsa, has the following historical collection pattern for its credit sales. 60 percent collected in the month of sale. 20 percent collected in the first month after sale. 15 percent collected in the second month after sale. 4 percent collected in the third month after sale. 1 percent uncollectible. The sales on account have been budgeted for the last seven months as follows: $ 129,000 156,500 181,500 June July August September October November December 213,000 238,000 263,000 225,500 Required: 1. Compute the estimated total cash collections during October from credit sales. 2. Compute the estimated total cash collections during the fourth quarter from sales made on account during the fourth quarter. 1. Total cash collections 2. Total cash collections

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

Jasper Company has 65% of its sales on credit and 35% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $527,000 for April, $537,000 for May, and $562,000 for June. Total sales for March are $300,100. Prepare a schedule of cash receipts from sales for April, May, and June.
Aztec Company sells its product for $150 per unit. Its actual and budgeted sales follow. May (Actual) June (Budget) July (Budget) August (Budget) 6,000 4,100 $ 900,000 2,400 5,000 $360,000 $750,000 $ 615,000 Sales units Sales dollars. All sales are on credit. Collections are as follows: 24% is collected in the month of the sale, and the remaining 76% is collected in the month following the sale. Merchandise purchases cost $110 per unit. For those purchases, 60% is paid in the month of purchase and the other 40% is paid in the month following purchase. The company has a policy to maintain an ending monthly inventory of 22% of the next month's unit sales. The May 31 actual inventory level of 1,320 units is consistent with this policy. Selling and administrative expenses of $114,000 per month are paid in cash. The company's minimum cash balance at month-end is $140,000. Loans are obtained at the end of any month when the preliminary cash balance is below $140,000. Any preliminary cash…
A company budgets the following merchandising purchases: April: $70.000; May $90,000, June: $60,000. All purchases are on account and the company pays 25% of purchases in the month of the purchase and the remaining amount in the following month. Cash disbursements for June for merchandise is $
subject - accounting
The following is a schedule of the projected unit sales of Western Company, which manufactures casual wear. Each unit sells for $25. The company began the period with a beginning accounts receivable balance of $10,000. Choose the correct answer from the options provided. Budgeted unit sales Percentage of sales collected in the quarter of the sale Percentage of sales collected in the quarter after the sale. Quarter First Second Third Fourth 1,500 1,300 1,400 1,300 Knowledge Check 01 What is the amount of budgeted sales revenue for the fourth quarter? O $32,500 $33,750 O $35,000 $37,500 $8,125 O $8,750 O $9,375 O $28,125 Year 5,500 75% 25% Knowledge Check 02 What is the amount of cash that is expected to be collected during the second quarter as a result of sales made during the first quarter?
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $ 80,000 $ 71,000 $ 83,000 Credit sales 80,000 85,200 91,300 Total $ 160,000 $ 156,200 $ 174,300 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month following the month of sale. Customers are granted a 1.5% discount for payment within 10 days of billing. Approximately 75% of collectible credit sales take advantage of the cash discount. Inventory purchases each month are 100% of the cost of the following month’s projected sales. (The gross profit rate for Timpco is approximately 30%.) All merchandise purchases are made on credit, with 20% paid in the month of purchase and the remainder paid in the following month. No cash discounts…
Hunt Company's sales, based on past experience, are 30% cash and 70% credit. Credit sales are typically collected as follows: 40% in the month of sale, 50% in the month after the sale, and 10% in the second month following month of sale. On December 31, the accounts receivable balance is $69,000, of which $24,000 is from November sales. Total sales for January and February are budgeted to be $110,000 and $130,000, respectively. What are Hunt Company's budgeted cash receipts for January? Multiple Choice $79,500. $92,500. $95,800. $112,500. $125,300.
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
s
Cloudy Company had the following historical collection pattern for its credit sales: 75% collected in the month of sale 12% collected in the first month after month of sale 8% collected in the second month after month of sale 3% collected in the third month after month of sale 2% uncollectible The sales on open account (credit sales) have been budgeted for the last six months of the year as shown below: $ 81,000 $ 93,000 $ 105,000 $ 117,000 $ 129,000 $ 111,000 July August September October November December The estimated total cash collections by Cloudy Company during November from collection of accounts receivable is:
Help me please
Joyner Company has the following historical collection pattern for its credit sales: 60% collected in month of sale 20% collected in the first month after sale 15% collected in the second month after sale 4% collected in the third month after sale 1% uncollectible Budgeted credit sales for the last six months of the year follow. July $49,000 August 54,000 September 59,000 October 64,000 November 69,000 December 61,500 Required: -A. Calculate the estimated total cash collections during October. B. Calculate the estimated total cash collections during the year's fourth quarter. A. Total cash collections during October B. Total cash collections during the year's fourth quarter