Bauer Corporation 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.
a. Bauer Corporation pays for 50% 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:

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:

c. Manufacturing overhead is estimated to be 160% of direct labor cost each month. This monthly estimate includes $ 39,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:

Monthly operating expenses are paid in the month after they are incurred. Monthly operating expenses include $ 11,000 for monthly depreciation on administrative offices and equipment, and $ 2,900 for bad debt expense.
e. Bauer Corporation plans to pay $ 7,000 ( cash) for a new server in May.
f. Bauer Corporation must make an estimated tax payment of $ 13,500 on June 15.

Requirement
Prepare a cash payments budget for April, May, and June and for thequarter.

Transcribed Image Text:

March April $130,000 May $126,000 June $119,000 $144,000 April $52,000 May $62,000 June $77,000 March $71,000 April $85,000 May $88,000 June $92,000