menu
bartleby
search
close search
Hit Return to see all results
close solutoin list

The General Flakes Company sells a brand of lo-fat breakfast cereal that appeals to people of all age groups and both genders. The company advertises this cereal in a variety of 30-second television ads, and these ads can be placed in a variety of television shows. The ads in different shoes vary by cost —some 30-second slots are much more expensive than others—and by the types of viewers they are likely to reach. The company has segmented the potential views into six mutually exclusive categories: males age 18 to 35; males age 36 to 55; males over 55; females age 18 to 35; females age 36 to 55; and females over 55. A rating service can supply data on the numbers of viewers in each of these categories who will watch a 30-second ad any particular television show. Each such viewer is called an exposure . The company has determined the required number of exposes it wants to obtain these required exposures at minimum cost. The data on costs per ad, numbers of exposures per ad, and minimal required exposures are listed in Table 4.1, where numbers of exposures are expressed in millions, and costs are in thousands of dollars. What should the company do? Suppose there are three objectives, not just two: the total advertising cost, the total number of excess exposures to men, and the total number of excess exposures to women. Continuing the approach suggested in the previous problem, how might you proceed? Take it as far as you can, including a sensitivity analysis and a trade-off curve.

BuyFindarrow_forward

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659

Solutions

Chapter
Section
BuyFindarrow_forward

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659
Chapter 4.2, Problem 6P
Textbook Problem
41 views

The General Flakes Company sells a brand of lo-fat breakfast cereal that appeals to people of all age groups and both genders. The company advertises this cereal in a variety of 30-second television ads, and these ads can be placed in a variety of television shows. The ads in different shoes vary by cost —some 30-second slots are much more expensive than others—and by the types of viewers they are likely to reach. The company has segmented the potential views into six mutually exclusive categories: males age 18 to 35; males age 36 to 55; males over 55; females age 18 to 35; females age 36 to 55; and females over 55. A rating service can supply data on the numbers of viewers in each of these categories who will watch a 30-second ad any particular television show. Each such viewer is called an exposure. The company has determined the required number of exposes it wants to obtain these required exposures at minimum cost. The data on costs per ad, numbers of exposures per ad, and minimal required exposures are listed in Table 4.1, where numbers of exposures are expressed in millions, and costs are in thousands of dollars. What should the company do?

Chapter 4.2, Problem 6P, The General Flakes Company sells a brand of lo-fat breakfast cereal that appeals to people of all

Suppose there are three objectives, not just two: the total advertising cost, the total number of excess exposures to men, and the total number of excess exposures to women. Continuing the approach suggested in the previous problem, how might you proceed? Take it as far as you can, including a sensitivity analysis and a trade-off curve.

Summary Introduction

To modify: The original model to place a lower limit on the total amount of excess exposures to men, total amount of excess exposures to women and minimize the total adverting cost and run a sensitivity analysis.

Linear programming:

It is a mathematical modeling procedure where a linear function is maximized or minimized subject to certain constraints. This method is widely useful in making a quantitative analysis which is essential for making important business decisions.

Explanation of Solution

Excel model:

All monetary values in the model are in $1,000s. The exposure to ads is in millions of exposures.

Solver input:

The solver input is selected from under the “Data” tab in Excel and the input is given as shown below:

Formula:

Two-way analysis for solver model:

The solver table add-in is added to the excel to perform the solver table function...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 4 Solutions

