In this video, the instructor discusses using Excel to forecast employee behavior and financial performance.
- [Narrator] We've got an emergency.…Jack has just discovered some suspicious cash shortages…at a company outlet store.…He was in the process of beginning his sales forecasting…when he discovered we've got some missing cash.…In fact, theft and cash handling are major issues…at many firms, so Jack is not alone here.…But, the key question he's coming up with is…could an employee be stealing from the firm?…Let's find out.…I'm in the 03_02 folder in the file labeled…Begin_EmployeeTheft.…
What we've done is gone through and gathered data…that Jack put together for us that covers various…cash shortages that have occurred over the last year.…And, in fact, Jack has found 41 days over the last year…where there was either a cash shortage or a cash overage.…There are eight different employees and three different…managers who work in this particular outlet store.…What we need to figure out is…are one or more of these people stealing from the company?…Even if we don't think they're stealing,…perhaps it's just careless cash handling,…
Join Professor Michael McDonald and discover how to use predictive analytics to forecast key performance indicators of interest, such as quarterly sales, projected cash flow, or even optimized product pricing. All you need is Microsoft Excel. Michael uses the built-in formulas, functions, and calculations to perform regression analysis, calculate confidence intervals, and stress test your results. You'll walk away from the course able to immediately begin creating forecasts for your own business needs.
- List the two methods of making decisions.
- Identify the most common method of conventional financial forecasting.
- Describe common challenges that come when trying to merge data.
- Assess the types of questions that business intelligence is best suited to answer.
- Distinguish the statistic that is most useful for estimating the impact of an X variable on a Y variable.