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

Need answer.instant upvote The fifth step in the appraisal process, reconciliation is: Select one: a. the addition to the market and residual approaches b. dependent upon the nature of the property and objective of the appraisal. c. simply the median of the three approaches to value d. simply the average of the three approaches to value
Manufacturers and distributors beg you to stock their new items as a big grocery chain's top buyer. Tens of new things are launched weekly. These items are often introduced with nationwide advertising campaigns and merchant promotions. To introduce new goods, shelf space for old products must be lowered or deleted. You need to work with the IS department to create a marketing MIS to predict the profit impact of adding or removing an item from inventory. What do you suggest to the IS department for establishing such a system?
In the sales adjustment gride, the physical adjustments are O Negative O Additive Substantive O Cumulative
Pls help ASAP
Advertising. Repeat Problem 27 for Problem 27 Advertising. A retail store estimates that weekly sales s and weekly advertising costs x (both in dollars) are related by The current weekly advertising costs are $2,000, and these costs are increasing at the rate of $300 per week. Find the current rate of change of sales.
Sara is the marketing manager in XYZ company. She is introducing new products. She transmits information about the features of the product to customers. Which of the following role is performed by her?
please answer within 30 minutes.
3
40 ________ is a planning tool that relies on past data to predict the future demand: Select one: a. Forecasting b. Market analysis c. Supply planning d. Demand flow strategy
2 3 4. 7 8. 10 auvGIISIng COIIUAly OIIVI UDTUU typos UI IOUIIIIS, WIGVISIOI, OGwspapci aIU TaUIv . TIIC COST for each medium with its audience coverage is given below. Television Newspaper Radio Cost per advertisement ($) 1600 1100 100 Audience per advertisement 99,000 38,000 16,000 The company is capable of using a number of newspaper advertisement slots up to 10. Moreover, in order to balance the advertising among the three types of media, the total number of advertisements on radio should not occur more than 45% of total number of advertisement. and at least lt 4% of the total number of advertisements should occur on television. The weekly advertising budget is S20300. How many advertisements should be run in each of the three types of media to maximize the total audience? If we assume the number of ads on each type of meduim as follows : T, N, R respectively Given the following Television constrain nT-14%N - 14%R What is the value of n? Remark: Write vour answer in percentage Inot…
To make sure they have enough stock, a department store implements a new application that analyses customers spending pattern and verify this data to popular clothing styles. Which of the following business objective is this information intended to support? [Untuk memastikan mereka mempunyai bekalan yang cukup, sebuah pusat membeli-belah melaksanakan satu aplikasi baharu yang menganalisa tahap perbelanjaan dan mengesahkan data tersebut dengan gaya gaya pakalan popular Manakah antara: objektif perniagaan berikut yang disokong oleh maklumat data itu? U a. Customer intimacy. [Keintiman pelanggan.] O b. Survival. [Kelangsungan hidup.] Oc. Operational excellence. [Kecemerlangan operasi.] O d. Improved decision making.
Need the answers for both of these please help