Allocate $45,000 of rent using square feet occupied \begin{tabular}{|l|l|l|l|} \hline & Square Feet & Percent of Total & Cost Allocated \\ \hline Housewares & & & \\ \hline Sporting & & & \\ \hline Total & & & \\ \hline \end{tabular} Allocate $25,000 of advertising using percentage of sales \begin{tabular}{|l|l|l|l|l|} \hline Housewares & \multicolumn{1}{|c|}{ Sales } & Percent of Total Cost Allocated \\ \hline Sporting & & & \\ \hline Allocale $10,000 of insurance using value of insured assets \\ \hline Housewares & Assets Insured & Percent of Total & Cost Allocated \\ \hline Sporting & & & \\ \hline Total & & & \\ \hline \end{tabular} Required information [The following information applies to the questions displayed below.] National Retail has two departments, Housewares and Sporting. Indirect expenses for the period follow. The company occupies 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. Allocate indirect expenses to the two departments. Rent expense is allocated based on square feet occupied. Advertising expense allocated based on total sales. Insurance expense is allocated based on the value of insured assets