Due soon please help!!

Required Information Problem 24-2A (Algo) Allocation of indirect expenses to departments LO P2 (The following information applies to the questions displayed below.) National Retail has two departments, Housewares and Sporting. Indirect expenses for the period follow. Rent Advertising Insurance Total $ 45,000 25,000 10,000 $ 80,000 The company occuples 4,000 square feet of a rented building. In prior periods, the company divided the $80,000 of Indirect expenses by 4,000 square feet to find an average cost of $20 per square foot, and then allocated indirect expenses to each department based on the square feet it occupied. The company now wants to allocate Indirect expenses using the allocation bases shown below. Value of Insured Department Square Feet Sales Assets Housewares 1,760 $ 290,000 $ 51,000 Sporting 2,240 210,000 49,000 Total 4,000 $ 500,000 $ 100,000 Problem 24-2A (Algo) Part 1 Required: 1. Allocate indirect expenses to the two departments using the allocation method used in prior periods. Square Footago Rate Total Department Housewares Sporting $ Oo $ 2. Allocate Indirect expenses to the two departments. Rent expense is allocated based on square feet occupled. Advertising expense is allocated based on total sales. Insurance expense Is allocated based on the value of Insured assets. Allocate $45,000 of rent using square foot occupied Square Footage Percent of Total Cost Allocated Housewares Sporting Total 0 0% $ 0 Allocate $25,000 of advertising using percentage of sales Sales Percent of Total Cost Allocated Housewares Sporting Total $ 0 0% S 0 Allocate $10,000 of insurance using value of insured assots Assets Insured Percent of Total Cost Allocated Housewares Sporting Total $ 0 0% $ 0