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 1 2 Overhead costs (identified by department) Indirect material $48,400 $82,200 $25,440 $516,000 Indirect labor $97,200 $144,000 $32,584 $1,439,000 Square feet of building floor space used 4,800 7,200 12,000 24,000 Assessed value of equipment used $21,000 $63,000 $126,000 $210,000 Cubic yards of factory space used 88,000 132,000 Machine hours 51,200 204,800 Direct labor $20,000 $400,000 Building depreciation of $96,000 is allocated on the basis of square feet of floor space. Personal property taxes of $36,000 are allocated on the basis of assessed values of equipment used. Costs for service departments 1 and 2 are allocated to production departments on the basis of cubic yards of factory space and machine hours, respectively. Required a. Prepare a 2016 overhead distribution worksheet for Bluestone Company similar to the one prepared for Exhibit 3-16. 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 Dept. 1 Dept. 2 Production Dept. 1 Dept. 2 Allocation Basis Directly identifiable with departments: Indirect material $Answer 48,400 Correct $Answer 82,200 Correct $Answer 25,440 Correct $Answer 516,000 Correct Indirect labor Answer 97,200 Correct Answer 144,000 Correct Answer 32,584 Correct Answer 1,439,000 Correct Allocated to departments: Building depreciation Answer 19,200 Incorrect Answer 28,800 Incorrect Answer 48,000 Incorrect Answer 96,000 Incorrect AnswerCorrect Personal property taxes Answer 3,600 Incorrect Answer 10,800 Incorrect Answer 21,600 Incorrect Answer 36,000 Incorrect AnswerCorrect Total overhead $Answer 314,000 Incorrect $Answer 492,000 Incorrect $Answer 185,648 Incorrect $Answer 4,042,000 Incorrect Allocation of service departments: Dept. 1 $Answer (314,100) Incorrect Answer 0 Correct $Answer 125,600 Incorrect $Answer 188,400 Incorrect AnswerCorrect Dept. 2 Answer 0 Correct Answer 0 Incorrect Answer 98,400 Incorrect Answer 393,600 Incorrect AnswerCorrect Total allocated overhead $Answer 0 Correct $Answer 0 Correct $Answer 409,648 Incorrect $Answer 4,624,000 Incorrect 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 $Answer 4 Correct Production Dept. 2 $Answer 5.78 Correct