Live Case – Project

Visualize and Improve Inventory Management using Finance, Accounting, and Inventory Data

A Collaboration Between

Project Synopsis

The Habitat for Humanity ReStore at Rockford is looking to students to visualize inventory movement using POS and other data and make recommendations for improving inventory and marketing effectiveness based upon the results of their analysis.

 

Project Topics

Account Management

Data Management

Marketing

Operations

Reporting, Financial Planning & Analysis

Company Information

CompanyRockford Area Habitat for Humanity
HQLoves Park, Illinois
RevenueUnlisted
Employees25-50
StageSmall Business
Hiring PotentialN/A
Websitehttps://rockfordhabitat.org

Company Overview

Rockford Area Habitat for Humanity is dedicated to building homes, neighborhoods, and lives through improved housing opportunity. We build simple, decent, affordable homes to be sold to families currently living in substandard housing. Rockford Habitat is for families who are ready to make a life-changing commitment to become homeowners. Families are selected on the basis of need for adequate housing, ability to make mortgage payments, and willingness to become partners in the program.

Experiential Learning Program Details

SchoolNorthern Illinois University (NIU)
Engagement FormatLive Case - Think "Hackathon" or Case Competition with a whole class of students! This learning format allows educators to deliver experiential learning to students at scale. Students are often split into groups to work on a live case (or a series of cases) from a real host company that directly relates to key learning objectives.
CourseBusiness in Action, Spring 2021 (Collum)
LevelUndergraduate
Students Enrolled68
Meeting Day & TimeJacie: Online, Mondays & Wednesday 3:30 - 4:45 PM CT
Student Time Commitment4-7 Hours Per Week
Company Time Commitment2 Hours
Duration9.57 Weeks

Program Timeline

Touchpoints & Assignments Due Date Type
Projects Revealed

Projects Revealed

Students select their preferred project
February 1st, 2021 Event na
Submit Project Preferences

Submit Project Preferences

We'll use this to assign teams and add you to projects: https://niu.az1.qualtrics.com/jfe/form/SV_3Cv9ceINbu3D36e  
February 1st, 2021 Event na
Project Kickoff Survey Due

Project Kickoff Survey Due

February 12th, 2021 Event na
Project Launch

Project Launch

Keri, Project Champion from Habitat for Humanity, will web conference into class to launch the projects. She will introduce herself, share about her background and introduce you to Habitat for Humanity of Rockford and their ReStore.  Be prepared to listen and to ask questions about the company and/or your project.
February 15th, 2021 Event na
Milestone Deliverable 1 Due Milestone Deliverable 1 Due
Please upload your deliverable using the link above
February 24th, 2021 Submission Required submission-required
Milestone Deliverable 2 Due Milestone Deliverable 2 Due
Please upload your deliverable using the link above
March 10th, 2021 Submission Required submission-required
Complete Temperature Check Survey #1

Complete Temperature Check Survey #1

March 14th, 2021 Event na
Project Check-In

Project Check-In

Keri, Project Champion from Habitat for Humanity, to web conference into class to launch the projects. Expect to dedicate 1-hour per section. Flexible to move this to around. Ideally between second and third deliverable
March 22nd, 2021 Event na
Milestone Deliverable 3 Due Milestone Deliverable 3 Due
Please upload your deliverable using the link above
March 29th, 2021 Submission Required submission-required
Complete Temperature Check Survey #2

Complete Temperature Check Survey #2

April 4th, 2021 Event na
Final Presentations (Please Upload) Final Presentations (Please Upload)
Keri, Project Champion from Habitat for Humanity to web conference (or visit) class to hear final presentations and provide feedback.
April 21st, 2021 Submission Required submission-required
End of Term SELF Evaluation Due

End of Term SELF Evaluation Due

April 25th, 2021 Event na
End of Term PEER Evaluation Due

End of Term PEER Evaluation Due

April 25th, 2021 Event na

Key Project Milestones

  • February 22, 2021 - Deep Dive into Habitat for Humanity & ReStore

    • What is Habitat for Humanity?
    • How is it run? How does the affiliate network operate?
    • What is the ReStore? How does it relate to Habitat for Humanity?
    • Review Habitat.org (umbrella agency)
    • Review RockfordHabitat.org (local org / project partner)
    • Review Internal Communication Network / Intranet “My Habitat”
      • See Attachments for Login Credentials!
    • Bonus: Go visit the Rockford ReStore
      • Attend: ReStore Orientation, Retore 101 Course

    Suggested Deliverable:

    Prepare an in-class presentation on your understanding of Habitat for Humanity and the ReStore Model

  • March 10, 2021 - Financial Data Analysis

    Delineate between accounting systems of non-profit versus a traditional retail store:

    • What are the key differences between accounting systems of non-profit versus a traditional retail store?
    • What financial data is tracked?
    • What are the key differences in the financial reports?
    • Key performance indicators and metrics for tracking and measuring performance?
    • Review financial statement exports from QuickBooks

    Conduct a financial deep dive:

    • What are the sources of revenue and expenses?
    • What trends can you identify in sales?
    • How is inventory categorized?
    • inventory revenue?
    • patterns in inventory flow (e.g. turnover)?

    Suggested Deliverable:

    Develop a report based on your new understanding of Rockford Habitat for Humanity’s Financial Statements and Inventory Deep Dive

  • March 26, 2021 - Analyze and Visualize Inventory and Other Financial Trends

    • Which inventory segments have the highest value per transaction sales?
    • Which product categories are repeat customers buying from?
    • How quickly does inventory move in each of the product categories?
    • Using an agreed upon set of KPI’s, what are the top 5 performing categories?
    • What other financial trends do you see? How can you help to visualize those?

    Suggested Deliverable:

    Develop a report and visualization on inventory flow

  • April 12, 2021 - Create a Plan for Adding Value to ReStore Marketing Campaigns to Customers and Donors

    How can the results from the analysis be used to optimize inventory decision-making, such as:

    • allocating showroom floor space (square footage) to higher performing goods?
    • informing customer segmentation and marketing strategies?
    • meeting the needs of customers and improve customer service?

    Suggested Deliverable:

    Develop an inventory optimization report and plan to use this data to help improve customer service, customer retention, donor relationships, and inventory management

Project Resources

There are no resources currently available

Industry Mentors

Company Admin

Keri Asevedo

[email protected]

Academic Mentors

Instructor

 

[email protected]

Assigned Students

Student

Ariel Nash 

[email protected]

Student

Robert Little 

[email protected]

Student

Christy Coronel 

[email protected]

Student

Clancy Anderson 

[email protected]

Student

Johnathan Cato 

[email protected]

Student

Nuam S Kim 

[email protected]

Student

Joe Jackson

[email protected]

Student

Ta’Lyn 

[email protected]