Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 11, Problem 6P
Industrial Designs has been awarded a contract to design a label for a new wine produced by Lake View Winery. The company estimates that 150 hours will be required to complete the project. The firm’s three graphic designers available for assignment to this project are Lisa, a senior designer and team leader; David, a senior designer; and Sarah, a junior designer. Because Lisa has worked on several projects for Lake View Winery, management specified that Lisa must be assigned at least 40% of the total number of hours assigned to the two senior designers. To provide label designing experience for Sarah, the junior designer must be assigned at least 15% of the total project time. However, the number of hours assigned to Sarah must not exceed 25% of the total number of hours assigned to the two senior designers. Due to other project commitments, Lisa has a maximum of 50 hours available to work on this project. Hourly wage rates are $30 for Lisa, $25 for David, and $18 for Sarah.
- a. Formulate a linear program that can be used to determine the number of hours each graphic designer should be assigned to the project to minimize total cost.
- b. How many hours should be assigned to each graphic designer? What is the total cost?
- c. Suppose Lisa could be assigned more than 50 hours. What effect would this have on the optimal solution? Explain.
- d. If Sarah were not required to work a minimum number of hours on this project, would the optimal solution change? Explain.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
if a cupcake recipe calls for 4 pounds of cake flour and 2.5 pounds of sugar, what would be the baker's percentage for sugar if the recipe were converted to a formula with cake flour as the main ingredient?
The Concordia Theatre contains 500 seats, and the ticket prices for a recent play were $43 for adults and $28 for children. For one soldout matinee, if the total proceeds were $16,805, how many of each type of ticket were sold?
one safe investment pays 10% per year, and a riskier investment pays 18% per year. A woman who has $145,600 to invest would like to have an income of $20,000 per year from her investments. How much should she invest at each rate?
Chapter 11 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 11 - Kelson Sporting Equipment, Inc., makes two types...Ch. 11 - The Sea Wharf Restaurant would like to determine...Ch. 11 - Blair Rosen. Inc. (BR) is a brokerage firm that...Ch. 11 - Round Tree Manor is a hotel that provides two...Ch. 11 - Industrial Designs has been awarded a contract to...Ch. 11 - Vollmer Manufacturing makes three components for...Ch. 11 - Photon Technologies, Inc., a manufacturer of...Ch. 11 - The Westchester Chamber of Commerce periodically...Ch. 11 - The management of Hartman Company is trying to...Ch. 11 - The employee credit union at State University is...
Ch. 11 - The Atlantic Seafood Company (ASC) is a buyer and...Ch. 11 - The Silver Star Bicycle Company will manufacture...Ch. 11 - The Clark County Sheriff’s Department schedules...Ch. 11 - Bay Oil produces two types of fuel (regular and...Ch. 11 - Consider the following network representation of a...Ch. 11 - Refer to the transportation problem described in...Ch. 11 - Aggie Power Generation supplies electrical power...Ch. 11 - The Calhoun Textile Mill is in the process of...Ch. 11 - Refer to the Calhoun Textile Mill production...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Geraldine has been offered positions by two insurance companies. The first company pays a salary of $12,000 plus a commission of $100 for each policy sold. The second pays a salary of $20,000 plus a commission of $50 for each policy sold. How many policies would need to be sold to make the total pay the same?arrow_forwardWhat is the total effect on the economy of a government tax rebate of $1,000 to each household in order to stimulate the economy if each household will spend 90% of the rebate in goods and services?arrow_forwardIf during the following year it is predicted that each comedy skit will generate 30 thousand and each musical number 20 thousand, find the maximum income for the year. A television program director must schedule comedy skits and musical numbers for prime-time variety shows. Each comedy skit requires 2 hours of rehearsal time, costs 3000, and brings in 20,000 from the shows sponsors. Each musical number requires 1 hour of rehearsal time, costs 6000, and generates 12,000. If 250 hours are available for rehearsal and 600,000 is budgeted for comedy and music, how many segments of each type should be produced to maximize income? Find the maximum income.arrow_forward
- If a patient had a PPO plan with a 500 dollar in network deductible, and a 90 percent coinsurance with a 1000 out of networks deductible and 70 percent co-insurance , how much would you pay for a 34,000 bill from an innetwork doctor.arrow_forwardOn Monday evenings in April 2015, each episode of WWE Entertainment was typically watched by 3.8 million viewers, while each episode of American Dad was typically watched by 1.5 million viewers.† Your marketing services firm has been hired to promote Gauss Jordan sneakers by buying at least 120 commercial spots during episodes of WWE Entertainment and American Dad. You have been quoted a price of $4,000 per spot for WWE Entertainment and $1,000 per spot for American Dad. Gauss Jordan, Inc.'s advertising budget for TV commercials is $680,000, and it would like at least 80% of the total number of spots to appear on WWE Entertainment. How many spots should you purchase on each show to maximize exposure?arrow_forwardOn Monday evenings in April 2015, each episode of WWE Entertainment was typically watched by 3.8 million viewers, while each episode of American Dad was typically watched by 1.5 million viewers.† Your marketing services firm has been hired to promote Gauss Jordan sneakers by buying at least 30 commercial spots during episodes of WWE Entertainment and American Dad. You have been quoted a price of $4,000 per spot for WWE Entertainment and $1,000 per spot for American Dad. Gauss Jordan, Inc.'s advertising budget for TV commercials is $170,000, and it would like at least 80% of the total number of spots to appear on WWE Entertainment. How many spots should you purchase on each show to maximize exposure? HINT [Calculate exposure as Number of ads ✕ Number of viewers.] (If an answer does not exist, enter DNE.) WWE spots American Dadarrow_forward
- If four cars sell for an average of $10,000 each and three of the cars sell for $8,400 each, what is the cost of the fourth car?arrow_forwardSuppose a town has 75,000 residents and needs to generate $4 million in new tax revenue. If the tax burden is distributed evenly, how much does each resident need to pay?arrow_forwardA tutor at ABC learning center receives a monthly base pay of P8,000 corresponding to a P5,000 tutorial fee input to the center. he gets a share of 15% of all tutorial fees beyond the mandatory P15,000 input. If each student he handles pays P6,000/month on tutorial fees and he has five students for the month, how much share does he receive beyond his base pay?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Elementary AlgebraAlgebraISBN:9780998625713Author:Lynn Marecek, MaryAnne Anthony-SmithPublisher:OpenStax - Rice University
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Matrix Factorization - Numberphile; Author: Numberphile;https://www.youtube.com/watch?v=wTUSz-HSaBg;License: Standard YouTube License, CC-BY