EM5-27 (similar to) Avery 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 Avery 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 is not used in the table leave the input field er January February March Total i Data Table Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February Direct material purchases paid in March 3,800 4,100 4,100 $ Direct materials purchases Direct labor costs January February March $ 3,800 $ 4,100 S 4,800 3,200 3,600 4,400 3,800 7.900 Total payments for direct materials 400 400 400 750 750 Direct Labor: Total payments for direct labor 750 300 300 300 3,200 3,600 4,400 11,200 Depreciation on plant Utilities for plant Property taxes on plant Depreciation on office Utilities for office Property taxes on office 150 150 150 510 510 510 180 160 300 300 Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 160 6,000 Office salaries 6,000 6.000 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. Selling and Administrative Expenses: Print Done Total payments for Selling and Admin, expenses Choose from any list or enter any number in the input fields and then click Check Answer. 1 part Clear All remaining