From the course: Excel: Creating Business Budgets
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Calculating variable costs - Microsoft Excel Tutorial
From the course: Excel: Creating Business Budgets
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.