Jayson 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.) i (Click the icon to view the additional information.) Complete a cash budget for Jayson Company for January, February and March. (Complete all input fields. Enter a "0" f into the cash budget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parentheses.) Beginning cash balance Cash receipts Cash available January February March Total $ 4,500 $ 4,639 $ 4,905 $ 4,500 10,350 13,570 16,050 39,070 44,850 18,200 24,035 44,470 Cash payments: Purchases of direct materials 3,000 7,100 Direct labor 3,000 3,100 3,600 9,700 Manufacturing overhead 1 800 750 750 3,300 Selling and administrative expenses 7,420 650 6,050 19,$20 15 15 Interest expense 12,220 13.215 14,215 39,650 Total cash payments Ending cash balance before financing 2,630 4,985 6,820 4,820 (4,500) (4,500) (4,500) (4,500) Minimum cash balance desired Projected cash excess (deficiency) (1,870) 485 2320 320 Financing: Borrowing 2,000 2,000 0 Principal repayments (2,000) (2,000) Total effects of financing 2,000 (2,000) $ Ending cash balance 4,630 || $ 4,985 $ 4,820 4,820 Complete a cash budget for Marcel Company for January, February and March. (Complete all input fields. Enter parentheses.) Marcel Company Cash Budget Beginning cash balance Cash receipts January, February, and March January Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Enter any number in the edit fields and then click Check Answer. Cash Receipts from Customers Total sales January February March $ 13,500 $ 16,100||$ 10,400||$ January February March Total 40,000 Total Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales $ 9,450 January-Credit sales, collection of January sales in January 2,025 January-Credit sales, collection of January sales in February February-Cash sales $ 2,025 11,270 February-Credit sales, collection of February sales in February February-Credit sales, collection of February sales in March March-Cash sales 2,415 $ 2,415 7,280 March-Credit sales, collection of March sales in March 1,560 $ 11,475|| $ 15,710 $ 11,255|| $ 38,440 Total cash receipts from customers Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February FebruaryDirect material purchases paid in March Total payments for direct materials Direct Labor: Total payments for direct labor Manufacturing Overhead: January February March Total $ 0 $ 3,100 $ 4,100 0 3,100 4,100 $ 7,200 2,600 4,000 4,400 11,000 Utilities for plant 450 450 900 Property taxes on plant 3,720 3,720 Total payments for manufacturing overhead 3,720 450 450 4,620 Selling and Administrative Expenses: Manufacturing Overhe Utilities for plant Property taxes on plant Total payments for ma Marcel's beginning cash balance is $6,000 and Marcel desires to maintain a minimum ending cash balance of $6,000. Marcel borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is available. The interest rate on amounts borrowed is 16% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Selling and Administrative Expenses: Utilities for office Property taxes on office Office salaries Total payments for Selling and Admin. expenses Print Done 630 630 1,260 1,320 1,320 4,000 4,000 4,000 12,000 5,320 4,630 4,630 14,580 $ 11,640 $ 12,180||$ 13,580 $ 37,400 Total cash payments Acccount balances, March 31: Prepaid Property Taxes $ 3,780 Accounts Payable $ 4,600 Utilities Payable $ 1,080