A metaller pays $130,000 rent each year for its two-stary building. Space in this boidding is occupled by five departments as shown here Check Answers Legend Grided cell: bea needed. The company allocates 584,500 of tocal rent expense to the firs floor and $45,500 to the second floor it then allocates rent expense for each floor to the departments on that floor based on square feet occupied. Required: Oetermine the rent erpense to be allocated to each department. (Use cells AZ to 115 from the given information to complete this question.) A retailer pays $130,000 rent each year for its two-story building. Space in this building is occupled by five departments as shown here. \begin{tabular}{|l|} \hline Total rent \\ First floor rent \\ \hline Second floor rent \\ \hline \end{tabular} The company allocates $84,500 of total rent expense to the first floor and 545,500 to the second floor, it then allocates rent expense for each floor to the departments on that floor based on square feet occupied. Required: Determine the rent expense to be allocated to each department (Use cells A2 to 115 from the given information to complete this question.)