From the course: Excel for Business Analysts

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Product pricing with business analytics

Product pricing with business analytics - Microsoft Excel Tutorial

From the course: Excel for Business Analysts

Start my 1-month free trial

Product pricing with business analytics

“

- [Instructor] There's more to being a good business analyst than just understanding how to gather data and put together a clean data set. Oftentimes, being a good business analyst means being able to model a complex business situation and then make recommendations to senior executives based on your analysis. I'm in the zero four zero six begin Excel spreadsheet. Now we have a scenario here where a firm is sort of in trouble. They've been losing money for the last six months. And while they've still got cash on hand, as they're doing their 2021 budget, it appears if things keep going the way they are, the firm will run out of cash by August, and then presumably have to shut down. So the firm needs to take decisive action in order to fix this problem. Now there's two key variables that they were thinking about. One of these key variables is marketing spend. The firm wants to spend an equal amount of money on marketing each…

Contents