Customer acquisition costs

6 posts / 0 new
Log in or register to post comments.
Last post
3 years ago
#1
Cornell Tsiang 1 X 3
CT
Customer acquisition costs

Hi 

I separated my sales & marketing team salaries from the rest of the sales and marketing costs. This is useful for headcount expansion assumptions.  However, I would like to include the salaries in my CAC calculations.  However, the CAC calculation doesnt allow me to include it (or at least there is a warning of corruption).  I tried to add a new category which didnt work. Is there a way to modify the CAC calculation inputs without corrupting the spreadsheet?

 

Thanks

3 years ago
James Longden A+ 103

Hi Cornell.  You should be able to:

  1. expand the linkedin expenses at the top,
  2. right-click to add a new link in,
  3. select the Income Statement Salaries & Wages (make a negative -link(2); and
  4. then drag and drop this in via the precedent links pane.

3 years ago
Cornell Tsiang 1 X 3
CT

HI James

 

I was able to do steps 1-3 but not sure on the last step.  I couldn't drag and drop "via the precedents links pane"? 

Moreover, I only want to carve out the salaries and wages line for marketing not the entire salaries and wages.  

Thanks for the help, most appreciated

 

Kind regards

 

Cornell

3 years ago
James Longden A+ 103

For the first issue, have a look through the main help: https://www.modano.com/resources/user_guide/automation/using_modules/lin...

For the second point, the aim here is to bring in all lines, and then enter a percentage against those that apply. Notwithstanding, the precedent take pane will allow you to select individual categories, if you only want to include a few select lines.

3 years ago
Cornell Tsiang 1 X 3
CT

Hi James

Perfect.

 

Thank you very much indeed

Kind regards

 

Cornell

1 year ago
steve43834 X 0
MC

Thank you for the link, sir.