Show the excel Formula to solve and get the answer.

1. Prepare a sales budget, Including a schedule of expected cash collections. 2. Prepare a direct materials budget, including a schedule of expected cash disbursements for purchases of matenials 3. Prepare a cash budget M B Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel ?x HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VE FILE Sign In Calibri Paste B IUA Alignment Number Conditional Format as Cell Cells Editing Formatting" Table Styles Clipboard Font Styles D45 1 S & P Enterprises needs a cash budget for March. The following information is available. January February March 3 Data 4 Actual January and February and expected March sales: 5 Cash sales 6 Sales on account 7 Total Sales $ 1,600 3,750 5,100 1. Prepare a sales budget, Including a schedule of expected cash collections. 2. Prepare a direct materials budget, including a schedule of expected cash disbursements for purchases of matenials 3. Prepare a cash budget M B Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel ?x HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VE FILE Sign In Calibri Paste B IUA Alignment Number Conditional Format as Cell Cells Editing Formatting" Table Styles Clipboard Font Styles D45 1 S & P Enterprises needs a cash budget for March. The following information is available. January February March 3 Data 4 Actual January and February and expected March sales: 5 Cash sales 6 Sales on account 7 Total Sales $ 1,600 3,750 5,100