Join Rudolph Rosenberg for an in-depth discussion in this video Allocating costs by category, part of Financial Analysis: Analyzing the Bottom Line with Excel.
…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.…
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