Question

Duck-n-Run has projected sales of $120,000 for January, $118,000 for February, and $146,000 for March. The...

Duck-n-Run has projected sales of $120,000 for January, $118,000 for February, and $146,000 for March. The firm collects 55 percent in the month of sale, 43 percent in the month after sale, and 2 percent two months after sale. The accounts receivable balance at the end of the previous quarter was $27,000 of which $22,000 was uncollected December sales.

What is the amount of the January collections?

Homework Answers

Answer #1

Accounts Receivable = $27,000

Uncollected November Sales = $5,000
Uncollected December Sales = $22,000

December Sales = Uncollected December Sales / 0.45
December Sales = $22,000 / 0.45
December Sales = $48,889

January:

Collection from November Sales = $5,000

Collection from December Sales = $48,889 * 43%
Collection from December Sales = $21,022

Collection from January Sales = $120,000 * 55%
Collection from January Sales = $66,000

Total Collection in January = Collection from November Sales + Collection from December Sales + Collection from January Sales
Total Collection in January = $5,000 + $21,022 + $66,000
Total Collection in January = $92,022

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
The Lumber Yard has projected the sales below for the next four months. The company collects...
The Lumber Yard has projected the sales below for the next four months. The company collects 42 percent of its sales in the month of sale, 47 percent in the month following the month of sale, 9 percent two months after the month of sale, and never collects 2 percent of its sales. How much will the company collect in April? January February March April Sales $ 136,850 $ 143,525 $ 151,975 $ 164,950
The following is the sales budget for Profit, Inc., for the first quarter of 2018: January...
The following is the sales budget for Profit, Inc., for the first quarter of 2018: January February March   Sales budget $ 214,000 $ 234,000 $ 257,000 Credit sales are collected as follows: 60 percent in the month of the sale 25 percent in the month after the sale 15 percent in the second month after the sale The accounts receivable balance at the end of the previous quarter was $98,000 ($68,000 of which was uncollected December sales). a. Calculate the...
The following is the sales budget for Coore, Inc., for the first quarter of 2019: January...
The following is the sales budget for Coore, Inc., for the first quarter of 2019: January February March   Sales budget $142,000 $159,000 $174,000 Credit sales are collected as follows: 70 percent in the month of the sale 25 percent in the month after the sale 5 percent in the second month after the sale The accounts receivable balance at the end of the previous quarter was $70,150 ($61,200 of which was uncollected December sales). a. Compute the sales for November....
Your projected sales for the first 3 months of next year are as follows: January, $15,000;...
Your projected sales for the first 3 months of next year are as follows: January, $15,000; February, $20,000; March, $25,000. Based on last year's data, cash sales are 20 percent of total sales for each month. Of the accounts receivable, 60 percent are collected in the month after the sale and 40 percent are collected in the second month following the sale. Sales for November of the current year are $15,000 and for December are $17,000. You have the following...
Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each...
Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each of the first three months of operations are as follows: January $240,000 February 310,000 March 470,000 All sales are on account. 59% of sales are expected to be collected in the month of the sale, 37% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for January, February, and...
Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each...
Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each of the first three months of operations are as follows: January $300,000 February 500,000 March 750,000 All sales are on account. Seventy-five percent of sales are expected to be collected in the month of the sale, 20% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for January, February,...
Kaspar Industries expects credit sales for January, February, and March to be $204,200, $266,000, and $317,000,...
Kaspar Industries expects credit sales for January, February, and March to be $204,200, $266,000, and $317,000, respectively. It is expected that 75% of the sales will be collected in the month of sale, and 25% will be collected in the following month. Compute cash collections from customers for each month. Collections from Customers Credit Sales                   January                 February              March January                         $______                 $________           $______ February                        ______                 ________           ______ March                             ______                 ________           ______                                        $______                 $________...
London Manufacturing Company expects the following sales in January, February, and March: Cash Sales Credit Sales...
London Manufacturing Company expects the following sales in January, February, and March: Cash Sales Credit Sales January $60,000 $270,000 February $50,000 $240,000 March $75,000 $355,000 The controller has determined that the company collects credit sales as follows: 60% in the month of sale, 30% in the first month after sale, 5% in the second month after sale, and 5% is expected to be uncollectible. How much cash will be collected from customers in March? $376,500 $410,000 $291,500 $373,500 Click if...
Sweeney Corporation has found that 80​% of its sales in any given month are credit​ sales,...
Sweeney 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, Sweeney Corporation has experienced the following collection​ pattern: 25% received in the month of the sale 50% received in the month after the sale 24% received two months after the sale 1% of the credit sales are never received November sales for last year were $90,000​, while December sales were $110,000. Projected sales for...
The LaGrange Corporation had the following budgeted sales for the first half of the current year:...
The LaGrange Corporation had the following budgeted sales for the first half of the current year: Cash Sales Credit Sales January $ 70,000 $ 170,000 February $ 75,000 $ 190,000 March $ 27,000 $ 150,000 April $ 22,000 $ 107,000 May $ 32,000 $ 220,000 June $ 100,000 $ 10,000 The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Collections...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT