Cash budget for March in good form

1.Zoo Inc. is preparing its cash budget for March. The budgeted beginning cash balance is $27,000. Budgeted cash receipts total $106,000 and budgeted cash disbursements total $93,000. The desired ending cash balance is $65,000. The company can borrow up to $70,000 at any time from a local bank, with interest not due until the following month.Required:Prepare the company’s cash budget for March in good form. Make sure to indicate what borrowing, if any, would be needed to attain the desired ending cash balance.Beginning cash balance___Add cash receipts___Total cash available___Less cash disbursements____Excess (deficiency) of cash available over disbursements___Borrowings___Ending cash balance___2.Baseball Corporation is preparing its cash budget for January. The budgeted beginning cash balance is $19,200. Budgeted cash receipts total $189,000 and budgeted cash disbursements total $190,400. The desired ending cash balance is $31,200.To attain its desired ending cash balance for January, the company should borrowA.13400 B049000 C.0 D.312003.Seventy percent of Pluto Corporation’s sales are collected in the month of sale, 20% in the month following sale, and 10% in the second month following sale. All sales are on account. The following are budgeted sales data for the company: January,February,March,April,Budgeted sales$200,000 $300,000 $350,000 $250,000Total budgeted cash collections in April would be4.M Corporation produces and sells Product D. To guard against stockouts, the company requires that 25% of the next month’s sales be on hand at the end of each month. Budgeted sales of Product D over the next four months are: June July August September Budgeted sales in units40,000 60,000 50,000 80,000Budgeted production for August would be?show me the fomula please