Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

B D M is planning a relocation and hopes the next location will have sufficient space for at least five to ten years. When determining

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'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.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'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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting Volume 1

Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield, Irene M. Wiecek, Bruce J. McConomy

13th Canadian Edition

1119740460, 978-1119740469

More Books

Students also viewed these Accounting questions

Question

5. Format and draft a research report

Answered: 1 week ago