课程: Excel: Creating Business Budgets

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Understanding revenue drivers

Understanding revenue drivers - Microsoft Excel教程

课程: Excel: Creating Business Budgets

开始一个月试用 购买团队方案

Understanding revenue drivers

“

- [Narrator] When building a business budget model, it's important that we understand the drivers of revenue. By this we mean, what products or services will we sell, and how many? If you'd like to follow along with me, have my business budget REV inputs open, and navigate to the sales plan worksheet. Once you have this worksheet open, you'll notice that there are two sections: days per month, and the sales amount. This first section here, days per month, is used to identify the number of days in each month that the business will be operating. This is really important as it can help with planning the volume of sales. In cell C7, what you'll notice is a formula has already been pre-populated, and this formula tells us the number of working days in that particular month. In this case, there are 23 business days in the month July 2020. We're going to assume that this business will be open Monday to Friday, with the exception of public holidays. What we can easily do at this point is…

内容