!! My Subscriptions Kayla Krantz Manufacturing Overhead Distribution Worksheet The following are selected operating data for the production and service departments of Bluestone Company for 2016. Departments Service Production 2 2 Overhead costs identified by department) Indirect material $145.200 5246,600 $76.320 $1.548.000 Indirect labor $291.600 $432.000 $97.752 $4.317.000 Square feet of building floor space used 14,400 21,600 36.000 72.000 Assessed value of equipment used $63.000 $189.000 5378.000 3630.000 Cubic Yards of factory space used 264.000 396.000 Machine hours 153.600 614400 Direct labor $60.000 $1.200.000 Building depreciation of $288,000 is allocated on the basis of square feet of floor space. Personal property taxes of $108.Lao are allocated on the basis of assessed support Required a. Prepare a 2016 overhead distribution worksheet for Bluestone Company similar to the one prepared for Exhibit 3-15 Use negative signs with answers, when appropriate. Under the Allocation Basis column, select the basis used to calculate each allocation Bluestone Company Overhead Distribution Worksheet For the Year Ended December 31, 2016 Service Production Type here to search 9:33 PM Adi E Business Course Return to course 31 My Subscriptions Kayla Krantz Bluestone Company Overhead Distribution Worksheet For the Year Ended December 31,2016 Service Production Dept. 1 Dept. 2 Dept. 1 Dept. 2 Allocation Basis Directly identifiable with departments: Indirect material $ 145.2005 246.600 $ 76.320 S 1.568.000 Indirect labor 291.600 432.000 97.752 4.317.000 Allocated to departments Building depreciation OX OM OX O x Floor space Personal property taxes OX OX OX 0 x Assessed value of equipment Total overhead $ ONS Ox5 ONS OX Allocation of service departments: Dept. $ OX OS 05 O x Cubic Yards of factory space Dept. 2 O OX OX O X Machine hours used Total alocated overhead OS OS ONS OM b. Compute the manufacturing overhead rates for production departments 1 and 2 using machine hours and direct labor costs, respectively, for allocation bases support Round answers to two decimal places, when applicable Production Dept 1 OX Production Dept 28 OX Check O Type here to search RI 9:33 PM 9 (2) A