ExcelHotelexample.xlsx
Sheet1
| 50 | Rooms |
| 150 | Cost per room |
| 50% | Profit margin |
| Fb CBC | 0.5 | 500 |
| Fab CPM | 1.5 | 500 |
| Google CPC | 2 | 500 |
| Conversion rate | 4% |
| Each buys | 2 | Nights |
| | | | | Fb CPC | Fab CPM | GOOGLE |
| Budget | | | | 500 | 500 | 500 |
| Number of impressions | | | | | 333333.333333333 |
| Number of click | | | | 1000 | 3333.3333333333 | 250 |
| CTR | | | | | 1% |
| Number of conversions | | | | 40 | *B9 | 10 |
| Number of rooms | | | | 80 |
| Gross revenue | | | | 12000 | 4000 | 3000 |
| Cost of sales | | | | 6000 | 2000 | 1500 |
| Advertising costs | | | | 500 | 500 | 500 |
| Total cost | | | | 6500 | 2500 | 2000 | 11000 |
| Totale profit | | | | 5500 | 1500 | 1000 | 8000 |
| ROI | | | | 0.8461538462 | 0.6 | 0.5 | 0.7272727273 |
masure.dorsan
