please help with this manufacturing overhead distribution chart thank you in advance
My Subscriptions Elin Boucha 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 1 2 Overhead costs identified by department) Indirect material $121,000 $205,500 $63.600 $1,290,000 Indirect labor $243.000 $360,000 $81.460 $3,597,500 Square feet of building floor space used 12,000 18,000 30,000 60,000 Assessed value of equipment used $52,500 5157.500 5315.000 5525,000 Cubic yards of factory space used 220,000 330.000 Machine hours 128.000 512.000 Direct labor 550.000 $1,000,000 Building depreciation of $240,000 is allocated on the basis of square feet of floor space. Personal property taxes of 390,000 are allocated on the basis of assessed values 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 de Type here to search SOM 40020 nesscourse Return to course # My Subscriptions Elir 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 Indirect labor Allocated to departments: Building depreciation Personal property taxes Total overhead $ Allocation of service departments Dept. 1 Dept. 2 Total allocated overhead 5 5 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 $ Production Dept. 2 $ $ Check Type here to search OPE (2 My Subscriptions Elin Boucha 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 1 2 Overhead costs identified by department) Indirect material $121,000 $205,500 $63.600 $1,290,000 Indirect labor $243.000 $360,000 $81.460 $3,597,500 Square feet of building floor space used 12,000 18,000 30,000 60,000 Assessed value of equipment used $52,500 5157.500 5315.000 5525,000 Cubic yards of factory space used 220,000 330.000 Machine hours 128.000 512.000 Direct labor 550.000 $1,000,000 Building depreciation of $240,000 is allocated on the basis of square feet of floor space. Personal property taxes of 390,000 are allocated on the basis of assessed values 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 de Type here to search SOM 40020 nesscourse Return to course # My Subscriptions Elir 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 Indirect labor Allocated to departments: Building depreciation Personal property taxes Total overhead $ Allocation of service departments Dept. 1 Dept. 2 Total allocated overhead 5 5 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 $ Production Dept. 2 $ $ Check Type here to search OPE (2