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
Skill Level Intermediate
1. Analyzing Gross Margin
2. Analyzing Operating Expenses
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.