Excel McGraw Hill Excel Question - Saved Search (Option + Q) File Home Draw Insert Formulas Data Review View Help Editing www Calibri A1 A B C D E BIE&A Merge General Xfx Accessibility tab summary: Information about the building is presented in rows 2 to 15 and cells G3 to 15. A statement of requirement i H J K L F G 1 2 3 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. 4 S Department Square feet occupied Total rent First floor rent Second floor rent $130,000 $84,500 $45,500 6 Jewelry 7 Cosmetics 8 9 Department 10 11 Tools Housewares 12 Shoes 13 1,440 (first-floor) 3,360 (first-floor) Square feet occupied 2,016 (second-floor) 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 floor. It then allocates rent 15 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 24 Cosmetics Department 25 Totals 26 Second Floor 27 Housewares Department 28 Tools Department 29 Shoes Department 30 Totals 31 Square Feet Percent of Total Cost Allocated Square Feet Percent of Total Cost Allocated + 32 33 Graded Worksheet Calculation Mode Automatic Workbook Statistic