Question

Royal Cigar Company is preparing a budget for cash collections. Its sales for November and December...

Royal Cigar Company is preparing a budget for cash collections. Its sales for November and December are estimated as $130,000 and $148,000, respectively. Past practice indicates that sales in any given month are collected as follows: month of sale, 65%; month following the month of sale, 30%; uncollectible accounts, 5%. The company allows a 2% discount for cash collections in the month of sale.

What is the net cash estimated to be collected in December?

Homework Answers

Answer #1
Budget for Cash Collection
December
Cash collection from the sale made in november($130,000*30%) $                        39,000
Cash collection from the sale made in December[($148,000*65%)-($148,000*65%*2%)] $                        94,276
Cash collection in the month of December $                      133,276
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Royal Cigar Company is preparing a budget for cash collections. Its sales for November and December...
Royal Cigar Company is preparing a budget for cash collections. Its sales for November and December are estimated as $120,000 and $136,000, respectively. Past practice indicates that sales in any given month are collected as follows: month of sale, 60%; month following the month of sale, 35%; uncollectible accounts, 5%. The company allows a 2% discount for cash collections in the month of sale. What is the net cash estimated to be collected in December? Net cash estimated collections:_________
On October 1 of the current year, Molloy Corporation prepared a cash budget for October, November,...
On October 1 of the current year, Molloy Corporation prepared a cash budget for October, November, and December. All of Molloy's sales are made on account. The following information was used in preparing estimated cash collections: August sales (actual) $ 46,000 September sales (actual) $ 56,000 October sales (estimated) $ 26,000 November sales (estimated) $ 76,000 December sales (estimated) $ 66,000 Approximately 60% of all sales are collected in the month of the sale, 30% is collected in the following...
Circle A Company (XXX) is preparing its cash collections budget for the 2nd quarter of 2012.  ...
Circle A Company (XXX) is preparing its cash collections budget for the 2nd quarter of 2012.   Budgeted sales are as follows: Budgeted sales Apr May Jun Cash sales $10,000 $9,000 $7,500 Credit sales 24,000 20,000 16,500 Total sales $34,000 $29,000 $24,000 Accounts receivable at March 31 were $14,000. The budget assumes that 20% of credit sales are collected in the month of sale, and the remaining 80% are collected one month later. Please prepare the cash collections budget. For the...
The Overland Company is preparing its cash budget for the month of June. The following information...
The Overland Company is preparing its cash budget for the month of June. The following information is available concerning its accounts receivable:    Estimated credit sales for June $ 334,000 Actual credit sales for May 259,000 Estimated collections in June for credit sales in June 25 % Estimated collections in June for credit sales in May 65 % Estimated collections in June for credit sales prior to May $ 52,000 Estimated write-offs in June for uncollectible credit sales 46,000 Estimated...
It is November 1 of Year 1. Sales for Kadan Company for November and December of...
It is November 1 of Year 1. Sales for Kadan Company for November and December of Year 1 and January of Year 2 are forecasted to be as follows: November, 400,000; December 600,000; January, 200,000 100% of sales are credit sales. Of these credit sales, 5% are collected during the month of sale, 25% in the following month, and 65% in the second following month; 5% are never collected. Total sales for September and October of Year 1 were 100,000...
Moore Inc. had the following historical pattern for its credit sales: 70% collected in the month...
Moore Inc. had the following historical pattern for its credit sales: 70% collected in the month of sale 20% collected in the firs month after sale 8% collected in the second month after sale 2% uncollectible The sales on open account (credit sales) have been budgeted for the last four months of the year as shown below: September $12,000 October $13,000 November $10,000 December $12,000 Required: a. The estimated total cash collections by the company during December from accounts receivable...
It is November 1 of Year 1. Sales for Jude Company for November and December of...
It is November 1 of Year 1. Sales for Jude Company for November and December of Year 1 and January (of Year 2) are forecasted to be as follows: November, 300,000; December 700,000; January, 200,000 100% of sales are credit sales. Of these credit sales, 15% are collected during the month of sale, 25% in the following month, 50% in the second following month, and 10% are never collected. Total sales for September and October of Year 1 were 100,000...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2...
27) Corbin Company has prepared the following sales budget: Month                     Cash Sales        &nbsp
27) Corbin Company has prepared the following sales budget: Month                     Cash Sales                    Credit Sales September                    $99,000                         $250,000 October                        225,000                           180,000 November                    310,000                           210,000 December                      94,000                           170,000 Collections of credit sales are 50% in the month of sale, 40% in the month following sale, and 10% two months following sale. No uncollectible accounts are expected. What is the expected balance in Accounts Receivable at November 30? A) $77,500 B) $105,000 C) $123,000 this is the correct answer. Please explain every step of how to get accts receivable D) $210,000
The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June...
The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding the cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2 percent...