Question

In: Advanced Math

Hampton Commission on the Arts (HCA) is planning on advertising its upcoming events. A local newspaper...

Hampton Commission on the Arts (HCA) is planning on advertising its upcoming events. A local newspaper claims that the ads on the paper can reach 27,000 art lovers, and it costs the HCA $6,000. Advertising on a local radio $10,000, and it is estimated to reach an audience of 39,000 people. HCA also considers google ads, which costs $15,000 will supposedly reach 52,000 arts customers. The breakdown of the audience for each type of commercial is as follows (charts below):

HCA has determined some marketing guidelines in order to improve outreach efforts. It wants to reach at least 200,000 potential arts customers. Past experience shows that older people are more likely to buy tickets than younger people; the number of potential customers over 35 should be at least 50% more than the potential customers under 35. The council also believes women are more likely to initiate ticket purchases to the arts than men, so it wants its advertising audience to be at most 40% male.

1) Construct a mathematical model for HCA to determine the number of ads of each type it should use at the minimum cost.

2) Solve the model using Excel Solver

Radio Ad

Newspaper Ad

Google Ads

Age

Male

Female

Age

Male

Female

Age

Male

Female

≥ 35

9,000

15,000

≥ 35

7,000

9,000

≥ 35

7,000

8,000

< 35

6,000

9,000

< 35

6,000

5,000

< 35

18,000

19,000

Solutions

Expert Solution

Considering all the constraints, we have developed the mathematical model for the given problem and solved using excel solver. For this problem, there is no feasible integer solution.


Related Solutions

South Hampton University is preparing its budget for the upcoming academic year. This is a specialised...
South Hampton University is preparing its budget for the upcoming academic year. This is a specialised private university that charges fees for all degree courses. Currently, 30,000 students are enrolled on campus. However, the university is forecasting a 5 per cent growth in student numbers in the coming year, despite an increase in fees to $3,000 per subject. The following additional information has been gathered from an examination of university records and conversations with university managers:  South Hampton is...
South Hampton University is preparing its budget for the upcoming academic year. This is a specialised...
South Hampton University is preparing its budget for the upcoming academic year. This is a specialised private university that charges fees for all degree courses. Currently, 30 000 students are enrolled on campus. However, the university is forecasting a 5 per cent growth in student numbers in the coming year, despite an increase in fees to $3 000 per subject. The following additional information has been gathered from an examination of university records and conversations with university managers: 1. South...
Emmanuel Richardson is a college student who is planning to attend several upcoming professional events. Each...
Emmanuel Richardson is a college student who is planning to attend several upcoming professional events. Each event will require the purchase of a suit and accessories costing between $100 and $200. Alice decides to purchase the suits and accessories on her credit card wear them to the events, and then return them for a full refund the following week. 1. Comment on the ethics of Emmanuel's plan? is there a problem with the plan, provide alternative plan(s)
The Federal Trade Commission (FTC) ordered Warner-Lambert to cease and desist from advertising that its product,...
The Federal Trade Commission (FTC) ordered Warner-Lambert to cease and desist from advertising that its product, Listerine antiseptic mouthwash, prevents, cures, or alleviates the common cold and sore throats. The order further required Warner-Lambert to disclose in future advertisements that “[c]ontrary to prior advertising, Listerine will not help prevent colds or sore throats or lessen their severity.” Warner-Lambert contended that even if its past advertising claims were false, the corrective advertising portion of the order exceeded the FTC’s statutory powers....
a) Always Round Tire hires Plain Truth Advertising to write copy for its newspaper advertisements. Always...
a) Always Round Tire hires Plain Truth Advertising to write copy for its newspaper advertisements. Always Round has a demand for advertising of MB = 400 − 2S where S is the number of hours that Plain Truth works. If Plain Truth has a fixed supply cost given by MC = $150 per hour, what are the number of hours that Always Round purchases from Plain Truth under the assumption of costless monitoring? How much is the contract worth to...
Part #1: K Company is planning its cash disbursements for the upcoming months. In June, it...
Part #1: K Company is planning its cash disbursements for the upcoming months. In June, it anticipates $72,000 in Purchases, $130,000 in Payroll, and $40,000 in Loan Payments. In July, it anticipates $77,000 in Purchases, $140,000 in Payroll, and $35,000 in Loan Payments. In August, it anticipates $84,000 in Purchases, $150,000 in Payroll, and $30,000 in Loan Payments. Purchases are usually paid half in the current month and half in the following month. Payroll is paid 70 percent in the...
A company is planning its advertising strategy for next year for its three major products. Since...
A company is planning its advertising strategy for next year for its three major products. Since the three products are quite different, each advertising effort will focus on a single product. In units of millions of dollars, a total of 6 is available for advertising next year, where the advertising expenditure for each product must be an integer greater than or equal to 1. The vice -president for marketing has established the objective: Determine how much to spend on each...
A company is willing to renew its advertising campaign with a local radio station only if...
A company is willing to renew its advertising campaign with a local radio station only if the station can demonstrate that there is evidence that more than 20% of the residents of the city have heard the ad and recognize the company’s product. The station contacts 500 residents, and finds that 114 remember the ad. (a) The station plans to conduct a test at ? = 0.10, but the company wants ? lowered to 0.05. Why? (b) Use the p-value...
Ads A company is willing to renew its advertising contract with a local radio station only...
Ads A company is willing to renew its advertising contract with a local radio station only if the station can prove that more than 20% of the residents of the city have heard the ad and recognize the company’s product. The radio station conducts a random phone survey of 400 people. a. What are the hypotheses? b. The station plans to conduct this test using a 10% level of significance, but the company wants the significance level lowered to 5%....
NewMedia Inc. is planning to expand its business globally. oOh!Media Ltd, an Australian advertising and media...
NewMedia Inc. is planning to expand its business globally. oOh!Media Ltd, an Australian advertising and media company, is among the acquisition targets NewMedia is evaluating. oOh!Media has a sizable lease portfolio. Cindy, NewMedia’s CFO, is concerned that under IFRS 16 oOh!Media’s financial results and leverage may look significantly less attractive. Cindy is familiar with the new lease accounting standard for U.S. GAAP, but has not been following the IFRS standard. She has asked your team to 1) explain the major...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT