Drop Down Options:

Under Manufacturing Overhead: Depreciation, Office Salaries, Property taxes on office, Property taxes on plant, Utilities for office, Utilities for plant

Under Selling and Administrative Expenses: Depreciation, Office Salaries, Property taxes on office, Property taxes on plant, Utilities for office, Utilities for plant

A Data Table Direct materials purchases Direct labor costs Depreciation on plant Utilities for plant Property taxes on plant Depreciation on office Utilities for office Property taxes on office Office salaries January February March $ 3,700 $ 3,500 $ 4,200 2,800 3,400 4,200 800 800 800 550 550 100 100 450 450 450 510510 510 180 180 180 3,500 3,500 3,500 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. Carmen Company has the following projected costs for manufacturing and selling and administrative expenses: E: (Click the icon to view the projected costs.) Prepare a schedule of cash payments for Carmen for January, February, and March. Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March 31. (lf 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 January-Direct material purchases paid in February February-Direct material purchases paid in March Total payments for direct materials Direct Labor: Total payments for direct labor Manufacturing Overhead: Total payments for manufacturing overhead Selling and Administrative Expenses: Total payments for Selling and Admin. expenses L Total cash payments Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable