Please complete cash budget for January, February, and March. Thank you.

%E22-28 (similar to) Question Help O Mason Company has prepared the following schedules and additional information: (Click the icon to view the cash receipls schedule. (Click the icon to view the cash payments schedule.) (Click the icon to view the additional information.) Complete a cas budget for Mason Company for January, February and March (Complete all answer boxes. Enter a "0" for any zero balances. Round all amounts entered into the cash bucgel to the nearest whole dollar. Enter a cash deficiency with a minus sign or parentheses.) Mason Company Cash Budget January, February, and March 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: Barrowing Principal repayments Total effects of financing Ending cash balance Enter any number in the edit fields and then click Check Answer. 3 remaining Clear All Check Answer Reference Cash Receipts from Customers Total sales January February March $ 11,200 $ 12,200 $ 14,100 $ January February | March | Total 37,500 Total $ 8,960 1,120 $ 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 FebruaryCredit sales, collection of February sales in March MarchCash sales March-Credit sales, collection of March sales in March 1,120 9,760 1,220 $ 1,220 11,280 1,410 13,910 $ 10,080 IS 12,100 1940 $ Total cash receipts from customers 36,090 Accounts Receivable balance, March 31: March-Credit sales, collection of March sales in April $ 1,410 Print Done A Reference January February | March | Total Cash Payments Direct Materials: Accounts Payable balance, January 1 JanuaryDirect material purchases paid in February FebruaryDirect material purchases paid in March $ 3,200 $ 3,600 3,600 $ 0 3,200 6,800 Total payments for direct materials Direct Labor: Total payments for direct labor 2,500 3,500 4,300 10,300 450 450 900 Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 3,000 3,000 3,000 3,900 450 450 650 650 Selling and Administrative Expenses: Utilities for office Property taxes on office Office salaries Total payments for Selling and Admin. expenses 1,320 5,000 6,320 1,300 1,320 15,000 17,620 5,000 5,650 5,000 5,650 11,820||$ 12,800 $ 14,000||$ 38,620 Total cash payments Acccount balances, March 31: Prepaid Property Taxes $ 3,240 Print Done A More Info Mason's beginning cash 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 15% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Print Done