The original campaign cost for the last quarter of December 31, 2023 was $ 1,448.395. However, for the upcoming campaign for the first quarter of March 31, 2024, the CFO is only recommending a total Budget max of $1,000 for the 15 campaigns listed in the Historical data due to recent additional expenses.Thus, the objective is to maximize the recommended Budget of $1,000, using Excel Solver, allocating $ 62.000 to each campaign to determine the Optimal Budget and make arelevant buiness decision for how the remaining budget is allocated. Also, what effect does the Budget have on the overall clicks and Conversions result?

A high-end restaurant wants to introduce a new gourmet dish to its menu. The dish's ingredient costs are $25 per plate, and the restaurant incurs an additional $10 per plate in overhead costs. The restaurant aims for a profit of $15 per plate. However, to maintain a competitive edge, the restaurant must also cover an additional 5% in marketing costs per dish sold. Using Goal Seek, calculate the new selling price per dish required to meet the profit target while covering the additional marketing costs.

The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint                       Television          Radio             Online                                          100,000          16,000            35,000 Audience per advertisement Cost per advertisement                                            $1,500            $250                $650 Maximum media usage                                               10                   24                     14 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized. (a) If the promotional budget is limited…