Part 6 (Chapter 24) Waterways Corporation is continuing its budget preparations. Waterways had the following static budget and overhead costs for March. Waterways Corporation Manufacturing Overhead Budget (Static) For the Month of March Waterways Corporation Manufacturing Overhead Costs (Actual) For the Month of March Production in units Costs uction in units 117500 Budgeted production in units Budgeted costs $7,050 11,750 10,575 5,875 42,000 16,800 2,500 1,200 1300 $99,050 7,100 11,825 10,700 5,900 42,000 16,800 2,500 1,200 1300 Indirect materials Indirect labor Utilities Maintenance Salaries Depreciation Property taxes Indirect materials Indirect labor Utilities Maintenance Depreciation Property taxes Janitorial Janitorial Total costs Total budgeted costs Waterways produced 118,500 units in March rather than the budgeted number of units. Instructions 1. Use Excel Worksheet 6-1 to prepare a flexible overhead budget based on producing the following amounts a. 115,000 units b. 116,000 units c. 117,000 units d. 118,000 units e. 119,000 units