Question

Bonita Industries estimates its sales at 160000 units in the first quarter and that sales will increase by 27000 units each quarter over the year. They have, and desire, a 25% ending inventory of finished goods. Each unit sells for $25. 40% of the sales are for cash. 70% of the credit customers pay within the quarter. The remainder is received in the quarter following sale. Cash collections for the third quarter are budgeted at

$2981500.

$4387000.

$5228500.

$6613938.

Answer 1

Solution:

Sales of second Quarter = 160000 + 27000 = 187000 units

Credit sales of second quarter = (sales units*sales price) *(100%- 40%) = 187000 * $25* 60% = $2,805,000.

Sales units of Third quarter = 187000 + 27000 = 214000 units

Cash Sales of third quarter = 214000*$25 *40% = $2,140,000

Credit sales of third quarter = 214000*$25 *60% = 3,210,000

Therefore,

budgeted cash Collection for third quarter = Cash sales of Third quarter + (Credit sales of Third Quarter*70%) + (Credit sales of second quarter * 30%)

= $2,140,000 + ($3,210,000*70%) + ($2,805,000*30%)

= $2,140,000 + $2,247,000 + $841,500

= $5,228,500