**Using Excel**

OPTIMIZE THE DIGITAL MARKETING STRATEGY American Dream is a retail and entertainment complex located in the Meadowlands Sports Complex in Rutherford, NJ. The mega-sized mall opened only a few months prior to the start of COVID in the United States. Given their untimely launch and negative press, they have been working hard to promote their 3-million square foot retail and entertainment establishment. The management team requested your recommendations on how to allocate their digital advertising budget across Social Media, Satellite Radio (such as SiriusXM), and Music Streaming Services (such as Spotify). American Dream's digital marketing budget for next quarter is set at $375,000.

The marketing agency has provided the following information about the industry exposureeffectiveness rating per ad, the estimate of the number of potential new customers reached per ad, and the cost for each ad.

MEDIA Effectiveness Metric per Ad New Customers per Ad Cost per Ad Social Media 100 4000 $9,000 Satellite Radio 30 2000 $3,000 Music Streaming Services 15 1000 $1,000