Marcel Company has the following projected costs for manufacturing and selling and administrativeexpenses:

Data Sheet:

Jan Feb Mar

Direct materials purchase: $3100 4500 4700

Direct labor costs 2800 3100 3800

Depreciation on plant 800 800 800

Utilities for plant 650 650 650

Property taxes on plant 200 200 200

Depreciation on office 500 500 500

Utilities for office 250 250 250

Property taxes on office 150 150 150

Office salaries 6000 6000 6000

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 for Marcel for January, February, and March.

Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March

96931.

(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