Carmen Company has prepared the following schedules and additional information: (Click the icon to view the cash receipts schedule.) (Click the icon to view the cash payments schedule.) (Click the icon to view the additional information.) Complete a cash budget for Carmen Company for January, February and March. (Complete all input fields. Enter a "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parentheses.) Carmen Company Cash Budget January, February, and March January February March Total Beginning cash balance Cash receipts Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Carmen Company has prepared the following schedules and additional information: (Click the icon to view the cash receipts schedule.) (Click the icon to view the cash payments schedule.) A (Click the icon to view the additional information.) Complete a cash budget for Carmen Company for January, February and March. (Complete all input fields. Enter a "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar. Enter a cash deficiency minus sign or parentheses.) with Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing Principal repayments Total effects of financing Ending cash balance i Reference X Cash Receipts from Customers Total Total sales January February March $ 10,800 $ 10,200 $ 12,900 S January February March 33,900 Total $ 7,560 1,620 $ 1,620 Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credit sales, collection of February sales in February February-Credit sales, collection of February sales in March MarchCash sales MarchCredit sales, collection of March sales in March 7,140 1,530 $ 1,530 9,030 $ 1,935 12,495 $ $ Total cash receipts from customers 9,180 $ 10,290 $ 31,965 X i Reference Total sales $ 10,800 $ 10,200 $ 12,900 $ January February March 33,900 Total 7,560 1,620 $ $ 1,620 Cash Receipts from Customers: Accounts Receivable balance, January 1 JanuaryCash sales JanuaryCredit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credit sales, collection of February sales in February FebruaryCredit sales, collection of February sales in March MarchCash sales March-Credit sales, collection of March sales in March 7,140 1,530 $ 1,530 9,030 1,935 12,495$ $ 9,180 $ 10,290 $ 31,965 Total cash receipts from customers Accounts Receivable balance, March 31: March-Credit sales, collection of March sales in April 1,935 Reference - X January February March Total $ 0 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 $ 3,700 3,500 3,500 $ 0 3,700 7,200 Direct Labor: Total payments for direct labor 2,500 3,200 3,500 9,200 750 750 Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 3,600 1,500 3,600 5,100 3,600 750 750 i Reference 750 750 Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 3,600 1,500 3,600 5,100 3,600 750 750 320 320 640 Selling and Administrative Expenses: Utilities for office Property taxes on office Office salaries Total payments for Selling and Admin. expenses 1,800 2,000 3,800 2,000 2,320 2,000 2,320 1,800 6,000 8,440 $ 9,900 $ 9,970 $ 10,070 S 29,940 Total cash payments Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable $ 4,050 $ 4,200 1,070