课程: Excel: Creating Business Budgets
今天就开通帐号，24,600 门业界名师课程任您挑！
How sales impact variable costs - Microsoft Excel教程
课程: Excel: Creating Business Budgets
How sales impact variable costs
- [Instructor] Understanding the relationship between product sales and variable costs is one of the most important parts of business budgeting. So let's take the time to understand it using a case study. If you'd like to follow along with me, have my business budget relationship open and navigate to the sales plan worksheet. Once you have this worksheet open, what you'll notice are the estimated number of daily sales in each month, and that appears in rows 14 to 17 here. However, as you can imagine, as the cafe sells more or less coffee, the volume of inputs required to produce those products will change, so let's go ahead and build the relationship between product sales and variable costs. In cell B27, you're asked to include the inputs. What we need to include here are the variable expense categories. To find them, let's go to the expense types worksheet, and you'll notice that we have already created them. Let's select cells B11 through to cell B14. Control C or copy on the…
随堂练习，边学边练
下载课堂讲义。学练结合，紧跟进度，轻松巩固知识。
下载课程离线学习
下载课程到移动设备，轻松离线学习。在领英学习 iOS 或安卓版 APP 下载课程