5 5-27

Data Table 1 January February March Direct materials purchases $ 3,500 $ 3,900 $ 4,100 Direct labor costs 2,700 3,900 4,100 Depreciation on plant 700 700 700 Utilities for plant 440 440 440 Property taxes on plant 260 260 260 Depreciation on office 300 300 300 Utilities for office 650 650 650 Property taxes on office 160 160 Office salaries 2,000 2,000 2,000 160 ex All Data Table 440 440 440 260 260 260 300 300 300 Utilities for plant Property taxes on plant Depreciation on office Utilities for office Property taxes on office Office salaries 650 650 650 160 160 160 2,000 2,000 2,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. gi 75% 99+ Armand 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 Armand 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 empty; do not enter a zoro) 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 January February March Total Direct Labor: Total payments for direct labor SofM unts Pay January February March Total Manufacturing Overhead: Utilities for plant W Property taxes on plant Total payments for manufacturing overhead - e bala materi Selling and Administrative Expenses: El matel Utilities for office for dir Property taxes on office Office salaries Total payments for Selling and Admin. expenses I Total cash payments Prepaid property taxes on January 2 X 9/12 Prepaid property taxes on March 31 9/12 11 $ 2,430 Acccount balances, March 31: Prepaid Property Taxes ho Accounts Payable Utilities Payable