Manuraduring Overhead Distribution Worksheet The following are selected operating data for the production and service departments of Bluestone Company for 2016 Departments Service Product Overhead costs identified by department Indirect material 124.200 141,100 Indirect labo 600 72.000 Square feet of building floor space used 2.400 1600 Assessed value of e pment used Cubi yards of factory space used Machine hours Direct labor Building depreciation of $4.000 is allocated on the bass of we feet of floor space. Personal property taxe 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 Worsksheet 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 24,200 $ 41,100 12.720 $ 250,000 Indirect labor 48.600 72,000 16,292 719,500 Allocated to departments Building deprecation 40DO X 3,600 X 16.292 219.500 X Floor space Personal property taxes 18.000 x 31,500 X 63 000 X 105.000 X Total overhead $ 12.900 KS 35.100 R$ 79.292 MS824.500 X Allocation of service departments Dept. 1 O X O X Cubi yards of factory space Dept. 2 0 O X Machine hours used Total allocated overhead $ O S O S OXS 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. 1 $ 0x Production Dept. 2 $ OX Check You have correctly selected 16. Partially correct Marks for this submission: 0.42/1.00