Plz help to solve, make sure you answer all yellow part (very IMPORTANT) also plz provide FUNCTIONS and EQUATIONS very important! thx

Chapter 15 Revenue Cycle and Current Accounts Management James Buchanan orthotics and Prosthetics is planning to request a lineofcredit from its bank. The company has produced sales estimates, and these appear in the worksheet below. Collection estimates are as follows: 10 percent within the month of sale, 75 percent in the month following the sale, and 15 percent in the second month following the sale. Labor and supplies estimates also appear in the worksheet below. Payments for labor and supplies aretypically made during the month following the one in which these costs have been incurred. General and administrative salaries will amount to approximately S27,000 a month; lease payments under long-term lease tracts will be $9,000 a month; depreciation charges will be $36,000. a month: miscellaneous expenses will be S2,700 a month; income tax payments of S63,000 will be due in both September and December; and a progress payment of S180,000 on a new building must be paid in October. Cash on hand on July 1 will amount to S132,000, and a minimum cash balance of $90,000 will be maintained throughout the cash budget period. What loan will be the company require in Aune July August September october November December anuary Collections worksheet 1. Billed charges $180,000 $180,000 $360,000 $540,000 $720,000 $360,000 $360,000 $90,000 $180,000 Within 30 days 30-60 days 60-90 days Total collections Supplies worksheet 4. Amount of labor and supplies $90,000 $90,000 $126,000 $882,000 $306,000 $234,000 $162,000 $90,000 5. Payments made for labor and supplies Net cash gain (loss 6. Total collections (line 3) Total purchases line 50 8. General and administrative salaries 9. Lease payments 2,700 10 Miscellaneous expenses 12. Progress payment S180,000 13. Total payments 14, Net cash gain(or loss Borrowing surplus summary: 15. Cash at beginning with no borrowing $132,000 16 Cash at end with no borrowing line 14 150 17. Target cash balance given) $90,000 18. Cumulative surplus cash (or loan balance)