Question

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

Homework Answers

Answer #1

Sales in January = $136,850
Sales in February = $143,525
Sales in March = $151,975
Sales in April = $164,950

Company collects 42% in the month of sales, 47% in the following month and 9% in two months after the month of sale

Cash Collection in April = 42% * Sales in April + 47% * Sales in March + 9% * Sales in February
Cash Collection in April = 42% * $164,950 + 47% * $151,975 + 9% * $143,525
Cash Collection in April = $153,624.50

Therefore, the company will collect $153,624.50 or $153,625 in April

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
Shown below are the budgeted sales for ABC Company for the next six months: Sales for...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for Cash Sales on Account January $15,000 $ 70,000 February $18,000 $ 80,000 March $14,000 $160,000 April $26,000 $120,000 May $18,000 $170,000 June $24,000 $105,000 On average, 35% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 10% are collected in the second month following sale, and the remaining 15% is collected three months...
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...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for Cash Sales on Account January $15,000 $ 70,000 February $18,000 $ 80,000 March $14,000 $160,000 April $26,000 $120,000 May $18,000 $170,000 June $24,000 $105,000 On average, 35% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 10% are collected in the second month following sale, and the remaining 15% is collected three months...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for Cash Sales on Account January $27,000 $226,000 February $33,000 $299,000 March $21,000 $273,000 April $24,000 $241,000 May $38,000 $213,000 June $19,000 $201,000 On average, 14% of the sales on account are collected in the month of sale, 38% are collected in the month following sale, 43% are collected in the second month following sale, and the remaining 5% is collected three months after the...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are credit sales. March $43,000 June $47,000 April 49,000 July 55,000 May 38,000 August 57,000 Sales in January and February were $46,000 and $45,000, respectively. Experience has shown that of total sales, 10 percent are uncollectible, 35 percent are collected in the month of sale, 45 percent are collected in the following month, and 10 percent are collected two months after sale. a. Prepare a...
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?
Judge Company's budgeted sales for the next five months are given below: Budgeted Sales January $149,000...
Judge Company's budgeted sales for the next five months are given below: Budgeted Sales January $149,000 February $274,000 March $373,000 April $167,000 May $232,000 20% of Judge Company's sales are cash sales and the other 80% are sales on account. The sales on account are collected in the pattern: 22% collected in the month of sale 35% collected in the month following sale 27% collected in the second month following sale 11% collected in the third month following sale 5%...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are credit sales. March...............................        $35,000 April.................................          41,000 May..................................          30,000 June.................................          39,000 July...................................          47,000 August..............................          49,000 Sales in January and February were $38,000 and $37,000, respectively. Experience has shown that of total sales, 10 percent are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale. Prepare a monthly cash receipts schedule for the firm...
Genesis, Inc. expects sales of $3,700, $4,200, $4,600, and $5,000 for the months of March through...
Genesis, Inc. expects sales of $3,700, $4,200, $4,600, and $5,000 for the months of March through June, respectively. The company collects 50 percent of sales in the month of sale, 30 percent in the month following the month of sale, and 17 percent in the second month following the month of sale. The remaining 3 percent of sales is never collected. How much money does the company expect to collect in the month of July? $4,594.00 $4,800.00 $5,000.00 $7,300.00 $4,286.00
The controller of Harrington Company estimates sales and production for the first four months of 2020...
The controller of Harrington Company estimates sales and production for the first four months of 2020 as follows: January February March April Sales $28,700 $38,200 $50,900 $25,800 Production in units 1,100 1,500 1,800 2,800 Sales are 40% cash and 60% on account, and 60% of credit sales are collected in the month of the sale. In the month after the sale, 40% of credit sales are collected. It takes 4 kg of direct materials to produce a finished unit, and...