• robert morgan -schneider downs & co., inc. • sr. manager, been with firm since 2008 ......
TRANSCRIPT
![Page 1: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/1.jpg)
www.solverglobal.com
![Page 2: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/2.jpg)
www.solverglobal.com
Leveraging BI360 for Effective Business Forecasting (WCS1)
![Page 3: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/3.jpg)
www.solverglobal.com
10:00AM – 11:00AM
8/21/2019
[email protected]@scheiderdowns.com
Neal Jennings, VP & CFO#1 Cochran Automotive Group
Robert Morgan, Sr. ManagerSchneider Downs & Co., Inc.
![Page 4: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/4.jpg)
www.solverglobal.com
Session Objectives
• Review why #1 Cochran Automotive Group selected BI360, and how BI360 was implemented as their budgeting and forecasting solution to better manage their 33 sites, 1,200 team members, and $950 million annual revenue.
• Discuss several scenarios that were implemented, focused on forecasting, budgeting, and corporate performance analysis.
• Discuss the technical integration aspects, as well as, the dynamic breadth of reporting elements available.
• Discuss the implementation methodology leveraged by Schneider Downs during the BI360 implementation.
![Page 5: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/5.jpg)
www.solverglobal.com
Session Agenda
• Introductions and Backgrounds• About #1 Cochran Automotive Group• Business Case for BI360 Forecasting• Annual Forecasting Timeline with BI360• Forecasting Steps at #1 Cochran (Demonstration)• Things to Think About (& Lessons Learned)• Leveraging a BI360 “Partner”• Implementation Methodology• Q&A
![Page 6: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/6.jpg)
www.solverglobal.com
Introductions and Backgrounds
• Neal Jennings - #1 Cochran Automotive Group• Vice President & CFO since August 2008• #1 Cochran Automotive Group ranked #71 in Top 150 (‘18 Automotive News)• Primary responsibilities include business development and acquisitions;
oversee financial administration, including accounting, forecasting, and financial reporting; and oversee information technology functions.
• Robert Morgan - Schneider Downs & Co., Inc.• Sr. Manager, been with firm since 2008• Schneider Downs is ranked #60 in Top 100 U.S. accounting firms (‘19
Accounting Today)• Offices in Pittsburgh, PA, Columbus, OH and Washington, D.C.• Solver partner since 2011
![Page 7: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/7.jpg)
www.solverglobal.com
#1 Cochran Automotive Group• Large Automotive Dealership Group (Ranked #71 in U.S.)• 23 Dealerships, 8 Collision Centers, Wholesale Parts Distribution• Centralized Accounting and Reporting• Privately Held (Rob Cochran, President & CEO)• 1200 Team Members• $950 Million Annual Revenue• Will Retail over 28,000 New and Preowned Vehicles in 2019
![Page 8: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/8.jpg)
www.solverglobal.com
Business Case For BI360 Forecasting
• Dealerships are Four Businesses in One; Tend to Silo Themselves.• New Vehicles• Used Vehicles • Service Department• Parts Department
• Analytical Culture. Historically forecasted at the department level.• Data Driven CEO. Healthy appetite for information.
![Page 9: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/9.jpg)
www.solverglobal.com
Business Case For BI360 Forecasting (Cont’d)
• Traditional Forecasting Process (100% in Excel)
Dealership Forecast Summaries = 23
23 Dealerships x 4 Departments = 92 Individual Forecasts
Collision Centers with Summaries = 8 Executive Summaries = 8
Total Forecasts Each Year = 131 (not very efficient!)
![Page 10: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/10.jpg)
www.solverglobal.com
Annual Forecast Timeline with BI360August• Design Changes
Considered• Draft New Forms &
Templates
September•Finalize Templates & Test
•Define Global Assumptions for Forecast Year
Early October• Forecast Launch
Meeting• Full day “Lock In”
Work Session• Teams of Accounting
and Ops.
Early November• Department Forecasts to
be reviewed/approved by Divisional Leaders
• Operational Signoff by Mid-November with Narrative “The Why”
December 1st
•Operational Forecast Due to CEO
•“Corporate” forecast by CFO Due to CEO with write up on assumptions for year
December 15th• Adjust for CEO Inputs
and Comments• Finalize by end of year
![Page 11: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/11.jpg)
www.solverglobal.com
Input Form Design (Interactive Demonstration)
• Highlighted the Areas to Enter in Yellow (Simplify)• Calculation cells are locked. No adaptations allowed.
• Global Assumptions in Blue (Accounting provides)• Forecast Drivers
• “If you know these few things, you can prepare a forecast”.
• Provide Historical/Relevant Data in the Same Template• Efficient, paperless.
• Provides Write Back Cells to Capture the Narrative• The “Why” or “Business Conditions” driving the forecast.
![Page 12: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/12.jpg)
www.solverglobal.com
Helpful BI360 Forecasting Features (Interactive)
• “Scenarios” to Compare Actual Versus Budget on One Page• Easy Access to Historical Data• Spreading a Fixed Annual Forecast Amount over 12 Months
• Can spread based on links to historical or forecast data.• Can easily increase the historical amount by a percentage.
• Can Summarize Across Spreadsheets• Can Capture Narrative Across Various Forecast Levels (Department Summaries, Store
Summaries, Executive Summaries, etc.)• Assigning GL Account Attributes to Forecast Data Allows for Efficient Rollup
• Example: Not forecasting 100 different GL accounts for office supplies, only the attribute of “Office Supplies”.
• Attributes assigned to both the actual GL accounts and the forecast GL accounts allow for efficient reporting.
• Can View BI360 Reports in an iOS App
![Page 13: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/13.jpg)
www.solverglobal.com
Dramatically Improved Reporting and Roll Up (Interactive Examples)
• Efficient Summaries and Reporting. No Need to Bring the “Novel”.• 2019 Plan Versus 2018 Expected Finish (Blend of Actual and Remaining
Forecast).• Multi Year Blend of Actual Plus Next Forecast Year.• Summary of Profit by…… (Anything that can be Dimensioned or Attributed)
• By Month• By Dealership• Department
• Ability to Show Multiple Forecast Scenarios and Compare/Contrast Versions.• Store Level Forecast• Corporate Forecast
![Page 14: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/14.jpg)
www.solverglobal.com
Things to Think About (& Lessons Learned)
• Plan out the attributes you want to report on and forecast in advance.• Think: “Levels of Reporting Detail”.
• Plan out how you want to store the data in the warehouse.• Typical Accounting Signage
• Positive Values – Assets, Expenses• Negative Values – Liabilities, Equity, Sales
• Do you want your forecast data to match accounting (or be 100% positive values). The decision affects how you design reports later on.
• Plan for any opportunity to forecast and store “subtotals” or roll up data. (example: Forecasting “Total Expenses”).
![Page 15: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/15.jpg)
www.solverglobal.com
Leveraging a BI360 “Partner”
• #1 Cochran worked with Schneider Downs (our CPA firm) in implementing BI360
• Very Effective Example of “Partnering”• SD led numerous white-boarding workshops. Excellent planning and mapping.• Worked with our I.T. folks to integrate our data warehouse.• Led training on report-building and developed several of the reporting concepts.• Our deadlines were their deadlines.
• Post-implementation Support was Innovative and Effective• Provided on-site BI360 support person.• Collaborated with us the right FTE to help us develop our B.I. capabilities.• Recruited, Hired and Trained the FTE and ultimately transitioned to #1 Cochran.
![Page 16: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/16.jpg)
www.solverglobal.com
Implementation Methodology: “People, Process, and Technology”• People
• Do they possess the skills necessary to be successful? • Accounting• Industry• Technical / Analytical
• What is their availability given current responsibilities?• Delegate work• Overtime• Temporary staff
• Once completed, how will their role/responsibilities change?• New responsibilities• Eliminate other responsibilities
• Designate a “champion” to lead the effort
![Page 17: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/17.jpg)
www.solverglobal.com
• Technology• What systems are being used that house the data?
• Inputs• Accounting software• Supporting operational software (internal and external)• Spreadsheets
• Outputs• Reporting/Visualization software (BI360, Power BI)• Spreadsheets, Email
• Document data elements in your current inventory of dashboards, reports, etc.
• Document new data elements needed
Implementation Methodology: “People, Process, and Technology”
![Page 18: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/18.jpg)
www.solverglobal.com
• Avoid the Technology Trap!• Purpose of technology is to support the
people and processes within the organization that use your data.
• Integration of all three makes or breaks the success of your project.
• People are first and Technology is last in this methodology for a reason.
• Don’t let perfection get in the way of progress.
Implementation Methodology: “People, Process, and Technology”
![Page 19: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/19.jpg)
www.solverglobal.com
• People• Improve productivity by eliminating manual
repetitive processes.• More time to focus on analysis of data and
decision making.• Involve more people within other areas of
the organization.
Benefits of “People, Process, and Technology” Methodology
![Page 20: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/20.jpg)
www.solverglobal.com
• Process• Improve timeliness of access to data by
eliminating duplication of effort.• Eliminate errors in results by reducing
human interaction with data.• Reduce monthly, quarterly and annual
reporting and forecasting cycles through gains in efficiencies.
Benefits of “People, Process, and Technology” Methodology
![Page 21: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/21.jpg)
www.solverglobal.com
• Technology• Reduce dependencies on internal/external
resources for development by investing in user-trainable tools.
• Integrate data from multiple sources by leveraging a data warehouse.
• Modern user interfaces designed for anytime self-service access.
Benefits of “People, Process, and Technology” Methodology
![Page 22: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/22.jpg)
www.solverglobal.com
• People• Evaluate resource skills, availability, and impact on roles and responsibilities.• Designate a “champion”.
• Process• Identify opportunities to change current processes.• Identify processes that need to remain unchanged.• Implement controls to ensure data integrity.
• Technology• Document systems to integrate and data elements.• Avoid the “Technology Trap”
Summary of “People, Process, and Technology” Methodology
![Page 23: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/23.jpg)
www.solverglobal.comwww.solverglobal.com
THANK YOU!• Neal Jennings, VP & CFO, #1 Cochran Automotive Group
• Robert Morgan, Sr. Manager, Schneider Downs & Co., Inc.• [email protected]
![Page 24: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/24.jpg)
www.solverglobal.com
Supplemental MaterialUsing Power BI with BI360 Data Warehouse to Visualize
Key Performance Indicators (KPIs)
![Page 25: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/25.jpg)
www.solverglobal.com
![Page 26: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/26.jpg)
www.solverglobal.com
Your feedback is valuable:
![Page 27: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/27.jpg)
www.solverglobal.com
Your feedback is valuable:
![Page 28: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/28.jpg)
www.solverglobal.com
Your feedback is valuable:
![Page 29: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/29.jpg)
www.solverglobal.com
Your feedback is valuable:
![Page 30: • Robert Morgan -Schneider Downs & Co., Inc. • Sr. Manager, been with firm since 2008 ... • Plan out the attributes you want to report on and forecast in advance. • Think:](https://reader034.vdocuments.us/reader034/viewer/2022050222/5f6806f1b7b9da275217c0be/html5/thumbnails/30.jpg)
www.solverglobal.com
Your feedback is valuable: