4. A large donor has come on board to support the city in this initiative. This donorhas given the city $100,000 dollars for the program but has specified that themoney MUST be used to promote the program to families. Therefore,management has decided that this money will be the project advertising budget.The goal of this advertising budget is to maximize the number of people reached.The ads must be ordered ahead of time and there are 3 different types of ads tochoose from. There is Television, Billboards, and Social media. It is assumedthat every ad purchased is used and the number of people reached is listed below.These ads are subject to the following constraints:A) Television ads require 2 hours of labor and cost $2k eachB) Social Media ads require 1 hour of labor and cost $1k eachC) Billboards require 5 hours of labor and cost $6K eachMEDIA# OF PEOPLE REACHEDPER ADTelevision30KSocial MediaBillboards25K22KFormulate the advertising linear model and solve for the optimal way to spend thismoney using the solver program. Do NOT delete any solver reports.

Decision Variable: Suppose-T be the no. of television advertisementsS be the no. of social media…

Answered: 4. A large donor has come on board to…

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

A) What is the theoretical minimum number of workstations? a. 3 workstations b. 3.5 workstations c. 3.83 workstations d. 4 workstations e. 5 workstations B) Which of the following statements is FALSE? a. Tasks A, B, and C can be started as soon as possible. b. All of the tasks A, B and C should be finished first before task F can be started. c. All of the tasks A through H should be finished first before task I can be started. d.All of the tasks B, E, C and F should be finished first before task H can be started. Answer the two questions please.
A consulting firm has four projects to consider. Each project will require time (in days) in the next three months according to the table below. Project Time in first month Time in second month Time in third month Revenue A 6 8 6 22000 B 5 6 8 18000 C 8 7 6 16000 D 5 5 4 15000 Revenue from each project is also shown. There is 20 days’ time available in the first month, 22 days’ time available in the second month, and 22 days’ time available in the third month to do these projects. The management wants to select at most 3 projects. If project B is selected, then project C must also be selected. The objective of the firm is to maximize the total revenue. Formulate an integer optimization model for this problem by defining the decision variables, the objective function and all the constraints.…
Minimize Z = 2x1 - 2x2 + 3x3, subject to - x1 + x2 + x3 ≤ 4 (resource 1) 2x1 - x2 + x3 ≤ 2 (resource 2) x1 + x2 + 3x3 ≤ 12 (resource 3) x1 , x2 , x3 are non-negative (a) Work through the simplex method step by step to solve the problem. (b) Identify the shadow prices for the three resources and describe their significance
Four jobs are to be assigned to employees. There are 5 available employees. Durations for each job/employee combination are given in the following table. Build an assignment model to minimize the total time. What is the minimum optimal time? Employees Jobs 1 2 3 4 5 A 15 20 18 28 16 B 16 25 14 18 20 C 25 30 27 32 17 D 32 25 20 26 20
A manufacturing plant produces a product 'A' that requires one unit of 'B' and ½ unit of 'C'. Each unit of 'B' is comprised of one unit of 'D', two units of 'E', and one unit of 'F'. Each unit of 'C' requires ½ unit of 'G' and three units of 'H'. The manufacturing lead times for the components are as follows: 'A' - two weeks, 'B' - one week, 'C' - two weeks, 'D' - two weeks, 'E' - three weeks, 'F' - one week, 'G' - two weeks, 'H' - one week. There are 20 units in stock for each of these components. 100 units of 'A' are needed for delivery in seven weeks: a) Develop the product structure and indexed bill of materials for the product. b) Create a gross and net requirements plan for the manufacturer of the product.
You own wheat warehouse with capacity of 20,000 bushels. At the beginning of month 1, you have 6,000 bushels of wheat. Each month, wheat can be bought and sold at the price per 1000 bushels given in the table Month Selling price ($) Purchase prie ($) 1 3 8 2 6 8 3 7 2 4 1 3 5 4 4 6 5 3 7 5 3 8 1 2 9 3 5 10 2 5 The sequence of events during each month is as follows: a. You observe your initial stock of wheat. b. You can sell any amount of wheat up to your initial stock at the current month's selling price. c. You can buy(at the current month's buying price) as much wheat as you want, subject to the warehouse size imitation. Your goal is to formulate an LP that can be used to determine how to maximise the profit earned over the next 10 months and solve using Excel solver or AMPL
Vivian and Wayne are planning on going to Lamazenatural childbirth classes. Lamaze classes meet once a weekfor five weeks. Each class gives 20% of the knowledge neededfor “natural” childbirth. If Vivian and Wayne finish theirclasses before the birth of their child, they will forget duringeach week 5% of what they have learned in class. To maximizetheir expected knowledge at the time of childbirth, duringwhich week of pregnancy should they begin classes? Assumethat the number of weeks from conception to childbirthfollows the probability distribution given in Table 9. Week of Birth Probability36 .0537 .1539 .2040 .3041 .1542 .1043 .05
What is true about the assignment problem if the solution has reached the table below? Project A Project B Project C Project D Expert W 0 100 200 0 Expert X 0 0 200 300 Expert Y 0 100 300 0 Expert Z 200 100 0 0 a. The minimum number of vertical and horizontal lines needed to cross out 0s is three. b. Optimal assignment of projects cannot be determined yet. c. Optimal assignment of projects can now be determined.
“Coady used a strategy of focusing on reducing the number of projects in the portfolio.” Brieflydescribe the term portfolio in relation to the attached extract?
Accompany makes two products (1&2) each product requires time on two machines (A&B). specification for each product is as follows. Product1 product2 Processing time on Machine A (hrs/unit) 2 2 Processing time on Machine B (hrs/unit) 1 2 Material and labour cost ( ksh/unit) 14 15 Selling price (ksh/unit) 16 18 Maximum possible sale (units) 130 150 The amount of time available on machine A is 360 hours and on machine B is 260 hours. Formulate the linear programme which, when…
A project that you are managing is into six months of its accomplishment andthe planned duration is also six months. You are now reviewing the projectstatus. The actual cost of Activity A and B are RM 200,000 and RM 100,000respectively. The planned value for Activity A and B are RM 180,000 and RM80,000 respectively. The Activity A is 100% complete whereas Activity B isonly 75% complete. (a) Formulate the problem to determine whether the project is on-time and on-budget after six months using the Earned Value Analysis (EVA) method. (b) Generate the expected “cost at complete” and “time at complete” to finishthe project at this pace. (c) Present two initiatives to be undertaken by the project manager to improvethe situation based on Q4(b).
Mr Sng is a retiree in his late sixties. He has $100,000 to invest. He has no regular source of income and no other assets. He is evaluating between 3 different lump-sum financial products shown in Table 3. All products require a minimum investment sum of $100,000. Monetary returns represent the net gain after one year of investing in the product. For example, if Mr Sng chose to invest in Product B, he may lose $5,000 after one year if the GDP growth is negative. He will earn $8,000 if the GDP growth exceeds 2% at the end of the year. If you were in the shoes of Mr Sng, how would you select the appropriate investment product for a time horizon of one year? (i) Use the Optimistic, Conservative and Regrets payoff analysis approaches. State which product(s) Mr Sng should invest in and what monetary return he can expect from each approach (ii) As you have only enough funds for one product, identify the most appropriate investment product. [Hint: Be sure to consider the…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS