Question

The Hernandez Company estimates its cash collections from its sales as follows:                         30% cash     &

The Hernandez Company estimates its cash collections from its sales as follows:

                        30% cash

                        70% on account

Of the credit sales the collection pattern is as follows:

                        60% in month of sales

                                    80% of these receive a 5% cash discount

                                    20% do not qualify for a discount

                        30% are collected in month following sale

                        8% are collected two months after sale

                        2% are uncollectible

If Si is the sales dollars in month i, (note that i-1 refers to the month prior, and i+1 refers to the upcoming month, etc.) then the cash receipts in month i can be estimated as follows:

  

Group of answer choices

0.3Si + (0.7) (0.6) [(0.8) (0.95)Si + 0.2Si] + (0.7) (0.3)Si+1 + (0.7) (0.08)Si+2

0.3Si + (0.7) (0.6) [(0.8) (0.95)Si + 0.2Si] + (0.7) (0.3)Si-1 + (0.7) (.08)Si-2

0.3Si + (0.7) [(0.6)Si + 0.3Si-1 + 0.08Si-2]

0.3Si + (0.6) (0.8) (0.95)Si + (0.6) (0.2)Si + 0.3Si-1 + 0.08Si-2

Homework Answers

Answer #1

The answer is

0.3Si + (0.7) (0.6) [(0.8) (0.95)Si + 0.2Si] + (0.7) (0.3)Si-1 + (0.7) (.08)Si-2

we can understand this equation step-by-step

step1:

0.3Si

It represent 30% cash receipt of this month

step2:

(0.7) (0.6) [(0.8) (0.95)Si + 0.2Si] - it has 2 paarts in it

first part is, of the balance 70% of this month, 60% will be received in this month. in that 60%, 80% is liable for cash discount of 5% (of 80%).

second part is, 20% of the above mentioned 60% is not liable for cash discount. it will receive in this month itself as it is.

step3:

(0.7) (0.3)Si-1

It represent 30% of the last month uncolleccted 70% sales

step4:

(0.7) (.08)Si-2

It represent 8% of uncollected 70% of two month before sale. remainig 2% is not included in the equation becuase it is uncollectable

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 $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?
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:_________
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...
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...
Exercise 9-24 Cash Collections (LO 9-3, 9-5) Coyote Loco, Inc., a distributor of salsa, has the...
Exercise 9-24 Cash Collections (LO 9-3, 9-5) Coyote Loco, Inc., a distributor of salsa, has the following historical collection pattern for its credit sales. 75 percent collected in the month of sale. 15 percent collected in the first month after sale. 5 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: June $ 127,500 July...
Northern Company has budgeted sales for the upcoming months as follows: April     450,000 May     465,000 June    ...
Northern Company has budgeted sales for the upcoming months as follows: April     450,000 May     465,000 June     490,000 July       515,000 August    500,000 Septemeber    475,000 18% percent of the sales are credit sales and the remainder are cash sales. Credit sales are collected 45% in the month of sale, 36% in the month following the sale, and 19% in the second month following the sale. Required: Prepare a schedule of cash collections for June, July, & August
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...
Problem 1 – Cash Collections Week 3 Providence City acquired its power plant from a private...
Problem 1 – Cash Collections Week 3 Providence City acquired its power plant from a private company on June 1. No receivables were acquired with the purchase. Therefore, total accounts receivable on June 1 had a zero balance. Providence plans to bill customers in the month following the month of sale, and 70% of the resulting billings will be collected during the billing month. 95% of the remaining balance should be collectable in the next following month. The remaining uncollectible...
ABC Company has the following historical collection pattern for its credit sales: 70% collected in month...
ABC Company has the following historical collection pattern for its credit sales: 70% collected in month of sale 15% collected in the first month after sale 10% collected in the second month after sale 4% collected in the third month after sale 1% uncollectible Credit sales are for the last 6 months are as follows: July $60,000 August $70,000 September $80,000 October $90,000 November $100,000 December $85,000 the estimated total cash collections during october from accounts receivable would be
OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly...
OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $129,000 November 161,000 December 236,000 The Accounts Receivable balance on September 30...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT