Please provide how you got the answer. Do not just add the answer with no work shown. Also, if you add a spreadsheet show how the answer was obtained, again do not just add the answer.

(Appendix 45) Sequential Method of Support Department Cost Allocation Stevenson Company is divided into two operating divisions: Hattery and Small Motors. The company allocates power and general factory costs to each operating division using the sequential method. General Factory is allocated first in the sequential method for the company. Support department cost allocations using the scqucntial method are based on the following data: Support Departments Operating Divisions General Small Power Battery Motors Factory $430,000 Overhead costs $160,000 $163.000 $84.600 Machine hours 2,00 2,0D 19.COD 1,500 1,000 1,500 10,000 20,000 Square footage Direct labor hours 18,000 60,000 Required: 1. Calculate the allocation ratios for Power and General Factory. (Note: Carry these calculations out to four decimal places.) Allocation ratios for General Factory Power Battery Small Motors III II Allocation ratios for Power Battery Small Motors