Manufacturing Overhead Distribution Worksheet The following are selected operating data for the production and service departments of Bluestone Company for 2016, Departments Service Production Overhead costs identified by department Indirect material $145.200 5246.600 $76.320 11,50.000 Indirect labor 5291,600 $432.000 597,252 54.317,000 Square feet of building floor space used 14.00 21.600 36.000 92.000 Assessed value of equipment used 562000 $189,000 $38.000 5630.000 Cubic yards of factory space used 264.000 396.000 Machine hours 151600 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 5108.000 are allocated on the basis of assessed values of equipme 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 Dept. 1 Dept. 2 Dept. 1 Dept. 2 Directly identable with departments Allocation Basis 9:27 PM GULD Fit 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 Dept. 1 Dept. 2 Dept. 1 Dept. 2 Allocation Basis Directly identifiable with departments Indirect material $ 145.2005 246,600 26.320 S 1.548.000 Indirect labor 291.600 432.000 92.752 4,317,000 Allocated to departments: Building depreciation 28.800 43.700 72.000 144,000 Floor space . Personal property taxes 5.400 16.200 32.400 54,000 Assessed value of equipment Total overhead $ 471,000 $ 738.000 278.4725 6,063.000 Allocation of service departments Dept. $ (471.000) OS 94.200 X 5 376,800 x Oubi yards of factory space . Dept. 2 0 (738.000) 35.143 x 702.857 X Machine hours used Total allocated overhead 5 OS OS 129.343 XS 1.07.657 x b. Compute the manufacturing overhead rates for production departments 1 and 2 using machine hours and direct labor costs, respectively, for allocation bases Round answers to two decimal places, when applicable Production Dept. 15 35.143 X Production Dept. 2 S 702.857 X G Check 9:27 PM ing