Heguired: 1. Prepare an everhead bosget for the expected activity sevel fer the coming veas 2. Prepare an overhead budget that reflects production that is 10 percent higher than expected (for both products). Engersol, Inc. Overhead Budget For the Year Ended December 31 Per DLH Budgeted direct labor hours Variable costs: Maintenance Power Indirect labor Total variable costs Fixed costs: Maintenance Indirect labor Rent Total fixed costs Total overhead costs Prepare an overhesd budget for production that is 20 percent lower than expected. 3. Which of the four data analytic types -descriptive, diagnostic, predictwe, or prescriptive-is being used in creating the three fexible budgets? (See Exhibits 2.5 and 2.6, pp. J7, 40, for a revi. of dota analytic types.) The fiexible budgets are used to detemine how weil the company will do under various sales scenarios