Overview Up until now your company has been collecting and reporting indirect costs as "total administrative cost". You decide that it would be helpful to allocate these costs by department in order to prepare departmental income statements. Use the following square footage measurements to allocate $900 of utilities and $1,100 of maintenance costs to each department: Assembly department, 1,500 square feet - Shipping department, 500 square feet If you want to make the task more challenging by using your own dollar amounts and/or square footage for the allocation. Instructions You may use the Excel template as a guide or to complete to the assignment; however, use of the template is not required. 1. Determine the percentage of square feet taken up by the Assembly department and the Shipping department. 2. Allocate $900 of utilities costs and $1,100 of maintenance costs to each department based on each department's usage of square feet. 3. Calculate the total indirect costs for each department. departmental income statements. ions ch om O Use the following square footage measurements to allocate $900 of utilities and $1.100 of maintenance costs to each department: Assembly department, 1,500 square feet Shipping department, 500 square feet If you want to make the task more challenging by using your own dollar amounts and/or square footage for the allocation. Instructions You may use the Excel template as a guide or to complete to the assignment; however, use of the template is not required. 1. Determine the percentage of square feet taken up by the Assembly department and the Shipping department. 2. Allocate $900 of utilities costs and $1,100 of maintenance costs to each department based on each department's usage of square feet. 3. Calculate the total indirect costs for each department. Task 11: Indirect Cost Allocation Prepared By: Allocate the $900 of utilities and $1,100 of maintenance costs to the assembly and shipping departments based on square feet. % of square Utilities Maintenance Total Indirect feet $1,100 Assembly Department 1,500 sq. ft. $ Shipping Department 500 sq.ft. Total $900 costs $ $ S