An office complex has the following operating expenses in year one

janitorial$10,500

insurance$12,900

maintenance$13,025

property taxes$13,651

landscaping$6,248

The following tenants have agreed to reimburse for CAM expenses according to the following lease terms

Office 1 (5,200 sq ft)Up to$2.50 psf

Office 2(4,300 sq ft)Up to$2.65 psf

Office 3(4,100 sq ft)Up to $2.90 psf

Office 4(2,800 sq ft)Up to $3.25 psf

Deli (2,200 sq ft)Up to $1.25 psf

Please show work and use excel if possible

1) What is the Op Ex for year one?

2) What will each tenant reimburse in year one?

3) At the end of year one, what will be the unreimbursed amount?