Manufacturing Overhead Distribution Worksheet The following are selected operating data for the production and service departments of Bluestone Company for 2016. Departments Service Production 1 2 2 Overhead costs (dentified by department) Indirect material $145,200 5246,600 576.320 $1.548.000 Indirect labor 5291,600 5432,000 $97,752 54.317,000 Square feet of building floor space used 14.400 21.600 36,000 72.000 Assessed value of equipment used 563.000 5189.000 $378.000 5630,000 Cubic yards of factory space used 264.000 396.000 Machine Hours 153,600 614 400 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,000 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 8:20 PM 94/2020 - Type here to search 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 5 145.200 S246.600 S 76.320 S 1,548.000 Indirect labor 291.600 432.000 97,752 4.317,000 Allocated to departments Building depreciation 28.800 43.200 72.000 164,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.472 3 6063.000 Allocation of service departments Dept. $ DX OS OXS 0 x Cubic yards of factory space o Dept 2 O ON OX Ox Machine hours used Total alocated overhead $ OS 0 OXS OX 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. 25 OM Check 2:25 PM Type here to search