课程: Excel: Creating Business Budgets
今天就开通帐号，24,600 门业界名师课程任您挑！
Calculating variable costs
- [Instructor] Calculating variable costs is one of the more complex parts of business budgeting, but with the right preparation, we can actually make this relatively easy. If you'd like to follow along with me, have my business budget variable open and navigate to the sales plan worksheet. Once the worksheet is open, have a look towards the bottom of the worksheet and you'll notice that there are two sections. The total product inputs per day and the total product input costs. Let's firstly have a look at the total product inputs per day. You'll notice in cell C42 that a formula has already been created. Let's select this formula bar at the very top of the screen and using the mouse, we will scroll up to have a look at what it's doing. It is multiplying the number of daily sales for each of our products by the inputs. In this particular case, the coffee beans. We want to copy and paste the cell across the rest of the table at the bottom. But before we do, we need some of these…
随堂练习，边学边练
下载课堂讲义。学练结合，紧跟进度，轻松巩固知识。
下载课程离线学习
下载课程到移动设备，轻松离线学习。在领英学习 iOS 或安卓版 APP 下载课程