# Video Training - Q\&A

{% embed url="<https://www.loom.com/share/a607a924614f496393905d0d4820d9ba>" %}
Expand the boxes below to view the outline of the video
{% endembed %}

## Outline: Use Cases + Questions We Will Answer

<details>

<summary>"Live Model" and Working in Excel</summary>

* What does the notion of live model mean? (min 0:39)
* My formulas are not calculating how do I fix that? (min 5:52)

</details>

<details>

<summary>Marketing Scenarios + CAC + New Ad Sources</summary>

* How do I override my forecast for an existing ad source? (min 1:34)
* How do I add a new ad source? (min 3:00)
* How do I adjust my CAC? (min 6:45)&#x20;
* How should I think about CAC across channels even though Drivepoint only asks for a blended CAC? (min 7:20)
* How should I think about how a new ad source influences my CAC? (min 8:15)

</details>

<details>

<summary>Checking my Work by Utilizing Drivepoint Templates</summary>

* How can I check the Marketing changes that I made and which templates are the most useful? (min 9:15)
* How do I compare against a base plan? (min 10:35)

</details>

<details>

<summary>Adding new Wholesale/Retail Accounts</summary>

* How do I add a new account/chain that I am starting to sell in? (min 12:57)
* How do I name my Wholesale tabs correctly? (min 14:56)

</details>

<details>

<summary>Adding New SKUs + Changing my Sales Mix</summary>

* How do I add a new SKU (min 19:09)?
* How should I think about import shipping? (min 19:31)
* How should I think about landed unit costs? (min 19:53)
* How do I change my sales mix? (min 21:10)
* How should I indicate cannibalization of Sales by product with new product launches? (min 21:43)
* How do I change my channel pricing? (min 21:58)
* Is there an easy shortcut to&#x20;

</details>

<details>

<summary>Other Tips</summary>

* As you are building scenarios, go big in your assumptions so that you can truly see the impact of the scenario. Instead of $4000 for Bing Ads, go for $400,000 in Bing Ads.
* If your product sales mix + pricing is generally pretty stable, we have a shortcut for assuming product information. (min 22:04)

</details>