Marketing Programs Effectiveness Analysis
|
[ Скачать с сервера (1.92 Mb)
]
| 11.07.2010, 09:53 |
| • The
timing of Lead Events and sales orders plays a critical role in the
computations. |
– Each type of Lead Event has a finite effective lifetime. The
effectiveness of a Lead Event (measured by its
share of revenue from a customer
order) declines over its lifetime. |
– The model accrues expense for a Program Event (which is <=
actual Program Expense) by estimating
how much of the initial "book
value" of the Program Event remains at the end of the sales time span. |
| – This model lumps all sales orders and all Lead Events by
quarter. |
| |
| • You can include more marketing and sales programs, and
programs from the support department. |
| |
• The model includes Excel graphs of key variables. These charts
are part of the model, and they are included
by default in exported Excel
workbooks. You can add more charts, import them, and the new charts will
be
included in exported Excel
workbooks. |
| |
| As you explore the model, we suggest that you |
• Read some of the Excel comments that are attached to Analysis
Variables throughout the workbook.
These comments also appear in
FinModel in convenient places. |
• View worksheet "Formulas" which shows the named
variables and symbolic formulas of the model
in a compact and readable form.
The symbolic formulas are not active in this Excel workbook, but they
give you some idea how the model
works, and how it looks in FinModel. |
|
| Категория: Другие разработки | Добавил: Den
|
| Просмотров: 452 | Загрузок: 245
|