$BDM$ is planning a relocation and hopes the next location will have sufficient space for at least five to ten years. When determining what real estate option is best for a company, it is sometimes a good idea to project the organization's growth. The real estate company that BDM has hired has requested information about the company's space requirements for the next five years. You have been asked to create a workbook that shows this projected growth. Following the instructions on page $30$ and $31,$ use MS Excel to create a user$-$friendly document that the agent can refer to when considering real estate options. The memo with detailed instructions from Jordan Runnalls, is on pages $163-165.$

NOTE:

For "Staff Growth", there are currently $50$ employees. You will calculate staff growth, office space, and lease costs for the next five years $(2025$ to $2029).$

The "Requirements" worksheet is a separate worksheet with the requirements listed. You will add the comparison data once you are assigned Task $6.$

Ensure all formatting and formulas are appropriately used in the tables.

The following are changes from the textbook:

You do not need to center the worksheet vertically and horizontally.

The third column for each item should be increased per year.

Add a documentation worksheet to the beginning of your workbook which identifies your name, the date, and the purpose of the workbook.

Instructions for the projection table prepare a number of tables that will help to project the companies space requirements in five years. In order to assist BDM in relocating an additional table of data needs to be created for the real estate agent to find a suitable location the Director of human resources and administration has provided you with the information you require in the memorandum. use spreadsheet software to prepare three tables for staff growth, office space and lease cost for a new office space beginning in January for next year. Place each table in a separate work sheet within the same workbook use absolute cell reference for the projections used borders fill in different fonts to improve the look of your table use a comma separate or where appropriate numbers will have two digits after the decimal centre each of the column headings centre each spreadsheet vertically and horizontally rename the tables appropriately use all caps for the titles and centre apply gridlines. Prepare a table for the real estate agent Sergio Ortega that will indicate BDM$\text{'}$s requirements for a new location input the office space and lease cost values calculated into requirements table by using a five$-$year projections BDM knish sure it will not grow the new space for lease has expired add in one other requirement needed for the new facility and create a table that is user$-$friendly for the real estate agent.

Staff Growth: the column headings are year, number of employees, increase, and projected yearly number of employees. There are currently $50$ employees in this number will remain the same for $2025$ calculate the projections for five years for the year $2025$ to $2029$ the projection is a $4\%$ employee increase per year.

Office Space: the column headings are year, number of employees, square footage, and projected yearly square footage calculate the projections for five years from years $2025$ to $2029$ the projection is $300ft.{?}^2$ per employee.

Lease Cost: the column headings are year, lease cost, increase, and projected yearly lease cost calculate the projections for five years $2025$ to $2029\mathrm{.}160,000$ for $2025$ has been allocated the projection cost is an increase of $3\%$ annually.

Requirements Table: our real estate agent has requested BDM$\text{'}$s company requirements to find an appropriate new BDM location following are the requirements that are needed to be put into a table. The date is January $1,2025,$ the term is five$-$year minimum, office space square footage per employee, board room, kitchen, washroom facilities, five training rooms with a $50-$student capacity, lease cost first right of renewal clause, include the title and the corporate logo$.$