This is the third time I am posting this same questions. Please help do everything that s required please.

James Smith, Crane & John Fabricators' budget director, has received budget information from several managers and is preparing the company's cash budget. January February March Quarter Collections from sales 476,200 559,860 636,720 1,672,780 Payments for direct materials 80,505 253,125 274,730 608,360 Payments for direct labor 98.640 103.680 116,640 318,960 78,490 78.980 80,240 237,710 Payments for manufacturing overheads Payments for Selling & administrative expenses 111,400 116,440 123,160 351,000 In addition to the information he received from these managers, James knows the following: Crane & John plans to have $32,400 in its cash account on January 1. Crane & John plans to purchase and pay cash for a piece of land in January at a cost of $85,000. a In addition to the information he received from these managers, James knows the following: Crane & John plans to have $32,400 in its cash account on January 1. Crane & John plans to purchase and pay cash for a piece of land in January at a cost of $85,000. . Crane & John plans to make a cash purchase of equipment in March at a cost of $28,000. Crane & John's income taxes from last quarter totaling $26,400 will be paid in January. . Crane & John is required to maintain a minimum cash balance of $50,000 in its account at First National Bank. Crane & John has negotiated with the First National Bank to provide a $175,000 line of credit that can be borrowed against in $1,000 increments on the first day of the month. Any repayments on the line of credit must also be made in $1,000 increments and are made on the last day of the month when cash is available. The annual interest rate on this line of credit is 6%. Any time a principal payment is made, all accrued interest to date is repaid. Prepare Crane & Hill's cash budget for the first quarter. (Round answers to decimal places, eg. 5,275. Enter answers in necessary fields only. Leave other fields blank. Do not enter 0. Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) Beginning cash balance $ 32400 $ 50165 $ Collections from sales 476200 559860 Total cash available to spend 508600 610025 Less Disbursements Payments for direct materials 80505 i 253125 i Direct labor 98640 i 103680 i Manufacturing overhead 78490 i 78980 i Selling & administrative expenses 111400 i 116440 i Land and Equipment purchases 85000 i Income taxes 26400 i Total cash disbursements 480435 552225 Cash excess (deficiency) 30165 58,800 Minimum cash balance (50,000) i (50,000) Cash excess (needed) (19,835) 8,800 Financing . Borrowings 22000