I have this project and added the link to data. I need help with coding in R.

https://docs.google.com/spreadsheets/d/13Gsyt9yUyVR-qCPixsvOCqmS2edfsAvbmWu4tCB_kog/edit?usp=sharing

question:

Prompts

1.Marketing Optimization

Your company is looking at optimizing their social media marketing by investing in various advertising campaigns. There are 250 Instagramcampaigns and 250 Facebook campaigns available. Each runs for one month and reaches 30,000 people. Revenue for each campaign is found as numberOfCustomersReached*conversionRate*customerPurchaseAmount. Profit for each campaign is found as Revenue - Cost.

1. Decide how much money to spend on the different ad campaigns tomaximizetotal profit while meeting a budget of $2,000. Assume you can invest a partial amount (however small you would like) in each campaign, but you can't run each campaign more than once. Return the number of campaigns run, total cost, total profit, average percentage reach to existing customers, average percentage reach to new customers, and average percentage reach to female customers.
2. Decide how much money to spend on the different ad campaigns tomaximizetotal profit while meeting a budget of $2,000. Each campaign is all or nothing - you can either run the whole campaign for the full cost or not run it at all. Return the number of campaigns run, total cost, total profit, average percentage reach to existing customers, average percentage reach to new customers, and average percentage reach to female customers.
3. You're not sure how much your budget requirement is hurting your marketing efforts, so you would like to see how sensitive your results are to your budget. How profitable will you be if you have a higher or lower budget? You would like to evaluate every budget option in $500 intervals between $500 and $10,000 (i.e. $500,$1000,$1500, etc.). Assume you can invest a partial amount (however small you would like) in each campaign, but you can't run each campaign more than once. To evaluate the different budget options, write a function which takes in budgetThreshold as an input and outputs the number of campaigns run, total cost, total profit, average percentage reach to existing customers, average percentage reach to new customers, and average percentage reach to female customers. Return these values in a csv file. The csv file should have 20 rows and the columns should be:
4. budgetThreshold
5. numberOfCampaigns
6. totalCost
7. totalProfit
8. mean%reachToExistingCustomers
9. mean%reachToNewCustomers
10. mean%reachToFemaleCustomers