In Problems 49-54, use Excel to solve each linear programming problem.
Manufacturing At one of its factories, a manufacturer of televisions makes one or more of four models of HD units (without cases): a 20-in. LCD, a 42-in. LCD, a 42-in. plasma, and a 50-in. plasma. The assembly and testing time requirements for each model are shown in the following table, together with the maximum amounts of time available per week for assembly and testing. In addition to these constraints, the supplier of cases indicated that it would supply no more than 200 cases per week and that of these, no more than 40 could be for the 20-in. LCD model.
20-in.LCD | 42-in.LCD | 42-in.Plasma | 50-in. Total Plasma Available | ||
Assembly time (hours) | 7 | 10 | 12 | 15 | 2000 |
Test time (hours) | 2 | 2 | 4 | 5 | 500 |
Profit(dollars) | 46 | 60 | 75 | 100 |
Use the profit for each television shown in the table to find the number of completed models of each type that should be produced to obtain the maximum profit for the week. Find the maximum profit.
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Mathematical Applications for the Management, Life, and Social Sciences
Additional Math Textbook Solutions
Pathways To Math Literacy (looseleaf)
Elementary Statistics ( 3rd International Edition ) Isbn:9781260092561
Elementary Statistics: A Step By Step Approach
Finite Mathematics for Business, Economics, Life Sciences and Social Sciences
Elementary Statistics
A First Course in Probability (10th Edition)
- In her last semester at SPC, Polly Hedron needs to take Statistics and Composition 2. Because Polly is registering early, she has 16 choices for her section of Statistics and 14 choices for her section of Composition. From how many possible schedules can Polly choose? (You may presume that none of these sections interfere with each other)arrow_forwardThe Donaldson Furniture Company produces three types of rocking chairs: the children's model, the standard model, and the executive model. Each chair is made in three stages: cutting, construction, and finishing. Stage Cutting Construction Finishing Children's Standard Executive 7 hr 5 hr 4 hr 3 hr 2 hr 5 hr 2 hr 2 hr 4 hr The time needed for each stage of each chair is given in the chart. During a specific week the company has available a maximum of 166 hours for cutting, 106 hours for construction, and 84 hours for finishing. Determine how many of each type of chair the company should make to be operating at full capacity. The number of executive chairs the company should make isarrow_forwardThe manager of the Burgle Doodle restaurant wants to determine how many sausage biscuits and ham biscuits to prepare each morning for breakfast customers. Two types of biscuits require the following resources: Biscuit Labor (hr.) Sausage (Ib.) Ham (Ib.) Flour (Ib.) Sausage 0.010 0.10 0.04 Ham 0.024 0.15 0.04 The restaurant has 6 hours of labor available each morning. The manager has a contract with a local grocer for 30 pounds of sausage and 30 pounds of ham each morning. The manager also purchases 16 pounds of flour. The profit for a sausage biscuit is $0.60; the profit for a ham biscuit is $0.50. The manager wants to know how many of each type of biscuit to prepare each morning in order to maximize profit. At the optimal solution, what is the shadow price associated with the Flour constraint? 12.5 We do not have enough information to determine the shadow price. 0 1arrow_forward
- The Lawson Fabric Mill Produces five different fabrics. Each fabric can be woven on one or more of the mill’s 36 looms. The sales department’s forecast of demand for the next month is shown in below Table 1, along with data on the selling price per yard, variable cost per yard, and purchase price per yard. The mill operates 24 hours a day and is scheduled for 30 days during the coming month. The mill has two types of looms: draw and regular. The draw looms are more versatile and can be used for all five fabrics. The regular looms can produce only three of the fabrics. The mill has a total of 36 looms: 8 are draw and 28 are regular. The rate of production for each fabric on each type of loom is given in below Table 2. The time required to change over from producing one fabric to another is negligible and does not have to be considered. The Lawson Fabric Mill satisfies all demand with either its own fabric or fabric purchased from another mill. Fabrics that cannot be woven at the…arrow_forwardA manufacturer produces three types of plastic fixtures. The time required for molding,trimming, and packaging is given in the table below:(Times are given in hours per dozen fixtures.) How many dozens of each type of fixture should be produced to obtain a maximumprofit?arrow_forwardTMA manufactures 37-in. high definition LCD televisions in two separate locations, Locations I and II. The output at Location I is at most 6000 televisions/month, whereas the output at Location II is at most 5000 televisions/month. TMA is the main supplier of televisions to the Pulsar Corporation, its holding company, which has priority in having all its requirements met. In a certain month, Pulsar placed orders for 3000 and 4000 televisions to be shipped to two of its factories located in City A and City B, respectively. The shipping costs (in dollars) per television from the two TMA plants to the two Pulsar factories are as follows. From TMA Location I Location II To Pulsar Factories City A $7 City B $9 What is the minimum cost? $4 $11 TMA will ship x televisions from Location I to city A and y televisions from Location I to city B. Find a shipping schedule that meets the requirements of both companies while keeping costs to a minimum. (x, y) =arrow_forward
- TMA manufactures 37-in. high definition LCD televisions in two separate locations, Locations I and II. The output at Location I is at most 6000 televisions/month, whereas the output at Location II is at most 5000 televisions/month. TMA is the main supplier of televisions to the Pulsar Corporation, its holding company, which has priority in having all its requirements met. In a certain month, Pulsar placed orders for 3000 and 4000 televisions to be shipped to two of its factories located in City A and City B, respectively. The shipping costs (in dollars) per television from the two TMA plants to the two Pulsar factories are as follows. From TMA Location I Location II, To Pulsar Factories City A $6 City B $4 $8 $11 TMA will ship x televisions from Location I to city A and y televisions from Location I to city B. Find a shipping schedule that meets the requirements of both companies while keeping costs to a minimum. (x, y) = What is the minimum cost?arrow_forwardTMA manufactures 37-in. high definition LCD televisions in two separate locations, Locations I and II. The output at Location I is at most 6000 televisions/month, whereas the output at Location II is at most 5000 televisions/month. TMA is the main supplier of televisions to the Pulsar Corporation, its holding company, which has priority in having all its requirements met. In a certain month, Pulsar placed orders for 3000 and 4000 televisions to be shipped to two of its factories located in City A and City B, respectively. The shipping costs (in dollars) per television from the two TMA plants to the two Pulsar factories are as follows. From TMA Location I Location II To Pulsar Factories City A $7 City B $4 $9 $10 TMA will ship x televisions from Location I to city A and y televisions from Location I to city 8. Find a shipping schedule that meets the requirements of both companies while keeping costs to a minimum. (x, y) = 0 What is the minimum cost? $arrow_forwardTMA manufactures 37-in. high definition LCD televisions in two separate locations, Locations I and II. The output at Location I is at most 6000 televisions/month, whereas the output at Location II is at most 5000 televisions/month. TMA is the main supplier of televisions to the Pulsar Corporation, its holding company, which has priority in having all its requirements met. In a certain month, Pulsar placed orders for 3000 and 4000 televisions to be shipped to two of its factories located in City A and City B, respectively. The shipping costs per television from the two TMA plants to the two Pulsar factories are as follows. To Pulsar Factories From TMA City A City B Location I $7 $3 Location II $8 $9 TMA will ship x televisions from Location I to city A and y televisions from Location I to city B. Find a shipping schedule that meets the requirements of both companies while keeping costs to a minimum. (x, y) $= Solve the linear programming problem by…arrow_forward
- Henry Lee is the Vice President of Purchasing for the consumer electronics division of the Major Electric Corporation (MEC). The company recently introduced a new type of video camcorder that has taken the market by storm. Although Henry is pleased with the strong demand for this product in the market place, it has been a challenge to keep up with MEC's distributors' orders of this camcorder. His current challenge is how to meet requests from MEC's major distributors in Pittsburgh, Denver, Baltimore, and Houston who have placed orders of 10,000, 20,000, 30,000, and 25,000 units, respectively, for delivery in 2 months (there is a 1-month manufacturing and one-month shipping lead time for this product). MEC has contracts with companies in Hong Kong, Korea, and Singapore who manufacture camcorders for the company under the MEC label. These contracts require MEC to order a specified minimum number of units each month at a guaranteed per unit cost. The contracts also specify the maximum…arrow_forwardProblem 2: Luxury Cruise Lines has a fleet of ships that travel to Alaska repeatedly every summer. A considerable amount of advertising is done each winter to help generate enough passengers for the summer. With the coming of the new winter season, a decision needs to be made about how much advertising to do this year. Amount of 225 400 350 275 450 advertising ($1,000s) Sales 16 21 17 23 (thousands of passengers) 1. How many thousands of passengers would be generated if Luxury Cruise spends $300,000 on advertising? 2. Estimate the amount of advertising needed to target a booking of 22,000 passengers. 3. Is the regression model a good model? Wwhy? 20arrow_forwardYou are in charge of purchases at the student-run used-book supply program at your college, and you must decide how many introductory calculus, history, and marketing texts should be purchased from students for resale. Due to budget limitations, you cannot purchase more than 1150 of these textbooks each semester. There are also shelf-space limitations: Calculus texts occupy 2 units of shelf space each, history books 1 unit each, and marketing texts 5 units each, and you can spare at most 2,000 units of shelf space for the texts. If the used book program makes a profit of $10 on each calculus text, $4 on each history text, and $8 on each marketing text, how many of each type of text should you purchase to maximize profit? HINT calculus text(s) history text(s) marketing text(s) What is the maximum profit the program can make in a semester?$arrow_forward
- Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage LearningAlgebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:CengageAlgebra for College StudentsAlgebraISBN:9781285195780Author:Jerome E. Kaufmann, Karen L. SchwittersPublisher:Cengage Learning