9#4

The

Fielding

Company is preparing its cash payments budget. The following items relate to cash payments the company anticipates making during the second quarter of the upcoming year.

LOADING...

(Click the icon to view the cash payment information.)

Requirement

Prepare a cash payments budget for April, May, and June and for the quarter. (If a box is not used in the table leave the box empty; do not enter a zero.)

The Fielding Company
Cash Payments Budget
For the Months of April through June
	April	May	June	Quarter
Cash payments for direct materials:
55% of current month purchases
45% of last month's purchases

Cash payments for direct labor

Cash payments for manufacturing overhead

Cash payments for operating expenses

Cash payments for new server

Cash payment for taxes

Total cash payments

More info

Dialog content starts

a.

The company pays for

55%

of its direct materials purchases in the month of purchase and the remainder the following month. The company's direct material purchases for March through June are anticipated to be as follows:

March	April	May	June
$111,000	$137,000	$126,000	$145,000

b.

Direct labor is paid in the month in which it is incurred. Direct labor for each month of the second quarter is budgeted as follows:

April	May	June
$52,000	$62,000	$77,000

c.

Manufacturing overhead is estimated to be

140%

of direct labor cost each month. This monthly estimate includes

$32,000

of depreciation on the plant and equipment. All manufacturing overhead (excluding depreciation) is paid in the month in which it is incurred.

d.

Monthly operating expenses for March through June are projected to be as follows:

March	April	May	June
$72,000	$82,000	$86,000	$93,000

Monthly operating expenses are paid in the month after they are incurred. Monthly operating expenses include

$15,000

for monthly depreciation on administrative offices and equipment, and

$3,500

for bad debt expense.

e.

The company plans to pay

$8,000

(cash) for a new server in May.

f.

The company must make an estimated tax payment of

$14,500

on June

15.