1.Zoo Inc. is preparing its cash budget for March. The budgeted beginning cash b
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.
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___
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 borrow
A.13400 B049000 C.0 D.31200
3.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,000
Total budgeted cash collections in April would be
4.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,000
Budgeted production for August would be?
show me the fomula please