Reference arcel (Clid i (Cod Complete entered Cash Receipts from Customers Total January February March 5 10,800 $ 11,300 $ 11,100 $ January February March 33,200 Total sales Total Beginnin Cash red 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 Februar-Cash sales 7.560 1.620 Cash av 5 1,620 Cash pay N 7.910 Purch Reference T.DZU January-ureur sales, collection of January sales in repruary February-Cash sales February--Credit sales, collection of February sales in February February--Credit sales, collection of February sales in March March-Cash sales 7.910 1,695 $ 1,695 MarchCredit sales, collection of March sales in March 7,770 1,665 11,225 $11.130||$ Total cash receipts from customers 9.1805 31,535 Accounts Receivable balance, March 31: March-Credit sales collection of March sales in April 5 1.665 Print Done - X Reference ml TH . th January February March Total a 20 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 3,200 S 4.400 4,400 $ 0 3,200 7,600 pid ial md Direct Labor: Total navments for direct Inbor as 3.000 3.000 4.000 10.000 lal fad m th th 720 720 1.440 a sto Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 2,400 2,400 2,400 3,840 720 720 510 510 ga teid aila ym Selling and Administrative Expenses: Utilities for office Property taxes on office Office salaries Total namonte.for Sallion and Admin avnanese 1,560 5,000 6560 1,020 1,560 15,000 5,000 5,000 5510 5.510 17 5A has alal ufad Print Done Reference STU STU TUZU Marcel Com (Click the Click the Complete a entered into 1,560 Ummes or omce Property taxes on office Office salaries Total payments for Selling and Admin. expenses 5,000 5,000 6,560 5,000 5,510 1,560 15,000 17,580 5,510 11,960 $ 12,430 $ 14,630 $ 39,020 Total cash payments Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable Beginning Cash recei Cash availal Cash paym Purchas $ 2,970 4,700 $ S 1,230 Direct la Manufad Print Done Help me into Ish budget for MI ed into the cash budget Marcel's beginning cash balance is $6,000 and Marcel desires to maintain a minimum ending cash balance of 56,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 15% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month Inning cash balance h receipts th available h payments Purchases of direct materid Print Done (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 Marcel Company for January, February and March (Complete all input fields, Enter a "0" for any zero bal entered into the cash budget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parentheses.) January, February, and March January February $ 6,000 6,000 9.180 11,225 15 180 17 225 Beginning cash balance Cash receipts Cash available Cash payments Purchases of direct materials Direct labor Manufacturing overhead 0 3,200 3,000 3,000 2.400 720 (Click the icon to view the cash receipts schedule.) (Click the icon to view the cash payments Click the icon to view the additional information) Complete a cash budget for Marcel Company for January, February and March (Complete all input fields. Enter a "0" for any entered into the cash budget to the nearest whole dollar Enter a cash deficiency with a minus sign or parentheses.) Beginning cash balance 6,000 Cash receipts 9.180 Cash available 15,180 Cash payments Purchases of direct materials 0 Direct labor 3,000 Manufacturing overhead 2.400 Selling and administrative expenses 6,560 Interest expense 0 Toto och monte 11 960 3,220 (6,000) (2,780) 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 3,000 0 3,000 $ 6,220 (Click the icon to view the cash receipts schedule, (Click the icon to view the additional information.) Complete a cash budget for Marcel Company for January, February and March (Complete all input fields entered into the cash budget to the nearest whole dollar. Enter a cash deficiency with a minus sign or pare Cash payments Purchases of direct materials Direct labor 0 3,000 2,400 6,560 Manufacturing overhead Selling and administrative expenses Interest expense 0 11,960 Total cash payments Ending cash balance before financing Minimum cash balance desired 3,220 (6,000)