Company has the following projected costs for manufacturing and selling and administrative expenses:

Direct materials purchases

$3,700

$3,500

$4,400

Direct labor costs

3,000

3,400

3,800

Depreciation on plant

700

700

700

Utilities for plant

550

550

550

Property taxes on plant

310

310

310

Depreciation on office

500

500

500

Utilities for office

350

350

350

Property taxes on office

180

180

180

Office salaries

2,500

2,500

2,500

(Click the icon to view the projected costs.) All costs are paid in month incurred except: direct materials, which are paid in the month following the purchase; utilities, which are paid in the month after incurred; and property taxes, which are prepaid for the year on

January

2. The Accounts Payable and Utilities Payable accounts have a zero balance on January

1. Prepare a schedule of cash payments forMaynardforJanuary,February,and March.Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as ofMarch31

(If a box is not used in the table leave the box empty; do not enter a zero.)

January

February

March

Total

Cash Payments

Direct Materials:

Accounts Payable balance, January 1

JanuaryDirect material purchases paid in February

FebruaryDirect material purchases paid in March

Total payments for direct materials

Direct Labor:

Total payments for direct labor

Direct Labor:
Total payments for direct labor

Manufacturing Overhead:
Utilities for plant
Property taxes on plant
Total payments for manufacturing overhead
Selling and Administrative Expenses:
Utilities for office
Property taxes on office
Office salaries
Total payments for Selling and Admin. expenses
Total cash payments

Acccount balances, March 31:
Prepaid Property Taxes
Accounts Payable
Utilities Payable