To Receive CPE Credit Participate in entire webinar Answer - - PDF document

▶
to receive cpe credit
SMART_READER_LITE
LIVE PREVIEW

To Receive CPE Credit Participate in entire webinar Answer - - PDF document

Feb 01, 2023 331 likes •523 views

Planning for the Future with BI360 Charles Allen Senior Managing Consultant BKD Technologies August 10, 2017 callen@bkd.com To Receive CPE Credit Participate in entire webinar Answer attendance checks & polls when they are

slide-1
SLIDE 1

1

Planning for the Future with BI360

Charles Allen

Senior Managing Consultant BKD Technologies callen@bkd.com August 10, 2017

To Receive CPE Credit

  • Participate in entire webinar
  • Answer attendance checks & polls when they are provided
  • If you are viewing this webinar in a group
  • Complete group attendance form with
  • Title & date of live webinar
  • Your company name
  • Your printed name, signature & email address
  • All group attendance sheets must be submitted to

training@bkd.com within 24 hours of live webinar

  • Answer attendance checks & polls when they are provided
  • If all eligibility requirements are met, each participant will

be emailed their CPE certificates within 15 business days of live webinar

slide-2
SLIDE 2

2

Introduction

Charles Allen

  • Senior managing consultant
  • More than 27 years of experience
  • Microsoft MVP

Agenda

  • Introduction
  • What Is a Budget?
  • Introduction to Solver BI360
  • Creating a Financial Budget
  • Entering Data into a Budget
  • Reporting Actual vs. Budget
  • Q&A
slide-3
SLIDE 3

3

What Is a Budget?

 Itemized summary of income & expenses for a given period?(1)  Way for organization to plan & manage its spending?  A real pain!

(1) personalfinance.duke.edu/manage-your-finances/budget/overview

slide-4
SLIDE 4

4

A Plan, Mechanism & Estimate

  • Plan for 1 to 10 years for all of company’s business

units

  • Mechanism for coordinating production & sales
  • An estimate, when compared to actual results, as a

way to evaluate performance

MIT Sloan School of Management Budget Presentation

Budget Approaches

Top-Down

  • Upper-level management establishes general or specific budget

guidelines or amounts

Bottom-Up

  • Lower-level employees set their budget amounts. These budgets are

prepared & submitted for approval by upper-level management

Blended

  • Combines top-down & bottom-up processes

Budgeting: Planning for Success (Christopher J. Skousen/Larry M. Walther)

slide-5
SLIDE 5

5

Budget Types

Line Item Budgets

  • Individual financial statement items are grouped by cost centers or departments(1)

Lapsing Budget

  • Business units must return unspent funds(2)

Flexible Budget

  • Adjusts or flexes for changes in volume of activity(3)

Zero-Based Budgets

  • All expenses must be justified for period(4)

Incremental Budgets

  • Uses previous period’s budget or actual results as a basis(5)

(1)BusinessDictionary.com, (2)Chron.com – What is a Budget Lapsing Organization?, (3)AccountingCoach – What is a flexible budget? (4)Zero-Based Budgeting – Investopedia, (5)Budgeting Methods – Incremental Budgeting | tutor2u Business

slide-6
SLIDE 6

6

Solver is an award-winning, global provider of self-service corporate performance management (CPM) software

  • Close to 2,000 customers in 40+ countries
  • Offices in U.S., Canada, EMEA, Asia, India & Latin America
  • Fast company & channel growth
  • GPUG member & sponsor

WHAT IT DOES

  • Leverages your existing Excel knowledge in

combination with modern web portal

  • Centralizes & streamlines your budgeting,

reporting & analysis into a single solution

  • Eliminates need to ask IT for assistance to

manage your BI solution

SOLVES PAIN POINTS

  • Lack of insight into overall business

performance

  • Manual processes that can lead to poor data

integrity

  • Difficulty integrating disparate data sources &

tools

slide-7
SLIDE 7

7

CLOUD FACTS

  • A true multitenant cloud solution
  • HTML5 web interface
  • Powerful data integration (ETL) with prebuilt & user-

definable connectors

  • Microsoft Azure public cloud platform

Payroll or CRM Payroll or CRM

GP GP eoStar or

  • ther data

eoStar or

  • ther data

OVERVIEW

DATA WAREHOUSE DATA WAREHOUSE REPORTING REPORTING BUDGETING BUDGETING DASHBOARDS DASHBOARDS

slide-8
SLIDE 8

8

MODULES SUMMARY

  • REPORTING: Design templates in Excel with real-

time connections to ERP & CRM systems

  • BUDGETING: Automate budgeting & forecasting
  • DASHBOARD: Graphically visualize critical

performance data

  • DATA WAREHOUSE: Aggregates disparate data &

facilitates enterprise reporting & budgeting

  • WEB PORTAL: Single, easy-to-access end-user

interface

slide-9
SLIDE 9

9

Designing a Budget Template

Design template using Report Designer Configure data settings in Admin Panel Configure interface settings in Admin Panel (optional) Input data into proper cells Save data back to data warehouse

BI360 Planning Training Guide

Data & Interface Settings

  • Data Settings – Determine what data from template

will be stored & to where

  • Interface Settings – Adds additional elements such as

line item details, charts & actual data for comparison

slide-10
SLIDE 10

10

Designing a Template Designing a Template

slide-11
SLIDE 11

11

Designing a Template

Entering Data into a Budget

slide-12
SLIDE 12

12

Entering Data into a Budget

There are two options

  • 1. Using Excel
  • 2. Using BI360 Web Portal

Entering Data into a Budget

Options when entering data into budget  Enter amounts in input cells  Enter line item details  Use charts to view effects  Use spreading  See actual data for comparison

slide-13
SLIDE 13

13

Entering Budget Data Using Excel Entering Budget Data in Excel

What else can you do?  Highlight rows that have line item details  Publish worksheets to Word  Publish worksheets to PowerPoint

slide-14
SLIDE 14

14

Entering Budget Data Using Portal Entering Budget Data Using Portal

slide-15
SLIDE 15

15

Reporting Actual vs. Budget

Reporting Actual vs. Budget

Pull actual results into data warehouse Design report using BI360 Run report Optional – Publish report to web portal for viewing Optional – Publish report via email or to folder or (gasp!) printer

slide-16
SLIDE 16

16

Questions BKD Technologies Support Center

  • Microsoft Dynamics GP – 877.253.7778

GPsupport@bkd.com

  • Monday through Friday, 8 a.m.–5 p.m.

Call Support Center toll-free

slide-17
SLIDE 17

17

Stay Connected

Follow us on Twitter Join us

  • n

LinkedIn dynamicsGPinsights.com

At Dynamics GP Insights, you can read articles, watch webinars & join conversations

View videos on YouTube The information contained in these slides is presented by professionals for your information only. Applying specific information to your situation requires careful consideration of facts & circumstances. Consult your BKD advisor before acting on any matters covered herein or in these seminars. BKD, LLP is registered with the National Association of State Boards

  • f Accountancy (NASBA) as a sponsor of continuing professional

education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Continuing Professional Education (CPE) Credits

slide-18
SLIDE 18

18

CPE Credit

  • CPE credit may be awarded upon verification of

participant attendance

  • For questions, concerns or comments regarding CPE

credit, please email the BKD Learning & Development Department at training@bkd.com

Charles Allen | Senior Managing Consultant | 713.499.4629 | callen@bkd.com