Question

In: Accounting

Cachet Inc. had a $93,000 balance in Accounts Receivable on July 1. In July, it expects...

Cachet Inc. had a $93,000 balance in Accounts Receivable on July 1. In July, it expects to collect 55% of these receivables and 30% of the July credit sales, which are budgeted at $138,000. What is the budgeted accounts receivable at the end of July? $41,400 $92,550 $138,450 $51,150

Solutions

Expert Solution

Answer---$138,450

Working.

Collections

From June sales

$ 51,150.00

From July sales

$ 41,400.00

Total collections

$ 92,550.00

Total accounts receivables

Accounts receivables for

June

$     93,000.00

Less: Collected in July

$     51,150.00

Balance from June Accounts receivables

$    41,850.00

July

$ 138,000.00

Less: Collected in July

$     41,400.00

Balance from July Accounts receivables

$    96,600.00

Total accounts receivables

$ 138,450.00

Alternative method

Receivables from june

$     93,000.00

Add: Budgeted sales of july

$ 138,000.00

Less: Total collections in july

$     92,550.00

Accounts receivables balane at the end of july

$ 138,450.00


Related Solutions

On 1 July 2020 Tran’s Hardware Pty Ltd had an accounts receivable ledger balance of $75,000...
On 1 July 2020 Tran’s Hardware Pty Ltd had an accounts receivable ledger balance of $75,000 debit and a credit balance in the allowance for doubtful debts ledger account of $15,000. On 3 July Tran’s was contacted by Nails and Hammers Pty Ltd to notify that the business had been declared bankrupt and that they would not be able to pay the $5,500 owing to Tran’s Hardware from a previous credit sale made to them in June 2020. The business...
Barkers, Inc. had the following selected accounts in its unadjusted trial balance: Accounts receivable                         &nb
Barkers, Inc. had the following selected accounts in its unadjusted trial balance: Accounts receivable                                  $176,000 Prepaid rent                                                  54,000 Prepaid insurance                                         24,000 Equipment                                                300,000 Accumulated depreciation-equipment            30,000 Unearned service revenue                              24,000 Salary expense                                          130,000 Additional data: One-third of the revenue received in advance has been earned by December 31, 2017. The prepaid insurance represents three years’ premium on a policy providing coverage starting October 1, 2017. Since the last payday, employees have earned an additional $2,000 which...
Sunny Corporation expects to have the following balances on July 1, 2020: Cash, $3,000; Accounts receivable,...
Sunny Corporation expects to have the following balances on July 1, 2020: Cash, $3,000; Accounts receivable, $135,000; and Accounts payable, $100,000. Its budgeted sales, merchandise purchases, and various expenses for the next three months follow. July August September Sales $220,000 $300,000 $380,000 Merchandise purchases 210,000 180,000 220,000 Payroll, rent, and other expenses 96,000 41,000 51,000 20% of the sales are for cash. Of the remaining credit sales, 30% are collected in the same month as the sale, and 70% are...
The December 31, 2021, balance sheet of the Windsor, Inc. had Accounts Receivable of $670,000 and...
The December 31, 2021, balance sheet of the Windsor, Inc. had Accounts Receivable of $670,000 and a credit balance in Allowance for Doubtful Accounts of $30,000. During 2022, the following transactions occurred: sales on account $1,558,000; sales returns and allowances, $171,000; collections from customers, $1,257,000; accounts written off, $39,000; previously written off accounts of $9,000 were collected. Journalize the 2022 transactions. (Credit account titles are automatically indented when the amount is entered. Do not indent manually.) Account Titles and Explanation...
Benny Company had a beginning balance on January 1, 2019 in Accounts Receivable of $200,000 and...
Benny Company had a beginning balance on January 1, 2019 in Accounts Receivable of $200,000 and a beginning credit balance in the Allowance for Doubtful Accounts of $4,000. During 2019, Drew sold $1,000,000 of goods on credit and collected $800,000. If Drew estimates that 2% of their ending accounts receivable will eventually not be collected, the adjusting journal entry for the Bad Debt Expense will include a credit to Allowance for Doubtful Accounts of A. none of the listed choices...
A company’s year-end balance in accounts receivable is $2,000,000. The allowance for uncollectible accounts had a...
A company’s year-end balance in accounts receivable is $2,000,000. The allowance for uncollectible accounts had a beginning-of-year credit balance of $30,000. An aging of accounts receivable at the end of the year indicates a required allowance of $38,000. If bad debt expense for the year was $40,000 and if credit sales for the year were $8,200,000 and $7,950,000 was collected from credit customers, what was the beginning-of-year balance in accounts receivable?
On July 1, MTC Wholesalers had a cash balance of $245,000 and accounts payable of $138,600....
On July 1, MTC Wholesalers had a cash balance of $245,000 and accounts payable of $138,600. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual Sales Month Budgeted Sales May $210,000   July $ 126,000 June 224,000 August 112,000 September 140,000 October 168,000 All sales are on credit with 75 percent collected during the month of sale, 20 percent collected during the next month, and 5 percent collected during the second month...
On July 1, MTC Wholesalers had a cash balance of $245,000 and accounts payable of $138,600....
On July 1, MTC Wholesalers had a cash balance of $245,000 and accounts payable of $138,600. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual Sales Month Budgeted Sales May $210,000   July $ 126,000 June 224,000 August 112,000 September 140,000 October 168,000 All sales are on credit with 75 percent collected during the month of sale, 20 percent collected during the next month, and 5 percent collected during the second month...
The following summarizes the aging of accounts receivable for Johnston Supplies, Inc. as of July 31,...
The following summarizes the aging of accounts receivable for Johnston Supplies, Inc. as of July 31, 2019: Number of Days Unpaid Total Accounts Receivable Historical % Uncollectible   Not yet due $ 127,200 5 % 1-30 days past due 89,900 10 % 31-60 days past due 54,300 16 % Over 60 days past due 32,500 37 % Required: a. The unadjusted balance of the Allowance for Doubtful Accounts of Johnston Supplies, Inc. is a credit balance in the amount of $29,157...
The following summarizes the aging of accounts receivable for Johnston Supplies, Inc. as of July 31,...
The following summarizes the aging of accounts receivable for Johnston Supplies, Inc. as of July 31, 2019: Number of Days Unpaid   Total Accounts Receivable    Historical % Uncollectible Not yet due   $   127,600         5   %      1-30 days past due      90,300         10   %      31-60 days past due      54,700         16   %      Over 60 days past due      32,900         36   %      Required: The unadjusted balance of the Allowance for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT