File Home Insert Draw Formulas Data Review View Help 25 X Calibri 11 ' Paste BI U Dab A ab Wrap Text Merge & Center Numb % M Undo Clipboard Font Alignment D27 X fx A B C E F 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. 1 2 3 4 5 Department 6 Jewelry 7 Cosmetics 8 9 Department 10 Housewares Square feet occupied 1,440 (first-floor) 3,360 (first-floor) Square feet occupied 2,016 (second-floor) 11 Tools 12 Shoes 13 960 (second-floor) 1,824 (second-floor) 14 The company allocates $84,500 of total rent expense to the first floor and $45,500 to the second floo 15 rent expense for each floor to the departments on that floor based on square feet occupied. 16 17 Required: 18 Determine the rent expense to be allocated to each department. 19 20 (Use cells A2 to 115 from the given information to complete this question.) 21 22 First Floor 23 Jewelry Department Square Feet Percent of Total Cost Allocated 1,440 30.0% 24 Cosmetics Department 3,360 70.0% 25 Totals 4,800 100.0% 26 27 Second Floor Housewares Department 28 Tools Department 29 Shoes Department 30 Totals 31 Square Feet Percent of Total Cost Allocated 2,016 42.0% 960 20.0% 1,824 38.0% 4,800 100.0% 32 33