COMPLETE FOR JANUARY, FEBRUARY, MARCH, AND THEN TOTAL COLUMN. 4 COLUMN TOTAL.

Reference - X Reference Cash Receipts from Customers January February March Total Total sales January February March $ 12,400 $ 16,100 S 11,100 S January February March Total 39,800 Total Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March $ 3,100 $ 3,900 3,900 $ $ 9,920 Total payments for direct materials 3,100 7,000 1.240 Cash Receipts from Customers: Accounts Receivable balance, January 1 JanuaryCash sales January-Creclit 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 March-Cash sales MarchCredit sales, collection of March sales in March 1,240 12,880 1,610 Direct Labor: Total payments for direct labor 3,000 3,900 3,800 10,700 S 1,610 850 850 1,700 8,880 1.110 11,600 S Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 2.400 Total cash receipts from customers 11,160 $ 15,730 S 2,400 2,400 38,490 850 850 4,100 Print [ Done Print Done Print Done Marcel Company Cash Budget January, February, and March January More Info Beginning cash balance Cash receipts Cash available Marcel's beginning cash balance is $9,000 and Marcel desires to maintain a minimum ending cash balance of $9,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 8% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Cash payments: Purchases of direct materials Direct labor Print Done Manufacturing overhead Selling and administrative expenses Interest expense Enter any number in the edit fields and then click Check Answer. January 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 Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing: Borrowing Principal repayments Total effects of financing Ending cash balance Enter any number in the edit fields and then click Check