Join Rudolph Rosenberg for an in-depth discussion in this video Adding standard costs to your revenue database, part of Financial Analysis: Analyzing the Bottom Line with Excel.
…Now that we have determined what our standard costs for…each product are, we can do something very powerful which is to merge it…with our revenue database seen in the previous chapter.…The benefit for us will be to have in a single data set and…therefore pivot table, all of our revenue and gross margin information.…This can become our unique source of data for all our analysis needs.…Let's do that together now.…Let's start with our standard costs and open as well our revenue database.…
For the revenue database,…I am using the last exercise file from the previous chapter, which for…your convenience I have copied in the exercise file folder of this video.…So let's go back to our revenue database.…So if you recall, in this revenue database, we have on…every line a single product, whether that's three or four lines per invoice.…But each line separately will represent the revenue that we have generated for…each of our products.…What we want to do here is take the standard costs that we have calculated,…and bring them back into this table and put them on every single line.…
Also check out the companion course, Financial Analysis: Analyzing the Top Line with Excel.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Finding data points
- Prepping data
- Calculating standard cost and gross margins
- Analyzing overall gross margin performance
- Analyzing individual and overall expenses