Ds Math - Welcome to the Site



1935480-318770SAVE THIS FILE AS: U2Review200SAVE THIS FILE AS: U2Review2MIG Unit 2 Review 2Name: ________________________Setting up and solving LP problems with ExcelUse the SOLVER feature of Excel to find the maximum values of the following problems. The Bead Store sells material for customers to make their own jewelry. Customer can select beads from various bins. Grace wants to design her own Halloween necklace from orange and black beads. She wants to make a necklace that is at least 12 inches long, but no more than 24 inches long. Grace also wants her necklace to contain black beads that are at least twice the length of orange beads. Finally, she wants her necklace to have at least 5 inches of black beads.? What is the maximum necklace length she can make using the orange and black beads?Decision Variables: Constraints: Objective Function: Optimal Solution: Maximum Length: A manufacturer of ski clothing makes ski pants and ski jackets. The profit on a pair of ski pants is $2.00 and on a jacket is $1.50. Both pants and jackets require the work of sewing operators and cutters. There are 84 minutes of sewing operator time and 48 minutes of cutter time available. It takes 8 minutes to sew a pair of ski pants and 4 minutes to sew a jacket. It takes 12 minutes to cut pants and 18 minutes to cut a jacket. Additionally, four customers have already preordered the ski jackets. Find the maximum profit and the amount of pants and jackets to maximize profit.Decision Variables: Constraints: Objective Function:Optimal Solution:Maximum Amount: A farmer has 10 acres to plant in wheat and rye. He has to plant at least 7 acres. However, he has only $1200 to spend and each acre of wheat costs $200 to plant and each acre of rye costs $100 to plant. Moreover, the farmer has to get the planting done in 12 hours and it takes an hour to plant an acre of wheat and 2 hours to plant an acre of rye. If the profit is $500 per acre of wheat and $300 per acre of rye how many acres of each should be planted to maximize profits?Decision Variables: Constraints: Objective Function: Optimal Solution: Maximum Profit: A bike manufacturer can form 2 simple bicycles or 1 elaborate bicycle per hour. The worker must form at least 10 bicycles each shift. A work shift is no more than 7 hours. The bike manufacturer makes a profit of $10 per hour worked on the simple bicycles and $12 per hour worked on the elaborate bicycles. Find the number of hours the worker should spend on each type of bicycle to maximize the profit each day. What is the maximum profit?Decision Variables: Constraints: Objective Function: Optimal Solution: Maximum Profit: ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download