Question

he following credit sales are budgeted by Wildhorse Co.: January $330500 February 486000 March 680400 April...

he following credit sales are budgeted by Wildhorse Co.:

January $330500
February 486000
March 680400
April 583200


The company’s past experience indicates that 70% of the accounts receivable are collected in the month of sale, 20% in the month following the sale, and 8% in the second month following the sale. The anticipated cash inflow for the month of March is

$599920.

$544320.

$583200.

$571540.

Homework Answers

Answer #1

Option a) $599920 is the correct answer.

Given,

credit sales for January = $330,500

credit sales for February = $486,000

credit sales for March = $680,400

credit sales for April = $583,200

The company’s past experience indicates that 70% of the accounts receivable are collected in the month of sale, 20% in the month following the sale, and 8% in the second month following the sale.

By keeping the company’s past experience in mind, we can anticipate cash inflow for the month of March is as follows

The anticipated cash inflow for the month of March = 8% of cash inflow from January + 20% of cash inflow from February + 70% of cash inflow from March

= ($330,500 X 8%) + ($486,000 X 20%) + ($680,400 X 70%)

= $26,440 + $97,200 + $476,280

= $599,920

The anticipated cash inflow for the month of March is $599,920.

Thank you, please appreciate by giving an upvote

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 following credit sales are budgeted by ELO Company: January $51,000   February   $75,000   March $105,000 April...
The following credit sales are budgeted by ELO Company: January $51,000   February   $75,000   March $105,000 April $90,000   The company’s past experience indicates that 70% of the accounts receivable are collected in the month of sale, 20% in the month following the sale, and 8% in the second month following the sale. The anticipated cash inflow for the month of April is: $84,000.   $90,000.   $88,200. $92,580.  
4. The Khaki Company has the following budgeted sales data: January February March April Credit Sales...
4. The Khaki Company has the following budgeted sales data: January February March April Credit Sales $350,000 $320,000 $400,000 $360,000 Cash Sales $70,000 $90,000 $80,000 $70,000 The regular pattern of collection of credit sales is 30% in the month of sales, 25% in the month following sales, and the remainder in the second month following the month of sale. There are no bad debts. Required: a. Determine budgeted cash receipts for April. b. Determine budgeted accounts receivable balance on March...
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000...
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000 January 9,000 23,000 February 11,000 25,000 March 77,800 12,000 12,000 22,000 March 68,500 12,500 12,500 23,500 May 72,000 12,300 12,300 24,500 Wages & other operating expenses are estimated as follows: Month Wages Other Expenses March 20,000 28,000 April 17,500 22,000 May 20,000 23,000  Newequipment purchased in February for $16,750 istobepaid forin April.  New furniture purchased in March for $15,000 isto be paid...
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%...
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...
Webster Company has the following sales budget.       January            $200,000             February&nbsp
Webster Company has the following sales budget.       January            $200,000             February           $240,000             March               $300,000             April                  $360,000       Cost of sales is 70% of sales. Sales are collected 40% in the month of sale and 60% in the following month. Webster keeps inventory equal to double the coming month's budgeted sales requirements. It pays for purchases 80% in the month of purchase and 20% in the month after purchase. Inventory at the beginning of January is $190,000.   Webster...
The PM Company has planned the following sales for the next three months: January February March...
The PM Company has planned the following sales for the next three months: January February March Budgeted Sales $40,000 $50,000 $70,000 Sales are made 20% for cash and 80% on account (A/R). From experience, the company has learned that a month's sales on account are collected according to the following pattern: Month of sale: 60% First month following sale: 30% Second month following sale: 8% Uncollectible: 2% The following additional information has been provided for March: Inventory purchases (70% paid...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $254,600 $39,100 February 220,900 46,100 March 326,000 48,500 Nieto’s sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto’s purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...
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                             ______                 ________           ______                                        $______                 $________...
Caba Corporation’s sales budget for the first half of the year is as follows: Budgeted Sales...
Caba Corporation’s sales budget for the first half of the year is as follows: Budgeted Sales January $ 115,000 February $ 198,000 March $ 220,000 April $ 250,000 May $ 210,000 June $ 290,000 Total: $ 1,283,000 Sales are 30% cash and 70% on account. Sales on account are to be collected over a three-month period, with 20% collected in the month of the sale, 65% collected in the first month following the sale, and 15% collected in the second...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT