must be answered in a formula

1. Prepare a sales budget, including a schedule of expected cosh collections. 2. Prepore a direct materials budget, including a schedule of expected cosh disbursements for purchoses of materials. 3. Prepore a cash budget. 1. Prepare a sales budget, including a schedule of expected cash collections. 2. Prepore a direct materials budget, induding a schedule of expected cash disbursements for purchases of materials. 3. Prepare a cash budget. - . 3 * Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel? \begin{tabular}{l} OULS \\ \hline \end{tabular} DATA REVEW VIEW Font Styler S\&.P Enterprises needs a cash budget for March. The following information is C D E The company has a line of credit available to bolster the cash balance as needed. Nhen preparing budgets, the company maintains their data on a separate sheet from the actual budget and schedules. Jick the Schedules and Cash Budget tab to prepare the folloving 1. Schedule of expected cash collections for March. 2. Schedule of expected cash disbursements for inventory purchases for March. 3. Cash budget for March. Indicate in the financing section amy borrowing that will be needed in March. Assume that amy interest will not be paid until the following month. 1. Prepare a sales budget, induding a schedule of expected cash collections. 2. Prepare a direct materials budget, induding a schedule of expected cash disbursements for purchases of materiols. 3. Prepare a cash budget. 1. Prepare a soles budget, induding a schedule of expected cash collections. 2. Prepore a direct materials budget, including a schedule of expected cosh disbursements for purchoses of moterials. 3. Prepore a cash budget