Download This FREE Template
Internet Sensitivity Marketing Template
Internet Sensitivity Marketing Template Assumptions
This internet sensitivity marketing template model is designed to allow users to vary price, units, costs, and success to compare outcomes. It allows you to compare various marketing input estimates and show net profit outcomes. It is developed for analyzing alternatives, but can then be used for forecasting and measuring as the business is underway.
- Spending is dollar budget for category of marketing
- Cost is net cost including handling and shipping
- Depending on model selling price is wholesale or retail net price
- Clicks are spending/cost per click
- Cost per click is average estimated cost to obtain a click
- Units are units sold or conversion rate times clicks
- Sales are units times selling price
- Gross margin is total sales less units times cost
- Variable marketing is internet marketing or commissions or other variable costs
- Marketing is the other marketing costs like brand building, etc. The estimated percentage is at top, or can be input of each subset
- Administrative is customer service, rent, insurance, accounting, etc. Percentage is at top or can be input for each subset
- Profit is gross margin less marketing, variable marketing less administrative