Analysis & Excel 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. 1. Prepare a soles 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