please answer all parts in excel

You report to the Director of Marketing at a company that offers three different product lines. Each product line has its own characteristics. She cares most about the resulting total revenue. She has an advertising budget of $30,000. Assume that the company will meet all demand. The total increase in the demand of a product line p resulting from advertising on that product line is expressed in the below equation: IncreasedDemandp=Squarerootof(fpAdSpendingp) where p refers to the product line fp is the factor for the model AdSpending p is the advertising spent on product p Create a separate spreadsheet tab (Q1A, Q1B, Q1C, and Q1D-report) to show your work for the following four situations. Ensure your spreadsheet tabs is well-organized and easy for your boss to use. A. Base Case: Assume an equal advertising budget of $10,000 is spent on each product line. Calculate the total revenue achieved under this base case scenario. Label your tab Q1A. B. Optimal Allocation: Determine the optimal allocation of the advertising budget across the three product lines to maximize the company's total revenue. Calculate the total revenue achieved with the optimal allocation. Label your tab Q1B. C. Increased Budget: Assume the total advertising budget is raised to $50,000. Determine the new optimal allocation of the advertising budget across the product lines. Calculate the total revenue achieved with this new optimal allocation. Label your tab Q1C. D. Optimization What-If Analysis: Perform a what-if solver sensitivity analysis where the advertising budget is varied between $20,000 and $100,000 in increments of $5,000. For each budget level, determine the maximum value of the total revenue that may be achieved. Present your findings in a clear and organized manner for your boss. Put your report in tab Q1D-report