Practical Management Science
Show all chapter solutions
add
Ch. 4.3 - A small business requires different numbers of...Ch. 4.3 - A small business requires different numbers of...Ch. 4.4 - During the next four months the SureStep Company...Ch. 4.4 - During the next four months the SureStep Company...Ch. 4.4 - During the next four months the SureStep Company...Ch. 4.4 - During the next four months the SureStep Company...Ch. 4.4 - During the next four months the SureStep Company...Ch. 4.4 - During the next four months the SureStep Company...Ch. 4.4 - During the next four months the SureStep Company...Ch. 4.5 - Chandler Oil has 5000 barrels of crude oil 1 and...Ch. 4.5 - Chandler Oil has 5000 barrels of crude oil 1 and...Ch. 4.5 - Chandler Oil has 5000 barrels of crude oil 1 and...Ch. 4.5 - Chandler Oil has 5000 barrels of crude oil 1 and...Ch. 4.5 - Chandler Oil has 5000 barrels of crude oil 1 and...Ch. 4.5 - Chandler Oil has 5000 barrels of crude oil 1 and...Ch. 4.6 - Repco produces three drugs, A, B, and C, and can...Ch. 4.6 - Repco produces three drugs, A, B, and C, and can...Ch. 4.6 - Repco produces three drugs, A, B, and C, and can...Ch. 4.6 - Repco produces three drugs, A, B, and C, and can...Ch. 4.7 - At the present time, the beginning of year 1, the...Ch. 4.7 - At the present time, the beginning of year 1, the...Ch. 4.7 - At the present time, the beginning of year 1, the...Ch. 4.7 - At the present time, the beginning of year 1, the...Ch. 4.7 - James Judson is the financial manager in charge of...Ch. 4.7 - James Judson is the financial manager in charge of...Ch. 4.7 - James Judson is the financial manager in charge of...Ch. 4.7 - James Judson is the financial manager in charge of...Ch. 4.7 - At the present time, the beginning of year 1, the...Ch. 4.7 - James Judson is the financial manager in charge of...Ch. 4.7 - James Judson is the financial manager in charge of...Ch. 4.8 - Pine Valley Bank has three branches. You have been...Ch. 4.8 - The Salem Board of Education wants to evaluate the...Ch. 4.8 - You have been asked to evaluate the efficiency of...Ch. 4.8 - You have been commissioned by Indiana University...Ch. 4 - A bus company believes that it will need the...Ch. 4 - During each four-hour period, the Smalltown police...Ch. 4 - Shoemakers of America forecasts the following...Ch. 4 - NewAge Pharmaceuticals produces the drug NasaMist...Ch. 4 - You have decided to enter the candy business. You...Ch. 4 - Sunblessed Juice Company sells bags of oranges and...Ch. 4 - A bank is attempting to determine where its assets...Ch. 4 - Young MBA Erica Cudahy can invest up to 20,000 in...Ch. 4 - A fertilizer company blends silicon and nitrogen...Ch. 4 - A chemical manufacturer uses chemicals 1 and 2 to...Ch. 4 - Hilands Appliances stocks laptops, TVs,...Ch. 4 - Many Wall Street firms use LP models to select a...Ch. 4 - A coal company produces coal at three mines and...Ch. 4 - A furniture company manufactures tables and...Ch. 4 - A chemical company produces three products, A, B,...Ch. 4 - Abotte Products produces three products, A, B, and...Ch. 4 - An investor has 100,000 to invest right now (the...Ch. 4 - At the beginning of year 1, you have 100,000....Ch. 4 - You now have 10,000, and the following investment...Ch. 4 - An oil company processes oil into aviation fuel...Ch. 4 - All steel manufactured by Allied Steel must meet...Ch. 4 - United Steel manufactures two types of steel at...Ch. 4 - Based on Heady and Egbert (1964). Walnut Orchard...Ch. 4 - Candy Kane Cosmetics (CKC) produces Leslie...Ch. 4 - Federated Oil has refineries in Los Angeles and...Ch. 4 - A feed company produces two types of cattle feed,...Ch. 4 - Carrington Oil produces gas 1 and gas 2 from two...Ch. 4 - Based on Thomas (1971). A toy company produces...Ch. 4 - A company produces two products: A and B. Product...Ch. 4 - A bank needs exactly two employees working each...Ch. 4 - Based on Gaballa and Pearce (1979). Northwest...Ch. 4 - A rock company uses five types of rocks to fill...Ch. 4 - An automobile manufacturer needs to plan its...Ch. 4 - An oil company produces gasoline from five inputs....Ch. 4 - The HiTech company produces Blu-Ray disc players....Ch. 4 - During the next two months an automobile...Ch. 4 - You want to take out a 450,000 loan on a 20-year...Ch. 4 - A graduated payment mortgage (GPM) enables the...Ch. 4 - Suppose you are planning for retirement. At the...Ch. 4 - Based on Brams and Taylor (2000). Suppose that Eli...Ch. 4 - AdminaStar processes Medicare claims. At the...Ch. 4 - All steel manufactured by Allied Steel must meet...Ch. 4 - During the next four quarters, Dorian Auto must...Ch. 4 - The Internal Revenue Service (IRS) has determined...Ch. 4 - You own a wheat warehouse with a capacity of...Ch. 4 - You can calculate the risk index of an investment...Ch. 4 - Based on Magoulas and Marinos-Kouris (1988). An...Ch. 4 - Capsule Drugs manufactures two drugs. The drugs...Ch. 4 - Molecular Products produces three chemicals: B, C,...Ch. 4 - Bexter Labs produces three products: A, B, and C....Ch. 4 - Mondo Motorcycles is determining its production...Ch. 4 - An automobile manufacturing company has a 500,000...Ch. 4 - Broker Sonya Wong is currently trying to maximize...Ch. 4 - Budget Auto produces inexpensive cars. Each car is...Ch. 4 - The ZapCon Company is considering investing in...Ch. 4 - You are a CFA (chartered financial analyst). An...Ch. 4 - Aluminaca produces 100-foot-long, 200-foot-long,...Ch. 4 - Each day, Eastinghouse produces capacitors during...Ch. 4 - During the next three months, a heating and...Ch. 4 - Gotham City National Bank is open Monday through...Ch. 4 - Based on Rothstein (1973). The Springfield City...Ch. 4 - Based on Charnes and Cooper (1955). Alex Cornby...Ch. 4 - City 1 produces 500 tons of waste per day, and...Ch. 4 - Based on Smith (1965). Silicon Valley Corporation...Ch. 4 - The Fresh Turkey Company produces two types of...Ch. 4 - The production line employees at Grummins Engine...Ch. 4 - Based on Lanzenauer et al. (1987). To process...Ch. 4 - Based on Robichek et al. (1965). The Korvair...Ch. 4 - Mackk Engine produces diesel trucks. New...Ch. 4 - Each hour from 10 A.M. to 7 P.M., Bank One...Ch. 4 - Owens-Wheat uses two production lines to produce...Ch. 4 - Rylon Corporation manufactures Brute cologne and...Ch. 4 - Sunco Oil has three different processes that can...Ch. 4 - Flexco produces six products in the following...Ch. 4 - Each week, Chemco can purchase unlimited...Ch. 4 - Bexter Labs produces three products: A, B, and C....Ch. 4 - Based on Franklin and Koenigsberg (1973). The city...Ch. 4 - Based on Carino and Lenoir (1988). Brady...Ch. 4 - Based on Dobson and Kalish (1988). Chandler...Ch. 4 - Based on Robichek et al. (1965). At the beginning...Ch. 4 - During each six-hour period of the day, the...Ch. 4 - Based on Glassey and Gupta (1978). A paper...Ch. 4 - Three bonds, as listed in the file P04_127.xlsx,...Ch. 4 - You have been assigned to develop a model that can...Ch. 4 - You have been assigned to develop a model that can...Ch. 4 - Keefer Paper produces recycled paper from paper...Ch. 4 - In this chapter, we give you the cost of producing...Ch. 4 - Discuss how the aggregate planning model could be...Ch. 4 - A large CPA firm currently has 100 junior staff...Ch. 4 - The employee scheduling model in this chapter was...Ch. 4 - Explain why it is problematic to include a...

Additional Business Textbook Solutions

Find more solutions based on key concepts
Show solutions add
CAPM AND REQUIRED RETURN Calculate the required rate of return for Manning Enterprises assuming that investors ...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

A process cost system is useful for costing separately identifiable products or batches of product.

College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)

What is a server?

Accounting Information Systems