Tedext

Company’s monthly ad spend budget - Different scenarios

You have to create different scenarios for your company’s monthly ad spend budget
Your company spends money on ads that are in Print magazines, social media, and radio.

These also effect your sales. Download the file and create the following scenarios
Only manipulate the following cells
 
1. Change the format of cells (Currency, Numbers, and Percentages) – 1 points
1. A # represents a number
2. A $ represents currency
3. A % represents percentage
2. Give a scenario for ONLY Print Magazine ad budget by spending $1,000 (split the budget into 3 parts). Name the scenario AdBudget1 – 3 points

3. Give a scenario for an ad spend that focus on ONLY 2 different radio stations (Radio Rock and Radio Rap) with a budget of $723 and $321, respectively. Name the scenario AdBudget2 – 3 points

4. An ad spend that focuses on 4 different social media platforms with each having a budget of $500. Name the scenario AdBudget3 – 3 points

5. An ad spend that focuses on 1 magazine, 1 radio station, 2 social media channels with a total budget of $1,730 (split it into 4 parts). Name the scenario AdBudget4 – 3 points

6. Keeping the ad spend at $100 each, create a scenario to see if the sales revenue increases or decreases if you change the percentages of Sales Pre-Qualified Leads to 60%, Sales Qualified Leads to 34%, and Sales Unit Booked to 10%. Name the scenario SalesFunnel1 – 4 points

7. Keeping the ad spend at $200 each, create a scenario to see if the sales revenue increases or decreases if you change the percentages of Sales Pre-Qualified Leads to 84%, Sales Qualified Leads to 57%, and Sales Unit Booked to 20%. Name the scenario SalesFunnel2 – 4 points

8. Keeping the ad spend at $300 each, create a scenario to see if the sales revenue increases or decreases if you change the percentages of Sales Pre-Qualified Leads to 53.5%, Sales Qualified Leads to 21.78%, and Sales Unit Booked to 78.5%. Name the scenario SalesFunnel3 – 4 points

9. Keeping the ad spend at $400 each, create a scenario to see if the sales revenue increases or decreases if you change the percentages of Sales Pre-Qualified Leads to 79.3%, Sales Qualified Leads to 68.14%, and Sales Unit Booked to 42.57%, and also changing Unit Price to $30.17. Name the scenario MultiScenario1 – 5 points

10. Keeping the ad spend at $1000 in total for Print, $1000 in total for Magazine, and $1000 for Social Media, create a scenario to see if the sales revenue increases or decreases if you change the percentages of Sales Pre-Qualified Leads to 80%, Sales Qualified Leads to 60%, and Sales Unit Booked to 25%, and also changing Unit Price to $18.15. Name the scenario MultiScenario2. – 5 points

11. Keeping the ad spend at $700 in total for Print, $800 in total for Magazine, and $500 for Social Media, create a scenario to see if the sales revenue increases or decreases if you change the percentages of Sales Pre-Qualified Leads to 75.25%, Sales Qualified Leads to 57.35%, and Sales Unit Booked to 32.52%, and also changing Unit Price to $40.52. Name the scenario MultiScenario3. – 5 points

12. For each scenario, edit the comments with proper date, instructions (do not copy paste mine, and the also the Sales Revenue, Total Ad Expenses, and Profit – 10 point

13. Save the file as your_full_name.xlsx and upload it to canvas. E.g. my name is Baber Mirza, I will save it as baber_mirza.xlsx – 10 points

Company’s monthly ad spend budget - Different scenarios

  • Order

  • Payment

  • Processing

  • Delivery

Validation error occured. Please enter the fields and submit it again.
Thank You ! Your email has been delivered.