A&E 8**

Please include Excel functions/formulas to yield appropriate answers.

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 materials. 3. Prepare a cash budget