Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Campbell Soup Company in Camden, NJ, runs many different types of advertising campaigns to reach their target markets. They have found that old
The Campbell Soup Company in Camden, NJ, runs many different types of advertising campaigns to reach their target markets. They have found that "old school" paper mailings directly to homes work well, especially among mothers. They have also found that online social media advertising works well to reach some people too. As Campbell's gets ready to do an advertising campaign in Miami, Florida, they did a small test run and learned that for every one thousand (1,000) printed ads sent via paper mail, they can generate $32,000 in new revenue. Differing, this test run found that for every one thousand (1,000) online media ads, they generated $24,000 in new revenue. Note these are UPDATED and new numbers. But advertising in a market the size of Miami is expensive! From their Advertising budget limited to $10,000, an online ad costs $2,000 and a mailed printed ad costs $2,500. From their Marketing budget limited to $20,000, an online ad costs $3,000 and a mailed printed ad costs $3,300. From their Corporate budget limited to $20,000, an online ad costs $2,000 and a mailed printed ad costs $1,000. Question: given this data - which is represented in the template file found on Canvas under Test 1 entitled "Ch3 test problem resource allocation.xlsx" - what will be the total profit realized from this advertising campaign? The correct answer will be found using this template file, and seeing the results found in cell F11. Hint: you must populate cells B2 and C2, and then run Solver. Enter the number and do not enter the $. Numeric Response
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started