Pottery Inc., is divided into 2 operating divisions: Pottery and Retail. The company allocates Power and General Factory department costs to each operating division. Power costs are allocated on the basis of the number of machine hours and general factory costs on the basis of square footage. Allocation for the coming year are based on the following data? Support Departments Power Department General factory Department $150,000 $160,000 Operating Divisions Pottery Retail $98,000 $56,000 Direct costs Normal Activity: Machine Hours Square Footage 1000 6,900 4000 3,100 6,000 2000 For all requirements, round allocation ratios to four significant digits and round allocated costs to the nearest dollar. Required: Complete 1-5 below and all computations below must use cell references. 1. Calculate the allocation ratios for the departments using the direct method in the table provided below. Power Department General factory Department Pottery I Retail Power Department General factory Department 2. Using the direct method, allocate the costs of the Power Department and General Factory Department to the Pottery and Retail departments in the table provided below. Power Department $150,000 General factory Department $160,000 Pottery $98,000 Retail $56,000 Direct costs Allocate: Power Department General factory Department Total After Allocation 3. Determine the support department to allocate first, by ranking the support departments in order of the percentage of service provided to the other support department. 4. Develop a table with the allocation ratios for the departments using the sequential (step) method showing the support department first that provides the greater service to the other support department. 5. Using the sequential method, allocate the costs of the power department and general factory department to the pottery and retail departments in the table provided below. Power Department $150,000 General factory Department $160,000 Pottery $98,000 Retail $56,000 Direct costs Allocation: Total After Allocation Pottery Inc., is divided into 2 operating divisions: Pottery and Retail. The company allocates Power and General Factory department costs to each operating division. Power costs are allocated on the basis of the number of machine hours and general factory costs on the basis of square footage. Allocation for the coming year are based on the following data? Support Departments Power Department General factory Department $150,000 $160,000 Operating Divisions Pottery Retail $98,000 $56,000 Direct costs Normal Activity: Machine Hours Square Footage 1000 6,900 4000 3,100 6,000 2000 For all requirements, round allocation ratios to four significant digits and round allocated costs to the nearest dollar. Required: Complete 1-5 below and all computations below must use cell references. 1. Calculate the allocation ratios for the departments using the direct method in the table provided below. Power Department General factory Department Pottery I Retail Power Department General factory Department 2. Using the direct method, allocate the costs of the Power Department and General Factory Department to the Pottery and Retail departments in the table provided below. Power Department $150,000 General factory Department $160,000 Pottery $98,000 Retail $56,000 Direct costs Allocate: Power Department General factory Department Total After Allocation 3. Determine the support department to allocate first, by ranking the support departments in order of the percentage of service provided to the other support department. 4. Develop a table with the allocation ratios for the departments using the sequential (step) method showing the support department first that provides the greater service to the other support department. 5. Using the sequential method, allocate the costs of the power department and general factory department to the pottery and retail departments in the table provided below. Power Department $150,000 General factory Department $160,000 Pottery $98,000 Retail $56,000 Direct costs Allocation: Total After Allocation
