Budgeted Cash Collections 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 been received as follows: 40 percent of credit sales in the month of the sale 35 percent of credit sales in the first subsequent month 20 percent of credit sales in the second subsequent month 5 percent of credit sales in the third subsequent month The forecast for both cash and credit sales is as follows. January $185.000 February 182,000 192,000 196,000 210,000 March April May Required: 1. What is the forecasted cash inflow for Ragman Company for May?

Budgeted Cash Collections 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 been received as follows: 40 percent of credit sales in the month of the sale 35 percent of credit sales in the first subsequent month 20 percent of credit sales in the second subsequent month 5 percent of credit sales in the third subsequent month The forecast for both cash and credit sales is as follows. January $185.000 February 182,000 192,000 196,000 210,000 March April May Required: 1. What is the forecasted cash inflow for Ragman Company for May?

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

Budgeted Cash Collections, Budgeted Cash Payments 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 been received 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,000 February 180,000 March 193,000 April 195,000 May 210,000 Required: 1. What is the forecasted cash inflow for Ragman Company for May?$fill in the blank 1 2. Due to deteriorating economic conditions, Ragman Company has now decided that its cash forecast should include a bad debt adjustment of 2 percent of credit sales, beginning with sales for the month of April. Because of this policy change, what will happen to the total…
Budgeted Cash Collections, Budgeted Cash Payments 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 been received as follows: 40 percent of credit sales in the month of the sale 35 percent of credit sales in the first subsequent month 20 percent of credit sales in the second subsequent month 5 percent of credit sales in the third subsequent month The forecast for both cash and credit sales is as follows. January $185,000 February 182,000 March 193,000 April 196,000 May 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 cash forecast should include a bad debt adjustment of 2 percent of credit sales, beginning with sales for the month of April. Because of this policy change, what will happen to the total expected cash inflow related to…
6. Budgeted Cash Collections, Budgeted Cash Payments 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 been received 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,000 February 182,000 March 192,000 April 195,000 May 200,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 cash forecast should include a bad debt adjustment of 2 percent of credit sales, beginning with sales for the month of April. Because of this policy change, what will happen to the total expected cash inflow…
Schedule of Cash Collections on Accounts Receivable and Cash BudgetBennett Inc. found that about 15% of its sales during the month were forcash. Bennett has the following accounts receivable collectionexperience: Percent collected in the month of sale Percent collected in the month after the sale Percent collected in the second month after the sale 25 68 5 Bennett's anticipated sales for the next few months are as follows: AprilMayJuneJulyAugust $250,000290,000280,000295,000300,000 (Note: Round all amounts to the nearest dollar.) Required:1. Calculate credit sales for May, June, July, and August.2. Prepare a schedule of cash receipts for July and August.
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 30% 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.$
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 30% 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.$fill in the blank 5ada08018fd8065_1 Calculate credit sales for June.$fill in the blank 5ada08018fd8065_2 Calculate credit sales for July.$fill in the blank 5ada08018fd8065_3 Calculate credit sales for August.$fill in the blank 5ada08018fd8065_4 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…
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 30% 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
NOT GRADED Budgeting Cash CollectionsSpencer Consulting, which invoices its clients on terms 2/10, n/30, had credit sales for May and June of $175,000 and $200,000, respectively. Analysis of Spencer's operations indicates that the pattern of customers' payments on account is as follows (percentages are of total monthly credit sales): Receiving Discount Beyond Discount Period Totals In month of sale 50% 20% 70% In month of following sale 15% 10% 25% Uncollectible accounts, returns, and allowances 5% 100% Determine the estimated cash collected on customers' accounts in June. $Answer
Budgeting Cash Collections. Spencer Consulting, which invoices its clients on terms 2/10, n/30, had credit sales for May and June of $150,000 and $170,000, respectively. Analysis of Spencer's operations indicates that the pattern of customers' payments on account is as follows (percentages are of total monthly credit sales): In month of sale In month of following sale Uncollectible accounts, returns, and allowances Beyond Receiving Discount Discount 50% 10% Period Totals 25% 75% 10% 20% 5% 100% Determine the estimated cash collected on customers' accounts in June.
3. What if the recession led Shalimar's top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption. Shalimar Company Cash Receipts Budget For the Coming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Cash sales Received on account from: Quarter 4, current year Quarter 1, next year Quarter 2, next year Quarter 3, next year Quarter 4, next year Total cash receipts
A company's past experience indicates that 60% of its credit sales are collected in the month of sale, 30% in the next month, and 5% in the second month after the sale; the remainder is never collected. Budgeted credit sales were: January $450000 February 286000 March 630000 The cash inflow in the month of March is expected to be $378000. $403300. $486300. $463800.
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?