(Click the icon to view the additional information.) Complete a cash budget for Mason Company for January, February and March. (Complete all inpu minus sign or parentheses.) January, February, and March January February $ 3,000 3380 11,340 Beginning cash balance Cash receipts Cash available 14,340 0 2,800 3,720 6,440 0 12,960 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 1,380 (3,000) (1.620) 2,000 0 2,000 3,380 Enter any number in the edit fields and then click Check Answer. Help Me Solve This e Text Pages Get More Help Type here to search Eipts from Customers: More Info Mason's beginning celah balance is $3,000 and Mason desires to maintain a minimum ending cash balance of $3,000. Mason 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 9% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. sh Print Done ats -Credit sales, collection of March sales in April 1.110 word=6010344008.questionid=5&flushed true&cid-65613538.centerwin=yes Reference Cash Receipts from Customers March Total Total salos January February S 12,600 $ 14,600 January February 11,100 $ March 38,300 Total $ 10,080 1,260 S 1.260 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 Feb-Cash sales February-Credit salon, colechon of February sales in February February-Credit sales collection of February sales in March March-Cash sales March-Credit sales, collection of March sales in March Total cash receipts from customers 11,680 1.460 $ 1,480 8.880 1.110 11,450 $ $ 11,340||$ 14.400 S 37.190 Accounts Receivable balance, March 31: March-Creditos, collection of March sales in April 1.110 Print Done 3.380 kAnswer - More Help - O I E 601034400&questionld Selflushed=true&cid=6561353&centerwin-yes ed Question 5, EM5-28 (simi... HW Score: 72 21%, 23.11 of 3 OLA Reference 0 Total payments for direct materials 3,100 4,000 $ 7.100 Direct Labor: Total payments for direct labor 2,800 3,600 4,100 10,500 Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 650 650 3,720 3,720 1,300 3,720 5,020 650 650 450 450 900 Selling and Administrative Expenses: Utilities for office Property taxes on office Office salarios Total payments for Selling and Admin. expenses 1.440 5,000 5,000 5,000 5,450 1.440 15,000 17,340 6,440 5,450 $ 12,960 $ 12,800 $ 14,200 $ 39,960 Total cash payments Acccount balances, March 31: Propaid Property Taxes Accounts Payable Utilities Payable $ 3,870 S 4.800 1,100 $ Print Done ere Help o BI