From the course: Financial Analysis: Analyzing the Bottom Line with Excel
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Allocating costs by category - Microsoft Excel Tutorial
From the course: Financial Analysis: Analyzing the Bottom Line with Excel
Allocating costs by category
Now that we have our source of data for our cost of production, we need to do the final step in order to have standard costs for each of our products. If you remember, standard costs, as defined in this course, is the average cost of production of a single product over a certain period of time. For example, it would be the average cost of production of the ultra thin pen over 2013. Let's look at a complete example and use the methodology and Excel table I use to do such an allocation.
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.
Contents
-
-
-
The basics of gross margin analysis3m
-
Finding the data points6m 9s
-
Preparing the data3m 50s
-
Categorizing expenditures3m 48s
-
Allocating costs by category33s
-
Calculating standard costs13m 42s
-
Using standard costs to calculate gross margin2m 30s
-
Adding standard costs to your revenue database4m 39s
-
Calculating gross margin9m 12s
-
Performing a price/mix analysis5m 32s
-
Analyzing overall gross margin performance5m 57s
-
The gross margin percentage levers4m 33s
-
-
-