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
A contractor, Susan Meyer, has to haul gravel to three building sites. She can purchase as much as 18 tons at a gravel pit in the north
of the city and 14 tons at one in the south. She needs 10, 5, and 10 tons at sites 1, 2, and 3, respectively. The purchase price per ton
at each gravel pit and the hauling cost per ton are given in the table below. Susan wishes to determine how much to haul from each pit
to each site to minimize the total cost for purchasing and hauling gravel.
Hauling Cost per Ton at Site
Pit
1
3
Price per Ton
North
$30
$60
$50
$100
South
$60
$30
$40
$120
Now suppose that trucks (and their drivers) need to be hired to do the hauling, where each truck can only be used to haul gravel from
a single pit to a single site. Each truck can haul 5 tons, and the cost per truck is five times the hauling cost per ton given above. Only
full trucks would be used to supply each site.
a. Formulate this problem as an assignment problem by constructing the appropriate cost table,…
Beautiful Images has been awarded a contract to design a label for a new wineproduced by Carolina Vines Winery. The company estimates that one-hundred-fifty hours will berequired to complete the project. The firm’s three graphics designers available forassignment to this project are Scott, a senior designer and team leader; Brett, a seniordesigner; and Claudia, a junior designer. Because Scott has worked on several projectsfor Carolina Views Winery, management specified that Scott must be assigned at leastForty percent of the total number of hours assigned to the two senior designers. To providea label-designing experience for Claudia, Claudia must be assigned at least Fifteen percent of the total project time. However, the number of hours assigned to Claudia must not exceed twenty-five percent of the total number of hours assigned to the two senior designers. Due to other project commitments, Scott has a maximum of fifty hours available to work on this project.Hourly wage rates are…
Industrial Designs has been awarded a contract to design a label for a new wine produced by Lake ViewWinery. The company estimates that 150 hours will be required to complete the project. The firm’s threegraphics 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 forLake View Winery, management specified that Lisa must be assigned at least 40% of the total number ofhours assigned to the two senior designers. To provide label-designing experience for Sarah, Sarah must beassigned at least 15% of the total project time. However, the number of hours assigned to Sarah must notexceed 25% of the total number of hours assigned to the two senior designers. Due to other projectcommitments, Lisa has a maximum of 50 hours available to work on this project. Hourly wage rates are $30for Lisa, $25 for David, and $18 for Sarah.a. Formulate a linear program…
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
- Departments X, Y, and Z occupy floor space of 80m2, 140m2 and 160m2respectively. If the total rental costs for floor space is $11400 per month, how much of the rental cost should each department pay?arrow_forwardThe Everton College store paid $1564 for an order of 47 calculators. The store paid $8 for each scientific calculator. The others, all graphing calculators, cost the store $52 each. How many of each type of calculator was ordered?arrow_forwardA furniture store expects to sell 120 coffee tables during the next year. It costs $1.50 to store one coffee table for one year. To reorder, there is a fixed cost of $10, plus $2.80 for each coffee table ordered. In what lot size and how many times per year should an order be placed to minimize inventory costs? coffee tables per order orders per yeararrow_forward
- Katie Jergens works for Dynamic Designs selling clothing. She is on a salary of $140 per week plus a commission of 7% of her sales. Last week, she sold 19 dresses at $79.95 each, 26 skirts at $24.75 each, and 17 jackets at $51.50 each. What were her total gross earnings for the week? Item Quantity Price Dresses Skirts Jackets Total sales = Commission = Weekly salary = Total weekly gross pay =arrow_forwardThe head of the production department of a RM electronic company wants to determine the relationship between the number of workers who assemble the product and the number of units assembled per day. with solution and explanation please.arrow_forwardParent volunteers at Somerville High School are processing yearbook order forms. Students have an option to get the basic yearbook or a deluxe option, which includes engraving and a protective cover. In Mrs. Hammond's class, 6 basic yearbooks and 4 deluxe yearbooks were ordered, for a total of $738. The students in Mr. Allen's class ordered 26 basic yearbooks and 4 deluxe yearbooks, for a total of $2,038. How much does each option cost?arrow_forward
- A plant supervisor must split her 40-hour workweek between hours working on the assembly line and hours supervising. She is paid $18.25 per hour for working and $24.75 per hour supervising. If her earnings for a certain week are $821.00, how much time does she spend on each task?arrow_forwardMany package delivery services charge a base price for packages up to some weight and a surcharge for each additional pound (or fraction thereof). Jesaki Express, a national package delivery service, charges a base price for overnight delivery of packages weighing 2 pounds or less and a surcharge for each additional pound (or fraction thereof). You are billed $28.11 for shipping a 5.9 pound package and $61.65 for shipping a 24.3 pound package. What is the base price that Jesaki Express charges for packages weighing 2 or less? $ . Round to the nearest cent. Thanks!!!arrow_forwardMany package delivery services charge a base price for packages up to some weight and a surcharge for each additional pound (or fraction thereof). Jesaki Express, a national package delivery service, charges a base price for overnight delivery of packages weighing 2 pounds or less and a surcharge for each additional pound (or fraction thereof). You are billed $28.11 for shipping a 5.9 pound package and $61.65 for shipping a 24.3 pound package. What is the base price that Jesaki Express charges for packages weighing 2 or less? $ . Round to the nearest cent.arrow_forward
- Bob Farrell works for a company that manufactures small appliances. Bob is paid $2.00 for each toaster, $4.60 for each microwave oven, and $1.55 for each food blender he assembles. If he produced 56 toasters, 31 microwave ovens, and 79 blenders, what were his total weekly gross earnings?arrow_forwardThe Callaghan family owns 410 acres of farmland in Co. Cork on which they grow wheat and oats. Each acre of wheat costs €105 to plant, cultivate, and harvest; each acre of oats costs €210. The Bradleys have a budget of €52,500 for next year. The government limits the number of acres of oats that can be planted to 100. The profit from each acre of wheat is €300; the profit from each acre of oats is €520. The Callaghans want to know how many acres of each crop to plant in order to maximize their profit. iii. Represent the problem in graphical format and highlight the feasible region.arrow_forwardA sporting goods store sells 100 pool tables per year. It costs $64 to store one pool table for a year. To reorder, there is a fixed cost of $32 per shipment plus $18 for each pool table. How many times per year should the store order pool tables, and in what lot size, in order to minimize inventory costs? The store should order pool tables times per year to minimize inventory costs.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
Matrix Factorization - Numberphile; Author: Numberphile;https://www.youtube.com/watch?v=wTUSz-HSaBg;License: Standard YouTube License, CC-BY