PLEASE MAKE SURE THE ANSWER IS ON A TABLE (JUST LIKE THE ONE SHOWN ON THE PROBLEM)

A retailer pays $130,000 rent each year for its two-story building. Space in this building is occupied by five departments as shown here. Department Jewelry Cosmetics Square feet occupied 1,410 (first-floor) 3,290 (first-floor) Department Housewares Tools Shoes Square feet occupied 2,115 (second-floor) 940 (second-floor) 1,645 (second-floor) The company allocates $84,500 of total rent expense to the first 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. Determine the rent expense to be allocated to each department. Allocate these portions of total rent expense across the departments occupying each floor. First Floor Sq. Feet Percent of Total Cost Allocated Jewelry Dept. % Cosmetics Dept. % Totals 0 0 % $ 0 Second Floor Sq. Feet Percent of Total Cost Allocated Housewares Dept. % Tools Dept. % Shoes Dept. % Totals o 0 % $