Please complete all parts of the problem with equations and formulas if possible. Thank you.

O E22-28 (similar to) Question Help Avery 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.) (Click the icon to view the additional information.) Complete a cash budget for Avery Company for January, February and March (Complete all answer boxes. Enter a '0' for any zera balances. Round all amounts entered into the cash budget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parenth .) Avery Company Cash Budget January, February, and March January Beginning cash balance Cash receipts Cash available Cash payments: Purchases af direct materials Direct labor Manufacturing overhead Selling and administrative expenses Inlerest expense Tolal cash payments Ending cash balance before 11 nancing Minimuin cash balance desired Projected cash excese (deficiency) Financing Borrowing Principal repayments Tolal 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 12,600 $ 10,100 $ 14,100 $ January February | March | Total 36,800 Total $ 8,820 Agoll 1,890 $ Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales JanuaryCredit sales, collection of January sales in January January-Credit sales, collection of January sales in February FebruaryCash sales FebruaryCredit sales, collection of February sales in February FebruaryCredit sales, collection of February sales in March MarchCash sales MarchCredit sales, collection of March sales in March 1,890 7,070 1,515 $ 1,515 9,870 2,115 13,500 $ Total cash receipts from customers $ 10,710 $ 10,475 $ 34,685 Accounts Receivable balance, March 31: MarchCredit sales, collection of March sales in April $ 2,115 Print Done i Reference - X | 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 $ 4,400 4,400 $ 3,200 Total payments for direct materials 7,600 Direct Labor: Total payments for direct labor 2,600 3,000 | 3,800 9,400 850 850 Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 3,000 3,000 1,700 3,000 4,700 850 850 510 510 Selling and Administrative Expenses: Utilities for office Property taxes on office Office salaries Total payments for Selling and Admin. expenses 1,920 4,000 5,920 1,020 1,920 12,000 4,000 4,510 4,000 4,510 14,940 11,560 $ 11,520 13,560 $ Total cash payments 36,640 Acccount balances, March 31: Prepaid Property Taxes $ 3,690 Print Done 1 More Info Avery's beginning cash balance is $3,000 and Avery desires to maintain a minimum ending cash balance of $3,000. Avery 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 14% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Print Done