Question

The following various elements relate to Whitfield, Inc.'s cash budget for April of the current year. For each item, determine the amount of cash that Whitfield should receive or pay in April. a. At $32 each, unit sales are 5,000 and 6,000 for March and April, respectively. Total sales are typically 40% for cash and 60% on credit; 30% of credit sales are collected in the month of sale, with the balance collected in the following month. Uncollectible accounts are negligible. March sales $Answer April cash sales Answer April credit sales Answer Cash collected in April $Answer b. Merchandise purchases were $49,000 and $82,000 for March and April, respectively. Typically, 20% of total purchases are paid for in the month of purchase with a 5% cash discount. The balance of purchases is paid for (without discount) in the following month. March purchases $Answer April purchases Answer Cash paid in April $Answer c. Fixed administrative expenses, which total $15,000 per month, are paid in the month incurred. Variable administrative expenses amount to 20% of total monthly sales revenue, one-half of which is paid in the month incurred, with the balance paid in the following month. April fixed expenses $Answer March variable expenses Answer April variable expenses Answer Cash paid in April $Answer d. A store asset originally costing $12,000, on which $6,000 depreciation has been taken, is sold for cash at a loss of $400. $Answer

Answer 1

Solution a:

Computation of cash collected against sales in April
Particulars	Amount
Collection of march sales (5000*$32*60%*70%)	$67,200.00
Cash Sales - April (6000*$32*40%)	$76,800.00
Collection of April credit sales (6000*$32*60%*30%)	$34,560.00
Cash collected in April	$178,560.00

Solution b:

Computation of cash paid for purchases in April
Particulars	Amount
Cash paid for march purchases ($49,000*80%)	$39,200.00
Cash paid for april purchases ($82,000*20%*95%)	$15,580.00
Cash paid for purchases in April	$54,780.00

Solution c:

Computation of cash paid for administrative expenses in April
Particulars	Amount
Cash paid for April fixed administrative expenses	$15,000.00
Cash paid for March Variable administrative expenses (5000*$32*20%*50%)	$16,000.00
Cash paid for April Variable administrative expenses (6000*$32*20%*50%)	$19,200.00
Cash paid for purchases in April	$50,200.00

Solution d:

Computation of cash collected against sale of assets in April
Particulars	Amount
Book value of asset ($12,000 - $6,000)	$6,000.00
Loss on sales	-$400.00
Cash collected on sale of asset	$5,600.00