in excel please

A retailer pays $150,000 rent each year for its two-story building. Space in this building is occupied by five departments as shown here. Ine company allocates $105,000 of total rent expense to the first floor and $45,000 to the second floor. It then allocates rent expense for each floor to the departments on that floor hased on square feet occupied. Determine the rent expense to be allocated to each department. Required: Determine the rent expense to be allocated to each department