None Kerwin Corporation has found that 60% of its sales in anygiven month are credit sales, while the remainder are cashsales. Of the credit sales, Kerwin Corporation hasexperienced the following collection pattern:20% received in the month of the sale40% received in the month after the sale25% received two months after the sale15% of the credit sales are never receivedCNovember sales for last year were $110,000, whileDecember sales were $115,000. Projected salesfor the next three months are as follows:January sales.February salesMarch sales..Requirement$145,000$125,000$175,000Prepare a cash collections budget for thefirst quarter, with a column for each month and forthe quarter. (Round your answers to the nearestwhole dollar.)Cash salesCollections on credit sales:20% Month of saleCash Collections BudgetFor the Months of January through MarchJanuaryFebruary58,00017,40040% Month after27,60016,50025% Two months after$119,500Total cash collections

Kerwin Corporation - Cash Collections Budget (January - March)Cash Sales:January: $87,000 (145,000…

Answered: Kerwin Corporation has found that 60%…

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 23E: Historically, Ragman Company has had no significant bad debt experience with its customers. Cash...

See similar textbooks

Similar questions

November sales for last year were $100,000, while December sales were $115,000. Projected sales for the next three months are as follows: January sales... February sales. March sales... $ 165,000 $ 125,000 . $ 190,000 Requirement Prepare a cash collections budget for the first quarter, with a column for each month and for the quarter. (Round your answers to the nearest whole dollar.)
Samson Corporation has found that 70% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, Samson Corporation has experienced the following collection pattern: 20% received in the month of the sale 40% received in the month after the sale 25% received two months after the sale 15% of the credit sales are never received Cash sales Collections on credit sales: 20% Month of sale 40% Month after 25% Two months after Total cash collections Samson Corporation Cash Collections Budget For the Months of January through March January I November sales for last year were $85,000, while December sales were $110,000. Projected sales for the next three months are as follows: January sales... February sales ... March sales. . . $ 145,000 $ 115,000 $ 170,000 Requirement Prepare a cash collections budget for the first quarter, with a column for each month and for the quarter. (Round your answers to the nearest whole dollar.)
Alderman Corporation has found that 70% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, Alderman Corporation has experienced the following collection pattern 20% received in the month of the sale 40% received in the month after the sale 22% received two months after the sale 18% of the credit sales are never received Cash sales Collections on credit salos 20% Month of sale 40% Month after 22% Two months after EXCE November sales for last year were $110,000, while December sales were $115,000 Projected sales for the next three months are as follows: January sales.. February sales. March sales. $ 160,000 120,000 $ 165,000 Requirement Prepare a cash collections budget for the first quarter, with a column for each month and for the quarter (Round your answers to the Alderman Corporation Cash Collections Budget For the Months of January through March January In (2) (2)
Monette Corporation has found that 70% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, Monette Corporation has experienced the following collection pattern: 25% received in the month of the sale 50% received in the month after the sale 16% received two months after the sale 9% of the credit sales are never received Cash sales Collections on credit sales: 25% Month of sale 50% Month after 16% Two months after Total cash collections Monette Corporation Cash Collections Budget For the Months of January through March January C November sales for last year were $100,000, while December sales were $115,000. Projected sales for the next three months are as follows: January sales. February sales March sales... $ 160,000 130,000 190,000 .$ Requirement Prepare a cash collections budget for the first quarter, with a column for each month and for the quarter. (Round your answers to the nearest whole dollar.)
omework (required) Anderson Corporation has found that 80% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, Anderson Corporation has experienced the following collection pattern: 25% received in the month of the sale 50% received in the month after the sale 18% received two months after the sale 7% of the credit sales are never received Cash sales Collections on credit sales: 25% Month of sale 50% Month after 18% Two months after Total cash collections Anderson Corporation Cash Collections Budget For the Months of January through March January February $ $ 33,000 Part 2 of 4 33,000 50,000 12,960 128,960 Points: 0.2 of 2 January sales.. February sales March sales. November sales for last year were $90,000, while December sales were $125,000. Projected sales for the next three months are as follows: Save $ 165,000 $ 130,000 $ 200,000 Requirement Prepare a cash collections budget for the first quarter, with a column for each month…
Bennett Inc. found that about 35% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August 300,000 Required: 1. Calculate credit sales for May.$ Calculate credit sales for June.$ Calculate credit sales for July.$ Calculate credit sales for August.$ Feedback 2. Prepare a schedule of cash receipts for July and August. Round your answers to the nearest whole dollar, if necessary. If an amount box does not require an entry, leave it blank or enter "0". Be sure to enter percentages as whole numbers. Bennett Inc.Schedule of Cash ReceiptsFor July and August July…
During its first year of operations, Fertig Company had credit sales of $3,000,000, of which $400,000 remained uncollected at year- end. The credit manager estimates that $18,000 of these receivables will become uncollectible. The accounts receivable turnover is 10 times and average collection period is 36.5 days. Assume that average net accounts receivable were $300.000. Explain what these measures tell us. BI V T, TI E LE E H I 99 H E à ला 11 A A OWord(s)
The Professional Service Company expects 80% of sales for cash and 20% on credit. The company collects 80% of its credit sales in the month following sale, 15% in the second month following sale, and 5% are not collected (that is, they are "bad debts"). Expected sales for June, July, and August are $60,000, $66,000, and $56,000, respectively. What are the company's expected total cash receipts in August?
From past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, another 75% are collected in the month following sale, and the remaining 5% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $270,000, and March sales totaled $300,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?
Besoluck company has sales of P480,000 and P450,000 for September and October respectively. Of the total Sales, 1% is returned. 75% of the total sales account for credit sales and 20% of credit sales avail of the discount of 2%. The company is able to collect 40% of credit sales in the month of sales and 60% is collected in the following month. During October, the company has written off P20,000 of worthless accounts but had collected P13,000 from an account previously written off. The company uses, 10% percent of receivables for estimating doubtful accounts. What amount is debited to doubtful accounts expense if the balance of the allowance for doubtful accounts on Oct 1 is P7,350.50?
Historically, Ragman Company has had no significant bad debt experience with its customers.Cash sales have accounted for 20 percent of total sales, and payments for credit sales have beenreceived as follows:40 percent of credit sales in the month of the sale35 percent of credit sales in the first subsequent month20 percent of credit sales in the second subsequent month5 percent of credit sales in the third subsequent monthThe forecast for both cash and credit sales is as follows.January $185,000February 182,000March 192,000April 196,000May 210,000 Required:1. What is the forecasted cash inflow for Ragman Company for May?2. Due to deteriorating economic conditions, Ragman Company has now decided that its cashforecast should include a bad debt adjustment of 2 percent of credit sales, beginning withsales for the month of April. Because of this policy change, what will happen to the totalexpected cash inflow related to sales made in April? (CMA adapted)
Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $ 96,000 $ 125,000 $ 78,000 Credit sales 288,000 450,000 234,000 Total sales $ 384,000 $ 575,000 $ 312,000 Management estimates that 4% of credit sales are eventually uncollectible. Of the collectible credit sales, 65% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an inventory equal to 75% of the sales projected for the month. All purchases of inventory are on open account; 30% will be paid in the month of purchase, and the remainder paid in the month following the month of purchase. Purchase costs are approximately 60% of the selling prices.Budgeted cash payments in November for November inventory purchases by Yekstop Corp. are:

SEE MORE QUESTIONS

Recommended textbooks for you

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

College Accounting, Chapters 1-27

Accounting

ISBN:

9781337794756

Author:

HEINTZ, James A.

Publisher:

Cengage Learning,

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

College Accounting, Chapters 1-27

Accounting

ISBN:

9781337794756

Author:

HEINTZ, James A.

Publisher:

Cengage Learning,

SEE MORE TEXTBOOKS