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,…
A 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 year
In excel please
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
- The 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 provincial government allocates 26% of its budget to education, 31% to health care, and 18% to social services. If the dollar amount budgeted for education is $15.0 billion, how much is budgeted for health care and for social services.arrow_forwardA company produces coffee makers. The labor cost of assembling one coffee maker during the regular business hours is $2.85. If the work is done in overtime, the labor cost is $3.85 per unit. The company must produce 820 coffee makers this week, and does not want to spend more than $2557 in labor costs. What is the smallest number of units that must be assembled during the regular hours?arrow_forward
- A diesel engine uses Type A filter and high-grade lubricating oil costing P5.50 per liter. With this filter, the oil and the filter have to be changed every 500 hours of operation, and 5 liters of coil have to be added every 100 hours. This filter costs P148 a piece. Eighty liters of coil fill the engine. Another type, filter B, costing P120 may be used with a lower grade of oil costing P4.80 per liter. However, if this filter is used, the oil and filter have to be changed every 300 hours, and 10 liters are added after each 150 hours the engine is used. Which type of filter and oil would you recommend?arrow_forwardYou are thinking of making your mansion more energy efficient by replacing some of the light bulbs with compact fluorescent bulbs, and insulating part or all of your exterior walls. Each compact fluorescent light bulb costs $4 and saves you an average of $2 per year in energy costs, and each square foot of wall insulation costs $1 and saves you an average of $0.20 per year in energy costs.† Your mansion has 150 light fittings and 2800 sq ft of uninsulated exterior wall. To impress your friends, you would like to spend as much as possible, but save no more than $800 per year in energy costs (you are proud of your large utility bills). How many compact fluorescent light bulbs and how many square feet of insulation should you purchase? How much will you save in energy costs per year? (If an answer does not exist, enter DNE.)arrow_forwardA distribution centre sends three different types of parcels. One consignment has 6 small, 8 medium and 9 large parcels which cost $173.20 to post.Another consignment has 7 small, 13 medium and 17 large parcels with totalpostage $291.05. A large parcel costs twice as much to post as a small one.Work out the total cost of posting 3 small parcels, 9 medium parcels and 2 large parcels.arrow_forward
- Flint lab produces 4 high tech product types. Each of the products must be wired, drilled, assembled and checked for quality standard before being delivered to consumers. The time requirement and profit for each product are as follows. Product A: 0.5 hr for wiring, 3 hrs for drilling, 1 hr for assembling, and 0.5 hr for inspection. One product A can be sold for $10 per unit. Product B: 1.5 hr for wiring, 1 hrs for drilling, 3 hrs for assembling, and 1 hr for inspection. One product B can be sold for $13 per unit. Product C: 1.5 hr for wiring, 2 hrs for drilling, 3 hrs for assembling, and 0.5 hr for inspection. One product C can be sold for $16 per unit. Product D: 1 hr for wiring, 3 hrs for drilling, 2 hrs for assembling, and 0.5 hr for inspection. One product D can be sold for $12 per unit. The maximum capacity for wiring, drilling, assembly, and inspection are 1500 hrs; 2350 hrs; 2600 hrs; and 1200 hrs respectively. Flint lab requires that there will be at least 150 units of A, 100…arrow_forwardmadison square garden seats 15000 people. Courtside seats cost $8, first level seats cost $6 and upper deck seats cost $4. The total revenue for a sellout is $76000. If half the courtside seats, , half the upper deck seats and all the first level seats are sold , then the total revenue is $44000. How many of each type of seat is there.arrow_forwardThe Colorado soccer league has set a budget of $1,972 for soccer balls. High-quality game balls cost $33 each while lower-quality practice balls cost $19 each. If 78 balls are to be purchased, how many balls of each type can be purchased to exactly use up the budgeted amount? Number of game balls Number of practice ballsarrow_forward
- A Toot can be made in 30 minutes and has a feather attached to it. A Wheet requires 15 minutes, has two feathers, and is sprinkled with 0.5 oz of sequin powder. A Honk requires 30 minutes, has three feathers, and one oz. of sequin powder. The net profit is $0.40 per Toot, $0.50 per Wheet, and $0.80 per Honk. The following resources are available: 80 hrs of labor, 360 feathers, and 90 oz. of sequin powder. Determine the quantity of each type of noisemaker that maximizes profit.arrow_forwardA Toot can be made in 30 minutes and has a feather attached to it. A Wheet requires 15 minutes, has two feathers, and is sprinkled with 0.5 oz of sequin powder. A Honk requires 30 minutes, has three feathers, and one oz. of sequin powder. The net profit is $0.40 per Toot, $0.50 per Wheet, and $0.80 per Honk. The following resources are available: 4800 minutes of labor, 360 feathers, and 90 oz. of sequin powder. Determine the quantity of each type of noisemaker that maximizes profit.arrow_forwardBreak.com is an ad-supported video-sharing website. Its advertisers can choose to have their ad displayed for some amount of time on particular page within the website. Break.com charges per impression made of an ad, i.e., per visitor that sees the ad. The cost for displaying an ad is usually quoted in cost-per-thousand impressions (CPM). For the homepage, the CPM is $9. The number of visitors per day to Break.com is random. Break.com claims that over the past 60 days the average number of visitors to the homepage per day is 1 million. Furthermore, Break.com claims the population standard deviation is 0.25 million. Calculate a 95% confidence interval for the average number of visitors to the homepage per day.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