Another great tool at your disposal…is to have a financial plan or even forecast…done at the product level.…One of the reasons is that you can use it…as a goal for you to reach on each of the product…or family of family of product you're selling.…Another great reason is that most of the time…products have a different gross margin profile…which means that some products…are more profitable than others.…Sometimes even companies sacrifice…most or all of their margin on a certain product…and use it as a way to attract new customers…with the objective of then…selling them more profitable products.…
Since products have a different gross margin profile,…that means that any change in performance…on a given products will influence…the profitability of your company.…If you generate as much revenue this year as last year…but do it by selling products that are less profitable,…you will end up making less money.…Let's talk briefly about how to prepare…a product level projection…since it is done on a revenue basis,…but we'll get most of the benefit…
Author
Released
9/9/2014- Distinguish between forecasting and planning.
- Recall the pros and cons of bottom-up projection.
- Explain how a finance manager can utilize a sales pipeline in business projections.
- Describe how a company can forecast its gross margin by product.
- Identify the pros and cons of using top-down projection.
- Recognize how business plans utilize forecasts.
- Summarize how to develop a set of worst-case scenarios.
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2013 Essential Training
with Dennis Taylor6h 32m Intermediate
-
Introduction
-
Welcome42s
-
-
1. Financial Projection Basics
-
Financial projections1m 34s
-
-
2. Estimating Volumes, Price, and Revenue
-
Revenue projection basics1m 46s
-
Preparing past P&Ls3m 40s
-
Market-driven forecasting2m 46s
-
-
3. Estimating Cost of Production and Margin
-
4. Estimating Operating Expenses
-
Projecting fixed OPEX1m 55s
-
Projecting variable OPEX1m 41s
-
5. The Top-Down Approach
-
The exit methodology2m 15s
-
6. Setting Up Targets
-
Moving from forecast to plan2m 10s
-
Conclusion
-
Next steps1m 10s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Creating a product-level projection