USING EXCEL SOLVERCheck the image for clarificationQ&H Company advertises during soap operas and football games. Each soap opera ad costs $75,000, and each football game ad costs $130,000. If S soap opera ads are purchased, they will be seen by 4S^1/2 million men and 22S^1/2 million women. If F football ads are purchased, they will be seen by 28F^1/2 million men and 10F^1/2 million women. The company wants at least 60 million men and at least 50 million women to see its ads.Determine how to minimize Q&H’s cost of reaching the required number of viewers.*Please show the equations in the cells 56. Q&H Company advertises during soap operas andfootball games. Each soap opera ad costs $75,000,and each football game ad costs $130,000. If S soapopera ads are purchased, they will be seen by 4S1/2million men and 22S'/2 million women. If F footballads are purchased, they will be seen by 28F1/2 millionmen and 10F1/2 million women. The company wantsat least 60 million men and at least 50 million womento see its ads.a. Determine how to minimize Q&H's cost ofreaching the required number of viewers.

Please follow the attachments below:

Answered: Determine how to minimize Q&H’s cost of…

Business

Operations Management

Determine how to minimize Q&H’s cost of reaching the required number of viewers.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter7: Nonlinear Optimization Models

Section: Chapter Questions

Problem 56P

See similar textbooks

Similar questions

