A. If they wish to maximize the number of exposures to working mothers, how many ads of each type should be purchased? What is the objective function, and system of constraints? **Problem 2: Advertising Optimization**General Supervisory Services has $12,000 available for advertising. The table below details the costs per ad and the number of people exposed to its ads for three different media platforms, with costs in thousands.| Ad Packages | Social Media | Radio | TV ||--------------|--------------|-------|----|| Cost | 2 | 2 | 4 || Total audience | 30 | 21 | 54 || Working mothers | 6 | 12 | 8 |- **Objective:** If the total available audience is 420,000, and the goal is to maximize the number of exposures to working mothers, determine how many ads of each type should be purchased. Formulate the objective function and the necessary system of constraints.- **Tasks:** - Set up and solve the problem using Excel. - Provide a detailed discussion on the solution and what it implies.- **Update:** If new estimates suggest media exposure to working mothers is: 6,000 (Social Media), 4,000 (Radio), and 8,000 (TV), adjust the optimization model accordingly.- **Discussion Task:** Write a paragraph discussing how altering parameters can impact variable values and optimization results. Participants are encouraged to explore different parameters.**Problem 3: Cost Optimization for Deli and Catering**A Deli and Catering company manages two menus: I and II, prepared at three different facilities (A, B, and C). Below are the summarized production capacities and weekly operating costs:| | A | B | C ||--------------|----|----|----|| I | 200| 200| 400|| II | 100| 200| 100|| Cost / week | $1000| $3000| $4000|- **Objective:** Determine the number of weeks each facility should operate to fulfill orders at minimal cost. Formulate the objective function and system of constraints.- **Tasks:** - Use Excel to model and solve the problem. - Provide a thorough explanation and interpretation of the solution.These exercises aim to develop learners' ability to apply optimization techniques and interpret results within practical business contexts.

Answered: Image /qna-images/answer/db07062a-3dd7-4e12-97ab-f2487cf3de4f.jpg

General Supervisory Services has $12,000 available for advertising. The following table gives the costs per ad and the number of people exposed to its ads for three different media (with costs in thousands).

General Supervisory Services has $12,000 available for advertising. The following table gives the costs per ad and the number of people exposed to its ads for three different media (with costs in thousands).

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Analyze either a product orientated or service orientated persuasive ad. The focus of this analysis section is the Theoretical Rationale for the ad you have chosen. Successful ads should use research and theory to inform their choices. Your analysis should include a discussion of the intended audience and how the ad addresses this particular audience. You must explain and justify or critique strategy choices, media choices, goals, etc. with both logic and research. For example, you might explain particular layout choices for your ads website in terms of heuristic processing or might discuss the use of slightly discrepant messages in print ads to slowly move target attitudes anchor points over time (Social Judgment Theory). In other words, I do not want to see you haphazardly critiquing an ad based on your own preferences, ideas, opinions, biases, et cetera (we see enough of that already). Instead, you are working to argue from a theoretical position whether and ad utilizes…
I love being a dad and I intend to capture my daughter's life on some sort of permanent media, specifically, I have chosen to use a Panasonic camera and have its film developed at Bryan Photo Studio. My choice to use the Panasonic camera and Picture Perfect Studio represent choices based on a. Needs b. Demand c. Want d. Affordability
1a) A YouTube advertisement has received a CPM of $20. The amount of people that have seen this ad is 150,000. What is the total cost of this advertisement? 1b) The total cost of running an Amazon AD is $4,000,000., if we estimate CPM of $20. How many viewers are expected to watch the AD? 1c) An influencer who focuses her content on skincare products reaches 500,000 people through her TikTok account on a video. An emerging brand asks her to do a review of their products where for 40 seconds of video the influencer is paid $8,600. Determine the CPM.
Design of health promotion programs including four phases (diagnosis, programme development, implementation, evaluation):1. Identify program objectives2. Develop a plan for building networks for collective action3. Select the best ways of achieving the objectives at environmental and individual level; more specifically, the selection of strategies, messages, channels, and settings4. Determine activities, including identification of necessary resources5. Set a clear program plan
Communicating Magnum current Image positioning Magnum is a Belgian brand of ice cream bars owned by the British-Dutch company Unilever, originally developed and produced by Frisko in the Danish city of Aarhus. It is sold as part of the Heartbrand line of products in most countries. Product background: Magnum is a crispy-based ice cream that is bigger than other ice creams and is eaten rather than licked. To overcome a slowdown in the sales of impulse ice cream products and to improved Magnum’s static sales, Unilever UK and its advertising agency launched a campaign that was targeted at young men age 18 to 24. The marketing team realized that to enjoy Magnum, the target market would have to bite, rather than lick, the ice cream so they turned that idea to come up with a new slogan that will fit the Magnum Ice cream bar. Questions: 1. Develop your most eye-catching slogan that will fit with the current looks of the Magnum Ice cream bar. Explain your slogan. 2. Based on your proposed…
Select any two of the objections and d=lop a specific example ofhow they might lead to a bad decision in market planning
3
The marketing mix refers to the set of actions, or tactics, that a company uses to promote its brand or product in the market. Questions 1. Provide a discussion on the 4P’s of the marketing mix for a product of your choice. 2. Determine the market segmentation for the product discussed in question 1 above.
I need the answer as soon as possible
om/qa/wait/40583814/ Question: Which of the following statements most accurately reflects the essence of the marketing discipline as we currently understand it? Multiple Choice Marketing must design the 4 P's with effectiveness and efficiency pursuant to objectives. In creating customer needs and wants, ensuring profitability is our focal concern. 000ln meeting customer needs and wants, we try to build long-term relationships that have benefits for everyone. It's entirely about creating needs and wants. Download Attachments O 122969522-4040151.jpeg Skip Question· Show Comment· Report Issue
Wrong answer = 1000 dislikes All of the following statements are incorrect except: a) Farm output varies from one year to another because farm commodities are highly seasonal. b) Physiological needs are part of the psychological needs. c) Engel’s law states that as income in the US continues to rise, the share of income spent on food remains constant at 6%. d) Functional and physiological food values reflect the contribution of food to consumer health and well-being.
1. Marketing objectives for new Soft Drink 2. Marketing strategies for achieving the objectives 3. How you intend to Measure, Review and Control the objectives