Jasmine Company manufactures both pesticide and liquid fertilizer, with each product manufac tured in separate departments. Three support departments support the production departments Power, General Factory, and Purchasing. Budgeted data on the five departments are as follows Support Departments Producing Departments Power General Factory Purchasing Pesticide Liquid Fertilizer Overhead $90,000 $314,000 $167,000 $78,900 $107,800 Square feet 1,500 1.500 4.200 4,800 Machine hours - 1,403 1,345 24,000 8,000 Purchase orders 20 20 40 7 120 60 The company does not break overhead into fixed and variable components. The bases for alloc tion are power-machine hours; general factory-square feet; and purchasing-purchase orders Required: Allocate in Excel using the Step Method.