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 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.)

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 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.)

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

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. 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 sales made in April? (CMA adapted)
Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
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?
Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?
Nonnas Re-Appliance Store collects 55% of its accounts receivable in the month of sale and 40% in the month after the sale. Given the following sales, how much cash will be collected in February?
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)
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.)
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.)
Assume Laksko's has credit sales of $462,400 in March, $507,500 in April, and $550,200 in May. Also assume that 64 percent of sales are collected in the month of sale, 35 percent are collected in the following month, and the remainder are never collected. Credit purchases are $224,600 in March, $236,700 in April, and $252,700 in May. Credit purchases are paid in 30 days. Interest is $12,400 a month, wages and other expenses are $64,400 a month. Fixed assets purchases of $119,500 are scheduled for April with additional purchases of $56,400 in May. The April 1 cash balance was $321,060 and taxes of $180,000 must be paid on April 15. What is the cash balance at the end of May?
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…
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…