i would like a detailed explantion of this question? example: equations and understanding how to start this problem.
Expected cash collections: March cash collections March collections on account: January sales February sales March sales Total cash collections Poyments to suppllers: Accounts payable for inventory purchases, beginning balance March purchases Total cash payments S\&P Enterprises Cash Budget For the Month of March Cash balance, March 1 Add cash receipts: Collections from customers Total cash available Less disbursements: Payments to suppliers Selling and administrative expenses Equipment purchases Dividends paid Total disbursements Preliminary cash balance Financing: Additional loan Loan repayments Interest Total financing Cash balance, March 31 AI fi 38.P Enterprises needs a cash budget for March. The following information is anilable. d. Data Jonvary tebruary. 4. Actual ianary and Fetharyand epected March rales: S. Cons ales 6. Sales on account 7 Totalsales $1,60025,000$26,600 t 9. Accounts Receivabie Collectons 10 Month of alie 11 Month followivale 12 Second month following sile 1) Unceliectble 14 Accounts mable for incentory purchases, March 1 balance. $10,500 Is Budreted inventory purchases in Murch $23,500 16 inventory parments: 17 Month of purchase 60K 18 Month following wurthase 40K 19 21 Budgeted depreciation in Marcb (included in total selling and admin eip) $3,200 2 23 Oher budated cah dabursenents in March 24 tquigment purchase: $14,000 25 Onidends to be paid $2,000 26 2) Ninimum cash balance to be maintained 21 March 1 cash balance 2) Murch 1 outstanding borrowings 10 March 1 interest due $10,000 $11,500 it 12. The company has a line of credit avalable to boluter the cash balnoce as needed. 50 (3) I4 When preparing budrets, the company muintains their data on a sepante sheet from the actual budeat and schedulas. is Aeguint: 17. Click the Schedvils und Cain Budet tab to prepare the followint: 1. Schedule of expected cash collections for March. 2 schedule of expected cash disbursements for inventory purchases for March. 1 Cas budet for March. indicate in the financing section any borrowing that will be needed in March. Assume that any interest will not be pald unti the following month. monined: Lethedile of epected cach collectlons for Murch