E The Apex Television Company has to decide on the number of 27- and 20-inch sets to be produced at one of its factories. Market research indicates that at most 40 of the 27-inch sets and 10 of the 20-inch sets can be sold per month. The maximum number of workhours available is 500 per month. A 27-inch set requires 20 work-hours and a 20-inch set requires 10 work-hours. Each 27-inch set sold produces a profit of $120 and each 20-inch set produces a profit of $80. A wholesaler has agreed to purchase all the television sets produced if the numbers do not exceed the maxima indicated by the market research. Formulate a linear programming model for this problem and use graphical method to solve it
3. As an owner of a restaurant known as Ryuichi House, you have decided to break down the salesof the club into four categories, the first category is beverages. Your estimate of beverages salesis that 30,000 drinks will be served. The selling price for each unit will average 60Php; cost is30Php. The second category is meals, which you expect to be 10,000 units with an average priceof 400Php and a cost of 200Php. The third category is desserts, of which you also expect to sell10,000 units but with an average price of 100Php per unit sold and cost of 40Php per unit. Thefinal category is snacks, which you expect to total 20,000 units at an average price of 250Php witha cost of 130Php. You will also expense 72,000Php for rent, 8,000Php for utilities, and 80,000Phpfor the entertainment.a. How much is the total sales?b. What is your break-even point in pesos per month?
SIMPLEX METHOD: Min C = 3X1 + 7X2 + 5X3 Subject to: X1 + X2 + X3 > 50 2X1 + 3X2 + X3 > 100 Based on the initial tableau, answer questions no. 1-5 What is the value of X3 on the Cj row? What is the value of S2 on the right-hand side/quantity column? What is the value of Zj on the right-hand side/quantity column? What is the value of X3 on the Cj – Zj row? What is the entering variable?
56. Q&H Company advertises during soap operas andfootball games. Each soap opera ad costs $75,000,and each football game ad costs $130,000. If S soapopera ads are purchased, they will be seen by 4S1y2million men and 22S1y2 million women. If F footballads are purchased, they will be seen by 28F1y2 millionmen and 10F1y2 million women. The company wantsat least 60 million men and at least 50 million womento see its ads.a. Determine how to minimize Q&H’s cost ofreaching the required number of viewers.b. How does this model violate the proportionalityand additivity assumptions of LP?c. Suppose that the number of women (in millions)reached by F football ads and S soap opera ads is8F1y2 1 22S1y2 2 0.3(FS)1y2. Why might this bea more realistic representation of the number ofwomen viewers seeing Q&H’s ads?
Q. A gas company owns two refineries, 32 LPG bottling plants, and 367 retail outlets. The company has eight executive grades. The first four grades are classified as a junior. Management, fifth and sixth as middle and seven and eighth as top management. Due to unsystematic career management, the company has landed in the peculiar problem of 70% executive strength getting cumulated in the middle grades. For instance, there are 512 executives in the middle management category against the actual requirement of 84. Further, 245 out of these 512 are due to be promoted to the top management category but vacancies are only 27. Due to this lack of adequate career up gradation opportunities. Many in the middle level are frustrated and lack the motivation to perform.1. How do you develop a career planning and development in performance management?2. Discuss what strategy this company must adopt to overcome this situation?
3-4) How many pounds of beans will Taco Loco have left over if they produce the optimal quantity of products X, Y, and Z? A) 28.73 B) 39.27 C) 0 D) 1E + 30 3-5) What is the increase in revenue if Taco Loco purchases 20 pounds of cheese for $1 and uses it optimally? A) $0 B) $9.09 C) $29.00 D) $158.18
1. The marketing concept states that a firm must put consumer needs first, even if it means foregoing satisfactory profits. a. True b. False 2. John wants to start his own fruit juice and beverage company. He is aware of the large number of competitors in this industry and of the fact that his product should not be very costly. To differentiate his product from that of his competitors, he decides to sell his beverages in specially designed containers that keep the juice fresh for 7 days even without refrigeration. John is focusing on the _____component of the marketing mix. a. Place b. Pricing c. Packaging d. Product 3. The sales of a product are rising rapidly and profits are peaking. This product is in the _____ stage of the product life cycle. a. Introduction b. Growth c. Maturity d. Decline 4. A(n) _____ is given to customers for accepting less of something or as an adjustment for variation in quality. a. Discount b.…
1. An electronics firm is currently manufacturing an item that has a variable cost of 25Php/unit and aselling price of 50Php/unit. Fixed costs are 700,000Php. Current volume is 30, 000 units. The firmcan substantially improve the product quality by adding a new piece of equipment at an additionalfixed cost of 300,000Php. Variable cost would increase to 30Php/unit but volume should jump to50,000 units due to a higher-quality product. Should the company buy the new equipment?a. Yes, because it will gain a profit of 50,000Php.b. Yes, because it will gain a profit of 250,000Phpc. No, because it will gain a loss of 100,000Phpd. No, because it will not gain anything.e. None of the above
10. What is the impact of specific dollar amount of dividend on the binomial tree? What is (are) disadvantage(s) of resulting tree. How do you get around this problem.
2) A buyer for a large sporting goods store chain must place orders for professional footballs with the footballmanufacturer six months prior to the time the footballs will be sold in the stores. The buyer must decidein November how many footballs to order for sale during the upcoming late summer and fall months.Assume that each football costs the chain $45. Furthermore, assume that each can be sold for a retail priceof $90. If the footballs are still on the shelves after next Christmas, they can be discounted and sold for$35 each. The probability distribution of consumer demand for these footballs (in hundreds) during theupcoming season has been assessed by the market research specialists and is presented below. Finally,assume that the sporting goods store chain must purchase the footballs in lots of 100 units. Demand Probability 4 0.30 5 0.50 6 0.20 a) Construct a decision tree…
1.A clockmaker makes two types of woodenclocksto sell at various malls. It takes him three hours to assemble a pine clock, which requires two oz of varnish. It takes four hours to assemblea molave clock, which takes four oz of varnish. He has eight oz of varnish available in stock and can work 12 hours. If he makes a P100 profit on each pine clock and P120 on each molave clock, how many of each type should he make to maximize his profit?2.A biologist is developing two new strains of bacteria. Each sample of Type A bacteria produces five new viable bacteria,and each Type B bacteria produces six new viable bacteria. Altogether, at least 150 new viable bacteria must be produced. At least 10, but not more than 20,of the original sample,must be Type A,and not more than 60 of the samples must be Type B. A sample of Type A costs P500,and a sample of Type B costs P700. If both types are to be used, how many samples of each type should be used to minimize the cost?
1. Suppose you are going on a weekend trip to a city that is d miles away. Develop a model that determines your round-trip gasoline costs. What assumptions or approximations are necessary to treat this model as a deterministic model? Are these assumptions or approximations acceptable to you? 2. Suppose that a manager has a choice between the following two mathematical models of a given situation: (a)a relatively simple model that is a reasonable approximation of the real situation, and (b)a thorough and complex model that is the most accurate mathematical representation of the real situation possible. Why might the model described in part (a) be preferred by the manager?