E22-27 (book/static) Marcel Company has the following projected costs for manufacturing and selling and administrative expenses: (Click the icon to view the projected costs.) 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 31. (If an input field i not used in the table leave the input field empty, do not enter a zero.) January February March Total Data Table Cash Payments Direct Materials: Accounts Payable balance, January 1 JanuaryDirect material purchases paid in February February-Direct material purchases paid in March January February March $ 3.100 $ 3,500 $ 4,800 3,300 3,500 3.600 550 550 550 Total payments for direct materials 650 650 650 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 200 200 200 Direct Labor: 550 550 Total payments for direct labor 550 250 250 250 170 170 170 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. Print Done Manufacturing Overhead: January February March $ 3,100 $ 3,500 $ 4,800 3,300 3,500 3.600 Total payments for manufacturing overhead 550 550 550 650 650 650 Selling and Administrative Expenses: 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 200 200 200 550 550 550 250 250 250 170 170 170 3.500 Total payments for Selling and Admin. expenses 3,500 3.500 Total cash payments 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. Print Done Dald Table Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable January February March $ 3,100 $ 3,500 $ 4.800 3,300 3,500 3,600 550 550 550 650 650 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 650 200 200 200 550 550 550 250 250 250 170 170 170 3,500 3,500 3.500 All costs are paid in month incurred except: direct materials, which are paid in the month following 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 zero balance on January 1. Enter any number in the edit fields and then click Check Answer. All parts showing Clear All