Problem 3

Create a new Problem 3 worksheet and use the solver (Module 12 (Video 3-4) to the following:

a. A quilter is making table runners and placemats. It takes her 12 minutes to make a table runner and 7.5 minutes to make a placemat. Each placemat uses 1.25 yards of fabric and each table runner uses 2/3 yard of fabric.

She has 31 hours available for making the table runners and placemats and has 237 yard of fabric on hand. She makes a profit of $2.50 on each table runner and $1.75 on each placemat. How many of each item should she make in order to maximize profit?

b. Use FORMULATEXT to show any formulas that you use.

c. There is a solution to this problem that the solver finds (question 3#a). Type your answers to the following questions in the same worksheet :

i. How many of each product should be sold to maximize profit?

j. What is the maximum profit that can be achieved?

k. What constraint(s) caused this solution to be the best possible?