Residential Construction Permits Research Project
The owner is trying to decide whether to change business models to generate more revenue; the company primarily works on non-residential construction projects, but is interested in expanding into residential markets.
How to Proceed
Part 1 – Excel
Your supervisor has asked you to research demand and profitability indicators to decide if this idea is worth considering. Is it more profitable to remain in non-residential construction, or are there missed opportunities in residential construction?
Using the City of Winnipeg’s open data website (use aggregate data), you will compare the frequency (#) and total value ($) of residential construction permits vs non-residential permits that have been issued in the following neighborhoods between the years 2015 to 2020:
- The Forks
- Tuxedo
- Waverley Heights
- West Broadway
Transfer the relevant data into an Excel spreadsheet, and ensure you:
- Download the raw data into a separate worksheet and use your name_raw in the label
- Sort the relevant data using a structured table and format it into a table of your choice.
- Use accounting format with zero decimal places.
- Create properly formatted title and table elements on a separate worksheet with your name_table in the label.
- Insert at least one mathematical/statistical function(s) into the spreadsheet.
- Create a chart or graph of your choice to help visualize your information on a separate worksheet with your name_graph in the label.
- Save as: Firstname_Lastname_Project.xlsx
Part 2 – Word
Your report will contain a total of 5 pages (title page, report pages (2 pages), flyer page, bibliography page).
Report layout:
- 12-point Calibri font, double spaced in Portrait orientation.
- Insert a left footer displaying your name (FirstName LastName) on all pages except on title page and flyer page.
- Insert a right footer (on the same line and left footer) displaying page numbers on all pages except the title page and flyer page.
- Apply narrow margins
Report content:
- Create a logo for Claw Construction to use throughout your document
- Use Office 365 to create a logo of your own design
- Create a title page (Using Word function) for your report (include your new logo)
- Create a report page which includes these three elements:
- An introductory paragraph (150-200 words) describing the problem you are trying to solve, and a summary of your research citing one at least one reference (using the reference function in APA)
- One table and one chart from your Excel file
- Conclusion paragraph with your recommendation(s)
- Create a marketing flyer (include your new logo) that targets residential construction using at least four layout/design techniques found in Word Module 4: Enhancing Page Layout and Design on a separate page in Landscape (for this page only) and no footer.
- Create a bibliography page using the Word function in APA style on the last page.
- Save as: Firstname_Lastname_Project.docx