Question: help please!!! Problem 3) Create a new Problem 3 worksheet and use the solver to the following: A quilter is making table runners and placemats.

help please!!! help please!!! Problem 3) Create a new Problem 3
Problem 3) Create a new Problem 3 worksheet and use the solver to the following: 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 placerat. How many of each item should she make in order to maximize profit? There is a solution to this problem that the solver will find. Type some comments in the worksheet answering the following questions: A - How many of each product should be sold to maximize profit? B - What is the maximum profit that can be achieved? C- What constraint(s) caused this solution to be the best possible? Use FORMULATEXT to show any formulas that you entered on any of the sheets. Print each sheet as a PDF file (scale to a single page each), and upload the PDF files and your Excel workbook to the Canvas assignment

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!